Question

Utopia Company operates a plant in Avalon with a monthly capacity of 35,000 units and a...

Utopia Company operates a plant in Avalon with a monthly capacity of 35,000 units and a plant in Bridgetown with a monthly capacity of 40,000 units. Product is shipped to regional distribution centers located in Riverdale, Seaside and Teatown.

The long-range planning group at Utopia reevaluated their forecasts and determined that due to an anticipated increase in demand in the next 5 years, the company should consider increasing capacity by constructing a new plant in one or more of the following cities: Cedar, Daphne, Elm or Florence.

Let Xij = the units shipped from plant i to distribution center j, with i = A, B, C, D, E or F and j = 1, 2, 3. For example, XD1 designates the # of units shipped from Plant D to Distribution Center 1.

(a) Why is the company considering opening at least one new plant?

(b) How many shipment variables will the LP formulation have? (That is, how many Xij variables are

included in the formulation?)

(c) Why do we need to introduce binary variables YC, YD, YE and YF? Do we need a binary

variables YA and YB? Why?

(d) Formulate a linear programming model for minimizing total costs (shipping costs+fixed costs);

you should have a total of 9 constraints. You can use steps (i)-(iv) below as a guide for writing the LP

Use suitable variables to express the objective function (minimize shipping costs + fixed costs).

Write the demand constraints for Distribution Centers 1, 2 and 3.

Write the supply constraints for plants A and B.

Use suitable variables to write the supply constraints for plants C, D, E and F.

(e) Write a constraint to express a requirement that the company will open only one new plant

(f) If the company will open only one plant, which plant do you think it will be C, D, E or F? Why?

(g) Write a constraint to express a requirement that the company will either open both plants C and D or neither of them (that is, if plant C opens then plant D has to open as well and if plant D is open then Plant C has to open too)

Homework Answers

Answer #1

a. The Company is considering opening atleast one new plant, in order to meet the increased demand in the coming future period.The company will then be able to main its market share and not lose its share to competitors. ALso this will help the company expand its volumes and hence increase turnover and profits.

b. 18 shipment variables.

