Oakton Manufacturing makes two types of rocking chairs specifically designed for

Question

Oakton Manufacturing makes two types of rocking chairs specifically designed for men and women known as the His and Hers models. Each chair requires four legs and two rockers but differing number of wooden dowels. Each His chair requires four short dowels and eight long dowels while each Hers chair requires eight short dowels and four long dowels. Each His chair contributes $10 in profit while each Hers chair contributes $12. The company has 900 legs, 400 rockers, 1200 short dowels, and 1056 long dowels available. The company wants to maximize its profit while also ensuring that it makes at least half as many His chair as Hers chairs.

Implement a Spreadsheet model for this problem and solve it using solver.

Explanation / Answer

Let x1 be the number(his) of model M to be produced

and x2 be the number(her) of model N to be produced.

x1 , x2 0.

The manufacturer gets profit of 10$ for model M and 12$ for model N. So the objective function is to maximize profit P = 10x1 + 12x2

Given Each His chair requires 4 short dowels and 8 long dowels while

each Hers chair requires 8 short dowels and 4 long dowels

Company has  1200 short dowels, and 1056 long dowels,

short dowels: 4x1 + 2x2 1200

Long dowels: 8x1 + 4x2 1056

The company has 900 legs, 400 rockers ,

where Each chair requires 4 legs and 2 rockers but differing number of wooden dowels

Thus, the manufacturer’s allocation problem is to Maximize

P = 10x1 + 12x2

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.