Question: Most use Solver to develop a solution. Show your steps on your Excel sheet. Solve for the value of the objective function and the variables.

Most use Solver to develop a solution. Show your steps on your Excel sheet.
Solve for the value of the objective function and the variables. Since the decision centers on the production of the two different cabinet models, we let
x= number of French Provincial cabinets produced each day
y= number of Danish Modern cabinets produced each day
Objective: Max $39x+$44y
subject to
Constraint #:
(1)2x+3y300 hours (carpentry department)
(2)2x+1y200 hours (painting department)
(3)75x+1y150 hours (finishing department)
(4)x35 units (contract requirement)
x,Y0
a. what is the value of the objective function?
b. what is the value of x and y?
c. what is the slack for constraint 3?
d. what constraints #'s are binding?
 Most use Solver to develop a solution. Show your steps on

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!