Loading...
Jim doy Billing Spreadsheet 110509IPM.Note Hopefully the last Walmart Billing Karen Bennett Jim Doty Karen Bennett EX /O=CITYOFYELM/OU=FIRST ADMINISTRATIVE GROUP/CN=RECIPIENTS/CN=JIMD Hopefully the last Walmart Billing EX /O=CITYOFYELM/OU=FIRST ADMINISTRATIVE GROUP/CN=RECIPIENTS/CN=KARENB EX /O=CITYOFYELM/OU=FIRST ADMINISTRATIVE GROUP/CN=RECIPIENTS/CN=KARENB Jim Doty EX /O=CITYOFYELM/OU=FIRST ADMINISTRATIVE GROUP/CN=RECIPIENTS/CN=JIMD Karen Bennett Hopefully the last Walmart Billing Karen- I have attached the latest copy of my Walmart spreadsheet for billing. The Latest (and Hopefully Last) invoice amounts are in red. I believe everything is up to date. Let me know if you have questions. Jim Doty Plant Manager City of Yelm Water Reclamation Facility 931 N.P. Road Mail: 105 Yelm Avenue W Yelm, WA 98597 Ph. (360)458-8411 Fax. (360)458-8166 <DC90029353CCCD468AA2A2858FFCD8F5AEDFC8@server1.ci.yelm.wa.us> Hopefully the last Walmart Billing.EML Karen Bennett Hopefully the last Walmart Billing Follow up 12.0 5555555 wal-mart billing Spreadsheet july.6.2009 wal-mart billing Spreadsheet july.6.2009 Karen Bennett EX /O=CITYOFYELM/OU=FIRST ADMINISTRATIVE GROUP/CN=RECIPIENTS/CN=KarenB KarenB@ci.yelm.wa.us 458-3835 Community Development Karen Bennett Karen Bennett wal-mart billing Spreadsheet july.6.2009.xls 2009 Labor Rates Invoice 11.5.09 Invoice 8.20.09 Invoice 7.16.09 Invoiced Amounts Sewer Dept. Labor Charges Septage Charges Service Date Gallons Pumped Septage Charge invoiced paid Previously Previously? Date Employee Hours Task Bob Rhodes Aris McClelland Jim Doty Pumped Tank Monitor System Met Parametrix Engineer Bob Rhoades Checked System Pumped System Write this report Invoiced Paid Writing Billing Report Tony Schall Charges 5/18/09 Labor Charges 1/23/09 Labor Charges 5/13/08 rate increase 0.03 Septage charges Invoiced 5/18/09 Septage Labor Total Receipt Outstanding 7350gal@$0.249 7325gal@$0.249 Comments Item Description Unit Price Septage Pumped 5/21/2009 7350 gal @ $0.249 Septage Pumped 7/1/2009 7325 gal @ $0.249 City of Yelm Manpower for Sewer Dept. Employees Subtotal Tax 8.4% Txbl * 8.4% tax paid on Septage Charges of $3654.08 Payment Details: 412-000-000-369-90-01 7/15/09 Labor Charges Payment Hourly W/Benefits Name 2009 Salary W/ Benefit Load 35% Doty Hatch Rhoades McClelland Schall Septage charges Invoiced 7/16/09 Tax@8.4% 6827gal@$0.24 8/20/09 Labor Charges Septage Pumped 8/12/09 6827 gal @ $0.24 8.4% tax paid on Septage Charges of $1638.48 11/5/09 Labor Charges 7035 gal@$0.24 Septage Charges Invoiced 11/5/09 Septage Pumped 10/29/09 7035 gal @ $0.24 Tax 8.5% 8.5% tax paid on Septage Charges of $1688.40 $38.86 $4,989.00 $6,735.15 $35.72 $4,586.00 $6,191.10 $34.67 $4,452.00 $6,010.20 $29.92 $3,841.00 $5,185.35 $25.51 $3,275.00 $4,421.25 1.00 $1,688.40 $1,688.40 2.00 $94.29 $94.29 $1,782.69 $143.51 $1,926.20 1.00 $1,638.48 $1,638.48 2.00 $128.62 $128.62 $1,767.10 $137.63 $1,904.73 1.00 $1,830.15 $1,830.15 2.00 $1,823.93 $1,823.93 $3,654.08 $306.94 0.08 3.00 $237.81 $237.81 $3,891.89 $306.94 $4,198.83 4Wal-Mart Invoiced Amounts ?11?/?07?/?2007 $4,351.30 $432.49 $4,783.79 $4,783.79 ?01?/?11?/?2008 $1,493.80 $277.51 $1,771.31 $6,555.10 $0.00 ?02?/?22?/?2008 $6,180.28 $298.28 $6,478.56 $6,478.56 $0.00 ?04?/?16?/?2008 $1,500.15 $129.12 $1,629.27 $1,629.27 $0.00 ?06?/?24?/?2008 $3,098.86 $197.56 $3,296.42 $3,296.42 $0.00 ?08?/?28?/?2008 $3,219.30 $154.30 $3,373.60 $3,373.60 $0.00 ?01?/?23?/?2009 $4,560.68 $201.44 $4,762.12 $4,762.12 $0.00 ?05?/?18?/?2009 $5,909.78 $377.04 $6,286.82 $6,286.82 $0.00 ?07?/?16?/?2009 $3,654.08 $237.81 $306.94 0.08 $4,198.83 $4,198.83 $0.00 ?08?/?20?/?2009 $1,638.48 $128.62 $137.63 0.08 $1,904.73 $1,904.73 $0.00 ?11?/?05?/?2009 $1,688.40 $94.29 $143.51 $1,926.20 $1,926.20 4Wal-Mart Labor Charges ?10?/?31?/?2007 2.00 ?11?/?13?/?2007 1.00 ?11?/?20?/?2007 2.00 ?11?/?20?/?2007 2.00 ?11?/?21?/?2007 1.00 ?11?/?21?/?2007 1.00 ?12?/?03?/?2007 1.00 ?12?/?05?/?2007 1.00 ?12?/?12?/?2007 2.00 ?12?/?31?/?2007 1.00 ?01?/?03?/?2008 2.00 ?01?/?20?/?2008 1.00 ?01?/?30?/?2008 2.00 ?02?/?19?/?2008 1.00 ?02?/?20?/?2008 2.00 ?03?/?14?/?2008 1.00 ?03?/?19?/?2008 2.00 ?04?/?07?/?2008 1.00 ?04?/?16?/?2008 2.00 ?05?/?09?/?2008 2.00 ?05?/?22?/?2008 2.00 ?06?/?13?/?2008 1.00 ?06?/?24?/?2008 2.00 ?07?/?29?/?2008 1.00 ?08?/?07?/?2008 2.00 ?09?/?08?/?2008 1.00 $25.18 ?01?/?23?/?2009 ?06?/?17?/?2009 ?09?/?11?/?2008 2.00 $50.36 ?01?/?23?/?2009 ?06?/?17?/?2009 ?10?/?23?/?2008 2.00 $50.36 ?01?/?23?/?2009 ?06?/?17?/?2009 ?11?/?17?/?2008 1.00 $25.18 ?01?/?23?/?2009 ?06?/?17?/?2009 ?12?/?11?/?2008 2.00 $50.36 ?01?/?23?/?2009 ?06?/?17?/?2009 $201.44 ?01?/?20?/?2009 1.00 $29.92 ?05?/?18?/?2009 ?06?/?22?/?2009 ?01?/?22?/?2009 1.50 $58.29 ?05?/?18?/?2009 ?06?/?22?/?2009 ?01?/?27?/?2009 2.00 $59.84 ?05?/?18?/?2009 ?06?/?22?/?2009 ?02?/?25?/?2009 1.00 $29.92 ?05?/?18?/?2009 ?06?/?22?/?2009 ?03?/?11?/?2009 2.00 $59.84 ?05?/?18?/?2009 ?06?/?22?/?2009 ?04?/?08?/?2009 1.00 $29.92 ?05?/?18?/?2009 ?06?/?22?/?2009 ?04?/?16?/?2009 2.00 $51.02 ?05?/?18?/?2009 ?06?/?22?/?2009 ?05?/?14?/?2009 1.50 $58.29 ?05?/?18?/?2009 ?06?/?22?/?2009 $377.04 ?05?/?19?/?2009 1.00 $29.92 ?07?/?16?/?2009 ?08?/?17?/?2009 ?05?/?21?/?2009 2.00 $59.84 ?07?/?16?/?2009 ?08?/?17?/?2009 ?06?/?15?/?2009 1.00 $29.92 ?07?/?16?/?2009 ?08?/?17?/?2009 ?07?/?01?/?2009 2.00 $59.84 ?07?/?16?/?2009 ?08?/?17?/?2009 ?07?/?06?/?2009 1.50 $58.29 ?07?/?16?/?2009 ?08?/?17?/?2009 $237.81 ?08?/?04?/?2009 1.00 $29.92 ?08?/?20?/?2009 ?09?/?22?/?2009 ?08?/?12?/?2009 2.00 $59.84 ?08?/?20?/?2009 ?09?/?22?/?2009 ?08?/?20?/?2009 1.00 $38.86 ?08?/?20?/?2009 ?09?/?22?/?2009 $128.62 ?09?/?02?/?2009 1.00 $29.92 ?11?/?05?/?2009 ?10?/?29?/?2009 1.00 $25.51 ?11?/?05?/?2009 ?11?/?05?/?2009 1.00 $38.86 ?11?/?05?/?2009 $94.29 4Wal-Mart Septage Charges ?09?/?07?/?2007 7425.00 $1,626.08 ?10?/?11?/?2007 6100.00 $1,335.90 ?10?/?31?/?2007 7000.00 $1,533.00 ?11?/?21?/?2007 6821.00 $1,493.80 ?12?/?12?/?2007 6870.00 $1,504.53 ?01?/?03?/?2008 7150.00 $1,565.85 ?01?/?30?/?2008 7200.00 ?01?/?30?/?2008 7200.00 $1,576.80 ?02?/?20?/?2008 7000.00 $1,533.00 ?03?/?19?/?2008 6850.00 $1,500.15 ?04?/?16?/?2008 7075.00 $1,549.43 ?05?/?22?/?2008 7075.00 $1,549.43 ?06?/?24?/?2008 7200.00 $1,576.80 ?08?/?07?/?2008 7500.00 $1,642.50 ?09?/?11?/?2008 7050.00 $1,755.45 ?01?/?23?/?2009 ?06?/?17?/?2009 ?10?/?23?/?2008 6725.00 $1,674.53 ?01?/?23?/?2009 ?06?/?17?/?2009 ?12?/?11?/?2008 7050.00 $1,755.45 ?01?/?23?/?2009 ?06?/?17?/?2009 ?01?/?27?/?2009 7000.00 $1,743.00 0.25 ?05?/?18?/?2009 ?06?/?22?/?2009 ?03?/?11?/?2009 7550.00 $1,879.95 ?05?/?18?/?2009 ?06?/?22?/?2009 ?04?/?16?/?2009 6675.00 $1,662.08 ?05?/?18?/?2009 ?06?/?22?/?2009 ?09?/?11?/?2008 7050.00 $211.50 ?05?/?18?/?2009 ?06?/?22?/?2009 ?10?/?23?/?2008 6725.00 $201.75 ?05?/?18?/?2009 ?06?/?22?/?2009 ?12?/?11?/?2008 7050.00 $211.50 ?05?/?18?/?2009 ?06?/?22?/?2009 $5,909.78 ?05?/?21?/?2009 7350.00 $1,830.15 ?07?/?16?/?2009 ?08?/?17?/?2009 ?07?/?01?/?2009 7325.00 $1,823.93 ?07?/?16?/?2009 ?08?/?17?/?2009 $3,654.08 ?08?/?12?/?2009 6827.00 $1,638.48 ?08?/?20?/?2009 ?09?/?22?/?2009 ?10?/?29?/?2009 7035.00 $1,688.40 ?11?/?05?/?2009 $1,688.40 .xls wal-mart billing Spreadsheet july.6.2009.xls wal-mart billing Spreadsheet july.6.2009.xls