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...
(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...
The City Council wants to gather input from residents about the recreational opportunities in the city....
The City Council wants to gather input from residents about the recreational opportunities in the city. Categorize each technique as simple random sample, stratified sample, systematic sample, cluster sample, or convenience sample. a) Get an alphabetical list of all residents and question every 250th resident on the list. b) Have 10 volunteers go downtown on Saturday afternoon and question people that they see. The volunteers may quit when they have questioned 25 people. c) Get an alphabetical list of all...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT