Canning Transport is to move goods from three factories to three distribution centers. Information about the move is given below. Give the network (draw chart with nodes) model and create an LP in Tab #11 to find the minimum shipping costs. Source Supply Destinatio Demand A B с 200 100 150 Shipping costs are: Source A B C X 3 9 X Y Z 5 Destination Y 2 10 6 50 125 125 Z 5 4 (Source B cannot ship to destination Z)

Canning Transport is to move goods from three factories to three distribution centers. Information about the move is given below. Give the network (draw chart with nodes) model and create an LP in Tab #11 to find the minimum shipping costs. Source Supply Destinatio Demand A B с 200 100 150 Shipping costs are: Source A B C X 3 9 X Y Z 5 Destination Y 2 10 6 50 125 125 Z 5 4 (Source B cannot ship to destination Z)

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
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
Evaluate the current China/Taiwan logistics costs. Assume a current total volume of 190,000CBM and that 89 percent is shipped direct from the supplier plants in containers. Use the datafrom the case and assume that the supplier-loaded containers are 85 percent full. Assume thatconsolidation centers are run at each of the four port locations. The consolidation centers useonly 40-foot containers and fill them to 96 percent capacity. Assume that it costs $480 to ship a20-foot container and $600 to ship a 40-foot container. What is the total cost to get thecontainers to the United States? Do not include U.S. port costs in this part of the analysis
. A company has a central supply facility and a distribution center located 400miles away. The central supply product cost is $75, TL transportation rates fromcentral supply to the DC are $60 per unit, and handling costs at the DC are $4 perunit. Calculate the market boundary location and the landed cost at the marketboundary. LTL rates are $2 per unit per mile.
Determine how many products to ship from each factory to each warehouse, or from each factory to each warehouse and direct to each end customer, to minimize shipping cost while meeting warehouse demands and not exceeding factory supplies Explain the above scenario using the problem given below: Warehouse Capucity Factory w, W, W. (Supply) 21 16 25 13 F. F, 17 18 14 23 13 32 27 18 41 19 Requirement 6 (Demand) 10 12 15 43 Use least cost Method to solve the problem. Using Transportation method
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
1. A company would like to develop an aggregate plan and evaluate its cost using the transportation method. Solve using Excel of the QM software. Note: do not do this manually Related data are shown in the tables below Demand forecast Period Demand (Unit) 1 80 2 90 3 40 Supply Capacity available (units) Regular time 40 65 30 Period 1 2 3 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
Q3) The Cure medical distribution center distributes urgent medical equipment for five local hospitals in Washington DC metropolitan area. Cure Medical distribution would like to invest in a new warehouse in Washington DC to minimize the total distance from five major hospitals. The coordinate of the five hospitals is given below: ( (2) 3 Great Fall (C) (47) 122 (121) Fairfax 10 We W Bu (645) -D (-20, 30)- -E (-40, -30) Colesville Fairland Calpen A (10,60) -B (10,-10) Ⓡ South Lourel stuxent search Refuge (MA A (14) tille (214) pha Bowit (00 X -C (45, -20) 201 C a) Use Solver to determine where the new warehouse should be in to minimize the total distance from 5 hospitals. What are the coordinates of the new warehouse? b) Solve your problem again to minimize the maximum distance between hospitals and the new warehouse. What are the coordinates of the new warehouse?
What is the initial total cost of the given transportation model if an Intuitive Approach method is applied? DESTINATION SOURCE DEMAND O 3050 O 3140 O 3045 O 3040 X Y N 4 P 75 8 12 S 11 Q 80 5 8 11 R 120 7 10 10 S 50 11 13 14 SUPPLY 100 125 100 325
The solution to this problem is shown below. Use it to answer parts (b) through (e). Transportation Problem Optimal Transportation Schedule To Destination From From Origin 1 оооо 2 3 3 1 2 11 19 0 0 0 9 0 0 Origin Excess Supply 34 16 0 6 Total Transportation Cost or Revenue is 347 Note: The Total Supply Exceeds The Todal Demand By 16 0 3 (b) How many chairs are moved from Baker to Business? (c) How many chairs are moved from Tirey to Parsons? (d) How many chairs are moved from Arena to Education? (e) Which site(s) has (have) chairs left? (Select all that apply.) Baker Hall Tirey Hall Arena Business Education Parsons Hall Holmstedt Hall
Weighted factor methodUse the table to calculate the most ideal X coordinate for supermarket Point Quantity offered/requested Transportation costs Coordinate X Coordinate Y Supermarket 1 3,000 0.04 4 8 Supermarket 2 3,500 0.04 7 2 Supermarket 3 2,000 0.07 3 5 Supermarket 4 1,500 0.07 7 4 Supermarket 5 1,200 0.07 6 8