PLEASE DO PART C and #2

eto.mheducation.com/ext/map/index.html?_con=con&external browser=0&aunchUrl=https%253A%252F%252Fblackboa... My Drive - Google Google Docs- cre. s blackboard TU work email Excel STV NET J Jobite - Dashbo Saved Help 9:11 Save & Exit Check Problem 11-8 (Static) Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for dema cases) for the next six months Month Forecast May 4,000 Jun 4,800 Jul 5,600 Aug 7,200 Sep 5,400 Oct 5.000 Use the following information to develop aggregate plans. Regular production cost Regular production capacity Overtime production cost Subcontracting cost Holding cost Beginning Inventory $10 per case 5,000 cases $ 16 per case $ 20 per case 5 1 per case per month Click here for the Excel Data File 1. Develop an aggregate plan using each of the following guidelines and compute the total cost for each Note: Backlogs are not allowed. 6. Use level production Supplement using overtime as needed. (Negative amounts should be indicated minus sign. Leave no cells blank - be certain to enter "0" wherever required.) Period May Juni Jul Aug Sep Da Total 4.000 4.800 5.600 7.200 6,400 5.000 33.000 Forecast Output Regular Overtimo Output - Forecast Inventory Beginning Proy 1 of 1 Noxi g stion 1 Homework ECOetomheducation.com/et/map/index.htmit.con conexternal browserschuthttp253A%252F%252Flackbos. * Google Mal My Drive Google Google Docs blackboard TV workenal STV NET J Jovit-Dwboard Incognito al Radio Homework 9-11 Help Save & Ek Submit Check my work 1 30 pos c. Use overtime up to 750 cases per period and inventory to handle variations in demand. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter wherever required) Petit Tocal 4.000 4.800 5600 7.200 6400 5.000 33.000 Pre Forecast Output Regular Ow Output-Force Inventory Beginning Ending Bladition Costs Regular Overme Hry of Inventory Back anders Total 2. Which plan as the lowest total cost ME GES HIHI Per 1 1 Next 11