can you do it on excel

I need the steps

1 5/5 points A company that uses a level output strategy for production has the forecast below. They currently produce 400 unit per period using regular time. Regular time costs $25 per unit. Carrying inventory costs $2 per unit and a backlog costs $8 per unit. . Period 1 2 Forecast 250 25 What is the total production cost for this plan? 62,100 2 5/5 points A company that uses a level output strategy for production has the forecast below. Regular time costs $25 per unit. Carrying inventory costs $2 per unit and a backlog costs $8 per unit. Period 1 N 2 Forecast 250 25 If the company reduces regular production to 375 unit and schedules 75 units of overtime when a shortfall is forecasted, what it the new cost of this plan? Overtime costs $40 per units. 64,100 1973 pm A company that uses a level output strategy for production has the forecast below. They currently produce 400 unit per period using regular time. Regular time costs $25 per unit. Carrying inventory costs $2 per unit and a backlog costs $8 per unit. Period 2 3 5 Total 4 6 250 250 450 500 600 350 2400 Forecast What is the total production cost for this plan? 62,100 A company that uses a level output strategy for production has the forecast below. Regular time costs $25 per unit. Carrying inventory costs $2 per unit and a backlog costs $8 per unit. Period 2 3 5 6 Total Forecast 250 250 450 500 600 350 2400 If the company reduces regular production to 375 unit and schedules 75 units of overtime when a shortfall is forecasted, what it the new cost of this plan? Overtime costs $40 per units. 64,100 A company that uses a level output strategy for production has the forecast below. They currently produce 400 unit per period using regular time. Regular time costs $25 per unit. Carrying inventory costs $2 per unit and a backlog costs $8 per unit. Period 2 3 4 5 6 Total 250 250 450 500 600 350 2400 Forecast What is the total production cost for this plan? 62.100 2 3/5 points A company that uses a level output strategy for production has the forecast below. Regular time costs $25 per unit. Carrying inventory costs $2 per unit and a backlog costs $8 per unit. Period 2 3 5 6 Total Forecast 250 250 450 500 600 350 2400 If the company reduces regular production to 375 unit and schedules 75 units of overtime when a shortfall is forecasted, what it the new cost of this plan? Overtime costs $40 per units. 64,100