Spreadsheet: 72183d1272900904-use-table-to-auto-populate-other-tables-printing-job-plan-v4b
Sheet: Printing

Job Plan - Printing |  |  |  |  |  |  |  |  | Shift and [NAME]: | 2010-05-03 11:33:36
1st Shift Op: |  |  | 2nd Shift Op: |  |  |  | 3rd Shift Op:
Order # | 95710 |  | Plan Setup Time: |  | 1.98 |  | Setup Start Time:
Machine: | 102 |  | Plan Run Time: |  | 196.078431372549 |  | Setup End Time:
Job Name: | Cadbury |  | [NAME] (FPM): |  | 900 |  | Act Setup Time
Qty (Ft.): | 9000000 |  | Linear Ft/hour: |  | 45900 |  | Run Start Time:
#Colors: | 6 |  | Material On: |  |  |  | Run End Time:
Slit on Press | N |  | Material Off: |  |  |  | Act Run Time:
Run Hours | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Plan (Linear Ft)
Per Hour | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900
Cumulative | 45900 | 91800 | 137700 | 183600 | 229500 | 275400 | 321300 | 367200 | 413100 | 459000
Act
Cumulative
Run Hours | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Plan (Linear Ft)
Per Hour | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900
Cumulative | 504900 | 550800 | 596700 | 642600 | 688500 | 734400 | 780300 | 826200 | 872100 | 918000
Act
Cumulative
Start Time | Stop Time | Barrier Description/Action Taken |  |  |  |  |  | Code | Time Lost | Hour
Target Waste % | 1st Shift Waste Target (lbs.) | 1st Shift Act Waste |  | 2nd Shift Waste Target (lbs.) | 2nd Shift Act Waste |  | 3rd Shift Waste Target (lbs.) | 3rd Shift Act Waste |  | Target Waste %:
 |  | Set-up | Production |  | Set-up | Production |  | Set-up | Production
0.055 |  |  |  |  |  |  |  |  |  | 0.055
Fill in the cumulative totals every hour and start & end time of the run. Describe any barriers (issues or problems) and actions taken to address the barriers. List time lost due to these barriers and the hour it occurred. Record waste generated from Set-up (mark "N/A" if there was no set-up on the shift), Production (quality or manufacturing defects) and Trim in the respective area for each shift.
Job Plan - Printing
Run Hours | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
Plan (Linear Ft)
Per Hour | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900
Cumulative | 963900 | 1009800 | 1055700 | 1101600 | 1147500 | 1193400 | 1239300 | 1285200 | 1331100 | 1377000
Act
Cumulative
Run Hours | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40
Plan (Linear Ft)
Per Hour | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900
Cumulative | 1422900 | 1468800 | 1514700 | 1560600 | 1606500 | 1652400 | 1698300 | 1744200 | 1790100 | 1836000
Act
Cumulative
Run Hours | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50
Plan (Linear Ft)
Per Hour | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900
Cumulative | 1881900 | 1927800 | 1973700 | 2019600 | 2065500 | 2111400 | 2157300 | 2203200 | 2249100 | 2295000
Act
Cumulative
Run Hours | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60
Plan (Linear Ft)
Per Hour | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900 | 45900
Cumulative | 2340900 | 2386800 | 2432700 | 2478600 | 2524500 | 2570400 | 2616300 | 2662200 | 2708100 | 2754000
Act
Cumulative
Start Time | Stop Time | Barrier Description/Action Taken |  |  |  |  |  | Code | Time Lost | Hour
Target Waste % | 1st Shift Waste Target (lbs.) | 1st Shift Act Waste |  | 2nd Shift Waste Target (lbs.) | 2nd Shift Act Waste |  | 3rd Shift Waste Target (lbs.) | 3rd Shift Act Waste |  | Target Waste %:
 |  | Set-up | Production |  | Set-up | Production |  | Set-up | Production
0.055 |  |  |  |  |  |  |  |  |  | 0.055
Fill in the cumulative totals every hour and start & end time of the run. Describe any barriers (issues or problems) and actions taken to address the barriers. List time lost due to these barriers and the hour it occurred. Record waste generated from Set-up (mark "N/A" if there was no set-up on the shift), Production (quality or manufacturing defects) and Trim in the respective area for each shift.