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

Question 1. Mr. Jack is in the process of expanding his manufacturing business. He decided to open a plant in the coming year. He has four locations in mind. The costs information for these locations is in the following table.Locations A B C DFixed Costs 60,000 80,000 100,000 130,000Variable Costs/unit30 20 15 10 i. Write an equation to represent the total costs for each location.ii. Draw the total costs lines for each location on the same axes. (Use output ranges of 2000, 4000, 6000, 8000 etc. and intervals of $50,000 on the Y axis.iii. Over what range of output is location A the most preferred location?iv. Over what range of output is location B the most preferred location?v. Over what range of output is location C the most preferred location?
QUESTION 7 Kelly Holiday Tavel Ltd is deciding which destination to award its “holiday site of the year” award to. It has compiled the following information and assigned weightings to reflect how important each factor is to its customers. All numbers are percentages. Which destination will win the award? Safety Culture Food Acapulco 50 70 80 Moscow 5 60 40 Romford 20 10 20 Toronto 80 50 60 WEIGHT 25 50 25 A. Acapulco B. Moscow C. Romford D. Toronto
Question 1. Identify the range of output for which each alternative is superior(has the lowest cost) 2. If the expected output at the selected location is to be 10000 units per year, which location would provide the lowest total cost? Location Fixed Cost Variable cost A $250,000 $11 B $100,000 $30 C $150,000 $20 D $200,000 $35
Scenario -- Deep Blue Seaways Deep Blue Seaways (a UK based company) is a shipping company that transports goods all over the world by sea. It has a number of problems. Firstly, it comprises of a Head Office and four divisions, each of which have their own set of systems and processes as a result of the takeover of 3 smaller companies during the last 4 years. The Heads of each Division are not renowned for their co-operative approach with each other, and they work as they were each running their own company rather than working for a larger corporation. The Chief Executive Officer (CEO) is agonising over what to do with this lack of co-operation as he knows that much money could be saved if processes and systems were aligned between the four divisions. Head Office staff constantly complain that they have to manipulate and seek clarification of the data coming into them from the divisions and this is both time consuming and tedious. Each division has its own IT department, all…
Scenario -- Deep Blue Seaways Deep Blue Seaways (a UK based company) is a shipping company that transports goods all over the world by sea. It has a number of problems. Firstly, it comprises of a Head Office and four divisions, each of which have their own set of systems and processes as a result of the takeover of 3 smaller companies during the last 4 years. The Heads of each Division are not renowned for their co-operative approach with each other, and they work as they were each running their own company rather than working for a larger corporation. The Chief Executive Officer (CEO) is agonising over what to do with this lack of co-operation as he knows that much money could be saved if processes and systems were aligned between the four divisions. Head Office staff constantly complain that they have to manipulate and seek clarification of the data coming into them from the divisions and this is both time consuming and tedious. Each division has its own IT department, all…
Question (2): Answer the following problem: A manufacturer of a certain industrial component is interested in locating a new facility in a target market. There are four supply points A, B, C and D. Two possible sites for the new facility are being considered, one in (market Q) and the other in (market Z). The following table shows the distances being considered and the four supply points. Use the load- distance model to determine whether the new facility should be located in (market Q) or in (market Z). (State your decision) Supply points Distance to market Q Distance to market Z Load between the supply point and new facility. A 32 14 15 B 8 14 10 C 12.5 32 12 D 6.5 26 8
Question 2 Acme Fasteners desires to locate a new facility. Based on preliminary analysis, the choice has been reduced to four locations: A, B, C, and D. These four locations were rated on a scale from 1 (worst) to 10 (best) on each of four criteria. Each criterion was also weighted to indicate its importance (i.e., the higher the weight, the more important). The list of ratings and weights follows. Based on weighted scores, where should Acme locate its new facility?
Question 2Tropical Bliss wants to use an event to promote its new products. The company will however need to decide regarding the location and venue to use for the launch of its exiting new product line. They have developed a payoff table for three locations: Montego-Bay, Kingston, and Mandeville, and have also identified three states of nature (the crowd response / turn-out) Large, Moderate and Low: What location should Tropical Bliss choose if the MaxiMax criterion is used? B. What location should Tropical Bliss choose if the LaPlace criterion is used? C. Using the MaxiMin criterion, which location should Tropical Bliss choose? D. If the probability of getting out a large crowd is 43%, the probability of getting out a moderate size crowd is 22%, and the probability of getting out a small crowd is 35%. Using expected monetary values, what decision should be made by Tropical Bliss and what is that optimal expected value? (E. Construct the appropriate decision tree to help…
Question content area Part 1 The fixed and variable costs for four potential plant sites for Brent Snyder's Ski Supplies are shown below: Site Fixed Cost Per Year Variable Cost Per Unit Atlanta $120,000 $5 Burlington 70,000 4 Cleveland 95,000 3 Denver 45,000 11 Part 2
Questions i. Calculate the weighted score for each alternative location. ii. Which location should be chosen?
Forecast for the 11 quarter using exponential smoothing technique. quarters 1 2 3 4 5 6 7 8 9 10 11 Sales 6 8 11 9 10 9 15 14 10 19 ?
QUESTION 21. Mr. Jack is in the process of expanding his manufacturing business. He decided to opena plant in the coming year. He has four locations in mind. The costs information forthese locations is in the following table. Location A B C D Fixed Costs 60,000 80,000 100,000 130,000 Variable costs/unit 30 20 15 10 a.i. Write an equation to represent the total costs for each location. ii. Draw the total costs lines for each location on the same axes. (Use output rangesof 200, 400, 600, 800 etc. and intervals of $50,000 on the Y axis. iii. Over what range of output is location A the most preferred location? iv. Over what range of output is location B the most preferred location?v. Over what range of output is location C the most preferred location? b. A food manufacturer wants to locate a warehouse to serve its major customers.The customers, annual volume and the X and Y coordinates are shown in thetable below. Customer Annual Volume X-Coordinate Y-Coordinate Judy Inc 25…

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