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+350 D 65 S+45 D≤ 6000 20 D≤ 800 9 S+18 D≤500 S≥0 and D≥0 (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 maximum possible profit, which is $ (Type integers or decimals rounded to two decimal places as needed.)

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter11: Linear Optimization Models
Section: Chapter Questions
Problem 1P: Kelson Sporting Equipment, Inc., makes two types of baseball gloves: a regular model and a catchers...
icon
Related questions
Question
I dont need to know how to use solver. I just want to know the optimal solution to produce for both, and the profit.
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+350 D
65 S+45 D≤ 6000
20 D≤ 800
9 S+18 D≤500
S≥0 and D≥0
(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 maximum possible profit, which is $
(Type integers or decimals rounded to two decimal places as needed.)
Transcribed Image Text: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+350 D 65 S+45 D≤ 6000 20 D≤ 800 9 S+18 D≤500 S≥0 and D≥0 (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 maximum possible profit, which is $ (Type integers or decimals rounded to two decimal places as needed.)
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,