Spreadsheet: 47533d1246555632-networkdays-in-production-schedule-production-schedule
Sheet: PRODUCTION SCHEDULE

 |  |  |  |  |  |  |  |  | DEPT.1   16 HRS | HRS |  | DEPT. 5   80 HRS | HRS |  | JULY |  |  |  |  |  |  |  | AUGUST
 | PRODUCTION SCHEDULE |  |  |  |  |  |  |  | OP 1 |  |  | OP 25 |  |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  |  |  | PAID HOLIDAYS |  |  | [NAME] | 1 |  | OP 26 |  |  |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1
 |  | JOB #: | 0001 |  |  | 2009-01-01 00:00:00 |  |  | OP 3 | 7 |  | OP 27 | 2 |  | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  | PROJECT #: | 1001 |  |  | 2009-03-10 00:00:00 |  |  | [NAME] | 8 |  | OP 28 | 59 |  | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 |  | WORK ORDER #: | WO0001 |  |  | 2009-05-25 00:00:00 |  |  | DEPT. 2   32 HRS | HRS |  | OP 29 | 3 |  | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 |  | SHIP DATE: | 2009-10-30 00:00:00 |  |  | 2009-07-06 00:00:00 |  |  | OP 5 | 2 |  | OP 30 | 8 |  | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  | CUSTOMER: | A |  |  | 2009-07-07 00:00:00 |  |  | OP 6 | 22 |  | OP 31 | 8 |  |  |  |  |  |  |  |  |  | 30 | 31
 |  |  |  |  |  | 2009-07-08 00:00:00 |  |  | OP 7 | 8 |  | DEPT. 6   160 HRS | HRS
 |  | DEPT. 1 START: | 2009-06-29 00:00:00 |  |  | 2009-07-09 00:00:00 |  |  | OP 8 |  |  | OP 32 | 8 |  | SEPTEMBER |  |  |  |  |  |  |  | OCTOBER
 |  | DEPT. 1 DONE: | 2009-07-01 00:00:00 | 2 |  | 2009-07-10 00:00:00 |  |  | OP 9 |  |  | OP 33 | 8 |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  | DEPT. 2 DONE: | 2009-07-14 00:00:00 | 4 |  | 2009-09-07 00:00:00 |  |  | OP 10 |  |  | OP 34 | 48 |  |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3
 |  | DEPT. 3 DONE: | 2009-08-05 00:00:00 | 16 |  | 2009-11-23 00:00:00 |  |  | OP 11 |  |  | OP 35 | 88 |  | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | DEPT. 4 DONE: | 2009-08-17 00:00:00 | 8 |  | 2009-11-24 00:00:00 |  |  | DEPT. 3   128 HRS | HRS |  | OP 36 | 8 |  | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17
 |  | DEPT. 5 DONE: | 2009-08-31 00:00:00 | 10 |  | 2009-12-24 00:00:00 |  |  | OP 12 | 40 |  | OP 37 |  |  | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24
 |  | DEPT. 6 DONE: | 2009-10-19 00:00:00 | 34 |  | 2009-12-25 00:00:00 |  |  | OP 13 | 78 |  | DEPT. 7   8 HRS | HRS |  | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  | DEPT. 7 DONE: | 2009-10-20 00:00:00 | 1 |  |  |  |  | OP 14 | 8 |  | OP 38 | 4
 |  | DEPT. 8 DONE: | 2009-10-30 00:00:00 | 8 |  |  |  |  | OP 15 | 1 |  | OP 39 | 2
 |  |  |  |  |  |  |  |  | OP 16 |  |  | OP 40
 |  | OUTSIDE OP 1: | 14 | WORK DAYS ADDED TO Dept. 6 TIME |  |  |  |  | OP 17 |  |  | OP 41 |  |  |  | Shaded cells above correspond to dept. hours. Extra days added for the 2 outside ops.
 |  | OUTSIDE OP 2: | 5 | WORK DAYS ADDED TO Dept. 8 TIME. |  |  |  |  | OP 18 | 1 |  | OP 42 | 2 |  |  | Date shaded red is a holiday.
 |  |  |  |  |  |  |  |  | DEPT. 4   16 HRS | HRS |  | OP 43
 |  |  |  |  |  |  |  |  | OP 19 | 0.5 |  | DEPT. 8   24 HRS | HRS
 | The dates for each dept. are worked backwards from the ship date. |  |  |  |  |  |  |  | OP 20 |  |  | OP 44 | 2
 | Dept. 8 needs to be done on the ship date and needs 3 days(24 hrs) |  |  |  |  |  |  |  | OP 21 | 1 |  | OP 45 | 22
 | to complete all it's op's. This means Dept. 7 needs to be done 4 days |  |  |  |  |  |  |  | OP 22 | 14 |  | TOTAL EST. HRS. | 384 | 9.6 WEEKS
 | before the ship date to give Dept 8 enough time (3 days) to finish. |  |  |  |  |  |  |  | OP 23 | 0.5 |  |  | 8 hrs = 1 workday
 | The hours listed at the right change from job to job but are based on 8 hr |  |  |  |  |  |  |  | OP 24
 | days, they will be multiples of 8.
 | I will also need to factor in weekends, holidays and outside processes.