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

Machine | Speed | Efficiency Factor | Hourly Target | Set-up / Color | Waste % | [NAME]
100 | 700 | 0.85 | 35700 | 0.33 | 0.055
102 | 875 | 0.85 | 44625 | 0.33 | 0.055
110 | 950 | 0.9 | 51300 | 0.33 | 0.055
112 | 1200 | 0.9 | 64800 | 0.2 | 0.025
116 | 1100 | 0.85 | 56100 | 0.33 | 0.055
118 | 550 | 0.85 | 28050 | 0.33 | 0.055
802 | 500 | 0.85 | 25500 | 0.5 | 0.055
806 | 500 | 0.85 | 25500 | 0.5 | 0.055 | 350
808 | 450 | 0.85 | 22950 | 0.5 | 0.055 | 350
 |  |  | 0
Slit On Press
Y |  |  |  |  | waste # = w/out trim
N
100: Jobs | Speed | Efficiency Factor | Hourly Target | Waste % |  | 112: Jobs | Speed | Efficiency Factor | Hourly Target | Waste % |  | 802: Jobs | Speed | Efficiency Factor | Hourly Target | Waste %
BD | 600 | 0.85 | 30600 | 0.055 |  | BD | 1200 | 0.9 | 64800 | 0.025 |  | Maribella | 350 | 0.85 | 17850 | 0.055
Coca Cola | 900 | 0.85 | 45900 | 0.055 |  | Community Coffee | 1200 | 0.9 | 64800 | 0.025 |  | [NAME] | 400 | 0.85 | 20400 | 0.055
Community Coffee | 875 | 0.85 | 44625 | 0.055 |  | Dahlgren | 1200 | 0.9 | 64800 | 0.025 |  | [NAME] | 450 | 0.85 | 22950 | 0.055
[NAME] | 800 | 0.85 | 40800 | 0.055 |  | [NAME] | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 875 | 0.85 | 44625 | 0.055 |  | Eggs | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
Farmer Brothers | 750 | 0.85 | 38250 | 0.055 |  | Farmer Brothers | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
Hawaii Coffee | 750 | 0.85 | 38250 | 0.055 |  | Hawaii Coffee | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
K/C (Var Shrink) | 700 | 0.85 | 35700 | 0.055 |  | Henkel | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 700 | 0.85 | 35700 | 0.055 |  | K/C (Var Shrink) | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 800 | 0.85 | 40800 | 0.055 |  | Kelloggs Bare Naked | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
Kelloggs Snacks | 875 | 0.85 | 44625 | 0.055 |  | [NAME] | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
Massimo | 750 | 0.85 | 38250 | 0.055 |  | Kraft | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
Nestle | 900 | 0.85 | 45900 | 0.055 |  | Massimo | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
P&G Always | 875 | 0.85 | 44625 | 0.055 |  | P&G Always | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 875 | 0.85 | 44625 | 0.055 |  | Sanfilippo | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
Poptarts 70/100g | 1100 | 0.85 | 56100 | 0.055 |  | [NAME] | 1200 | 0.9 | 64800 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
Sanfilippo | 875 | 0.85 | 44625 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 750 | 0.85 | 38250 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 1000 | 0.85 | 51000 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 |  | 0.055
 | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 |  | 0.055
 | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 |  | 0.055
 | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 |  | 0.055
 | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.9 | 0 | 0.025 |  |  | 0 | 0.85 | 0 | 0.055
