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
Get step-by-step solutions from verified subject matter experts
