Question

SOLVE USING SOLVER IN EXCEL: Demand for each of the 3 warehouses has increased by 1000...

SOLVE USING SOLVER IN EXCEL:

  1. Demand for each of the 3 warehouses has increased by 1000 cases per week. To meet this increased demand, an additional factory needs to be built with a capacity of 3000 cases per week. The two potential locations being considered are Memphis and San Francisco. The cost per case to ship between these locations and the warehouses are as follows:

Factories

Orlando

Dallas

Los Angeles

Memphis

6

4

12

San Francisco

13

8

5

Which location should the new factory be located, in order minimize the total cost? Give the total cost and your new shipping pattern. (10 points)

Location of the new factory                          

Total Cost =                          

Your shipping pattern:

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

The solution USING SOLVER IN EXCEL is:

Orlando Dallas Los Angeles Supply
Memphis 6 4 12 3000
San Francisco 13 8 5 3000
Demand 1000 1000 1000
Orlando Dallas Los Angeles Supply
Memphis 1000 1000 0 2000 3000
San Francisco 0 0 1000 1000 3000
1000 1000 1000
Demand 1000 1000 1000
Cost 15000

Location of the new factory = Memphis   

Total Cost = 15000

Your shipping pattern:

Orlando Dallas Los Angeles
Memphis 1000 1000 0
San Francisco 0 0 1000
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Widgetco manufactures widgets at two factories, one in Memphis and one in Denver. The Memphis factory...
Widgetco manufactures widgets at two factories, one in Memphis and one in Denver. The Memphis factory can produce as many as 150 widgets per day, and the Denver factory can produce as many as 110 widgets per day. Widgets are shipped by air to customers in Los Angeles and Boston. The customers in each city require 130 widgets per day. Because of the deregulation of airfares, Widgetco believes that it may be cheaper to first fly some widgets to New...
DryIce, Inc., is a manufacturer of air conditioners. The company anticipates nationwide demand for the next...
DryIce, Inc., is a manufacturer of air conditioners. The company anticipates nationwide demand for the next year to be 180,000 units in the South, 120,000 units in the Midwest, 110,000 units in the East, and 100,000 units in the West. Managers at DryIce are designing the manufacturing network and have selected four potential sites --- New York, Atlanta, Chicago and San Diego. Plants could have a capacity of 200,000 units. The annual fixed costs at the four locations are shown...
The Pineapple Company produces ice-cream at its factories in Kobe, Nagoya, and Sendai. These factories have...
The Pineapple Company produces ice-cream at its factories in Kobe, Nagoya, and Sendai. These factories have not been able to keep up with demand for orders at Pineapple’s four warehouses in Tokyo, Osaka, Fukuoka, and Sapporo. As a result, the company has decided to build a new factory to expand its production capacity. The two locations being considered are Kumamoto and Hiroshima. We are given information regarding the monthly demands at the four warehouses. Warehouse Monthly Demand (Litres) Tokyo 15,000...
This file contains data on the crime rates (total and violent) and population. Using Excel or...
This file contains data on the crime rates (total and violent) and population. Using Excel or other software of your choice, for each of the following pairs make a ScatterPlot then determine the Correlation Coefficient: (3pts) Crime Rate and Population (3pts) Violent Crime Rate and Population (3pts) Crime Rate and Population Density (that’s the Number of people Per square mile – Hint: You need to compute this last one on your own using data in the table.) Copy and paste...
In your Using MS Excel in Logistics Activities assignment, enter the data provided in the scenario...
In your Using MS Excel in Logistics Activities assignment, enter the data provided in the scenario into a simple Microsoft Excel spreadsheet. In your spreadsheet, Calculate the total volume of the products. Calculate the total weight of the products. Calculate the total weight of the shipment (ignore the shelving). Determine the number of 40-ft containers required to ship the order. Calculate the total shipping cost from the Dell plant to the Oracle campus. For this Assignment, You must use MS...
CASE STUDY – Jacobson Carpet Company In January 2002, Ms. Mary Lewis was preparing to meet...
CASE STUDY – Jacobson Carpet Company In January 2002, Ms. Mary Lewis was preparing to meet with Mr. Carpenter, President of Jacobson Carpet Company. Ms. Lewis assumed that the meeting was related to the recent Board of directors of the company. As a direct assistant to the President, she knew from experience that this type of meeting often resulted in a project to be studied. Her expectation was confirmed as soon as Mr. Carpenter began to inform her of the...
Total utility can be objectively measured in numbers that indicate usefulness or benefit to the consumer....
Total utility can be objectively measured in numbers that indicate usefulness or benefit to the consumer. ____ 2. Consumers should purchase quantities of a good to the point where MU > P. ____ 3. Voluntary exchange requires that there must be mutual gain. ____ 4. Points along a budget line represent the maximum combinations of two commodities that a consumer can afford. ____ 5. The budget line represents a consumer's preferences for a commodity. ____ 6. A change in consumer...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
Department of Management Information Systems, Operations Management and Decision Sciences, University of Dayton, Dayton, Ohio 45419,...
Department of Management Information Systems, Operations Management and Decision Sciences, University of Dayton, Dayton, Ohio 45419, [email protected] Hub Group, a North American intermodal freight rail transportation company, developed an integrated produc- tion decision support system to improve its yield management and container allocation. The system combines a suite of analytical tools, including forecasting, error distribution analysis, expected value-based heuristics, and optimization tools to improve the decision making of Hub's frontline employees. It is important to note that the production decision...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT