please show how it is worked on excel

3. Kosar Manufacturing has collected the following information on one of its major products. Most efficient production rate =2023 units per period Production change costs =$25 per unit of change (from the most efficient production rate =2,077 units/perio X=27 Inventory costs =$6 per unit per period (on closing inventory balance) Backorder costs =$12 per unit to carry demand into next period Beginning inventory =54 units Calculate a level production schedule that yields X inventory at the end of period 6. What is the total cost of this solution? What is the total inventory cost of this solution? (25 points)