c. it is important to introduce a Binary Variable, to calculate the investment required in case of opening a new plan in each prospective area and consider the opportunity cost in case the amount is not invested and the loss of opportunity of selling more units in case of increased demand. YA and YB are required in case it is decided to not ship from existing units if the new plants work out more economic in terms of capacity,productivity and efficiency.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The Martin-Beck Company operates a plant in St. Louis with an annual capacity of 30,000 units....
The Martin-Beck Company operates a plant in St. Louis with an annual capacity of 30,000 units. Product is shipped to regional distribution centers located in Boston, Atlanta, and Houston. Because of an anticipated increase in demand, Martin-Beck plans to increase capacity by constructing a new plant in one or more of the following cities: Detroit, Toledo, Denver, or Kansas City. The estimated annual fixed cost and the annual capacity for the four proposed plants are as follows: Proposed Plant Annual...
please solve in excel A computer manufacturing company wants to develop a monthly plan for shipping...
please solve in excel A computer manufacturing company wants to develop a monthly plan for shipping finished products from three of its manufacturing facilities to three regional warehouses. It is thinking about using a transportation LP formulation to exactly match capacities and requirements. Data on transportation costs (in dollars per unit), capacities, and requirements are given below. ​                                           Warehouse   Plant                              1          2          3         Capacities A                               2.41     1.63     2.09         4,000 B                               3.18     5.62     1.74         6,000 C                               4.12     3.16     3.09         3,000 Requirement              8,000   2,000   3,000 ​ a.   How many variables are involved in the LP formulation? b.   How many constraints are there in...
Valence Pharmaceuticals has three manufacturing facilities in the US where they produce an anticancer drug. The...
Valence Pharmaceuticals has three manufacturing facilities in the US where they produce an anticancer drug. The drug is shipped from the plants to four distribution centers. Plants 1, 2, and 3 produce 12, 17, and 11 shipments per month, respectively. The distribution centers, A, B, C, and D, each needs to receive 10 shipments per month. The distance (in miles) from each plant to each distribution center is shown in the following table: Distribution Center Plant                A                     B                     C                     D 1                      800                  1,300               400                  700 2                      1,100               1,400               600                  1,000 3                      600                  1,200               800                  900 The...
1. The transportation problem done in class is to find how many generators should be shipped...
1. The transportation problem done in class is to find how many generators should be shipped from each manufacturing facility to each distribution center so that shipping cost is minimized. To remind you, the LP is Min Transportation costs: 3x11 + 2 x12 + 7 x13 + 6 x14 + 7x21 + 5 x22 + 2 x23 + 3 x24 + 2x31 + 5 x32 + 4 x33 + 5 x34 s.t. Need to make sure demand at destination is...
Fork International Company has five distribution centers which are located at the coordinates as follows. The...
Fork International Company has five distribution centers which are located at the coordinates as follows. The demand at each distribution center are also provided. Distribution Center xy-Coordinates Demand Quantity A (2,4) 10 B (6,2) 15 C (4,10) 25 D (13,4) 30 E (10,5) 20 (i) Determine the coordinates of the center of gravity of the five distribution centers. (ii) If a plant is built at the center of gravity of the five distribution centers, what is the load-distance score? (Assume...
A company produces a certain product and has the capacity to produce 100 units per month...
A company produces a certain product and has the capacity to produce 100 units per month in regular time, and an additional 15 units per month in overtime. The production cost of the product varies by month due to changes in the material costs over time. The quantities of the product to be delivered over the next six months have already been set. The delivery requirements and production costs are given in the following table: Month 1 2 3 4...
Jerston Company has an annual plant capacity of 4,000 units. Data concerning this product are given...
Jerston Company has an annual plant capacity of 4,000 units. Data concerning this product are given below:    Annual Sales at Regular Selling Prices    3,400 Units    Manufacturing Costs:             Variable $15.00 Per Unit    Fixed $60,000.00 Per Year    Selling and Administrative Expenses:          Variable $4.00 Per Unit    Fixed $8,500.00 Per Year The company has received a special order for 600 units at a selling price of $22 each. Regular sales would...
A company manufactures a product that is sold for $37.95 each. Plant capacity is 750,000 units...
A company manufactures a product that is sold for $37.95 each. Plant capacity is 750,000 units annually, but normal volume is 500,000 units. Costs at a normal volume are given below. Unit Cost Direct Materials $9.72 Direct Labor $4.79 Variable Manufacturing Overhead $11.21 Fixed Costs $4.37 Selling and Administrative Variable Expense $2.28 A customer offered to purchase 50,000 units at $33.72 each to be packaged in large cartons, not the normal individual product containers. It will pick up the units...
Tochet Company manufactures CB1, a citizens band radio. The company’s plant has an annual capacity of...
Tochet Company manufactures CB1, a citizens band radio. The company’s plant has an annual capacity of 50,000 units. Tochet currently sells 40,000 units at a price of $105. It has the following cost structure: Variable manufacturing cost per unit $45 Fixed manufacturing costs $800,000 Variable marketing and distribution cost per unit $10 Fixed marketing and distribution costs $600,000 The Marketing Department indicates that decreasing the selling price to $99 would increase sales to 50,000 units. This strategy will require Tochet...
Please show in excel with equations! 1) A Chemical company manufactures three chemicals: A, B, and...
Please show in excel with equations! 1) A Chemical company manufactures three chemicals: A, B, and C. These chemicals are produced via two production processes: 1 and 2. Running process 1 for an hour costs $400 and yields 300 units of A, 100 unit of B, and 100 unit of C. Running process 2 for an hour costs $100 and yields 100 unit of A and 100 unit of B. To meet customer demands, at least 1000 units of A,...