>

FORM 7

Annual Production and Profit Planning Worksheet

DATE_________________    PLAN FOR THE PERIOD OF_________________

SPECIES SAWED          Total
1. MBF lumber sawed during planning period          
2. Standard revenue/MBF          
3. Less: Standard selling cost/MBF          
4. Net revenue/MBF          
5. Less: Standard log cost/MBF          
: Standard direct labor cost/MBF          
: Standard variable overhead/MBF          
6. Total variable cost/MBF          
7. Contribution margin/MBF          
8. Total contribution margin/year          
9. Total fixed costs for the planning period:  
10. Profit before taxes:  
11. Estimated income taxes:  
12. Net profit:  
INSTRUCTIONS: For each species you plan to saw during the planning period:
  1. Enter volume of lumber production planned in MBF.
  2. Enter standard revenue per MBF for each species.
  3. Enter standard selling cost per MBF for each species.
  4. Subtract line 3 from line 4.
  5. Enter standard log cost/MBF, standard direct labor cost/MBF, standard variable overhead cost/MBF.
  6. The sums of log, labor and variable overhead costs from line 5.
  7. Subtract line 6 from line 4.
  8. Multiply line 7 times line 1. Put total in line at far right.
  9. Enter total fixed costs for the planning period. This would be annual fixed costs if the planning period is one year.
  10. Subtract line 9 from line 8.
  11. Enter estimated income taxes for the planning period based on the profit before taxes shown in line 10.
  12. Subtract line 11 from line 10. This is the estimated net profit for the planning period.

Back to main document