Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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. MaximizeProfit=20D80011S+18D400240S+360D70S+45D5000(Availabilityofpine)(Availabilityofoak)S0andD0 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 possible profit, which is $ (Type integers or decimals rounded to two decimal places as needed.) \begin{tabular}{lrr} Availability of pine & a binding constraint and it has & slack. \\ Availability of oak & a binding constraint and it has & slack. \\ Availability of labor & - a binding constraint and it has & slack. \end{tabular} (Type integers or decimals rounded to two decimal places as needed.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started