9.3 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: T-shirt factory 1. Mexico 2. Puerto Rico 3. Haiti Silk-Screen Company 4. Miami 5. Atlanta 6. Houston Demand (1,000) 4. Miami $4 $3 $2 7. New York $5 $7 $8 20 Silk-Screen Company 5. Atlanta $6 $5 $4 Distribution Center 8. St. Louis $7 $6 $6 12 6. Houston $3 $5 $4 9. Los Angeles $9 $10 $8 20 Supply (1,000 lbs.) 18 15 23 (a) Formulate this problem in Excel and (b) determine the optimal shipments to minimize total production and shipping costs for the apparel company.

9.3 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: T-shirt factory 1. Mexico 2. Puerto Rico 3. Haiti Silk-Screen Company 4. Miami 5. Atlanta 6. Houston Demand (1,000) 4. Miami $4 $3 $2 7. New York $5 $7 $8 20 Silk-Screen Company 5. Atlanta $6 $5 $4 Distribution Center 8. St. Louis $7 $6 $6 12 6. Houston $3 $5 $4 9. Los Angeles $9 $10 $8 20 Supply (1,000 lbs.) 18 15 23 (a) Formulate this problem in Excel and (b) determine the optimal shipments to minimize total production and shipping costs for the apparel company.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section: Chapter Questions

Problem 2C

See similar textbooks

Similar questions

