Answer:
The maximum profit is $72,800 with 80 cabinets of Mission-style and no cabinets of Rustic-style to be used
Explanation:
Let the furniture cabinet maker produce x Mission-style cabinets and y Rustic-style cabinets
Objective function: Maximize profits
Profit yielded by a Mission-style cabinet = $910
Profit yielded by x Mission-style cabinets = $910 * (x)
Profit yielded by a Rustic-style cabinet = $1200
Profit yielded by y Rustic-style cabinet = $1200 * (y)
Objective function: Max (910x + 1200y)
Subjected to Constraints
Labor Hours: No of hours required to produce a Mission-style cabinet =15
No of hours required to produce a Rustic-style cabinet =20
Total Labor Hours = 1200
Constraint 1) 15*(x) + 20*(y) = 1200
Budget = $30,000
Cost of materials for a Mission-style cabinet =$340
Cost of materials for a Rustic-style cabinet =$430
Constraint 2) 340*(x) + 430*(y) <= 30000
Constraint 3) x and y >= 0
Put these constraints in Excel solver, we obtain the maximum profit as $72,800 with 80 cabinets of Mission-style and no cabinets of Rustic-style to be used
