<tbody>
[TD="class: xl76"]Budget[/TD]
[TD="class: xl78"]4,000,000[/TD]
[TD="class: xl69, width: 87"][/TD]
[TD="class: xl73, width: 98"][/TD]
[TD="width: 97"][/TD]
[TD="width: 90"][/TD]
[TD="width: 87"][/TD]
[TD="class: xl76"]Maintenance[/TD]
[TD="class: xl78"]120,000[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl71"]Model[/TD]
[TD="class: xl74"]Ratio[/TD]
[TD="class: xl72"]Cost[/TD]
[TD="class: xl74"]Maintenance[/TD]
[TD="class: xl71"]Unit Output[/TD]
[TD="class: xl68"]F300[/TD]
[TD="class: xl77"]1[/TD]
[TD="class: xl70"]350,000[/TD]
[TD="class: xl75"]12,000[/TD]
[TD="class: xl67"]125[/TD]
[TD="class: xl68"]S250[/TD]
[TD="class: xl77"]3[/TD]
[TD="class: xl70"]660,000[/TD]
[TD="class: xl75"]22,500[/TD]
[TD="class: xl67"]243[/TD]
[TD="class: xl68"]TOTAL
[/TD]
[TD="class: xl78"]4[/TD]
[TD="class: xl78"]1,010,000[/TD]
[TD="class: xl78"]34,500[/TD]
[TD="class: xl78"]368
[/TD]
</tbody>
| 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>
[TD="class: xl68, width: 181, colspan: 2"]Documentation[/TD]
[TD="width: 87"][/TD]
[TD="width: 98"][/TD]
[TD="width: 97"][/TD]
[TD="class: xl69"]Ratio[/TD]
[TD="class: xl70"]C7:C8[/TD]
[TD="class: xl71"] Input : 3*C7[/TD]
[TD="class: xl69"]Cost[/TD]
[TD="class: xl70"]D7:D8
[/TD]
[TD="class: xl71"] Input : D7*C8
[/TD]
[TD="class: xl69"]Maintenance[/TD]
[TD="class: xl70"]E7:E8[/TD]
[TD="class: xl71, colspan: 2"] Input*C7 : Input*C8[/TD]
[TD="class: xl69"]Unit Output[/TD]
[TD="class: xl70"]F7:F8[/TD]
[TD="class: xl71, colspan: 2"] Input*C7 : Input*C8[/TD]
[TD="class: xl68, colspan: 2"]
Documentation(2)
[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="colspan: 2"]Use Solver to maximize C9[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="colspan: 2"]by changing D9:F9[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
</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.
