Hi please help me solve these problems using the excelsolver
Hi Please Help Me Solve These Problems Using The Excel Solver 1 (124.87 KiB) Viewed 97 times
Hi Please Help Me Solve These Problems Using The Excel Solver 2 (115.45 KiB) Viewed 97 times
Hi Please Help Me Solve These Problems Using The Excel Solver 3 (121.77 KiB) Viewed 97 times
A machine operator needs to perform two operations, turning and threading, on a number of different jobs. The time required to perform these operations in minutes for each job is given. Determine the order in which the jobs should be processed in order to minimize the total time required to turn out all the jobs. Jobs: Time for turning (in min.) Time for threading (in min). 1 3 8 2 12 10 3 5 9 4 2 6 5 9 3 6 11 1
There are seven jobs, each of which has to be processed on machine A and then on Machine B (order of machining is AB). Processing time is given in hours. Find the optimal sequence in which the jobs are to be processed so as to minimize the total time elapsed. JOB: MACHINE: A (TIME IN HOURS). MACHINE: B (TIME IN HOURS). 1 3 8 2 12 10 3 15 10 4 6 6 5 10 12 6 11 1 7 9 3
Find the optimal sequence that minimizes the total elapsed time required to complete the following tasks on two machines I and II in the order first on Machine I and then on Machine II. Task: Machine I (time in hours). Machine II (time in hours). A 2 6 B C 5 4 8 7 D E 96 4 3 F 8 9 G H 7 5 3 8 I 4 11
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!