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 numbers 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,
1,200 short dowels, and 1,056 long dowels available. The company
wants to maximize its profit while also ensuring that it makes at
least half as many His chairs as Hers chairs.
(a) Build a table that shows the capacity usage breakdown and profit contribution of the two products.
(b) Formulate a linear optimization model for this problem. (Such as the model on slide 16 of the "9.2" slides – that slide is not numbered, but it’s the one after slide 15.)
(c) Build a spreadsheet representation of the model, and then solve it using Solver. Identify the production amounts of each product and total profit at the solution point. In other words, report how many of each type of chair they should produce and how much profit that will generate. Keep the Solver solution as part of your spreadsheet.
there is one constraint left
x - 0.5y >= 0
but it does not change the solution
Get Answers For Free
Most questions answered within 1 hours.