Question

In: Operations Management

A soft drink manufacturing company has 3 factories - one in Orlando, one in Tampa, and...

A soft drink manufacturing company has 3 factories - one in Orlando, one in Tampa, and one in Port St. Lucie - which supply soft drink bottles to 3 warehouses located in the city of Miami. The associated per-unit transportation cost between the factories and the warehouses is provided in the table below.

Transportation Costs of Factories ($):

Factories / Warehouses W1 W2 W3
Orlando 6 4 5
Tampa 7 6 5
Port St. Lucie 5 7 6

The factory in Orlando has a capacity of 20,000 units.

The factory in Tampa has a capacity of 20,000 units.

The factory in Port St. Lucie has a capacity of 23,000 units.

The requirements of the warehouses are:

Warehouse Requirement (Bottles)
W1 20,000
W2 19,000
W3 22,000

The descriptive model for the optimization model is given below. Let:

D11 = number of bottles shipped from Orlando to W1

D12 = number of bottles shipped from Orlando to W2

D13 = number of bottles shipped from Orlando to W3

D21 = number of bottles shipped from Tampa to W1

D22 = number of bottles shipped from Tampa to W2

D23 = number of bottles shipped from Tampa to W3

D31 = number of bottles shipped from Port St. Lucie to W1

D32 = number of bottles shipped from Port St. Lucie to W2

D33 = number of bottles shipped from Port St. Lucie to W3

Minimize: 6D11 + 4D12 + 5D13 + + 7D21 + 6D22 + 5D23 + 5D31 + 7D32 + 6D33

Subject to:

D11 + D12 + D13 <= 20000

D21 + D22 + D23 <= 20000

D31 + D32 + D33 <= 23000

D11 + D21 + D31 >= 20000

D12 + D22 + D32 >=19000

D13 + D23 + D33 >= 22000

All Dij >= 0

Solve the model in Excel and answer the questions below

How much of the companies production should be shipped from each factory to each warehouse in order to minimize the total transportation cost? Enter your answers as integers.

Solutions

Expert Solution


Related Solutions

WRITE OBJECTIVE FUNCTION AND CONSTRAINTS. A soft drink manufacturing company has 3 factories—one in Orlando, one...
WRITE OBJECTIVE FUNCTION AND CONSTRAINTS. A soft drink manufacturing company has 3 factories—one in Orlando, one in Tampa, and one in Port St. Lucie—which supply soft drink bottles to 3 warehouses located in the city of Miami. The associated per-unit transportation cost table is provided below.                                            Transportation Costs ($) Factories/Warehouse (W) W1 W2 W3 Orlando 4 3 7 Tampa 7 6 4 Port St. Lucie 3 6 6 The factory in Orlando has a capacity of 15,000 units. The...
A soft drink company has recently received customer complaints about its one-liter-sized soft drink products. Customers...
A soft drink company has recently received customer complaints about its one-liter-sized soft drink products. Customers have been claiming that the one-liter-sized products contain less than one liter of soft drink. The company has decided to investigate the problem. According to the company records, when there is no malfunctioning in the beverage dispensing unit, the bottles contain 1.02 liters of beverage on average, with a standard deviation of 0.15 liters. A sample of 70 bottles has been taken to be...
Consider you are a regional soft drink company competing in the US soft drink market. Dr....
Consider you are a regional soft drink company competing in the US soft drink market. Dr. Pepper was such a player, operating mostly in and around Texas. How could you compete successfully in this industry that is dominated by two large companies? Use appropriate frameworks to support your answer.
1 )Why, historically, has the soft drink industry been so profitable? Soft drink plays an important...
1 )Why, historically, has the soft drink industry been so profitable? Soft drink plays an important role in the people’s daily life. There is no doubt that this industry is profitable. The soft drink can be found in everywhere in the world, and the reasons of its high profit have several aspects. The first aspect is a little capital investment and material cost. They include that machinery, overhead, labor, and materials. The machinery, overhead, and labor are the basic requirements...
(Yoggo Soft Drink) A small, privately owned Asian company is producing a private-label soft drink, Yoggo....
(Yoggo Soft Drink) A small, privately owned Asian company is producing a private-label soft drink, Yoggo. A machine-paced line puts the soft drinks into plastic bottles and then packages the bottles into boxes holding 10 bottles each. The machine-paced line is com-prised of the following four steps: (1) the bottling machine takes 1 second to fill a bottle, (2) the lid machine takes 3 seconds to cover the bottle with a lid, (3) a labeling machine takes 5 seconds to...
A soft drink bottling company just ran a long line of 12-ounce soft drink cans filled...
A soft drink bottling company just ran a long line of 12-ounce soft drink cans filled with cola. A sample of 32 cans is selected by inspectors looking for non-conforming items. Among the things the inspectors look for are paint defects on the can, improper seal, incorrect volume, leaking contents, incorrect mixture of carbonation and syrup in the soft drink, and out-of-spec syrup mixture. The results of this inspection are given here. Construct a c chart from the data. Can...
Part I: Soft Drink Case (randomized block ANOVA) A soft drink producer has developed four new...
Part I: Soft Drink Case (randomized block ANOVA) A soft drink producer has developed four new products with different flavors. The company wants to know whether customers have different preferences for these four products. Six persons were asked to sample taste and rate each flavor on a scale of 1- 20. The data are given in the Excel dataset “drink.xls” which is attached. Based on the data given, with a significance level of α = 0.05, conduct a formal hypothesis...
Management of a soft-drink bottling company has the business objective of developing a method for allocating...
Management of a soft-drink bottling company has the business objective of developing a method for allocating delivery costs to customers.  Although one cost clearly relates to travel time within a particular route, another variable cost reflects the times required to unload the cases of soft drink at the delivery point.  To begin, management decided to develop a regression model to predict delivery time based on the number of cases delivered.  A sample of 20 deliveries within a territory was selected.  The delivery times and...
A manufacturing company produces products at three factories designated as numbers 1, 2, and 3. The...
A manufacturing company produces products at three factories designated as numbers 1, 2, and 3. The products are shipped to two demand destinations designated as A and B. For the coming month, production will be: Factory 1 = 3,000 units; Factory 2 = 2,500 units; and Factory 3 = 4,200 units. And for the coming month, demand will be: Destination A = 4,500 units and Destination B = 6,000 units. Which of the following is a correct linear programming constraint...
Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual...
Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3,200 cases. A case of the soft drink costs R&B $4. Ordering costs are $23 per order and holding costs are 21% of the value of the inventory. R&B has 250 working days per year, and the lead time is 5 days. Identify the following aspects of the inventory policy: Economic order quantity. If required, round your answer to two decimal...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT