Question: DE F G M N O H J L Using Solver to Optimize Location for Steel Appliances 1. Using Data Analysis Solver, solve the model

DE F G M N O H J L Using Solver to Optimize

DE F G M N O H J L Using Solver to Optimize Location for Steel Appliances 1. Using Data Analysis Solver, solve the model to obtain location of facility represented by pink dot in chart below. D. 2. Change tonnage from St. Lous in Cell D7 to 1,700. How do you expect location of facility to change? Try using Solver. S/Ton Mile Tons F 0.90 500 0.95 300 0.85 700 1.50 225 1.50 150 1.50 250 1.50 175 1.50 300 A B 1 Steel Appliances 2 3 Sources/ 4 Markets 5 Buffalo 6 Sources Memphis 7 St. Louis 8 Atlanta 9 Boston 10 Markets Jacksonville 11 Philadelphia 12 New York 13 14 Facility Location 15 16 681.3 17 882.0 18 $ 1,265,235 20 21 22 2 23 24 25 26 27 Coordinates y. d. 700 1200319 250 600 515 225 825 460 600 500 391 1050 1200 487 800 300 594 925 975 261 1000 1080375 681.3 882 3. Change tonnage from St. Lous in Cell D7 to 2,700. How do you expect location of facility to change? Try using Solver. 1400 1200 A Buffalo Boston New York Philadelphia 1000 800 St. Louis > 19 Costs 600 Memphis Atlanta 400 Jacksonville 200 0 0 200 400 600 800 1000 1200 28 29 30 31 32 Question 22 2 points Save Answer Open the "Steel Appliances.xlsx" Excel file (under Module 6). Select the "Complete" worksheet. Change the demand in Jacksonville to 500 tons. Solve the model by Solver to obtain the optimal location of the facility. What is the distance between the new optimal facility location and Boston? 0241 O 475 O 551 O 577

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!

For LaForge Systems, whose financial statements are given in Problem 2, show the adjustments from the current levels of CFO (which is $427 million), EBIT ($605 million), and EBITDA ($785 million) to...

Question 1 15 pts Refer to The Capacitated Plant Location Model starting on Page 118 in your book, includes Figures 5-4 to 5-7. 1. List and describe each decision variable (2 pts). 2. List and...

Using Solver to Optimize Location for Steel Appliances I. Lsing Data | Analysis / Solver, solve the model to obtain x and y cwertinates. 2. Cnange tannage from Sit. Laus in Ceil DT to 1,500. How do...

I don't understand how to do this. Please explain using linear programming! Using Solver to Optimize Location for Steel Appliances 1. Using Data | Analysis | Solver, solve the model to obtain...

Questions: 1. Identify the key criteria and considerations that need to be taken into account in evaluating BFSI entry in the proposed foreign markets. 2. Of the countries under consideration, which...

included a clearer image answer to second comment: the required part is the 22 steps assessment based on the excel workbook information provided A1 f Scholarship Dinner B C D E F H | J K L M...

Rename the Excel file in the following way: Lastname_firstname_AGEC 3413_Fall 22_HW 4" while submitting. For question # 2 you need to use a word file. The word file should be named in the following...

provide 3 concepts ideas or issues you think are most importanf amd why (using the articpes) then probide 2 examples of how you might use thess concepts or ideas in the future (if not applicable to...

need a formulas to solve using excel - J K L M N 0 P Q R S 7 0 TOTAL 15 points 0 Table 1 3 points 0 Table2 3 points 0 Table 3 4 points O Table 45 points I prefer that you put all of the pivot tables...

DE D E F G H 1 J P L M N o Using Solver to Optimize Location for Steel Appliances 1. Using Data Analysis | Solver, solve the model to obtain location of facility represented by pink dot in chart...

Solving Two-stage Robust Optimization Problems by A Constraint-and-Column Generation Method Bo Zeng Department of Industrial and Management Systems Engineering University of South Florida, Email:...

Refer to problem 52. Guadalupe sells the building on October 26, 2011. What is her 2011 depreciation deduction if she purchased the building on a. June 30, 1992? b. June 30, 1994?

The Small Business Job Protection Act of 1996 limited the exclusion for damages received to nonpunitive damages received on account of a personal physical injury or physical sickness. The law...

6. Inventory with a cost of 7,000 was salvaged and sold for 3,500. The balance of the inventory was a total loss. Instructions Prepare a schedule computing the amount of inventory fire loss. The...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...