Consider a cellular manufacturing environment. There are nine cells which either have a capacity to take on 1 or 2 jobs. Suppose there are seven jobs and the hours to complete the jobs by cell are given below:

	Job 1	Job 2	Job 3	Job 4	Job 5	Job 6	Job 7
Cell 1	7.8	6.4	3.4	7.8	4.8	2.1	6.1
Cell 2	4.3	6.5	4.4	5.9	6.8	7.4	3.3
Cell 3	5	3.9	2.5	2	5.2	6.1	4.6
Cell 4	2.1	6.5	7	2.7	5.5	4.7	5.8
Cell 5	6.6	5.2	6.3	6.7	3.9	2.6	2.9
Cell 6	4.9	7.2	4	3.3	5.8	3.4	5.3
Cell 7	7.7	6.4	2.4	2.6	6.3	6	3.2
Cell 8	6.5	5.3	4.3	7.8	3.1	2.5	5
Cell 9	3	4.8	8	3.7	6.1	4.4	5.4

Cells 1, 3, 7, and 9 can handle up to 2 jobs and all other cells can handle at most 1 job. All seven jobs must be handled by a cell. Determine cell-to-job assignments to minimize the total manufacturing time.

PLEASE SHOW STEP BY STEP IN EXCELL!! I AND MANY OTHER STUDENTS GREATLY APPRECIATE YOUR WORK!!! Thank you.