6.- Comfort Zone Furniture has plants in Boston, Dallas and Seattle,which ship their production to four demand centers, with thetransportation costs indicated in the following table. Using thenorthwest corner method and stepping stone find the optimal solution.BostonDallasSeattleDemand1$3$6$1202$5$8$9603$7$5$7304$4$2$340Capacity505050150

The transportation model is used to calculate the minimum cost of the route by selecting different…

Answered: 6.- Comfort Zone Furniture has plants…

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

SOLVE USING EXCEL Metal Fabricators, Inc. manufactures gas grill tanks, Model # 1420, for four original equipment manufacturers (OEMs). Demand is forecast to be as follows: Quarter 1 = 2,800 tanks, Quarter 2 = 3,400, Quarter 3 = 3,600, and Quarter 4 = 2,900. Due to a hedging program for sheet steel and increases in international tariffs, production cost per quarter vary as follows: Quarter 1 = $23.50 per tank, Quarter 2 = $28.00, Quarter 3 = $25.90, and Quarter 4 = $29.00. Due to production contracts with the OEMs, no shortages are allowed. Beginning inventory for Quarter 1 is 300 tanks. At the end of each quarter, inventory holding costs are $4.25 per tank. a. Formulate the problem as a linear programming model (see Supplement D). b. Solve the model in (a) using Excel Solver.
Please answer part i of question 1. 1. 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 the table below. Customer Annual Volume X-Coordinate Y-Coordinate Judy Inc. 25 3 7 Zac Supermarket 13 5 2 Harry Inc. 6 8 4 Sky Productions 4 1 5 i) Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.
FloorsRUs is considering new locations for its manufacturing plants. Costs for constructing a new facility in Huntsville are $1,100,000 and the company estimates that for every product from its new line, there would be an additional cost of $3. If the company were to locate in Hays, the new facility would cost $1,800,000 and each product would incur a $2 incremental cost. The company plans to sell the products to retailers for $7. At what volume is the point of indifference? At what forecasted volumes should FloorsRUs select Huntsville as their new manufacturing location and what volumes should the company select Hays and why?
a company's business model was to operate through its facilities- Vancouver, Calgary, Winnipeg, Toronto(ontario), ottawa, Montreal and Halifax. Supply comes from South America, southeast Asia, and Florida. the company was shipping first to Toronto and then to each facility at a total cost of $23095.5 per week. The company is considering the possibility of opening a logistics facility in Miami. Toronto and Vancouver were already available as transshipment centres. What would be the cost savings if Miami centre was opened and what would be the optimal shipment plan?
Jk.335. Propiem 14-8 Rent'R Cars is a multisite car rental company in the city. It is trying out a new "return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below. From To A B C Demand D $9 9 5 50 From/To $8 Candidate solution A B C Total shipped Cost A - B C Total costs 8 3 60 $6 8 3 25 $5 D 0 10 a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.) Supply 50 40 75 30 165 165 E F G Supply $
Refer to Problem 8.1. Shipping cost from Myanmar to Denver, Colorado, the final destination, is $1.50 per unit. Shipping cost from China to Denver is $1 per unit, while the shipping cost from Billings to Denver is $.25 per unit. Considering both labor and transportation costs, which is the most favorableproduction location?
Shipping cost from Myanmarto Denver, Colorado, the final destination, is $1.50 per unit. Shipping cost from China to Denver is $1 per unit, while the ship-ping cost from Billings to Denver is $.25 per unit. Considering both labor and transportation costs, which is the most favorableproduction location?
An auto company currently maintains plants in Cincinnati and Tulsa to supply two distributioncenters in Boston and Phoenix. The production and distribution costs, distribution demands aswell as facility capacities are given in the table attached. b) Using the intuitive lowest cost method, determines which of the candidate locations, inaddition to existing locations, gives the initial solution with a lower cost? c) Using the solutions obtained in b), identify which distribution center still faces a shortage. d) Suppose the company has chosen Houston as their third plant and would like to know the optimaltransportation strategy that minimizes overall costs by solving a minimum-cost flow problem.Terry has defined decision variables, represented as xij, to denote the number of items shippedfrom plant i to distribution center j wherei= C(Cincinnati), T(Tulsa), and H(Houston)j= B(Boston) and P(Phoenix)
A supply chain manager faced with choosing among four possible locations has assessed each location according to the following criteria, where the weights reflect the importance of the criteria. Location Criteria Weight 1 2 3 4 Raw material availability 0.06 P VG OK VG Infrastructute 0.07 P G VG OK Transportation costs 0.33 G P OK P Labor relations 0.25 VG G P OK Quality of life 0.29 G OK P VG VG = Very good 5 pts; G = Good 4 pts; OK = Acceptable 3 pts ; P = Poor 1 pt. Using this information, determine the best and the worst location. Round your answers to two decimal places. Location Total Points 1 2 3 4 ______ is the best location and _______ is the worst location.
Ashley’s Auto Top Carriers currently maintains plants in Atlanta and Tulsa that supply major distribution centers in Los Angeles and New York. Because of an expanding demand, Ashley has decided to open a third plant and has narrowed the choice to one of two cities-New Orleans or Houston. The pertinent production and distribution costs, as well as the plant capacities and distribution demands, are shown in the table. from/to LA NY NORMAL PRODUCTION UNIT PRODUCTION ATLANTA 8 5 600 6 TULSA 4 7 900 5 NEW ORLEANS 5 6 500 4 ANTICIPATED HOUSTON 4 6 500 3 ANTICIPATED FORECAST DEMAND 800 1200 2000 Which of the new possible plants should be opened? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
The fixed and variable costs (in U.S. dollars) for thenew recycling plant that Eldon Yi is opening in Australia arecomputed as follows: a) Over what range is each city preferable?b) For a recycling of 5,000 units, which site is best?
For each of the four types of organizations shown, rate the importance of each factor in terms ofmaking location decisions using L = low importance, M = moderate importance, and H = highimportance.Factor Local Bank Steel Mill Food Warehouse Public SchoolConvenience for customersAttractiveness of buildingNearness to raw materialsLarge amounts of powerPollution controlsLabor cost and availabilityTransportation costsConstruction costs

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

6.- Comfort Zone Furniture has plants in Boston, Dallas and Seattle, which ship their production to four demand centers, with the transportation costs indicated in the following table. Using the northwest corner method and stepping stone find the optimal solution.