Question

Please include step by step instructions or spreadsheet

A company buys liquid material for its three manufacturing facilities from several suppliers.

Facility K requires 71,000 gallons of liquid material per month,

Facility L requires 75,000 gallons of liquid material per month, and

Facility M requires 82,000 gallons of liquid material per month.

Supplier W charges $14.60 per gallon and can supply up to 58,000 gallons per month,

Supplier Y charges $12.65 per gallon and can supply up to 40,000 gallons per month, and

Supplier Z charges $13.55 per gallon and can supply up to 62,000 gallons per month.

The company must also pay shipping costs to suppliers.

The shipping costs per gallon ($/gal) from suppliers to manufacturing facilities are shown below.

From          Facility     Facility   Facility

Supplier         K              L               M

W                  2.80         3.40         2.45

X                   2.45        2.83        1.99

Y                    2.30         3.20        2.18

Z                    3.15         3.25        3.48

Determine the best supplier selection for the company.

Answer the following questions using the optimal solution.

Supplier W should send    thousand gallons every month to facility K

Supplier X should send      thousand gallons every month to facility K

Supplier Y should send      thousand gallons every month to facility K

Supplier Z should send      thousand gallons every month to facility K

Supplier W should send      thousand gallons every month to facility L

Supplier X should send      thousand gallons every month to facility L

Supplier Y should send ??     thousand gallons every month to facility L

Supplier Z should send ??     thousand gallons every month to facility L

Supplier W should send ?? thousand gallons every month to facility M

Supplier X should send ?? thousand gallons every month to facility M

Supplier Y should send ??    thousand gallons every month to facility M

Supplier Z should send ??    thousand gallons every month to facility M

The total monthly costs for the company is $ ??

Answer 1

Please leave a like. Thank you.