Can you help me find the solution using the SOLVER feature in Microsoft 365 excel? Thank you !
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 = 260 S + 360 D 75 S + 50 D $ 5000 (Availability of pine) 25 D $ 700 (Availability of oak) 10 S + 19 D = 400 (Availability of labor) S 2 0 and D 2 0 Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce standard desks and O deluxe desks. This solution gives the maximum possible profit, which is (Type integers or decimals rounded to two decimal places as needed.) Availability of pine is not a binding constraint and it has slack. Availability of oak is not a binding constraint and it has Availability of labor is a binding constraint and it has 0 slack (Type integers or decimals rounded to two decimal places as needed.)AutoSave . Off) Book1 - Excel O Search A rmurator R X File Home Insert Page Layout Formulas Data Review View Help 15 Share Comments La From Text/CSV To Recent Sources [ Queries & Connections III 24 7 2 P X clear Group 2, Solver G Le From Web La Existing Connections Refresh Properties Reapply 2B Ungroup -= Data Analysis Get Text to What-If Forecast Data From Table/Range Stocks Geography All v Edit Links Advanced Columns OF Anais Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analysis A1 X Y A B C D E F G H P Q R S T U V W UI AWN - 24 25 26 27 28 Sheet1 + Ready