In: Math
A company wants to ship products from Jefferson City and Omaha to Des Moines, Kansas City or St. Louis.
In the table below you see shipping costs and supply and demand amounts.
How do you set this up in Excel through the Solver? Please show the steps. Thanks!
From to | Des Moines | Kansas City | St. Louis | Supply |
---|---|---|---|---|
Jefferson City | 14 | 9 | 7 | 30 |
Omaha | 8 | 10 | 5 | 20 |
Demand | 25 | 15 | 10 |
all represented in pictures step by step, type each:
first add in solver:FILE> options> add-ins>Go,> Solver-add in> look Data tab in excel
for the problem:
step 1:
write like this: in the second table in each city we want to move atleast one product so 1 for each cell. sum in the end sum formula in formula bar
step 2: sumproduct of costs and items which should be minimised for cost effective results. sumproduct formula notice in the formula bar
step 3: go to data> solver> then > do the following by selecting cells , click min and click add for 2 constraints by equaling cell references and constraints, demands equals demands for both the tables and supplies for same.
notice all the cell numbers carefully for the procedure and no mistakes:
step 4:
click solve: and ok to get the required answer , in tabular form in which city the items to be shipped respectively for less cost