Accounts Receivable Worksheet <br />Public Works Maintenance: Traffic Operations <br />1820 Roosevelt Blvd, Eugene, OR 97402 <br />(541) 682-4800 <br />50 <br />Party: Damage was done on 6-21-07 Washington license <br />plate 226TI <br />Date: <br />....... .... <br />.............. ... .......... ......... <br />........................ .............. .. . ........................... <br />..................... I ....... ... . I ............ I ......... ...... ...... <br />......... ............. ...... I ........ <br />Employee <br />Hourly <br />Rate <br />+ <br />Benefit <br />Rate <br />= <br />Base <br />Rate <br />X <br />Total <br />Hours <br />X <br />Overhead <br />33.47% <br />= <br />Employee <br />Charge <br />Represented Employees: <br />21.11 <br />$0.00 <br />6.00 <br />$0.00 <br />126.66 <br />837070 <br />5.00 <br />1 <br />6.00 <br />$40.45 <br />30.00 <br />Electrician 1 <br />$26.26 <br />$63.15 <br />$14.67 <br />1 <br />$40.93 <br />$6.32 <br />12 <br />$69.47 <br />1.3347 <br />$8.60 <br />$655.55 <br />Electrician 11 <br />$28.69 <br />$0.86 <br />$15.54 <br />$9.46_ <br />$44.23 <br />$0.1215 <br />1.5 <br />351 <br />1.3347 <br />$2.981 <br />$88.55 <br />Trf Signal Tech <br />$26.26 <br />$9.43 <br />$14.67 <br />1 <br />$40.93 <br />$0.941 <br />1 <br />$10.37 <br />1.3347 <br />$54.63 <br />$0.00 <br />0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />0 <br />1.3347 <br />$0.00 <br />$0.00 <br />Rep. Employees OT: <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.001 <br />$0.00 <br />$0.00 <br />$0.00 <br />0 <br />1.3347 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />0 <br />1.3347 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />0 <br />1.3347 <br />$0.00 <br />$0.00 <br />$0.00 <br />s0.001 <br />0 <br />1.33471 <br />$0.00 <br />Exempt Employees: <br />$0.00 <br />$0.00 <br />$0.00 <br />0 <br />1.3347 <br />$0.00 <br />Exempt Employees OT: <br />$0.001 <br />$0.00 <br />$0.00 <br />0 <br />1.3347 <br />$0.00 <br />LABOR TOTAL: <br />........................ <br />................ . ......................... <br />NT.*.*'.* ............ ... ......... .................... <br />EQU1.PMt ' <br />Equipment Type <br />Hourly <br />Rate <br />X <br />Total <br />Hours <br />= <br />Equipment <br />Charge <br />534007 <br />27.17 <br />Material <br />Charge <br />6.00 <br />Charges <br />163.02 <br />547001 <br />21.11 <br />$0.00 <br />6.00 <br />$0.00 <br />126.66 <br />837070 <br />5.00 <br />1 <br />6.00 <br />$40.45 <br />30.00 <br />534009 <br />15.65 <br />$63.15 <br />1.00 <br />1 <br />15.65 <br />$6.32 <br />$69.47 <br />70 Watt HPS lamp <br />$8.60 <br />0.00 1 <br />1 <br />$0.86 <br />$9.46_ <br />0.00 <br />$0.1215 <br />351 <br />$2.981 <br />0.00 <br />$32.73 <br />Fuse holder and fuse <br />$9.43 <br />1 <br />0.00 <br />EQUIPMENT TOTAL: <br />1 335.33 <br />MAT-P ........... .... .............................................. <br />........ <br />........... <br />... <br />....... . . ...... <br />......................................... I........,............,..............� ... : <br />. . ..... . .. .. ... ...... <br />.......................................................... <br />Material Type <br />Actual <br />Cost <br />X <br />Number of <br />Units <br />+ <br />Overhead <br />10% <br />= <br />Material <br />Charge <br />25ft. Fiberglass pole and Luminaire <br />Charges <br />$566.98 <br />$0.00 <br />$0.00 <br />arm <br />$404.51 <br />1 <br />$40.45 <br />$444.96 <br />70 Watt Cobra Head fixture <br />$63.15 <br />1 <br />$6.32 <br />$69.47 <br />70 Watt HPS lamp <br />$8.60 <br />1 <br />$0.86 <br />$9.46_ <br />10-2 WIG OF wire <br />$0.1215 <br />351 <br />$2.981 <br />$32.73 <br />Fuse holder and fuse <br />$9.43 <br />1 <br />$0.941 <br />$10.37 <br />0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.001 <br />$0.00 <br />1 $798.73 <br />.............. <br />INVOICE TOTAL::'::::'.+++:**:.: <br />Labor <br />Charge <br />$798.73 <br />Equipment <br />Charges <br />$335.33 <br />Material <br />Charges <br />$566.98 <br />MA I LKIAL I U I AL: I :0566.95 I U I AL: I $1,70I.05 j <br />