9

A company is planning production for the next 4 months. They want to minimize the cost of production. The production cost is stable but demand and production capacity vary from month to month. The maximum amount of inventory which can be held is 12,000 units and management wants to keep at least 3,000 units on hand. Monthly inventory holding cost is 3% of the cost of production. The company estamater the number of units carried in inventory each month by averaging the beginning and ending inventory for each month There are currently 5000 units in inventory. The company wants to produce at no less than one half of its maximum capacity in any month. \begin{tabular}{|c|c|c|c|c|c|} \hline 8 & Minimum Production & 4,000 & 3,500 & 4,000 & 4,500 \\ \hline 9 & Maximum Production & 8,000 & 7,000 & 8,000 & 9,000 \\ \hline 10 & & & & & \\ \hline 11 & & & \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline 11 & Minimum Inventory & 3,000 & 3,000 & 3,000 & 3,000 \\ \hline 12 & Maximum Inventory & 12,000 & 12,000 & 12,000 & 12,000 \\ \hline 13 & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline 14 & Unit Production Cost & $300 & $300 & $300 & $300 \\ \hline 15 & Unit Carrying Cost & $9 & $9 & $9 & $9 \\ \hline \end{tabular} 16 17 Monthly Production Cost 18 Monthly Carrying Cost Total Cost S What formula should be entered in cell D17 to compute the monthly production costs? =D3D14=D4D14=D6D14=D5D14