Question

In: Math

A company wants to ship products from Jefferson City and Omaha to Des Moines, Kansas City...

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

Solutions

Expert Solution

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


Related Solutions

OFC Company of Kansas City prints business forms and other specialty paper products, such as writing...
OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2019 for the Business Services division are: Activity Cost Driver Budgeted Activity Cost-Driver Rate Storage Cartons in inventory 570,000 $ 0.6020 /carton/month Requisition...
OFC Company of Kansas City prints business forms and other specialty paper products, such as writing...
OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory-management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2016 for the Business Services division are:   Activity Cost Driver Budgeted Activity Cost-Driver Rate   Storage Cartons in inventory 520,000 $ 0.6320 /carton/month   Requisition handling...
A company has three factories in Chicago, Kansas City, and Houston where it produces its products...
A company has three factories in Chicago, Kansas City, and Houston where it produces its products and from where it can weekly supply its three distribution centers located in New York, Los Angeles, and Atlanta. The supply capacities at the three factories, the demand requirements at each of the three distribution centers, and the transportation costs in $ per ton from each factory to each distribution center are shown in the table below. Formulate a linear programming (LP) model of...
OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards.
  OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2019 for the Business Services division are: Activity Cost Driver Budgeted Activity Cost-Driver Rate Storage Cartons in inventory   600,000   $...
OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards.
OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2019 for the Business Services division are: Activity Cost Driver Budgeted Activity Cost-Driver Rate Storage Cartons in inventory 430,000 $ 0.5120 /carton/month Requisition...
Slick Oil Company has three warehouses from which it can ship products to any of three...
Slick Oil Company has three warehouses from which it can ship products to any of three retail outlets. The demand in cans for the product Gunkout is 320 at retail outlet 1; 350 at outlet 2; and 255 at outlet 3. The inventory (capacity) of Gunkout at warehouse A is 270; at warehouse B is 375; and at warehouse C is 390. The cost of transporting one unit of Gunkout from each warehouse to each retail outlet follows. Retailer Warehouse...
(a) A commercial 737 jet transporting 143 passengers and 5 crew members from Kansas City to...
(a) A commercial 737 jet transporting 143 passengers and 5 crew members from Kansas City to Baltimore burned 11,800 lbs. (about 1700 gallons) of Jet A fuel en route. Jet A fuel is kerosine based, consisting primarily of CnH2n+2 hydrocarbons, with n = 6 to 16, so the carbon: hydrogen ratio is close to 1:2. During this flight, how much CO2 was released into the atmosphere? Assume the combustion of the fuel was complete, so all the fuel was burned...
[The following information applies to the questions displayed below.] OFC Company of Kansas City prints business...
[The following information applies to the questions displayed below.] OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2019 for the Business Services division are: Activity Cost Driver Budgeted Activity Cost-Driver Rate...
Required information [The following information applies to the questions displayed below.] OFC Company of Kansas City...
Required information [The following information applies to the questions displayed below.] OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2019 for the Business Services division are: Activity Cost Driver Budgeted Activity...
1.  Greg flew from Kansas City to Boston on Thursday to attend business on Friday. He could...
1.  Greg flew from Kansas City to Boston on Thursday to attend business on Friday. He could have flown home Friday evening with no additional airfare. He stayed over Saturday through Monday to attend a sporting event and vis­it the historic sights. Greg paid airfare of $300, meals of $26 per day (after reduction to 50 percent) and lodging of $59 per day. Greg may deduct how much? 2. Shaoq is a very successful self-employed hair stylist who incurred the following...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT