Question

A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood. A desk contributes $400 to profit, and a chair contributes $250. Marketing restrictions require that the number of chairs produced be at least twice the number of desks produced. There are 2000 units of wood available.
1. High level model is setup for you to plug in and solve.
2. If you want to practice creating the model, you don't need to use the model setup in the second tab.
3. Use Solver to maximize the company’s profit. Make sure to name the cells properly to get full credit.
4. Use $ format for cells like cost, profit etc. Fill the information for objective function & constraints.

Answer 1

Step-by-step explanation:

Although I cannot find any model or solver, we can proceed to model the optimization problem from the information given.

the problem is to maximize profit.

let desk be x

and chairs be y

400x+250y=P (maximize)

4x+3y<2000   (constraints)

according to restrictions y=2x

let us substitute y=2x in the constraints we have

4x+3(2x)<2000

4x+6x<2000

10x<2000

x<200

so with restriction, if the desk is 200 then chairs should be at least 2 times the desk

y=2x

y=200*2

y=400

we now have to substitute x=200 and y=400 in the expression for profit maximization we have

400x+250y=P (maximize)

80000+100000=P

180000=P

P=$180,000

the profit is $180,000