atsFinnish Furniture manufactures tables in facilities located in three cities-Reno,Denver, and Pittsburgh. The tables are then shipped to three retail stores locatedin Phoenix, Cleveland, and Chicago. Management wishes to develop a distributionschedule that will meet the demands at the lowest possible cost ($). The shippingcost per unit from each of the sources to each of the destinations is shown in thefollowing table:FROM/TOPHOENIX CLEVELANDCHICAGORENO101619DENVER121413PITTSBURGH181212The available supplies are 120 units from Reno, 200 from Denver, and 160 fromPittsburgh. Phoenix has a demand of 140 units, Cleveland has a demand of 160units, and Chicago has a demand of 180 units. The manager would like to knowthe number of tables to be shipped from each manufacturing facility to each of theretail stores to minimize the cost.Solve using Solver then determine the optimal value of the following:a. Number of tables shipped from Reno to Phoenixb. Number of tables shipped from Reno to Cleveland mentsRENO101619DENVER121413PITTSBURGH181212HillThe available supplies are 120 units from Reno, 200 from Denver, and 160 fromPittsburgh. Phoenix has a demand of 140 units, Cleveland has a demand of 160units, and Chicago has a demand of 180 units. The manager would like to knowthe number of tables to be shipped from each manufacturing facility to each of theretail stores to minimize the cost.Solve using Solver then determine the optimal value of the following:a. Number of tables shipped from Reno to Phoenix =%3Db. Number of tables shipped from Reno to Cleveland =%3Dc. Number of tables shipped from Denver to Chicago =d. Number of tables shipped from Pittsburgh to Cleveland%3De. Minimum Cost = $

Decision Variables: Suppose-x11 be the no. of tables shipped from Reno to Phoenixx12 be the no. of…

Answered: Finnish Furniture manufactures tables…

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

Helen lives in Townsville and loves cycling. She recently took part in an overseas charity ride in New Zealand over a two-week period. She paid the organisers to take part in the event. She also raised money from others for the charity while on the ride. While visiting New Zealand which category of traveller is Helen? International stopover B Domestic Stayover International Excursionist Domestic Excursionist E None of the above
Explain the following sentence "In reality, it can be difficult for managers to achieve logistics management goals when designing logistical procedures because they may face heavy stresses on the supply chain such as rising overall costs"??
The Winston Company has four distribution centers (A, B, C, and D) that require 40,000, 60,000, 30,000, and 50,000 gallons of de-ionized water, respectively, per month for cleaning their long-haul trucks. Three de-ionized water wholesalers (1, 2, and 3) indicated their willingness to supply as many as 50,000, 70,000, and 60,000 gallons, respectively. The total cost (shipping plus price) of delivering 1,000 gallons of de-ionized water from each wholesaler to each distribution center is shown in the following table: Distribution Center Wholesaler A B 1 $1.70 $1.90 $1.60 $1.70 2 $1.40 $1.90 $1.60 $1.70 3 $1.60 $1.50 $1.80 $1.40 a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? O A. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center needed, O B. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. C. The sum of supply capacities…
The Winston Company has four distribution centers (A, B, C, and D) that require 40,000, 60,000, 30,000, and 50,000 gallons of de-ionized water, respectively, per month for cleaning their long-haul trucks. Three de-ionized water wholesalers (1, 2, and 3) indicated their willingness to supply as many as 50,000, 70,000, and 60,000 gallons, respectively. The total cost (shipping plus price) of delivering 1,000 gallons of de-ionized water from each wholesaler to each distribution center is shown in the following table: Distribution Center Wholesaler A B D $1.90 $1.90 $1.70 $1.60 $1.70 2 $1.40 $1.60 $1.70 3 $1.60 $1.50 $1.80 $1.40 a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? O A. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center is needed. O B. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. O C. The sum of supply capacities…
Dr. Vicki Belya is traveling from Yangoon to Los Angeles. She needs to change planes in Bangkok and board another airline’s flight in Tokyo. However, the ariline she is flying does not have interline agreements. Provide a basic explanation of what she can expect at every point of her journey.
Prescott Industries transports sand and stone extracted fromits open-pit mines located in Odessa and Bryan to its con-crete block manufacturing facilities in Abilene, Tyler, and SanAngelo. For the capacities, locations, and shipment costs pertruckload shown in the Figure 13.13, determine the shippingpattern that will minimize transportation costs. What are theestimated transportation costs associated with this optimalallocation pattern?
3. Figure 1 Daily Subway and Bus Use in Five Major Cities 0.75 0.5 0.25 Subway OBus London Tokyo Singapore Hong Kong Figure 2 Subway vs. Bus Ridership, New York City OBus Subway 1970 1980 1990 2000 2010 Information in figure I suggests that public transportation users in London Information in Figure I supports the author's point that buses are growing in popularity as a means of urban transport by indicating that A) take subways and buses at similar rates. B) are unusually reliant on buses. C) take at least one subway trip daily. D) take subways at about the same rate as people A) many people around the world take at least one bus trip every day. B) bus ridership surpasses subway ridership in some major cities. C) people in Tokyo make far more trips by bus daily than they do trips by subway. D) the number of bus trips taken by people in major cities has substantially increased. in New York. 2 Which of the following statements about bus use in New York City is best supported by…
1. A company would like to develop an aggregate plan and evaluate its cost using the transportation method. Develop the aggregate for them. Solve using Excel Related data are shown in the tables below Demand forecast Period Demand (Unit) 1 Period 1 2 3 2 3 80 90 40 Supply Capacity available (units) Regular time 40 65 30 Other Data Beginning Inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost Overtime 20 12 10 30 R 100 R 150 R 200 R 5 Subcontract 10 5 5
A company has three existing warehouses to which it will ship furniture from a new factory whose location must be decided. The factory will receive raw materials from its wood supplier and fabric supplier. The annual number of shipments, shipment costs and the location of the suppliers and warehouses are shown below Existing facilities Annual L to or from fact cost Coordinate location Wood supplier 120 10 (100, 400) Fabric supplier 200 10 (800,700) Ware h 1 61 10 (300, 600) Ware h 2 40 10 (200, 100) Ware h 3 70 10 (600, 200) Using the median load answer the following questions –Where the factory should be located to minimize annual transportation cost –What will be the minimum annual transportation cost
: x v fx C DE в F G H K M Consider the linear distribution and the from-to diagram shown in the figure. Assuming that the goal is to minimize the total distance traveled, determine the final distribution recommended by CRAFT using the peer-to-peer trading method. 30 m 30 m from A A B A 2 6 B 3 A В 80 m 20 m
Consider the transportation problem having the following parameter table: Source Demand 12 2 Destination 1 8 a6 6 3 2 5 4 3 Supply 4 2 (a) Use the transportation simplex method to solve the above problem
Waikato Farm Machinery Ltd (‘WFML’), is a well- established business, with the main base of its operations in Te Rapa, Hamilton. Its business is the importation and distribution of farm machinery such as tractors, loaders, diggers, bulldozers as well as farming equipment such as disc ploughs, rotovators, grain silos including machinery used by dairy farmers in milking sheds. The imported equipment is then sold at wholesale prices to smaller businesses in other centres in the Waikato and King Country regions, that on sell them to farmers. WFML has developed a formidable reputation as a supplier of such goods for at least two reasons. First, it imports machinery and equipment of the highest quality such as John Deere tractors from the United States and International Harvester tractors from Germany. Secondly, it has consistently stood by the goods it sells and efficiently attends to any difficulties experienced by retailers such as the repair of any defects. More importantly it is able to…

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