Could you also post any equations used so I can recreate this same spreadsheet.

Fairways Woods Company Shipping Analysis Shipping Costs per route Now York Fairway Inc. makes custom gof clubs. They are manufactured in 3 plants in Denver Phoenx, and Dallas They are then shippod to distribution centers in Sacramento, Sait Lake, Chicago, Albuquene, and Now York. Since shipping costs are a major expense, man determine the opomal shipping routes and 260 quires an analysis to ship from plant to warehouse. shipped along those Each plant has a maximum product capa ity and each distribution You mu Sacramemo Salt Lake Chica Albec New York Total Smipped Denver conter has a demand that must be satised clubs to send along each route, staying w demand, for the laowest totsl shipping cost 1 determine how many pacity, meeing Tohal Shipping Coat Minimize totsl shipping costs (green cel) How many to ship from eech plant to each warehouse. (yolow cels) Number to ship cannof be less man zero Total number shipped from each plant cnnot excood the plants capscty. Toral number shipped to oach warehouse must be equan to ar grealer than demand Use the SUM and SUMPROoCT funcions, and Salver to ind the aptimal solutlion Decisions Consiraints: Hints: AYK. 17 Shipping Costs+ Fairways Woods Company Shipping Analysis Shipping Costs per route Now York Fairway Inc. makes custom gof clubs. They are manufactured in 3 plants in Denver Phoenx, and Dallas They are then shippod to distribution centers in Sacramento, Sait Lake, Chicago, Albuquene, and Now York. Since shipping costs are a major expense, man determine the opomal shipping routes and 260 quires an analysis to ship from plant to warehouse. shipped along those Each plant has a maximum product capa ity and each distribution You mu Sacramemo Salt Lake Chica Albec New York Total Smipped Denver conter has a demand that must be satised clubs to send along each route, staying w demand, for the laowest totsl shipping cost 1 determine how many pacity, meeing Tohal Shipping Coat Minimize totsl shipping costs (green cel) How many to ship from eech plant to each warehouse. (yolow cels) Number to ship cannof be less man zero Total number shipped from each plant cnnot excood the plants capscty. Toral number shipped to oach warehouse must be equan to ar grealer than demand Use the SUM and SUMPROoCT funcions, and Salver to ind the aptimal solutlion Decisions Consiraints: Hints: AYK. 17 Shipping Costs+