Consider the Following Data That Illustrates Demand,production Costs,and Expected Capacity

Essay

Consider the following data that illustrates demand,production costs,and expected capacity for a given product.

$\begin{array}{lllll} &&\text { Month }\\& 1 &2 &3&4 \\\text { Demand (units) } & 100 & 125 & 200 & 175 \\\text { Production cost/Unit } & \$ 20 & \$ 25 & \$ 30 & \$ 35 \\\text { Production Capacity (units) } & 150 & 150 & 150 & 150\end{array}$ .

Inventory carrying costs are estimated at $4 per unit per month.The firm wants to produce at least 50 units per month to uniformly utilize its existing resources.Assume that beginning inventory is zero.Use Excel to formulate and solve this problem to determine how many units of the product should be produced monthly to meet the expected demand at minimal cost.