MGMT Bakehouse Inc (MBI), supplies bread, cakes, and other specialty products, to a large percentage of the country; to the following customer types. Retailers e.g. supermarkets, who sell baked goods to the public, and MGMT Bakehouse Inc delivers to the retailers. Wholesalers also sell to the public but come to MGMT Bakehouse Inc directly to collect their baked goods. Finally, institutions like hotels and hospitals, to whom MGMT Bakehouse Inc delivers directly, buy baked goods to incorporate into offering for their clients e.g. guests menus and patient meal plans. From the ordering of flour and other ingredients to the processing of cash, receivables, and payables, the company uses an integrated ERP with a common database for all of its business processes. Internally MGMT Bakehouse Inc is organized into the following departments: Production which bakes the bread; Distribution that delivers the bread; Sales Department where customer orders and wholesale pickups are managed; Marketing…
The Bright Company wants to figure out the best way to ship their new product, Flying Widgets, from their factories through their warehouses to their retail outlets. They would like to set up a Transhipment table so they can use POM to find the least cost shipping routes. They have hired you to set up the Transhipment table based on the information below. You will be paid handsomely if you can come up with the correct table. Shipping Costs Shipping Costs 01 02 03 04 Wi W2 W3 W1 4. 2 F1 4 W2 4 F2 4 2 W3 4. 3. 4. Also, Flying Widgets can be shipped from Factory 1 to Factory 2 for $3 per unit. Factory 1 can produce 300 units and factory 2 can produce 100 units. Outlet 1 demand is 50 units, Outlet 2 is 150 units, Outlet 3 is 100 units, and Outlet 4 is 100 units.
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"??
DM Office Products (DMOP) Is a wholesale supplier of office products with one facility in Pennsylvania. It has decided to bulld a new distribution warehouse in the state of New York to help serve the growing demand In that market. It has four major customers located In Buffalo, Syracuse, Albany, and New York City. Though New York City is the largest market, it also has the greatest competition, and DMOP Is not a major player there. When DMOP ships an order to a customer, It uses its own small fleet of two trucks to deliver, so the cost of delivery Is essentially the same for a full or partlally full truck. The expected number of annual shipments to each city and their coordinates on an x, y grid is shown in the following table. x-COORDINATES 340 y-COORDINATES 865 CITY NUMBER OF SHIPMENTS Buffalo 85 Syracuse Albany New York City 1,435 2,315 2,290 915 89 645 129 45 69 Use the centroid method to recommend a location for the new warehouse for DMC (Round your answers to 1 decimal place.) Cx…
Freight Agents can be employed to handle your cargo from your Overseas Suppliers that can be located in either Dubai or China to your Company premises here in Zambia. Discuss three likely services that can be offered by these Agents in this regard, the influence of COVID 19 on them and measures put in place to mitigate the impact..
DM Office Products (DMOP) Is a wholesale supplier of office products with one facility in Pennsylvanla. They have decided to build a new distribution warehouse in the state of New York to help serve the growing demand in that market. They have four major customers located in Buffalo, Syracuse, Albany, and New York City. Though New York City is the largest market, It also has the greatest competition, and DMOP is not a major player there. When DMOP ships an order to a customer, they use their own small fleet of two trucks to deliver, so the cost of delIvery is essentially the same for a full or partially full truck. The expected number of annual shipments to each city and their coordinates on an x, y grid is shown in the following table. y-COORDINATES 850 CITY x-COORDINATES NUMBER OF SHIPMENTS Buffalo 325 78 82 Syracuse Albany New York City 1,420 2,300 2,275 900 630 122 25 62 Use the centroid method to recommend a location for the new warehouse for DMOP. (Round your answers to 1 decimal…
Suppliers A, B, and C supply components to three plants -- F, G, and H via two transshipment facilities -- T1 and T2. It costs $4 to ship from T1 regardless of final destination and $3 to ship to T2 regardless of supplier. Shipping to T1 from A, B, and C costs $3, $4, and $5, respectively, and shipping from T2 to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. The Logistics Manager has come to you for help. Answer the following question: Which of these is not an element of the objective function? Group of answer choices 4D-T1 600T1 9T2-G 3C-T2 Plz do fast asap
AP&P is a vegetarian food supplier chain that operates in various branches inSingapore. The vegetarian food products are processed and manufactured locally.AP&P also sells ready to eat vegetarian meal package. All food is pre-packed, andAP&P owns the licenses for their packaged food supplies which are also supplied tolocal supermarkets, wet markets in various part of Singapore. Pre-packed foodproduct is also sold to retailers. Customers can also directly pre-order online and isdelivered by AP&P delivery service.a) There are 3 main factories in Singapore and each factory is managedby 2 managers.b) Each FACTORY is uniquely identified by factory id and location (city).c) Each FACTORY may or may not have kitchen helpers and delivery staff.d) Each STAFF are uniquely identified by staff id, name, factory id.e) Each RETAILER is uniquely identified by retailer id, name, and location.f) There are total of 10 SUPERMARKET that carries AP&P foodvegetarian supplies and each…
Friedland Timbers asa Source: Waters, C. D. J. (2019). Logistics: an introduction to supply chain management. Johann Klassen is the Managing Director of Friedland Timbers asa. which makes specialised wood products for the construction industry. He has recently been worried by late deliveries to some important customers. The industry is very competitive, and Johann knows that customers will go to other suppliers if he cannot guarantee deliveries. The marketing manager is particularly upset because he has worked with these customers for a long time, and promised deliveries that were not made. Johann asked the production manager for an explanation. She told him that ‘Our own suppliers were late in delivering certain types of wood. This shortage of a key raw material disrupted our production plans. We cannot be blamed for this. If anyone in the company is to blame, it is the warehouse manager who does not keep enough stocks of raw materials to cover for late deliveries.’ Johann then went…
(iii) Find the initial basic feasible solution for the following transportation problem using VAM. Explain each step. Destination D1 D2 D3 D4 Supply 01 11 13 17 14 250 Origin 02 16 18 14 10 300 O3 Demand 200 225 275| 250 21 24 13 10 400
2) Using the cost table of the transportation problem shown below, do the following: a) Develop the appropriate LP model of the problem. WAREHOUSE PLANT A B C D DEMAND 1 5 10 7 20 200 2 3 12 5 25 400 3 8 10 10 18 600 4 7 8 12 30 1000 SUPPLY 200 500 300 1000
SRS Limited is a manufacturing company in Asia (China and India) specializing in bicycles that they sell to the USA, Canada, and Africa. Recently they acquired JAP Bicycle in Jamaica and supplying them with bikes and parts. They want to get in the automatic wheelchair for the physical challenge. SRS Limited contracted you as a transportation consultant to see their shipment from Asia to Canada, the East and West coast of the USA, Jamaica, and Africa. a. Differentiate the difference between intra-modal and inter-modal and why you will have recommended one over the other.