Answered Essay: Problem Implement the linear optimization model that you developed for Burger Office

Problem Implement the linear optimization model that you developed for Burger Office Equipment in Problem in Excel and use Solver to find an optimal solution. Interpret the Solver Answer report and identify the binding constraints and verify the values of the slack variables by substituting the optimal solution into the model constraints Problem 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. Standard desks require 70 board feet of pine and 10 hours of labor, whereas deluxe desks require 60 board feet of pine, 18 square feet of oak, and 15 hours of labor. For the next week, the company has 5,000 board feet of pine, 750 square feet of oak, and 400 hours of labor available. Standard desks net a profit of $225, and deluxe desks net a profit of $320. All desks can be sold to national chains such as Staples or Office Depot. a. Identify the decision variables, objective function, and constraints in simple verbal statements b. Mathematically formulate a linear optimization model.

Hi, Sir.

I have a homework so I want to know this problem.

(This probelm is a number 7 of chapter 13 in Business analytics 2ed)

Problem Implement the linear optimization model that you developed for Burger Office Equipment in Problem in Excel and use Solver to find an optimal solution. Interpret the Solver Answer report and identify the binding constraints and verify the values of the slack variables by substituting the optimal solution into the model constraints Problem 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. Standard desks require 70 board feet of pine and 10 hours of labor, whereas deluxe desks require 60 board feet of pine, 18 square feet of oak, and 15 hours of labor. For the next week, the company has 5,000 board feet of pine, 750 square feet of oak, and 400 hours of labor available. Standard desks net a profit of $225, and deluxe desks net a profit of $320. All desks can be sold to national chains such as Staples or Office Depot. a. Identify the decision variables, objective function, and constraints in simple verbal statements b. Mathematically formulate a linear optimization model.

Expert Answer

Answer to question a :

The required simple verbal statements as follows :

Decision variables : Number of each type of desks which must be sold under standard and Deluxe category

Objective function : To Maximize total profit by selling designated number of standard and deluxe desks

Constraints :

Following are the different types of constraints :

  1. The total quantity of pine required should not be more than 5000 board feet of Pine available
  2. The total quantity of oak required should not be more than 750 square feet of Oak available
  3. Total labour hours required for both products together should not be more than 400 hours of labor available

Answer to question b :

Let required number of desks to be produced as follows :

Standard desks = S numbers

Deluxe desks = D numbers

Where, S, D > = 0

Objective function :

Profit from S number of Standard desks = Profit per desk x Number of desks = $ 225.S

Profit from D number of deluxe desks = Profit per desk x Number of desks = $ 320.D

Therefore total profit earned , $ = 225S + 320D

Since, objective is to maximize profit,

Thus the objective function is = Z = Maximize ( 225.S + 320D)

Constraint function :

S, D > = 0

  1. Total quantity of Pine required for standard desks = 70.S

Total quantity of Pine required for deluxe desks = 60.D

Therefore,

Total quantity of Pine required = 70S + 60D Board feet of Pine

Since , maximum available Pine = 5000 board feet of Pine ,

70S + 60D < = 5000

  1. Total quantity of Oak required = 18D square feet of Oak

Since , maximum available Oak = 750 square feet

Therefore , 18D < = 750

  1. Total amount of labor hours required for S number of standard desks = 10.S

Total amount of labor hours required for D number of deluxe desks = 15.D

Thus total amount of labor hours required = 10S + 15.D hours

Since maximum available labor hours would be 400 hours

Therefore ,

10.S + 15.D < = 400

Buy Essay
Calculate your paper price
Pages (550 words)
Approximate price: -

Help Me Write My Essay - Reasons:

Best Online Essay Writing Service

We strive to give our customers the best online essay writing experience. We Make sure essays are submitted on time and all the instructions are followed.

Our Writers are Experienced and Professional

Our essay writing service is founded on professional writers who are on stand by to help you any time.

Free Revision Fo all Essays

Sometimes you may require our writers to add on a point to make your essay as customised as possible, we will give you unlimited times to do this. And we will do it for free.

Timely Essay(s)

We understand the frustrations that comes with late essays and our writers are extra careful to not violate this term. Our support team is always engauging our writers to help you have your essay ahead of time.

Customised Essays &100% Confidential

Our Online writing Service has zero torelance for plagiarised papers. We have plagiarism checking tool that generate plagiarism reports just to make sure you are satisfied.

24/7 Customer Support

Our agents are ready to help you around the clock. Please feel free to reach out and enquire about anything.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

HOW OUR ONLINE ESSAY WRITING SERVICE WORKS

Let us write that nagging essay.

STEP 1

Submit Your Essay/Homework Instructions

By clicking on the "PLACE ORDER" button, tell us your requires. Be precise for an accurate customised essay. You may also upload any reading materials where applicable.

STEP 2

Pick A & Writer

Our ordering form will provide you with a list of writers and their feedbacks. At step 2, its time select a writer. Our online agents are on stand by to help you just in case.

STEP 3

Editing (OUR PART)

At this stage, our editor will go through your essay and make sure your writer did meet all the instructions.

STEP 4

Receive your Paper

After Editing, your paper will be sent to you via email.