a Please refer to the excel file tab question 9 and calculate the cost of inventory and backorders using a level production plan. In the level production plan backorders are allowed but for each unfilled order, it costs the company $10/unit. The employees work an 8 hour day and overtime is not allowed. Please find the data and all the inputs in the excel sheet. Show your work on the excel file, $700 $1350 $700, $750 total Period 1 240 Period 2 235 Period 3 265 Period 4 220 Period 5 220 Period 6 260 level Demand 6 240 235 Period 1 Period 2 Period 3 Period 4 Period 5 Period 6 265 cumulative demand production per period cumulative production inventory back-orders Initial Employees Capacity/employed Hourly cost/emplo Inventory Holding Shortage Cost Hiring Cost Firing Cost 220 40 $18 $20 $10 $230 $190 220 260 inventory holding cost back-order cost total cost a Please refer to the excel file tab question 9 and calculate the cost of inventory and backorders using a level production plan. In the level production plan backorders are allowed but for each unfilled order, it costs the company $10/unit. The employees work an 8 hour day and overtime is not allowed. Please find the data and all the inputs in the excel sheet. Show your work on the excel file, $700 $1350 $700, $750 total Period 1 240 Period 2 235 Period 3 265 Period 4 220 Period 5 220 Period 6 260 level Demand 6 240 235 Period 1 Period 2 Period 3 Period 4 Period 5 Period 6 265 cumulative demand production per period cumulative production inventory back-orders Initial Employees Capacity/employed Hourly cost/emplo Inventory Holding Shortage Cost Hiring Cost Firing Cost 220 40 $18 $20 $10 $230 $190 220 260 inventory holding cost back-order cost total cost