In: Accounting
firm need to produce the following number of units during the next three months; month 1, 200 units; month 2, 300 units; month 3, 300 units. For each unit produced during months 1 and 2, a $9 variable cost is incurred; for each unit produced during month 3, a $12 variable cost is incurred. The inventory cost is $2.50 for each unit in stock at the end of a month. The cost of setting up for production during a month is $250. Units made during a month may be used to meet demand for that month or next month only. Assume that production during each month must be a multiple of 100. Given that the initial inventory level is 0 units, use dynamic programming to determine an optimal production schedule
Given Information
Opening Inventory=0 units
Set up cost for Every Month= $250
Inventory Holding Cost =$2.5 per Unit
Variable cost per unit |
Production(Units) |
|
Month 1 |
$9 |
200 |
Month 2 |
$9 |
300 |
Month 3 |
$12 |
300 |
Case 1
Given
Set up cost for every month =$250
In this Case we just produce the required demand in their corresponding months.
Month 1 |
Month 2 |
Month 3 |
|
Demand |
200 |
300 |
300 |
Production |
200 |
300 |
300 |
Cost |
250 + 200*$9 =$2050/- |
250 + 300*$9 =$2950/- |
250 + 300*$12 =$3850/- |
Total cost = $2050+$2950+$3850 =$8850/-
Case 2:
Inventory Holding Cost =$2.5 per Unit
In this case as the production cost is $3 less in Month 2 we produce the demand of Month 3 in Month 2 itself.
Month 1 |
Month 2 |
Month 3 |
|
Demand |
200 |
300 |
300 |
Production |
200 |
300+300 =600 |
0 |
Cost |
250 + 200*9 =$2050/- |
250 + 600*9+2.5*300 =$6400/- |
0 |
Total cost = $2050+$6400=$8450/-
Conclusion:
We can see that Production cost in Case 2 is less than Case 1.
Hence the optimal production schedule is Case 2
PLEASE LIKE THIS ANSWER, IT HELPS ME A LOT. THANK YOU