ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
Project RatesPiece Work (1)Potential Piece Work (2)Hourly (3)"On The Fence" Items (4)First YearSecond YearThrid yearFourth YearFith Year
2
0.3380.00
3
Link To Custom Glass Sheet
11113311111111333333333333333333333333333311222111111111111111111111111111111111111111111
4
Open JointsBlow TubesDBV Heater CoverSSV heater covers SSV Wands
5
$19/hr------------ =$76/4hrs=$76/240 min. Break = 15min--------- $76=225 minutes=$.338/minAny ColorYellowImplosionStandard / Bonus for batch of 20OriginalCON Ground GlassSGG H/CsStandardOriginal Dual
6
Actual Retail$1.00$20.00$35.00$35.00$35.00$35.00$35.00$35.00$45.00$48.00$55.00$55.00PurpleRedBasicBlackBlueGreenYellowPurpleRed$20.00$20.00$27.00$27.00$29.00$32.00$32.00$32.00$32.00$60.00$70.00$60.00$70.00$42.00$42.00$10.85$78.00$88.00$88.00$98.00$78.00$88.00$88.00$98.00$120.00$140.00
7
Dist Profit @ Retail
18.80-3.83-4.06-4.3018.80-0.50-0.50-0.5018.8018.80-21.20-22.3537.8945.5436.5443.5040.8842.000.000.005.900.0051.1058.1058.1065.1051.1058.1058.1065.1070.0083.00
8
Dist Additonal cost
2.000.500.500.502.000.500.500.502.002.000.500.502.002.002.002.003.503.503.503.503.503.503.503.508.008.00
9
Suggested Retail
15.204.334.564.8015.201.001.001.0015.2015.2021.7022.8524.1126.4625.4628.501.120.000.000.004.950.0030.4033.4033.4036.4030.4033.4033.4036.4058.0065.00
10
Dist Profit (WS)2.80-3.83-4.06-4.302.80-0.50-0.50-0.502.802.80-21.20-22.357.8910.546.548.5019.8821.000.000.000.480.0012.1014.1014.1016.1012.1014.1014.1016.1010.0013.00
11
Premier Profit 0.900.900.830.830.830.83-20.004.504.504.504.504.504.502.506.123.063.250.000.004.500.000.000.000.000.000.000.000.000.000.000.000.320.000.004.024.52-2.850.00-2.003.204.25-1.30-1.30-1.30-1.3011.456.48-1.30-1.306.808.000.951.191.437.360.000.000.006.345.289.2010.3510.0611.2310.7312.590.320.000.000.002.200.0016.3618.1917.4119.1415.1917.0116.2418.0630.6336.36
12
Actual WS16.000.000.000.0016.000.000.000.0016.0016.000.000.0030.0035.0030.0035.0021.0021.000.000.005.430.0039.0044.0044.0049.0039.0044.0044.0049.0060.0070.00
13
Suggested Wholesale Price
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$7.80$7.15$7.15$7.15$7.15$7.15$0.00$20.00$20.00$20.00$20.00$20.00$20.00$21.70$31.50$26.55$28.17$0.00$0.00$20.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$2.77$0.00$0.00$16.10$17.10$0.00$0.00$0.00$14.00$14.00-$2.60-$2.60-$2.60-$2.60$24.40$18.90-$2.60-$2.60$20.30$15.68$4.66$4.99$5.32$15.68$0.00$0.00$0.00$15.68$15.68$28.98$30.59$28.16$31.45$30.05$34.30$2.24$0.00$0.00$0.00$9.90$0.00$46.80$52.80$52.80$58.80$46.80$52.80$52.80$58.80$84.00$98.00
14
1.501.601.701.801.902.00Sold to Dist @ 3.903.583.583.583.583.5810.0010.0010.0010.0010.0010.0010.8515.7513.2714.090.000.0010.00$0.001.38$8.05$8.55$7.00$7.00-$1.30-$1.30-$1.30-$1.30$12.20$9.45-$1.30-$1.30$10.1511.203.333.563.8011.200.000.000.0011.2011.2020.7021.8520.1122.4621.4624.501.120.000.000.004.950.0023.4026.4026.4029.4023.4026.4026.4029.4042.0049.00
15
Blower Pay$0.00$0.00$0.35$0.39$1.00$0.75$0.75$0.75$0.75$0.75$20.00$3.50$3.50$3.50$3.50$3.50$3.50$7.34$8.63$9.21$9.84$0.00$0.00$3.50$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.30$0.00$0.00$2.03$2.03$2.85$0.00$2.00$2.50$2.00$0.00$0.00$0.00$0.00$0.00$2.97$0.00$0.00$2.65$0.00$0.00$2.70$2.38$2.38$2.38$3.04$0.00$0.00$0.00$4.06$3.38$6.50$6.00$7.44$8.11$8.11$8.79$0.00$0.00$0.00$0.00$0.00$0.00$4.06$4.73$5.41$6.08$4.73$5.41$6.08$6.76$5.41$6.08
16
Material Cost$2.00$2.00$2.00$2.00$2.00$2.00$2.00$2.00$2.00$2.00$2.00$2.00$1.00$1.00$1.00$1.00$2.00$0.76$2.00$2.00$1.30$0.75$0.75$0.70$0.50$0.80$0.80$2.54$5.00$5.50$2.62$3.12$2.62$3.12$0.80$2.75$2.98$3.48$3.58$4.18$3.48$3.98$4.08$4.58$5.96$6.56
17
TOTAL COST$3.00$2.75$2.75$2.75$2.75$2.75$20.00$5.50$5.50$5.50$5.50$5.50$5.50$8.34$9.63$10.21$10.84$0.00$0.00$5.50$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$1.06$0.00$0.00$4.03$4.03$2.85$0.00$2.00$3.80$2.75$0.00$0.00$0.00$0.00$0.75$2.97$0.00$0.00$3.35$3.20$2.38$2.38$2.38$3.84$0.00$0.00$0.00$4.86$5.92$11.50$11.50$10.06$11.23$10.73$11.91$0.80$0.00$0.00$0.00$2.75$0.00$7.04$8.21$8.99$10.26$8.21$9.39$10.16$11.34$11.37$12.64
18
Glass Job Instructions and how to train people
See Note
SMALL AMOUNT OF COLOR AND 5MM CLEAR ROD 1 MIN
26X4 MM 10 MM ROD 4-5 SMALL PIECES OF COLOR/TWISTED CANE
SEE SHEET FOR INSTRUCTIONS
COLOR BACK AND PUSH DECORATE WITH INDICATOR AND SMALL DESIGN FIRE POLISH
19MM BUDAH WAND 8MM ROD
16X2.5 MM 19MM BUDAH TOP .15 Bonus per for groups of 20
16X2.5MM 19MM CHINESE JOINT VERY SMALL AMOUNT OF FRIT
16X2.5 DBV OIL TOP
16X2.5 MM SMALL AMOUNT OF COLOR
16X2.5 MM SMALL AMOUNT OF COLOR 19MM GG JOINT
16X2.5 MM SMALL AMOUNT OF COLOR SPHERE GG JOINT
19X3.2 VERY SMAL AMOUNT OF FRIT UP TO 3 COLORS
19X3.2 VERY SMALL AMOUNT OR FRIT UP TO 3 COLORS 19MM CHINEESE GG JOINT
19X3.2 VERY SMAL AMOUNT OF FRIT UP TO 3 COLORS SPHERE GG JOINT
19X3.2 VERY SMAL AMOUNT OF FRIT UP TO 3 COLORS
19X3.2 VERY SMAL AMOUNT OF FRIT UP TO 3 COLORS
19X3.2 VERY SMALL AMOUNT OR FRIT UP TO 3 COLORS 19MM CHINESE GG JOINT
19X3.2 VERY SMAL AMOUNT OF FRIT UP TO 3 COLORS SPHERE GG JOINT
19
20
21
22
small videoSee VideoSee VideoLathe VideoSee VideoSee Video
SGG Wand Front for Custom Wands
23
Video LinkLong VideoSee VideoSee VideoSee Video
Top Bubble Part Video
See VideoSee VideoSee VideoSee VideoSee VideoSee Video
24
25
Production Time per Part
0.001.051.162.222.222.222.222.222.2210.3510.3510.3510.3510.3510.3521.7325.5327.2529.1010.350.906.006.008.445.927.405.934.684.684.684.688.438.798.798.797.858.007.037.037.039.0012.0010.0019.2317.7522.0024.0024.0026.000.0013.4612.0014.0016.0018.0014.0016.0018.0020.0016.0018.00
26
27
Blowers Times
28
Steves Time 6.0015.00
29
Steves Time6.0015.00
30
Steves Time7.0015.00
31
Steves Time6.0015.00
32
Steves Time5.0016.00
33
Steves Time6.0017.00
34
Steve's average Time
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.0015.50#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
35
Steves Best Time
0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.005.0015.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
36
Nicks Time
37
Nicks Time
38
Nicks Time
39
Nicks Time
40
Nicks Time
41
Nicks Time
42
Nicks Average Time
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
43
Nicks Best Time
44
Adams Time
45
Adams Time
46
Adams Time
47
Adams Time
48
Adams Time
49
Adams Time
50
Adams Average Time
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
51
XXX Time7.86
52
XXX Time
53
XXX Time
54
XXX Time
55
XXX Time
56
XXX Time
57
Mikes Average TIme
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!7.86#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
58
XXXX Time5.422.777.27
59
XXXX Time
60
XXXX Time
61
XXXX Time
62
XXXX Time
63
XXXX Time
64
Keiths Average TIme
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!5.42#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!2.77#DIV/0!#DIV/0!7.27#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
65
XXXXX Time
66
XXXXX Time
67
XXXXX Time
68
XXXXX Time
69
XXXXX Time
70
XXXXX Time
71
Cook's Average TIme
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
72
XXXXXX Time
73
XXXXXX Time
74
XXXXXX Time
75
XXXXXX Time
76
XXXXXX Time
77
XXXXXX Time
78
Jesse's Average TIme
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
79
Jeff's Time102:43:12130:48:00
80
Jeff's Time
81
Jeff's Time
82
Jeff's Time
83
Jeff's Time
84
Jeff's Time
85
Jeffs's Average TIme
#DIV/0!2.13#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!102:43:12#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!130:48:00#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
86
Sean's Time268:48:00183:50:24
87
Sean's Time133:55:12
88
Sean's Time
89
Sean's Time
90
Sean's Time
91
Sean's Time
92
Sean's Average TIme
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!11.20#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.62#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
93
XXXXXXXX Time
94
XXXXXXXX Time
95
XXXXXXXX Time
96
XXXXXXXX Time
97
XXXXXXXX Time
98
XXXXXXXX Time
99
Ottos's Average TIme
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
100
XXXXXXXXX Time
13.917.16