| Finnish Furniture manufactures tables in facilities located in three cities -- Reno, Denver and Pittsburgh. | |||||||||||
| The tables are then shipped to three retail stores located in Phoenix, Cleveland, and Chicago. | |||||||||||
| Management wishes to develop a distribution schedule that will meet the stores demands at the lowest possible cost. | |||||||||||
| The shipping cost per unit from each of the sources to each of the destinations is shown in the following table. | |||||||||||
| From/To | Phoenix | Cleveland | Chicago | ||||||||
| Reno | 10 | 16 | 19 | ||||||||
| Denver | 12 | 14 | 13 | ||||||||
| Pittsburgh | 18 | 12 | 12 | ||||||||
| The available tables are 120 units from Reno, 200 from Denver and 200 from Pittsburgh. | |||||||||||
| Cleveland has demand for 160 units, Chicago has demand for 180 units, and Phoenix has demand for 140 units. | |||||||||||
| What is the minimum total cost? | |||||||||||




Finnish Furniture manufactures tables in facilities located in three cities -- Reno, Denver and Pittsburgh. The...
Finnish Furniture manufactures tables in facilities located in three cities -- Reno, Denver and Pittsburgh. The tables are then shipped to three retail stores located in Phoenix, Cleveland, and Chicago. Management wishes to develop a distribution schedule that will meet the stores demands at the lowest possible cost. The shipping cost per unit from each of the sources to each of the destinations is shown in the following table. From/To Phoenix Cleveland Chicago Reno 10 16 19 Denver 12 14...
9-13 write the equations for the problem from gne chart.
develope a spreadsheet for a linear programmkng solution to this
problem. and hse SOLVER to find the solution.
please show how to do this in EXCEL!
to Ballas is $11, to Atlanta is $8, and to Denver is $12. How many units should be shipped from each plant to each regional distribution center? What is the total cost for this? :9-13 Finnish Furniture manufactures tables in facilities located in three...
Dexter Office Supplies has 3 manufacturing facilities located in Denver, Atlanta and Chicago and ships to 4 retail outlets located in Boston, Dallas, LA and St. Paul. The company wants to maximize profit of shipping one of its higher-volume products, boxes of standard copy paper. The profit per unit (box of paper shipped) for each of the delivery routes along with limits on supply and demand for the coming month are provided in the table below. profit per unit DESTINATIONS...
International Paper Company has four warehouses at different cities: Buffalo, Detroit, Pittsburgh and Raleigh. They provide paper to five book publishers in Boston, New York, Chicago, Indianapolis and Memphis. The costs of shipping one box of paper, the amount of paper (in boxes) available at each warehouse, and the amount of paper ordered (in boxes) by each publisher are found in the table below: From / To Boston New York Chicago Indianapolis Memphis Supply Buffalo 9 7 11 12 13...
M4_A2. Jackson Paper Mills, Inc., has plants in Boone, NC and Augusta, Georgia. Warehouses are located in Tampa, FL and Winchester, VA. Distributors are located in Detroit, MI; Knoxville, TN; and New Orleans, LA. Products are shipped from the plants to the warehouses and from the warehouses to the distributors. There is no storage at the warehouses so any product entering the warehouses must be shipped to distributors. The plant capacities and distributor demands are shown in the tables below:...
A company that manufactures compressors has plants in three
locations: Cleveland, Chicago, and Boston. During a week, the total
capacity of each plant to produce one type of special compressor is
25, 45, and 35 units, respectively. The company wants to ship at
least 40, 10, 20 and 30 units to distribution centers in Dallas,
Atlanta, San Francisco, and Philadelphia respectively. The unit
production and distribution costs from each plant to each
distribution center are given in the table below....
2. A company that manufactures compressors has plants in three locations: Cleveland, Chicago, and Boston. During a week, the total capacity of each plant to produce one type of special compressor is 25, 45, and 35 units, respectively. The company wants to ship at least 40, 10, 20 and 30 units to distribution centers in Dallas, Atlanta, San Francisco, and Philadelphia respectively. The unit production and distribution costs from each plant to each distribution center are given in the table...
The XYZ Chicharon has three supply points here in Davao City, one located in Matina, the other is at Bankerohan and lastly at Toril and three distribution stores in Ma-a, Sasa and Agdao. The capacities of the three supply points are 50, 45 and 75 per kilo per week. The weekly demands of the three distribution stores are 40, 50 and 80 per kilo per week. The supply points are able to supply the following number of kilo per week...
Location Section Project A small logistic company named LogTransit currently has 3 manufacturing facilities (suppliers) called Supplier #1, #2 and #3 to supply for goods of its 3 retail stores (customers) called Customer A, B, and C. Due to customer demands at stores are increasing, the company is considering to construct a new manufacturing facility. The new factory will have a supply capacity of 200 units per week. After screening many potential sites, Toledo and Cincinnati have been determined to...
Q4. ABC Ltd. manufactures luxury golf bags in their two plants located in Augusta and Tupper Lake Warchouse facilities are located in Albany and Portsmouth. Distributors are located in Boston, New York and Philadelphia. The Augusta plant has a capacity of 300 units per month, and the Tupper Lake plant has a capacity of 100 units per month. Boston has a demand of 150 units per month, New York has a demand of 100 units per month, and Philadelphia has...