Budget | 4,000,000 | |||||
Maintenance | 120,000 | |||||
Model | Ratio | Cost | Maintenance | Unit Output | ||
F300 | 1 | 350,000 | 12,000 | 125 | ||
S250 | 3 | 660,000 | 22,500 | 243 | ||
TOTAL | 4 | 1,010,000 | 34,500 | 368 |
<tbody>
</tbody>
Documentation | ||||
Ratio | C7:C8 | Input : 3*C7 | ||
Cost | D7:D8 | Input : D7*C8 | ||
Maintenance | E7:E8 | Input*C7 : Input*C8 | ||
Unit Output | F7:F8 | Input*C7 : Input*C8 | ||
Documentation(2) | ||||
Use Solver to maximize C9 | ||||
by changing D9:F9 | ||||
subject to | ||||
D9 ≤ C3 | ||||
E9 ≤ C4 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3401;width:70pt" width="93"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:3181;width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:3584;width:74pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:3547;width:73pt" width="97"> </colgroup><tbody>
</tbody>
I'm trying to get how many of each model to buy so daily production is maximised.
1) F300 model cost $350,000 & S250 cost $220,000
2) At least one third purchase should be F300
3) Maintenance for F300 is $12,000 & S250 is $7,500. Total maintenance budget is 120,000
4) F300 will produce 125 units & S250 will produce 81 units
Thanks.