$10$

$10$

points

${}_{\text{e}\text{B}\text{o}\text{o}\text{k}}$

References

b$.$ Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $$4$ per engine per month. Backlog cost is $$135$ per engine per month. There should not be a backlog in the last month. Set regular production equal to the monthly average of total forecasted demand. Assume that using overtime is not an option. $($Negative amounts should be indicated by a minus sign. Leave no cells blank $-$ be certain to enter $"0"$ wherever required. Round average inventory row, Inventory cost row, and Total row values to $1$ decimal.$)$

$\backslash$table$[[$Period$,1,2,3,4,5,6,7,8,$Total$],[$Forecast$,96,135,143,165,125,125,140,143,1,072],[$Output$],[$Regular$,134,134,134,134,134,134,134,134,1,072],[$Output $-$ Forecast,$38,-1,-9,-31,9,9,-6,-9,],[$Inventory$],[$Beginning$,0,38,37,28,(3),6,0,(9),],[$Ending$,38,37,28,(3),6,0,(9),0,],[$Average$,19\mathrm{.}0,37\mathrm{.}50,32\mathrm{.}5,12\mathrm{.}5,1\mathrm{.}5,3\mathrm{.}0,(4\mathrm{.}5),(4\mathrm{.}50),],[$Backlog$],[$Costs$],[$Output$],[$Regular$],[$Inventory$],[$Backorder$],[$Total$,,,,,,,,,]]$