What are the constraints A soft drink manufacturing company has three factories-one in Orlando, one in Tampa, and one in Port St. Lucie that supply soft drink bottles to three warehouses located in the city of Miami. The associatedper-unit transportation cost between the factories and the warehouses is provided in the table below.Factories/Warehouse (W)OrlandoTampaPort St. LucieTransportation Costs ($)WarehouseW1W2W3W1775The factory in Orlando has a capacity of 14,000 units.The factory in Tampa has a capacity of 25,000 units.The factory in Port St. Lucie has a capacity of 23,000 units.The requirements of the warehouses are:Requirement(Bottles)W2418,00019,00022,00065W3546Determine how much of the company's production should be shipped from each factory to each warehouse in order to minimize the total transportation cost? ABTransportation Costs ($)W112 Factories/Warehouse (W)3 Orlando4 Tampa5 Port St. Lucie6 Warehouse Requirement (Bottles)78 Model9 Production to be shipped10 Orlando11 Tampa12 Port St. Lucie131415 Constraints161718W17718000OOO000W2W2C4W35645619000 22000ܘܘܘDW30OOO00ECapacity140002500023000shipped004FGTransportation Costs ($)W1C11C12C13Factories/Warehouse (W)OutcomeOrlandoTampaPort St. LucieWarehouse Requirement (Bottles)H18000W2C21C22C23C11*B10+C21*C10+C31*D10+c12*B11+c22*d11+c13*B12+c23*C12+c33*D1219000W3C31C32C33J22000Minimum

This is a transportation problem. As from the excel image, let's consider each decision variable as…

Answered: What are the constraints

Business

Operations Management

What are the constraints

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?
Using the information in Problem (The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct a netmaterial requirements plan using the following on-hand inventory.
Subj: Business/ Operations Management Scenario: John used the AirBnB platform to book a condo for his staycation with his family on Dec 17 in Cebu, but due to the typhoon Odette, he had to cancel on Dec 16. Because the cancellation was done within 48 hrs, he's no longer eligible for a full refund. He also missed to file a claim within 14 days due to power outage and loss of internet connection caused by the typhoon. 1. Identify the problems with Airbnb’s current refund process. 2. Provide at least three possible solutions and include the pros and cons for each suggested solution then choose the best solution based on your assessment. 3. What are the pros and cons of the current policy versus your proposed solution?
Refer again to Problems( Using the information in Problem(The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct agross material requirements plan. ). In addition to100 units of S, there is also a demand for 20 units of U, which isa component of S. The 20 units of U are…
Finance Mrs Banks baked some curry puffs. She packed them into boxes of 7 and had 3 curry puffs left. If she had 39 boxes of curry puffs, how many of them did she bake?
Select one CORRECT OPTION Network Planning in SCM does not impact the following a.Match supply and demand b.SCM Cost c.Optimize resources utilization d.New product launch
The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure.
Suppose that you're a CTO of a company and tasked of building a new warehouse for your Org's systems, answer the following questions in detail and explain why? Tell me about: Location of the warehouse ( State in the US)- where and why? How many systems you will request? Cooling considerations, and why? Expected rough estimate on cost to build and configure the warehouse (land, building cost, system cost, internet, power)?
Jerusalem Medical Ltd., an Israeli producer of portablekidney dialysis units and other medical products, developsa 4-month aggregate plan. Demand and capacity (in units) areforecast as follows: The cost of producing each dialysis unit is $985 on regular time,$ 1,310 on overtime, and $1,500 on a subcontract. Inventory carryingcost is $100 per unit per month. T here is to be no beginning or endinginventory in stock and back orders are not permitted. Set up a productionplan that minimizes cost using the transportation method.
1 to 4 are based on this problem.Jack is considering purchase the following items for his backpacking trip. The cost and the condition of each item are listed in the following table: Item Number Description Condition 1 Backpacking Tarp Not if 3 and only if 2 2 Hammock Not if 3 3 Backpacking Tent Not if 1 or 2 4 Sleeping Bag Must if 5 5 Sleeping Pad Only if 4 Ci is the Cost of item i. Jack needs at least 3 items. Formulate an IP to minimize the total cost. Decision Variables: Xi=1 if item i is purchased; 0 otherwise. Question 1: What are the constraints for item 1? a.) X1+X3<=1; X2-X1<=0 b.) X1-X2-X3<=-1 c.) X1+X3<=1; X1-X2<=0 d.) X1+X3>=1; X1-X2<=0 Question 2: What is the constraint for item 2? a.) X2-X3<=0 b.) X2+X3<=1 c.) X2+X3>=1 d.) X2+X3<=0 Question 3: What is the constraint for item 4? a.) X4+X5>=0 b.) X4-X5>=0 c.) X4-X5<=0 d.) X4+X5<=0 Question 4: Which statement about the formulation is not true? a.) In this…
How did you get the total demand as 640 and why is the anwser 46 can you express it algebraicly