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
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:
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.
Please explain the full calculations
Location A would result in annual fixed costs of $300,000 and variable costs of $55 per unit. Annual fixed costs at Location B are $600,000 with variable costs of $32 per unit. Sales volume is estimated to be 30,000 units per year. Which location has the lower cost at this volume? How large is its cost advantage? At what volume are the two facilities equal in cost?
Facility Location. A paper products manufacturer has enough capital to build and manage some additional manufacturing plants in the United States in order to meet increased demand in three cities: New York City, NY; Los Angeles, CA; and Topeka, KS. The company is considering building in Denver, CO; Seattle, WA; and St. Louis, MO. Max Operating Capacity 400 tons/day 700 tons/day Denver Seattle $10/ton $17/tor $5/ton $11/ton.... $18/ton.... $28/ton Los Angeles Topeka New York City Figure 1: Graphical representation of the given data = • The cost fi of building plants in these cities is fi $10,000,000 in Seattle. Unmet Demand 300 tons/day 100 tons/day 500 tons/day • Due to geographic constraints, plants in Denver and Seattle would have a maximum operating capacity kį of 400 tons/day and 700 tons/day respectively. $5,000,000 in Denver and f2 = • The cost cij per ton of transporting paper from city i to city j is outlined in Figure 1. • The unmet demand d, for Los Angeles, Topeka, and New…
When deciding on this location of a Telecommunications room, what are the five issues to keep in mind?
Draw a network diagram, including ES, EF, LS, LF, Float and Duration for the following scenario:
The Skulls, a student social organization, has two different locations underconsideration for constructing a new chapter house. Skull's president, a POM student, estimates that due to differing land costs, utility rates, etc., both fixed and variable costs would be different for each of the proposed sites, as follows: Location Annual Fixed Variable Alpha Ave $5000 $200 per person Beta Blvd $8000 $150 per person If it is estimated that thirty persons will be living in this new chapter house, which location should the Skulls select?