Problem
how to figure overhead/profit on hard and soft
costs both in MacNail construction
estimating software.
Instructions from newsletter #12
Diagnosis
They want overhead or profit to apply to hard
costs AND soft costs in the estimate.
Solution
1. Open the estimator you’d like to change.
2. Go to the Summation, and scroll down to the soft costs area.
3. Choose Display from the Options menu, and turn on Formulas.
4. Edit the formulas to include additional items besides hard costs. For example, the cell for labor overhead
shows =D34*oh. D34 is the subtotal line for labor, and “oh” is a defined name that contains the overhead
%.
5. To change the formula, first click in the cell, and check the formula bar.
6. Insert the cursor between = and D, and type an open parenthesis.
7. Insert the cursor just after D34, then click in the worksheet on every cell that you’d like to figure
overhead on top of. Notice that the addition sign is added automatically each time you click on a cell.
8. When you’ve clicked on every desired cell, type a close parenthesis (see the formula bar in the bottom
illustration).
9. Hit the enter key. If you’ve typed everything correctly, the formula will be accepted.
10. Repeat the process for any other cells you’d like to change.
Warning: if you figure sales tax on top of overhead, make sure you don't also figure overhead on top of sales tax!
If you do that, you'll get a circular reference error that will prevent the estimate from successfully being calculated.
11. When you’re done, choose Display from the Options menu again, and turn off Formulas. Comments
Entered 1/10/96 by Dennis. Updated 11/18/2010.
|
