Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Burger office equipment produces two types of desks, standard and deluxe. deluxe

ID: 3121782 • Letter: B

Question

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, ad constraints in simple verbal statements.

b. mathematically formulate a linear optimization model.

then answer the question:

The decision variables in the correct formulation of Problem 13.3 are:

*The amount of pine, oak, and labor to use

The number of standard and deluxe desks to produce

*The number of standard and deluxe desks to produce and amount of pine, oak, and labor to use

*The amount of profit to achieve

If you could answer the problem and attach the excel that would be very helpful. thanks.

*The amount of pine, oak, and labor to use

*

The number of standard and deluxe desks to produce

*The number of standard and deluxe desks to produce and amount of pine, oak, and labor to use

*The amount of profit to achieve

If you could answer the problem and attach the excel that would be very helpful. thanks.

Explanation / Answer

The variables in a linear program are a set of quantities that need to be determined in order to solve the problem; i.e., the problem is solved when the best values of the variables have been identified.

therefore the decision variables are :- The number of standard and deluxe desks to produce.

objective function is to maximize the total profit .

suppose x - number of standard desks

y - number of deluxe desk

constraints :-

70x + 60 y< 5000

18y < 750

10x+15y < 400

Maximize Z = 225 x+ 320 y

then constraints are

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Chat Now And Get Quote