Question: Implement the linear optimization model that you developed for Burger Office Equipment in Problem 6 on a spreadsheet and use Solver to find an optimal
Implement the linear optimization model that you developed for Burger Office Equipment in Problem 6 on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the binding constraints, and verify the values of the slack variables by substituting the optimal solution into the model constraints.
Burger Office Equipment produces two types of desks, standard and deluxe. Deluxe desks have oak tops and more-expensive hardware and require additional time for finishing and polishing. Standard desks require 70 board feet of pine and 10 hours of labor, whereas deluxe desks require 50 board feet of pine, 20 square feet of oak, and 18 hours of labor. For the next week, the company has 5,000 board feet of pine, 750 square feet of oak, and 400 hours of labor available. Standard desks net a profit of $250, and deluxe desks net a profit of $350. All desks can be sold to national chains such as Staples or Office Depot.
Step by Step Solution
There are 3 Steps involved in it
To tackle this problem well follow these steps Step 1 Formulate the Linear Optimization Model Decision Variables Let x be the number of standard desks ... View full answer
Get step-by-step solutions from verified subject matter experts
