Question: INSTRUCTIONS: Use Solver to determine the optimal method to ship products from the factories to the distribution centers. Your solution should minimize costs, subject to

INSTRUCTIONS:

Use Solver to determine the optimal method to ship products from the factories to the distribution centers. Your solution should minimize costs, subject to the following constraints:

Demand for each distribution center must be met
Each factory has an initial inventory. You cannot ship more than that initial inventory from each factory.
Only whole cases may be shipped.

INSTRUCTIONS: Use Solver to determine the optimal

A B D E F G . J K L 1 Broadway Cafe Shipping Analysis 2 3 Plant Shipping Costs (per Case) Plant Number of Cases Shipped Total Number of Cases Shipped Denver Cheyenne Austin Total Cost Demand 180 110 170 160 220 Denver $8.00 $9.00 $5.00 $6.00 $4.00 Cheyenne $6.00 $4.00 $3.00 $4.00 $5.00 Austin $4.00 $8.00 $7.00 $7.00 $6.00 $ 310 260 280 850 4 Distribution Center 5 Santa Fe 6 Portland 7 Albuquerque 8 Helena 9 Phoenix 10 Total 11 12 Initial Inventory 13 Remaining Inventory 14 15 Constraints 16 17 18 Total Shipped 19 20 21 22 23 24 Number Shipped 25 26 27 28 >= Demand

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

My excel doesn't work please help TZ Edge - Golf Club Distribution Plan Plant Shipping Costs (per Case) Plant Number of Cases Shipped Demand Distribution Center Atlanta Baltimore Boise Dallas Denver...

1. General Appliance Corporation- adapted from Business Analytics by J. R. Evans (20 pts) General Appliance Corporation (GAC) produces refrigerators at two plants: Marietta, Georgia and Minneapolis...

General Appliance Corporation (GAC) produces refrigerators at two plants: Marietta, Georgia and Minneapolis Minnesota. These plants have corresponding capacities of 1200 and 800 refrigerators...

Vehicle Routing at Otto's Discount Brigade," from the textbook. Disregard the section titled, "Challenge for the Logistic Manager." You will use the "Supply Chain Analytics Case Study Data" and...

Use the following problem statement to answer questions 1-6. The LMN Company is a distributor of products. The network model below shows the shipping costs, supply, demand, and shipment routes...

Can I get the solved version with screenshots for better understanding. Using the Solver add-in in Microsoft Excel, the "Supply Chain Analytics Case Study Template," run a linear optimization...

Using the Solver add-in in Microsoft Excel, the "Supply Chain Analytics Case Study Template," run a linear optimization analysis to determine the optimal number of shipments from each of the four...

i need the model TE 33150 Operations Research Lab Lab 7 Instructions: Model the following problem and submit your LP on Monday 11/5/2020 at 11:55 Start your code before your lab session and utilize...

Discussion Questions for Crystal View Incorporated Case:(45points)Write-up for Crystal View Inc.should be turned in by the end of October 8(11:59 pm, Oct 8).This is a group exercise. Consider the...

You work as an operations consultant for a textile company. Your client has a well-established distribution system in the US market. The company has hundreds of stores and four distribution centers....

Pevnick Inc. began operations as a detective agency on January 1, 2015. The trial balance columns of the worksheet for Pevnick Inc. at March 31 are as follows. Other data: 1. Supplies on hand total...

A single-phase induction motor has a power factor of 0.8 lagging and an input apparent power of 5 kVA. If the line voltage is 220 volts, what is the input current in amps?

Insurance experts have estimated that extra costs of up to blank a year may be required to replace the services of a homemaker in a family with small children. $ 6 , 0 0 0 $ 1 5 , 0 0 0 $ 3 , 0 0 0 $...

Hopkins Chocolate Company buys green cocoa beans that are processed into consumer products. Cocoa beans are currently selling for $2,000 United States Dollars (USD) per metric ton. Hopkins buys 100...