Assignment 3: Solve the following problems and upload the solutions file (only PDF format) onto the Moodle (due date: Nov. 10th at 11:59 pm). Don Levine Corporation is considering adding an additional plant to its three existing facilities in Decatur, Minneapolis, and Carbondale. Both St. Louis and East St. Louis are being considered. Evaluating only the transportation costs per unit, as shown in the following tables, which site is better? Provide the mathematical model and solve the problem using excel solver, include the results in your submission. (Don't upload the excel file) Ciro Capacity FROM EXISTING PLANTS DECATUR DES 25 MINNEAPOLIS CARBONDALE DEMAND 250 201 200 25 FROM PROPOSED PLANTS TO EAST ST. LOUIS ST. LOUIS Blue Earth 529 $30 528 Des Moines 530 Capacity 150

Assignment 3: Solve the following problems and upload the solutions file (only PDF format) onto the Moodle (due date: Nov. 10th at 11:59 pm). Don Levine Corporation is considering adding an additional plant to its three existing facilities in Decatur, Minneapolis, and Carbondale. Both St. Louis and East St. Louis are being considered. Evaluating only the transportation costs per unit, as shown in the following tables, which site is better? Provide the mathematical model and solve the problem using excel solver, include the results in your submission. (Don't upload the excel file) Ciro Capacity FROM EXISTING PLANTS DECATUR DES 25 MINNEAPOLIS CARBONDALE DEMAND 250 201 200 25 FROM PROPOSED PLANTS TO EAST ST. LOUIS ST. LOUIS Blue Earth 529 $30 528 Des Moines 530 Capacity 150

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section: Chapter Questions

Problem 100P

See similar textbooks

Similar questions

Solve on Excel spreadsheets upload the excel file if possible
Requirement show your working
Don Levine Corporation is considering adding an additional plant to its three existing facilities in Decatur, Minneapolis, and Carbondale. Both St. Louis and East St. Louis are being considered. Evaluating only the transportation costs per unit as shown in the tables below, which site is best? FROM EXISTING PLANTS TO DECATUR MINNEAPOLIS CARBONDALE DEMAND Blue Earth $20 $17 $21 250 Ciro 25 27 20 200 Des Moines 22 25 22 350 Capacity 300 200 150 FROM PROPOSED PLANTS TO EAST ST. LOUIS ST. LOUIS Blue Earth $29 $27 Ciro 30 28 Des Moines 30 31 Capacity 150 150
The new Health-Watch facility is targeted to serve seven census tracts in Erie, Pennsylvania, whose lati-tudes and longitudes are shown in Table 13.1, along with the population in each census tract (in thou-sands). Customers will travel from the seven census-tract centers to the new facility when they needhealth care. What is the target area’s center of gravity for the Health-Watch medical facility?
Mick Karra is the manager of MCZ Drilling products which produces a variety of especially valves for oil field equipment. Recent activity in the oil fields has cause demand to increase drastically, and a decision has been made to open a new manufacturing facility. Three locations are being considered, and the size of the facility would not be the same in each location Thus, overtime might be necessary at times. The folowing table gives the total monthly cost (in 1000s) for each possible location under each demand posibility. The probabilities for the demand levels have been determined to be 20% for low demand, 30% for medium demand, and 50% for high demand Demand is Low Demand is medium Demand is High Ardmore, OK 85 110 150 Sweetwater, TX 90 100 120 Lake Charles, LA 110 120 130 (a) Which location would be selected based on the optimistic criterion? (b) which location would be selected based on the pessimistic criterion? (c) which location would be selected based on the…
Using the grid technique, determine the least-cost location for the following problem:
who needs to be involve in facility location decisions?
Explain corner-point feasible (CPF) solution?
Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 2 4 6 8 10 14 16 18 20 Q (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.
Takealot to open massive new distribution centre in Cape Town in 2022 Takealot Property developer Atterbury says that construction is underway on a new distribution centre (DC)for online retailer Takealot in Cape Town, expected to launch in August 2022.The 24,000 sqm facility consists of 22,000 sqm of warehouse space and 2,000 sqm offices, designedto provide Takealot with expansion options to add an additional 50,000 sqm of warehousing to theinitial phase.“The new Takealot DC is designed for sustainability and will feature a dedicated solar PV installation,energy-efficient lighting systems, a rainwater harvesting system and water-saving xeriscapelandscaping. The cross-dock facility will provide clear racking height of up to 18 metres andspecialised floors,” Atterbury said.The developer said that a 6,700 sqm Takealot Customer Collection Centre – which includesexpansion opportunities with the potential to grow to 17,000 sqm – is also under construction atRichmond Park. “The Customer…
Takealot to open massive new distribution centre in Cape Town in 2022 Takealot Property developer Atterbury says that construction is underway on a new distribution centre (DC)for online retailer Takealot in Cape Town, expected to launch in August 2022.The 24,000 sqm facility consists of 22,000 sqm of warehouse space and 2,000 sqm offices, designedto provide Takealot with expansion options to add an additional 50,000 sqm of warehousing to theinitial phase.“The new Takealot DC is designed for sustainability and will feature a dedicated solar PV installation,energy-efficient lighting systems, a rainwater harvesting system and water-saving xeriscapelandscaping. The cross-dock facility will provide clear racking height of up to 18 metres andspecialised floors,” Atterbury said.The developer said that a 6,700 sqm Takealot Customer Collection Centre – which includesexpansion opportunities with the potential to grow to 17,000 sqm – is also under construction atRichmond Park. “The Customer…
Please explain the full calculations