Skip to main content

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
ProductMachine Hours per UnitContribution per UnitContribution per Machine Hour
X2 hoursโ‚น100โ‚น50 (100 รท 2)
Y3 hoursโ‚น135โ‚น45 (135 รท 3)

โžก๏ธ Product X is preferred (higher contribution per hour)


Constraints

Constraint TypeProduct XProduct Y
Minimum Units50 units40 units
Maximum Units200 unitsNo limit
Machine Time Req.100 hours120 hours
  • Time used for minimum production = 220 hours
  • Time left for allocation = 600 - 220 = 380 hours

Optimal Allocation Strategy

  1. Prioritize Product X due to higher efficiency
    • Max additional units of X = 150 (200 max - 50 min)
    • Time needed = 150 ร— 2 = 300 hours
  2. Remaining time = 380 - 300 = 80 hours
    • Product Y uses 3 hours per unit โ†’ can produce โ‰ˆ 27 units

Final Product Mix

ProductBase QtyExtra QtyTotal UnitsTotal Time Used
Product X50150200400 hours
Product Y402767201 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