Here is an operations management problem that I have been struggling with.

Balsam Pine Forestry estimates the demand forecast for the four-month holiday season as follows: September 2,880, October 3,740, November 3,880, December 3,520. The company has 9 workers and 0 units in inventory. Due to financial reasons: - use overtime only in November - you can have backorders in October, but no other months - you may NOT have inventory carried over (trees will not last that long) - new workers can only be hired in October. Hiring expenses will occur in October. The number of workers at the end of October will remain for the rest of the season. Record backorder as a negative beginning inventory the following month. Hiring costs, $40 per new worker; layoff costs, $60 per worker laid off; holding costs, $25 per unit; backorder cost, $10 per unit; regular time labor, $15 per hour; overtime, $22.50 per hour. Productivity is 2 trees harvested per worker hour, eight hours per day, 20 days per month. Find the total cost of this plan. (Leave the cells blank, whenever zero (0) is required.) Question 14 (60 pts) | September October November December Forecast Beginning inventory Production required Production hours required Regular workforce Regular production Overtime hours Overtime production Total production Ending inventory Ending backorders Workers hired Workers laid off September October November December Regular time Overtime Inventory Backorder Hiring Hiring Layoff Total Total cost for season XXXX XXXXX XXXXX Balsam Pine Forestry estimates the demand forecast for the four-month holiday season as follows: September 2,880, October 3,740, November 3,880, December 3,520. The company has 9 workers and 0 units in inventory. Due to financial reasons: - use overtime only in November - you can have backorders in October, but no other months - you may NOT have inventory carried over (trees will not last that long) - new workers can only be hired in October. Hiring expenses will occur in October. The number of workers at the end of October will remain for the rest of the season. Record backorder as a negative beginning inventory the following month. Hiring costs, $40 per new worker; layoff costs, $60 per worker laid off; holding costs, $25 per unit; backorder cost, $10 per unit; regular time labor, $15 per hour; overtime, $22.50 per hour. Productivity is 2 trees harvested per worker hour, eight hours per day, 20 days per month. Find the total cost of this plan. (Leave the cells blank, whenever zero (0) is required.) Question 14 (60 pts) | September October November December Forecast Beginning inventory Production required Production hours required Regular workforce Regular production Overtime hours Overtime production Total production Ending inventory Ending backorders Workers hired Workers laid off September October November December Regular time Overtime Inventory Backorder Hiring Hiring Layoff Total Total cost for season XXXX XXXXX XXXXX