Question

In: Operations Management

The Versatech Corporation has decided to produce three new products. Five branch plants now have excess...

  1. The Versatech Corporation has decided to produce three new products. Five branch plants now have excess production capacity. The unit manufacturing cost of the first product would be $31, $29, $32, $28, and $29 in Plants 1, 2, 3, 4, and 5, respectively. The unit manufacturing cost of the second product would be $45, $41, $46, $42, and $43 in Plants 1, 2, 3, 4, and 5, respectively. The unit manufacturing cost of the third product would be $38, $35, and $40 in Plants 1, 2, and 3, respectively, whereas Plants 4 and 5 do not have the capability for producing this product. Sales forecasts indicate that 600, 1000, and 800 units of products 1, 2, and 3, respectively, should be produced per day. Plants 1, 2, 3, 4, and 5 have the capacity to produce 400, 600, 400, 600, and 1000 units daily, respectively, regardless of the product or combination of products involved. Assume that any plant having the capability and capacity to produce them can produce any combination of the products in any quantity.

  2. (a) Write down an optimization formulation for this problem. Remark: You need to write down the abstract optimization formulation, explain the meaning of each optimization variable and explain what are the data.

  3. (b) There is no “transportation” in the problem statement (there is no “truck”, no “route”). Nevertheless, the formulation is similar to a transportation problem. Ex- plain how to view this problem as a transportation problem.
  4. (c) Solve the problem and report the optimal solution and optimal cost. You can use software to solve the problem; if so, please provide the code (e.g. copy the code to the solution file, or take a snapshot and paste the picture in the solution file).

Solutions

Expert Solution

(a)

Optimization model is as follows:

Let Xij be the number of product i to be produced in plant j

Minimize 31X11+29X12+32X13+28X14+29X15+45X21+41X22+46X23+42X24+43X25+38X31+35X32+40X33

s.t.

X11+X12+X13+X14+X15 = 600

X21+X22+X23+x24+X25 = 1000

X31+X32+X33 = 800

X11+X21+X31 <= 400

X12+X22+X32 <= 600

X13+X23+X33 <= 400

X14+X24+X34 <= 600

X15+X25+X35 <= 1000

X34, X35 = 0

Xij >= 0

---------------------------------------------------------------------------------------------------------------

(b)

There is no "transportation" in the problem statement. However, the problem is about deciding how many products of each type to be produced in each plant. In transportation analogy, each product type is a demand node, each plant is a capacity node and manufacturing cost is equivalent of transportation cost.

---------------------------------------------------------------------------------------------------------------

(c)

Create spreadsheet model as follows:

Enter Solver Parameters as follows:

Click Solve to generate the solution. After that, values appear automatically in yellow cells (B11:F13).

Click OK

-----------------

Alternatively, solution can be obtained by LINGO as follows:

---------------------------------------------------------------------------------------------------------------


Related Solutions

The Weigelt Corporation has three branch plants with excess production capacity. Fortunately, the corporation has a...
The Weigelt Corporation has three branch plants with excess production capacity. Fortunately, the corporation has a new product ready to begin production, and all three plants have this capability, so some of the excess capacity can be used in this way. This product can be made in three sizes--large, medium, and small--that yield a net unit profit of $420, $360, and $300, respectively. Plants 1, 2, and 3 have the excess capacity to produce 750, 900, and 450 units per...
Shoe Supply has decided to produce a new line of shoes that will have a selling...
Shoe Supply has decided to produce a new line of shoes that will have a selling price of $68 and a variable cost of $27 per pair. The company spent $187,000 for a marketing study that determined the company should sell 85,000 pairs of the new shoes each year for three years. The marketing study also determined that the company will lose sales of 24,000 pairs of its high-priced shoes that sell for $129 and have variable costs of $63...
Unicola has now decided that it wants to build a $500,000,000 manufacturing facility to produce the...
Unicola has now decided that it wants to build a $500,000,000 manufacturing facility to produce the packaging for a series of new soft drink and snack food lines. The company is doing this in order to save costs and maximize efficiencies in its quest for a better market presence in the Asia region. They are interested in potentially locating, building, and operating a single manufacturing facility in one of these foreign markets: Bangladesh, Hong Kong, India, Indonesia, Malaysia, Pakistan, Singapore,...
You have decided that now is the time to buy a new laptop. List the factors...
You have decided that now is the time to buy a new laptop. List the factors that are important in choosing a new laptop and gather relevant information from various sources about different models on the market. Given that you have a maximum of $1600 to spend, identify which model you will buy and discuss the reasons for your choice. Present your answer so as to illustrate the steps required in the decision-making process as discussed in this chapter. “Accounting...
1. You have decided that now is the time to buy a new laptop. List the...
1. You have decided that now is the time to buy a new laptop. List the factors that are important in choosing a new laptop and gather relevant information from various sourcees about different models on the market. Given that you have a maximum of $1600 to spend, identify which model you will buy and discuss the reason for your choice. present your answer so as to illustrate the steps required in the decision-making process as discussed in the chapter?...
Question 1 Muzi Corporation produces three products at two different plants. The cost of producing a...
Question 1 Muzi Corporation produces three products at two different plants. The cost of producing a unit at each plant is given in the following table. Plant A Plant B Product 1 Product 2 Product 3 R5 R6 R8 R8 R7 R10 Each plant has the capacity to produce a total of 10 000 units. Demand for at least 6 000 units of product 1, at least 8 000 units of product 2 and at least 5 000 units of...
Mountain Distribution has decided to analyze the profitability of five new customers. The company has the...
Mountain Distribution has decided to analyze the profitability of five new customers. The company has the following​ activities: Activity Cost Driver Rate Order taking $80 per purchase order Customer visits $80 per customer visit Deliveries $4.00 per delivery mile travelled Product handling $0.85 per case sold Expedited deliveries $335 per expedited delivery. It buys bottled water at ​$12.20 per case and sells to retail customers at a list price of $14.50 per case. Data pertaining to the five customers​ are:...
The owners of a new venture have decided to organize as a corporation. The initial equity...
The owners of a new venture have decided to organize as a corporation. The initial equity investment is valued at $100,000, reflecting contributions of the entrepreneur and her family and friends. On hundred thousand shares of stock were initially issued. What dollar amount would initially be recorded in the common stock account? If a par value on the common stock were set at $0.01 per share, show how the initial equity investment would be recorded. Now assume that 20,000 additional...
the kelowna go-kart club has decided to build a clubhouse five years from now. it must...
the kelowna go-kart club has decided to build a clubhouse five years from now. it must accumulate $50000 by the end of five years by setting aside a uniform amount from its dues at the end of each year. if the imterest rate is 10 percent, how much must be set aside each year?
Cholesterol Dairy Products has plants in five provinces and operates a very large home delivery service....
Cholesterol Dairy Products has plants in five provinces and operates a very large home delivery service. Sales last year were $100 million, and the balance sheet at year-end is similar in percent of sales to that of previous years (and this will continue in the future). All assets and current liabilities will vary directly with sales. Assume the firm is already using capital assets at full capacity. Balance Sheet (in $ millions) Assets Liabilities and Shareholders' Equity Cash $5 Accounts...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT