A manufacturer produces printers at plants in New Orleans, Albuquerque, and Nashville. These are sent to regional distributors in Jacksonville, Boise, and Charlotte. The shipping costs vary, and the company would like to find the least-cost way to meet the demands at each of the distribution centers.

Jacksonville needs to receive 750 printers per month, Boise needs 650, and Charlotte needs 250. New Orleans has 800 printers available each month, Albuquerque has 500, and Nashville has 350.

The shipping cost per unit from New Orleans to Jacksonville is $8, to Boise is $12, and to Charlotte is $10. Due to truck capacity limits, no more than 50 printers can be shipped between New Orleans and Charlotte each month.

The cost per unit from Albuquerque to Jacksonville is $10, and to Charlotte is $9. Printers from Albuquerque are never shipped to Boise. The cost per unit from Nashville to Jacksonville is $11, to Boise is $8, and to Charlotte is $12.

a) Enter your model in Excel and use Solver to find the optimal distribution plan. Include your spreadsheet with your homework submission.

b) What is the optimal distribution plan?

c) What is the cost of the optimal distribution plan?