Hello can I have some help on the matter please :)

like this format below:

Save Homework: Chapter 13 Aggregate Planning and S&OP (Copy) Score: 0 of 1 pt 12 of 15 (10 complete) HW Score: 66.67%, 10 of 15 pts Problem 13.5 Question Help The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 3 months as follows: January February March April 1.500 1.700 1,700 1,700 May June July August 2,300 2,100 1,900 1,500 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 $125 per unit. Inventory holding cost is $20 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 = 1800 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 (Units) Demand Ending Production Inventory 200 1.800 Period Month 0 December 1 January 2 February 3 March 1,500 1,700 1.800 4 5 April May June July 1,700 1,700 2,300 2.100 1,900 1.800 1.800 1.800 1.800 1.800 1.800 6 7 8 August 1,500 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) Period Month 0 December 1 January 2 February 3 March 4 April 5 May 0 June 7 July 8 August Ending Demand Production Inventory Stockouts (Units) 200 1,200 1.700 700 1,500 1,700 900 1.600 1.700 1000 1.900 1,700 800 D 2.100 1,700 400 2,300 1.700 0 200 1,700 1,700 0 o 1.300 1.700 400 0 The total stockout cost = $ 25000 (Enter your response as a whole number) The total inventory carrying cost $ 106000 (Enter your response as a whole number) The total cost, excluding normal time labor costs, is - $ 130000 (Enter your response as a whole number) Question is complete