Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you help me find the solution using the SOLVER feature in Microsoft 365 excel? Thank you ! Burger Office Equipment produces two types of

Can you help me find the solution using the SOLVER feature in Microsoft 365 excel? Thank you !

image text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of College Algebra

Authors: Margaret L Lial, John E Hornsby, David I Schneider, Teresa McGinnis

10th Edition

0321970632, 9780321970633

More Books

Students also viewed these Mathematics questions

Question

Do not go, wait until I come

Answered: 1 week ago

Question

Pay him, do not wait until I sign

Answered: 1 week ago