Question: Linear Programming: Please solve Using solver int the excel. The master must put 6 workers to perform 6 typical operations. From the timekeeping data, it
Linear Programming: Please solve Using solver int the excel.
The master must put 6 workers to perform 6 typical operations. From the timekeeping data, it is known how many minutes, on average, each worker spends on each operation. These data are presented in the table2.
Table 2.
| Works
| Workers
| |||||
| A | B | C | D | E | F | |
| 1 | 10 | 11 | 9 | 12 | 8 | 7 |
| 2 | 6 | 8 | 15 | 7 | 5 | 16 |
| 3 | 7 | 8 | 10 | 9 | 3 | 11 |
| 4 | 5 | 9 | 6 | 6 | 10 | 8 |
| 5 | 3 | 4 | 12 | 8 | 2 | 5 |
| 6 | 5 | 7 | 11 | 10 | 4 | 9 |
How to distribute workers by operations so that the total cost of working time would be minimal?
Write detailed conclusions.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
