Optimal Product Mix
Ideal vs Real World
-
Ideal World:
- Unlimited resources
- Equal contribution margins
- All customer orders accepted
-
Real World:
- Resources are limited
- Products require different resource quantities
- Contribution margins vary
- We must optimize the product mix for profit
Example Scenario
Machine Constraint
- Total Machine Time Available: 600 hours/month
- Cooling Time: 4 hours/day โ not available for production
- Products: X and Y
Product | Machine Hours per Unit | Contribution per Unit | Contribution per Machine Hour |
---|---|---|---|
X | 2 hours | โน100 | โน50 (100 รท 2) |
Y | 3 hours | โน135 | โน45 (135 รท 3) |
โก๏ธ Product X is preferred (higher contribution per hour)
Constraints
Constraint Type | Product X | Product Y |
---|---|---|
Minimum Units | 50 units | 40 units |
Maximum Units | 200 units | No limit |
Machine Time Req. | 100 hours | 120 hours |
- Time used for minimum production = 220 hours
- Time left for allocation = 600 - 220 = 380 hours
Optimal Allocation Strategy
-
Prioritize Product X due to higher efficiency
- Max additional units of X = 150 (200 max - 50 min)
- Time needed = 150 ร 2 = 300 hours
- Remaining time = 380 - 300 = 80 hours
- Product Y uses 3 hours per unit โ can produce โ 27 units
Final Product Mix
Product | Base Qty | Extra Qty | Total Units | Total Time Used |
---|---|---|---|---|
Product X | 50 | 150 | 200 | 400 hours |
Product Y | 40 | 27 | 67 | 201 hours |
Total Time Used | ~601 hours (rounding effect) |
Key Learning: Contribution Per Unit of Constraint
- When machine hours are limited โ compute โน per machine hour
- When labour hours are limited โ compute โน per labour hour
- When raw materials are limited โ compute โน per unit of raw material
๐ Conclusion
- Use marginal costing + constraints to guide production decisions
- Always respect minimum/maximum limits
- Prioritize products that give highest contribution per constraint
- This is a basic form of linear programming, useful in:
- Capacity planning
- Short-term profit maximization
- Decision-making under limited resources