Question 1: A Canadian company was able until now to meet the demand of itscustomers from its factory located in the Quebec region. Strong sales growth,however, is forecasted for next year in the two markets served by the company(1:Eastern Quebec, 2: Western Quebec). The company, therefore, is consideringthe construction of another plant for which two potential sites have been identified:one in Rimouski and the other in Longueuil. The collected data are provided inTable below.Quebec plantRimouski platformLongueuil platformPotential market (ton)Transportation costs($ per ton)Market 1 Market 26004002007007001000300800Production cost Capacity Fixed cost($ per ton)$3800$3500$3600(ton)100010001000($1000)$4000$5900$6200Products sold can be grouped in a single family and the average sale price of theproducts of this family is $50,000 per ton on both markets.(a) Draw an activity graph that corresponds to this context.(b) Propose an optimization model to solve this problem.(c) Implement your model using the any solver; determine whether to build a newplant and, if so, on which site?

Find the Given details below: Given details: Market Plant 1 2 Capacity Production…

Answered: Question 1: A Canadian company was able…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Name and elaborate 3 effects of the pandemic on the future demand for air cargo. Give reasons to support the answer.
basis K- Pan American Refineries, headquartered in Houston, must decide among three sites for the construction of a new oil-processing center. The firm has selected the six factors listed below as a for evaluation and has assigned rating weights from 1 to 5 on each factor. Subhajit Chakraborty, the CEO, has rated each location for each factor on a 1 to 100 point basis. In the table below, the rating weights and the rating value for each of the locations on the factor are presented: Factor 1 2 3 4 5 6 Factor Description Proximity to port facilities Power-source availability and cost Workforce attitude and cost Distance from Houston Rating Weight 5 3 3 3 1 2 Location A Location B 70 70 85 75 50 65 75 60 55 10 100 50 Location C 80 100 75 60 85 90 Community desirability Equipment suppliers in area a) Based on the given information, the best location for Pan American Refineries is , with a total weighted score of. (Enter your response as an integer) b) If Location B's score for Proximity to…
Questions i. Calculate the weighted score for each alternative location. ii. Which location should be chosen?
b. An operations manager has narrowed down the search for a new King Kola plant to three locations. Fixed and variable costs follow. 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 6 8 10 14 16 18 20 0 (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.
A manager received an analysis of several cities being considered for a new office complex. The data (10 points maximum) are as follows: Factor Business services Community services Real estate cost Construction costs Cost of living Taxes Transportation A с Thus, Location Score A A B с Thus, 17 17 17 8 6 4 3 2 8 9 B 6 6 Click here for the Excel Data File a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores? 8 7 7 19 19 19 5 7 is/are the best. C 6 7 7 6 8 b. If business services and construction costs are given weights that are double the weights of the other factors, how would the locations stack up? is/are best and 4 8 is/are least desirable.
Identify and clarify seven key factors affecting decision on the location?
3. Consolidated Refineries, headquartered in Houston, must decide among three sites for the construction of a new oil-processing center. The firm has selected the six factors listed below as a basis for evaluation and has assigned rating weights from 1 to 5 on each factor: Factor 1 2 3 4 5 6 Factor Name Proximity to port facilities Power source availability and cost Workforce attitude and cost Distance from Houston Community desirability Equipment suppliers in area Rating Weight 5 3 4 2 2 3 Management has rated each location for each factor on a 1- to 100-point basis. Factor Location A Location B Location C 1 100 80 80 2 80 70 100 3 30 60 70 4 10 80 60 5 90 60 80 6 50 60 90 a. Which site will be recommended based on total weighted scores? b. If location B's score for Proximity to port facilities was reset at 90, how would the result change? c. What score would location B need on Proximity to port facilities to change its ranking?
Metro has initiated discussions on attracting rail service. A depot would need to be constructed, which would require $2.5million in land and $7.5 million in construction costs. Annual operating and maintenance costs (O&M) for the facility would be $150,000, and personnel costs would be an additional $110,000. Other assorted costs would be born by the railroad and federal authorities. Annual benefits (B) of the rail service are estimated as listed: $120,000 for Railroad annual payments, $25,000 for Rail tax charged to passengers, $20,000 for Convenience benefits to local residents, and $12,000 for Additional tourism dollars for Metro. Apply the B-C ratio method, with a MARR of 8% per year and 20 year study period, to determine if the rail service should be established. a. BC ratio=2.12, good project b. BC ratio=-1.76, good project c. BC ratio=1.69, good project d. BC ratio=0.14, not good project
The LP model and output below represent a problem whose solution will tell a specialty retailer how many of four different styles of umbrellas to stock in order to maximize profit. It is assumed that every one stocked will be sold. The variables measure the number of women's (X1), golf (X2), men's (X3), and folding umbrellas (X4), respectively. The constraints measure storage space in units (Constraint 1), special display racks (Constraint 2), demand (Constraint 3), and a marketing restriction (Constraint 4), respectively. There is nothing you need to solve for this problem. All questions below can be answered by the output. MAX 5 X1 + 7 X2 + 6 X3 + 4.5 X4 SUBJECT TO 1) 2 X1 + 3 X2 + 3 X3 + X4 <= 120 2) 1.5 X1 + 2 X2 <= 54 3) 2 X2 + X3 + X4 <= 72 4) X2 + X3 >= 12How many women's umbrellas (X1) should be stocked?How many golf umbrellas (X2) should be stocked?
Location Score Factor (100 points each) Weight A B C Convenience 0.15 87 92 84 Parking facilities 0.20 73 83 93 Display area 0.18 90 89 96 Shopper traffic 0.27 90 90 93 Operating costs 0.10 85 89 88 Neighborhood 0.10 95 87 94 1.00 Click here for the Excel Data File a. Using the above factor ratings, calculate the composite score for each location. (Do not round Intermediate calculations. Round your final answers to 2 decimal places.) Location A Composite Score B C b. Determine which location alternative (A, B, or C) should be chosen on the basis of maximum composite score. Oc OB OA 13
The Giant Farmer Company processes food for sale in discount food stores. It has two plants: one in Chicago and one in Houston. The company also operates warehouses in Miami, Florida; Denver, Colorado; Lincoln, Nebraska; and Jackson, Mississippi. Forecasts indicate that demand soon will exceed supply and that a new plant with a capacity of 8,000 cases per week is needed. The question is where to locate the new plant. Three potential sites are Buffalo, Atlanta, and Memphis. The two tables below give data on capacities, forecasted demand, and shipping costs that have been gathered. Plant Chicago Houston Capacity (cases per week) New plant Warehouse Plant Chicago Houston Buffalo (alternative 1) Atlanta (alternative 2) Memphis (alternative 3) For each alternative new plant location, determine the total cost of the shipping pattern that will minimize total transportation costs. Where should the new plant be located? If the new plant is located in Buffalo, the optimal cost is $ (Enter your…
Problem 8-10 Factor Initial cost Traffic Maintenance Dock space Neighborhood Location East #1 East #2 West Weight East #1 100 60 20 24 15 0 00 00 N West East #1 East #2 8 8 4 4 2 East #2 110 35 25 24 9 a. Using the above factor ratings, calculate the composite score for each location. West 110 35 Composite Score 25 13 11 b. Determine which location has the highest composite score:

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS