The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next months as follows:
January
February
March
April
May
June
July
August
Her operations manager is considering a new plan, which begins in January with units of inventory on hand. Stockout cost of lost sales is $ per unit. Inventory holding cost is $ per unit per month. Ignore any idletime 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.
Part
The average monthly demand requirement units
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
Month,Demand, production,Ending Inventory, stockouts units
December,
January,"
February,"
March,"
April,"
May,"
June,"
July,"
August,"