9-13 Finnish Furniture manufactures tables in facilities located inthree cities-Reno, Denver, and Pittsburgh. The tables are thenshipped to three retail stores located in Phoenix, Cleveland, andChicago. Management wishes to develop a distribution schedulethat will meet the stores' demands at the lowest possible cost.The shipping cost per unit from each of the sources to each ofthe destinations is shown in the following table: TO FROMPHOENIXCLEVELANDCHICAGORENO101619DENVER121413PITTSBURGH181212The available supplies are 120 units from Reno, 200 fromDenver, and 160 from Pittsburgh. Phoenix has a demand of 140units, Cleveland has a demand of 160 units, and Chicago has ademand of 180 units. How many units should be shipped fromeach manufacturing facility to each of the retail stores if cost isto be minimized? What is the total cost?

Answered: Image /qna-images/answer/d0fd9628-1b03-426a-9781-269357df1741.jpg

Answered: The available supplies are 120 units…

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

A sports apparel company has received an order for a college basketball team’snational championship T-shirt. The company can purchase the T-shirts from textile factoriesin Mexico, Puerto Rico, and Haiti. The shirts are shipped from the factories to companies inthe United States that silk-screen the shirts before they are shipped to distribution centers.Following are the production and transportation costs ($/shirt) from the T-shirt factories tothe silk-screen companies to the distribution centers, plus the supply of T-shirts at thefactories and demand for the shirts at the distribution centers (a) Formulate this problem in Excel and (b) determine the optimal shipments to minimize totalproduction and shipping costs for the apparel company.
A sports apparel company has received an order for a college basketball team’snational championship T-shirt. The company can purchase the T-shirts from textile factoriesin Mexico, Puerto Rico, and Haiti. The shirts are shipped from the factories to companies inthe United States that silk-screen the shirts before they are shipped to distribution centers.Following are the production and transportation costs ($/shirt) from the T-shirt factories tothe silk-screen companies to the distribution centers, plus the supply of T-shirts at thefactories and demand for the shirts at the distribution centers: Silk-Screen CompanyT-shirt factory T-shirt factory 4. Miami 5. Atlanta 6. Houston Supply(1,000 lbs.)1. Mexico $4 $6 $3 182. Puerto Rico $3 $5 $5 153. Haiti…
The Palestinian ministry of sports has four basketball games on a particular night. The ministry wants to assign four teams of officials to the four games in a way that will minimize the total distance traveled by the officials. The supply is always one team of officials and the demand is for only one team of officials at each game. The distances in km for each team of officials to each game location are shown in the following table officials 1 2 3 a 100 150 120 b 130 210 90 c 120 170 90 A) Formulate this problem as Assignment Model (the objective function and constraint equations for the demand and supply) . b) Use QM to solve the Model.
Expedition companies headquartered in Bintaro want to developed its business in Medan, Balikpapan and Menado and will place 3 branch heads (Aria, Yuda and Roni) from several branch offices owned by the company in Central Java to set-up offices and run operations in 3 locations. Below is the cost to allocate the 3 branch heads to each location: branch head/ branch office Medan(3 Rp. 10.000) Balikpapan(3 Rp. 10.000) Manado (3 Rp. 10.000) ARIA 800 1100 1200 YUDA 500 1300 1300 RONI 500 1000 2300 a. Create a table using the assignment method.b. Based on the results of your calculations, what advice can you give to the most optimum company leaders of location placement of each branch head above? Explain why?c. What is the total optimum cost that must be incurred by the company to allocate to all branch offices of the company?
A travelling salesman, named Magan Shah plans to visit five cities 1, 2, 3, 4 and 5. The travel time (in hours) between these cities is shown below. To city 1 2 3 4 5 From city 1 x 5 8 4 5 2 5 x 7 4 5 3 8 7 x 8 6 4 4 4 8 x 8 5 5 5 6 8 x How should he schedule his touring plan in order to minimize the total travel time, if he visits each city once a week?
Tommy Hilfiger is currently considering to source certain textile goods, Tommy Jeans, from Mexico. The estimated shipping time from Mexico to the U.S. for each shipment of Tommy Jeans is 4 days and the estimated freight cost of each shipment is $800. On the other hand, the current average shipping time from Vietnam to the U.S. for each shipment of Tommy Jeans is 23 days and the average freight cost is $2300. Even though the shipping time and freight cost seem to be much lower in case of Mexico, Tommy Hilfiger management is concerned about the production cost of each Jeans shipment. The management anticipates that the production cost of each Jeans shipment will be higher in Mexico compared to Vietnam. However, Tommy Hilfiger management has decided that even if the total cost (sum of production cost, freight cost, and holding cost) remain similar to Vietnam, Tommy Hilfiger will still source Jeans from Mexico because of the reduced shipping time, which, in turn, will result in better…
ASAP PLEASE.. The distribution of goods from the source (factory) to the target (warehouse) will cause problems regarding TRANSPORT, namely how the goods are sent from the factory to the warehouse which produces minimum costs. If it is known that - the capacity of 3 factories is 40000, 30000 and 20000, - the need for 3 warehouses is 20000, 50000 and 30000 respectively. The cost of shipping goods from the factory to the warehouse is shown in the following table Solve the above TRANSPORTATION problems with VAM and MODI
Anderson Watch Company is considering opening four possible distribution centers located in Atlanta, Lexington, Milwaukee, and Salt Lake City with a fixed cost to open of $17,000, $22,000, $35,000, and $25,000, respectively. They currently have ten retail stores located in Seattle, San Francisco, Las Vegas, Tucson, Denver, Dallas, Birmingham, Orlando, Cleveland, and Philadelphia. Lisa, the supply chain VP, wants to minimize the transportation costs of shipping their French down pillows. The per-unit shipping cost from each distribution center to each retail location and the amounts currently in inventory and ordered at each retail location are shown in the following tables. What is the minimum cost solution? What is the minimum cost solution if Lisa wants to use single sourcing?
A sports apparel company has received an order for a college basketball team’s national championship T-shirt. The company can purchase the T-shirts from textile factories in Mexico, Puerto Rico, and Haiti. The shirts are shipped from the factories to companies in the United States that silk-screen the shirts before they are shipped to distribution centers. Following are the production and transportation costs ($/shirt) from the T-shirt factories to the silk-screen companies to the distribution centers, plus the supply of T-shirts at the factories and demand for the shirts at the distribution centers: Determine the optimal shipments to minimize total production and transportation costs for the apparel company.
9-7 The management of the Executive Furniture Corporation decided to expand the production capacity at its Des Moines factory and to cut back the production capacities at its other two factories. It also recognizes a shifting market for its desks and revises the requirements at its three warehouses. The table on this page provides the requirement at each of the warehouses, the capacity at each of the factories, and the shipping cost per unit to ship from each factory to each warehouse. Find the least-cost way to meet the requirements given the capacity at each factory.
The Executive Furniture Corporation, which manufactures office desks at three locations: Des Moines, Evansville and Fort Lauderdale. The firm distributes the desks through regional warehouses located in Albuquerque, Boston and Cleveland. The production costs per desk are the same at each factory and hence the only relevant costs are those of shipping from each source to each destination. They are assumed to be constant regardless of their volume shipped. An estimate of the monthly production capacity at each factory and estimate of the number of desks required per month at each destination and the shipping cost ($) per desk from each source to each destination is given in the following table: Transportation table for Executive Furniture Corporation To From Albuquerque Boston Cleveland Factory capacity Des Moines 6 5 8 300 Evansville 5 9 8 400 Fort Lauderdale 4 5 6 350 Requirements 350 250 450…
Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are as follows: Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the countries vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows: From Hamilton Butler Clermont Southern Gas 10 20 15 Northwest Gas 12 15 18 Develop a network representation of the distribution system. Develop the objective function and the constraints.

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