102: Jobs | Speed | Efficiency Factor | Hourly Target | Waste % |  | 116: Jobs | Speed | Efficiency Factor | Hourly Target | Waste % |  | 806: Jobs | Speed | Efficiency Factor | Hourly Target | Waste %
BD | 600 | 0.85 | 30600 | 0.055 |  | Poptarts 70/100g | 1100 | 0.85 | 56100 | 0.055 |  | [NAME] | 475 | 0.85 | 24225 | 0.055
Cadbury | 900 | 0.85 | 45900 | 0.055 |  | [NAME] | 1100 | 0.85 | 56100 | 0.055 |  | Cadbury | 400 | 0.85 | 20400 | 0.055
Coca Cola | 900 | 0.85 | 45900 | 0.055 |  | P&G Charmin | 0 | 0.85 | 0 | 0.055 |  | [NAME] | 475 | 0.85 | 24225 | 0.055
Community Coffee | 875 | 0.85 | 44625 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | Exopack Toma | 350 | 0.85 | 17850 | 0.055
[NAME] | 800 | 0.85 | 40800 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | Fresenius | 400 | 0.85 | 20400 | 0.055
Dahlgren | 875 | 0.85 | 44625 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | Keebler | 400 | 0.85 | 20400 | 0.055
[NAME] | 875 | 0.85 | 44625 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | Kelloggs 2.5oz FS | 525 | 0.85 | 26775 | 0.055
Farmer Brothers | 750 | 0.85 | 38250 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | Kelloggs Meal Starters | 400 | 0.85 | 20400 | 0.055
Flexo Cookies | 875 | 0.85 | 44625 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | MC Sautess | 425 | 0.85 | 21675 | 0.055
Fresenius | 400 | 0.85 | 20400 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | [NAME]'s | 350 | 0.85 | 17850 | 0.055
Hawaii Coffee | 750 | 0.85 | 38250 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | P&G Cascade | 425 | 0.85 | 21675 | 0.055
Henkel | 875 | 0.85 | 44625 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | P&G Charmin | 500 | 0.85 | 25500 | 0.055
K/C (Var Shrink) | 700 | 0.85 | 35700 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | Poptarts Vend | 500 | 0.85 | 25500 | 0.055
Kelloggs .9oz FS | 900 | 0.85 | 45900 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | [NAME] | 350 | 0.85 | 17850 | 0.055
Kelloggs Bare Naked | 750 | 0.85 | 38250 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 700 | 0.85 | 35700 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 1100 | 0.85 | 56100 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 800 | 0.85 | 40800 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
Kelloggs Snacks | 875 | 0.85 | 44625 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
Massimo | 750 | 0.85 | 38250 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
Nestle | 900 | 0.85 | 45900 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
P&G Always | 875 | 0.85 | 44625 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 875 | 0.85 | 44625 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
Poptarts 70/100g | 1100 | 0.85 | 56100 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
Sanfilippo | 875 | 0.85 | 44625 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 750 | 0.85 | 38250 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 |  | 0.055
Schwan | 700 | 0.85 | 35700 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 |  | 0.055
[NAME] | 1000 | 0.85 | 51000 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 |  | 0.055
Yogobits | 750 | 0.85 | 38250 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 |  | 0.055
Fresenius | 400 | 0.85 | 20400 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 |  | 0.055
 | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
110: Jobs | Speed | Efficiency Factor | Hourly Target | Waste % |  | 118: Jobs | Speed | Efficiency Factor | Hourly Target | Waste % |  | 808: Jobs | Speed | Efficiency Factor | Hourly Target | Waste %
Cadbury | 950 | 0.9 | 51300 | 0.055 |  | [NAME] | 450 | 0.85 | 22950 | 0.055 |  | [NAME] | 475 | 0.85 | 24225 | 0.055
Community Coffee | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | [NAME] | 475 | 0.85 | 24225 | 0.055
Dahlgren | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | Exopack Toma | 350 | 0.85 | 17850 | 0.055
[NAME] | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | Keebler | 400 | 0.85 | 20400 | 0.055
Eggs | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | Kelloggs 2.5oz FS | 525 | 0.85 | 26775 | 0.055
Farmer Brothers | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | Kelloggs Meal Starters | 400 | 0.85 | 20400 | 0.055
Flexo Cookies | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | MC Sautess | 425 | 0.85 | 21675 | 0.055
Hawaii Coffee | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | [NAME]'s | 350 | 0.85 | 17850 | 0.055
Henkel | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | P&G Daily Facials | 375 | 0.85 | 19125 | 0.055
K/C (Var Shrink) | 700 | 0.9 | 37800 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | P&G Cascade | 425 | 0.85 | 21675 | 0.055
Kelloggs .9oz FS | 1000 | 0.9 | 54000 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  | [NAME] | 350 | 0.85 | 17850 | 0.055
[NAME] | 1100 | 0.9 | 59400 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
Kelloggs Snacks | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
Massimo | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
P&G Always | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
Poptarts 70/100g | 1400 | 0.9 | 75600 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
Sanfilippo | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
[NAME] | 1400 | 0.9 | 75600 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
Tlc | 950 | 0.9 | 51300 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.9 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.9 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.9 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.9 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.9 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055
 | 0 | 0.9 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055 |  |  | 0 | 0.85 | 0 | 0.055