Using the given information, produce an aggregate plan and determine the following. PLEASE PROVIDE STEPS TO SOLVE IN EXCEL

Period	Forecast
1	180
2	170
3	140
5	150
5	130
6	150
Reg Time	$20 per unit (150 units per period maximum)
Overtime	$30 per unit (20 units max per period maximum)
Subcontracting:	None
Beginning Inv:	none
Holding Cost	#5 per unit per period
Back Order Cost	$20 per unit per period

a. What is total forecasted demand?

b. What is total regular time capacity?

c. How should overtime capacity be utilized?

d. What are total regular time costs?

e. What are total overtime costs?

f. What are total carrying costs?

g. What are total backorder costs?

h. What are total costs for each period?

i. What are total costs for the six periods?

j. If hiring cost is $500 and firing cost if $400, would it be more economical on a per unit basis to use overtime or to hire and fire a temporary person (who can produce a maximum of 30 units per period)? What would be the difference in total costs for the six periods?