Question: There is one problem to be solved. Define your decision variables clearly. You are not required to submit any answer report or sensitivity report for

There is one problem to be solved. Define your decision variables clearly. You are not required to submit any answer report or sensitivity report for any question.

Yoda Company produces chairs, tables, and sofas. Each product must pass through three departments: Department 1, Department 2, and Department 3. Yoda employs 29, 40, and 8 workers in Departments 1, 2, and 3, respectively. All workers work one 8-hour shift, 6 days a week. The number of sofas produced cannot exceed total number of chairs and tables produced. Moreover, the number of tables produced cannot exceed 60% of the total production. The following table gives the time requirements and profits per unit for these products.

Production Times (minutes per unit)

Department 1

Department 2

Department 3

Unit Profit ($)

Chair

30

80

12

8

Table

60

60

4

12

Sofa

60

100

8

15

Formulate this problem as an LP model to maximize total profit and then provide an excel solution.

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!