Question:I need help on Level plan for the 4 Quarters. Please, show me how you got the answer with excel. Thank you

Deb Bishop Health and Beauty Products has developed a new shampoo and you need to develop its aggregate schedule. The cost accounting department has supplied you the cost relevant to the aggregate plan and the marketing department has provided a?four-quarter forecast.

Your job is to develop an aggregate plan for the next four quarters.

Forecast: 1,400,1,000,1,700,1,200

Qua I'lEI Fotecast 1,400 1,000 1,700 1,200 hand Hiring and Layoff Plan Pmducliun 1,500 1400 1000 1700 1200 Hire [U nits) 700 Layoff [Units] 100 400 500 The total cost, including normal time labor cost; lot this biting and layoffs plan is 5 322000 {enteryour response as a wmle number). b} Try a plan thal holds employment steady (level strategy) by producing lhe average forecast for all fourquarlers (enfer your responses as whole numbers). Level Pla n Ending Shortage Hire Layoff 0\"\"\"9' Puma\" Pmdmm" Inventory (Units) (Units) [Units] 1,500 0 1 1,400 1325 0 15 0 175 2 1,000 1325 Enter your answer in the edit elds and then click Check Answer. Costs Previous quarter's output 115m] units Beginning inventory t] units Stooico ut cost for baokorders $55 per unit Inventory holding cost $9 per unit for every unit held at the end of the quarter Hiring workers $51] per unit Layo workers $5 per unit Unit cost $40 per unit Dye rtir'ne $15 extra per unit Subcontracting Not available