Question

The Wearever Carpet Company manufactures two brands of carpets-shag and sculptured-in 100 yard lots. It requires...

The Wearever Carpet Company manufactures two brands of carpets-shag and sculptured-in 100 yard lots. It requires 8 hours to produce one lot o shag carpet and 6 hours to produce one lot of sculpture carpet. The company has the following production goals, in prioritized order:

1) Do Not underutilize production capacity, which is 480 hours.

2) Achieve product demand for shag is more important than meeting demand for sculptured, by a ration of 5 to 2. 3) Limit production overtime to 20 hours

Solve:

a) Fromulate a Goal Programming Model to determine teh amount of shag and sculptured carpet to produce the best meet the company's goals.

b) Solve his model by using the computer (Excel and Solver)

c) include a separate sheet with your goal programming model: define each regular decision variable and deviational variable explicitly in your model, and indicate which goal each of your constraints refers to

Homework Answers

Answer #1

a) Goal programming model is following

Standard variables: Let S and C be the number of 100-yard lots of Shag (S) and Sculpted (C) carpets to be produced. O be the number of overtime hours to be used

Deviation variables: Let djp and djn be the positive and negative deviation variables respectively for jth goal

Min 3*d1n + 2*2*(5/7)*d2n + 2*2*(2/7)*d3n + 1*d4p

8S+6C-O <= 480

goal 1: 8S+6C-O-d1p+d1n = 480   

goal 2a: S - d2p + d2n = 40

goal 2b: C - d3p + d3n = 50

goal 3: O - d4p + d4n = 20

All variables >= 0

b) Solution using Excel Solver is following:

c) Optimal solution:

Values of Decision variables

S = 40

C = 30

O = 20 hours

Deviation variables:

d3- = 20

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 Wearever Carpet Company manufactures two brands of carpet, shag and sculptured, in 100-yard lots. It...
The Wearever Carpet Company manufactures two brands of carpet, shag and sculptured, in 100-yard lots. It requires eight hours to produce one lot of shag carpet and six hours to produce one lot of sculptured carpet. The company has the following production goals in prioritized order. (1) Do not underutilize production capacity, which is 480 hours. (2) Limit production overtime to 20 hours. (3) Achieve product demand of forty 100-yard lots for shag and fifty 100-yard lots for sculptured carpet....
A manufacturing company produces two products, which has the following information: Characteristic Product 1 Product 2...
A manufacturing company produces two products, which has the following information: Characteristic Product 1 Product 2 Profit/unit $4 $2 Dept. A hours/unit 1 1 Dept. B hours/unit 2 4 Last month’s production schedule used 400 hours of labor in department A and 950 hours of labor in department B. The management has been experiencing problems during the past six months because of variable monthly department workload amounts. Management would like to develop a production schedule for the coming month that...
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...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From the April 2004 Issue Save Share 8.95 In 1991, Progressive Insurance, an automobile insurer based in Mayfield Village, Ohio, had approximately $1.3 billion in sales. By 2002, that figure had grown to $9.5 billion. What fashionable strategies did Progressive employ to achieve sevenfold growth in just over a decade? Was it positioned in a high-growth industry? Hardly. Auto insurance is a mature, 100-year-old industry...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT