Aggregate demand for a product family is given in the table below for the 4 quarters of the preceding year. The production strategy is level production, in which the same amount is produced in each quarter. Pertinent details are:

• The per unit cost of production is $45/unit.
• Inventory is held at a cost of $9/unit/quarter.
• Up tp 40 units can be subcontracted in any quarter at a cost of $54/unit.
• Demand that cannot be met from production and inventory and subcontracting is a lost sale which is accounted for at $84/unit.

Compute the levels of ending inventory, subcontracting, and lost sales for the four quarters. Then compute the total cost. For level production, the production level is computed as: (Total Demand - Initial Inventory)/number periods.

Quarter	Demand	Production	Ending Inventory	Subcontract	Lost Sales
Prior			120
Q1	320
Q2	160
Q3	640
Q4	960

What is the total of the quarterly ending inventory levels for the year? 1380 What is the total of the quarterly subcontracted levels for the year? 0 What is the total of the quarterly lost sale levels for the year? 0 What is the total cost for the year? 100620

Can you show how they got those answers (which are correct). Can you show how they got it in a excel sheet with the excel formulas as well?