The president of Hill Enterprises, Teri Hill, projects the firm’s aggregate demand requirements over

Question: The president of Hill Enterprises, Teri Hill, projects the firm’s aggregate demand requirements over the next 8 months as follows January 1,400 May 2,200 February 1,600 June 2,200 1,500 July 1,800 March April 1,800 August 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand Stockout cost of lostShow transcribed image textTranscribed image text: The president of Hill Enterprises, Teri Hill, projects the firm’s aggregate demand requirements over the next 8 months as follows January 1,400 May 2,200 February 1,600 June 2,200 1,500 July 1,800 March April 1,800 August 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month Ignore any idle-time costs. The plan is called plan C Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels Conduct your analysis for January through August The average monthly demand requirement 1775 units (Enter your response as a whole number) In order to arrive at the costs, first compute the ending inventory and stockout units for each month by filling in the table below (enter your responses as whole numbers) Conduct your analysis for January through August The average monthly demand requirement 1775 units (Enter your response as a whole number) In order to arrive at the costs, first compute the ending inventory and stockout units for each month by filling in the table below (enter your responses as whole numbers). Stockouts Ending Demand Production Inventory 200 Period Month 0 December January (Units) 1 1.400 1,775 2 February 1,600 1,775 3 March 1,800 1,775 4 April 1.800 1,775 5 May 2,200 1,775 June 2,200 1,775 7 July 1,800 1,775 1,400 1,775 678 August ▬▬▬▬▬▬-