fi <br />Accounts Receivable Worksheet <br />Public Works Maintenance: Traffic Operat ions <br />�a539 <br />Billing For: Broadway and Hilvard <br />Date 9/5/2007 <br />1820 Roosevelt Blvd, Eugene, OR 87402 <br />(841) 682.4800 <br />I Send to <br />Hourly <br />Rate <br />Responsible Party: Wildish road crew conduit was dug up and <br />caused the damage in controller cabinet due <br />Location: to wires shorting out. <br />Total <br />Hours <br />Dvsw: 9a2s Account Code: .... 7�]F <br />:::::::::::::...... ::::::::: :::: : :::: `:: :::: <......:::::::::::::::::::: ::: .. .. ; <br />............. <br />........... .... .... ... ... <br />..................................................... .. ........... <br />......................................... <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 />27.17 <br />1 <br />0.50 <br />$2.10 <br />13.59 <br />$23.10 <br />0.00 <br />Electrician l <br />$25.20 <br />$0.00 <br />$14.67 <br />$39.87 <br />5.5 <br />$0.00 <br />1.3347 <br />$0.00 <br />$292.68 <br />Electrician ll <br />$27.53 <br />$15.54 <br />$0.00 <br />$43.07 <br />$0.00 <br />1 <br />1.3347 <br />$57.49 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />0 <br />$0.00 <br />1.3347 <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 />Rep. Employees OT: <br />$0.00 <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 />$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.001 <br />$0.00 <br />$0.00 <br />0 <br />1.3347 <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.00 <br />$0.00 <br />$0.00 <br />0 <br />1.33471 <br />$0.00 <br />LABOR TOTAL: <br />$350.17 <br />......................................... <br />.......... :::::::...... ::: <br />EQIJIPMI= NT:::::::: ; ............ ; <br />Equipment Type <br />Hourly <br />Rate <br />x <br />Total <br />Hours <br />= <br />Equipment <br />Charge <br />Bucket truck 534009 <br />15.65 <br />Material <br />Charge <br />2.00 <br />$648.00 <br />31.30 <br />Bucket truck 534007 <br />27.17 <br />$64.80 <br />3.00 <br />$712.80 <br />81.51 <br />Bucket truck 534010 <br />27.17 <br />1 <br />0.50 <br />$2.10 <br />13.59 <br />$23.10 <br />0.00 <br />$0.00 <br />$0.00 <br />0.00 <br />$0.00 <br />$0.00 <br />0.00 <br />$0.00 <br />0.00 <br />$0.00 <br />0.00 <br />EQUIPMENT TOTAL: <br />1 126.40 <br />1N.V0(CS 0TAL <br />Labor <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 />Out put file for controller cabinet <br />$648.00 <br />$735.90 <br />1 <br />$64.80 <br />$712.80 <br />Load switch for traffic signal <br />$21.00 <br />1 <br />$2.10 <br />$23.10 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />$0.00 <br />1N.V0(CS 0TAL <br />Labor <br />Charges <br />$350.17 <br />Equipment <br />Char es <br />$126.40 <br />Material <br />Charges <br />$735.90 <br />MATERIAL TOTAL: 1 $735.90 TOTAL: 1 $1,212.46 <br />