Could u additionally show the equations used so ican recreate this on my spread sheet i need work plus answer.

nsert Page Layout Formulas DataReview View +Share T Wrap Test General Delete Merge & Cerner. $, % , .0.00 Conditional Format Col Sort & Farmatting as Teble Styles Formt rways Woods Company Shipping Analysis Shipping Costs per route Fairway Inc. makes custom golf clubs. They are manufactured in 3 plants in Denver, Phoerix, and Dalss. They are then shipped to distribution certers in Sacramanto, Salt Lake, Chicago, Albuquerque, and New York. Since shipping costs are a major expense, management requires an analysis to determine the opsmal shipping roubes and quantries shipped along those routes. Each plant has a maximum production capacity and esch distribution center has a demand that must be satisfied. You must dlebermine how many clubs to send along each route, staying wahin piant capecity, meeting demand, for the lowest total shipping cost Denver Phoenix Dallas ship from plant to Plants Denver Phoonb Dalias Sat Laka Chicago A Objective: Decisions: Constraints: Minimize total shipping costs. fgreen cel) How many to ship from each plant to ech worehouse. (veslow cels) Number to ship cannot be less than zevro. Total number shippod from each plant canmot exceed the plant's capacity Tolai number shipped to esch warehouse must bo oqual to or greater than demand. Use the SUM and SUMPRODUCT functions and Saver to fnd the optimal solution. Ar 17 | Shipping Costs nsert Page Layout Formulas DataReview View +Share T Wrap Test General Delete Merge & Cerner. $, % , .0.00 Conditional Format Col Sort & Farmatting as Teble Styles Formt rways Woods Company Shipping Analysis Shipping Costs per route Fairway Inc. makes custom golf clubs. They are manufactured in 3 plants in Denver, Phoerix, and Dalss. They are then shipped to distribution certers in Sacramanto, Salt Lake, Chicago, Albuquerque, and New York. Since shipping costs are a major expense, management requires an analysis to determine the opsmal shipping roubes and quantries shipped along those routes. Each plant has a maximum production capacity and esch distribution center has a demand that must be satisfied. You must dlebermine how many clubs to send along each route, staying wahin piant capecity, meeting demand, for the lowest total shipping cost Denver Phoenix Dallas ship from plant to Plants Denver Phoonb Dalias Sat Laka Chicago A Objective: Decisions: Constraints: Minimize total shipping costs. fgreen cel) How many to ship from each plant to ech worehouse. (veslow cels) Number to ship cannot be less than zevro. Total number shippod from each plant canmot exceed the plant's capacity Tolai number shipped to esch warehouse must bo oqual to or greater than demand. Use the SUM and SUMPRODUCT functions and Saver to fnd the optimal solution. Ar 17 | Shipping Costs