PLEASE USE EXCEL, X$=39$ AND SHOW FORMULAS Kosar Manufacturing has collected the following information on one of its major

products.

Most efficient production rate $=(2,050+x)$ units per period

Production change costs $=$$$28$ per unit of change $($from the most efficient production rate

$=2,050+x$ units$/$period$)$

Inventory costs $=$$$7$ per unit per period $($on closing inventory balance$)$

Backorder costs $=$$$15$ per unit to carry demand into next period

Beginning inventory $="x**2"$ units

Calculate a level production schedule that yields $x$ inventory at the end period $6.$

What is the total cost of this solution? What is the total inventory cost of this solution?

$(25$ points$)$