Question: ******USING EXCEL SOLVER - determine how much O- and D-Type Fuel (in pounds) John needs, and his total cost!********** John owns a shipping company and

******USING EXCEL SOLVER - determine how much O- and D-Type Fuel (in pounds) John needs, and his total cost!**********

John owns a shipping company and is looking to minimize how much he spends on fuel. He needs at least 10000 pounds of fuel per day, and his trucks operate on a special mixture of O-Type Fuel and D-Type Fuel.

The truck's fuel must contain at least 60 units of hydrogen per pound of fuel mix and at most 9 units of oxygen per pound of fuel mix to operate. The oxygen/hydrogen concentration and cost for O-Type Fuel and D-Type Fuel are as follows:

Fuel Type Hydrogen Concentration Oxygen Concentration Cost
O-Type Fuel 45 units per pound 15 units per pound $1.05 per pound
D-Type Fuel 90 units per pound 6 units per pound $1.34 per pound

John must determine how much O-Type Fuel and D-Type Fuel he should mix, in pounds, to minimize his cost of fuel per day.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!