B)

Availability of pine (is/is not) a binding constraint and it has ______ slack. Availability of oak (is/is not) a binding constraint and it has ______slack. Availability of labor (is/is not) a binding constraint and it has ______slack.

Please show how to solve this using SOLVER in excel. thanks!

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. After reviewing the hardware and labor required, along with the profit for each model, Burger Office Equipment found the following linear optimization model for profit, where S is the number of standard desks produced and D is the number of deluxe desks produced. Implement the linear optimization model on a spreadsheet and use Solver to find an optimal solution. Interpret the optimal solution, identify the binding constraints, and verify the values of the slack variables Maximize Profit = 240 S + 340 D 65 S +50 D56000 15 D S 750 9 S +19 DS 300 S20 and D20 (Availability of pine) (Availability of oak) (Availability of labor) Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce standard desks and deluxe desks. This solution gives the (Type integers or decimals rounded to two decimal places as needed.) possible profit, which is $