Johnson 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 80 board feet of pine and 10 hours of labor, whereas deluxe desks require 60 board feet of pine, 18 square feet of oak, and 16 hours of labor. For the next week, the company has 5,000 board feet of pine, 750 board feet of oak, and 400 hours of labor available. Standard desks net a profit of $150, and deluxe desks net a profit of $320. All desks can be sold to national chains such as Staples or Office Depot.
a. What is the objective function?
b. What are the equations for the constraints?
c. Set up your linear program in Microsoft Excel. Solve it using the Solver add-in.
d. What is the optimal solution? Identify the number of desks to build and the total profit.
e. Which constraints use all of the available resources? Which constraints have resources remaining?