Loading...
HomeMy WebLinkAbout03.a. St. Mary's College ExpenditureS.a. Central Contra Costa Sanitary District July 11, 2014 TO: FINANCE COMMITTEE VIA: ROGER S. BAILEY, GENERAL MANAGER FROM: THEA VASSALLO, FINANCE MANAGER SUBJECT: INFORMATION REQUESTED REGARDING THE EXPENDITURE TO ST. MARY'S COLLEGE At the June 23, 2014 Finance Committee meeting, Member Nejedly had questions regarding the $57,249.68 expenditure to St. Mary's College (Check #200525 dated 6/12/14) and requested the 2012 bill. Attached is the payment authorization for the expenditure in question, for a reimbursement of overpayment by St. Mary's College (Attachment A). Also attached is the 2012 bill to St. Mary's College (Attachment B). Staff will be available at the meeting to provide additional information and answer questions. TV: cg ATTACHMENT A Central Contra Costa Sanitary District Payment Authorization Pay to: St. Mary's College Attn: Anne Geiger Address: PO Box 4747 City: Moraga State: CA Zip: 94575 Amount: $57, 249.68 Date Desired: June 12, 2014 Distribute Check to: Kim Stahl Description: Reimbursement of over payment of Sewer Service Charges for fiscal year 2013/2014 for St. Mary's College, 1928 St. Mary's Road, Moraga CA 94556; which was a result of EBMUD meter reading error. ACCOUNT NO. AMOUNT 001 -0000- 300.24 -00 $57,249.68 TOTAL $57,249.68 Initiated; y: (�fXa S ture (USE 130 INK) Da te: 6/10/14 Approved Py2�� -- �• Signature (USE BLUE INK) Date: V Approved By: ( L Signature (USE BLUE INK) Date: ISI �f� ' Saint Mary's College of California .'O moo, ;717 F:!ar -a,a. C�"� 9,;;75 -171' ,e! 1175 631 12F,5 ii. 925 2.170837 Facilities Services tilr. Cholmas Brightbill Senior Fngineer Central Contra Costa Sanitary District 5019 Imhoff Place Martinez, CA 94553 -4392 Dear 'I homas: RECEIVED i�Vi1 ���i ?1tENTAL SERVICES May 21, 2014 Thank you again for meeting with us a couple of months ago. At that time, we mentioned some concerns we had about the CCCSD billings for 2013. As you know, the agreement we have is that CCCSD will use the unit numbers for the months of December, January and February in calculating the invoices for Saint Mary's College, giving the college a 15% discount. We have determined that CCCSD used an incorrect unit number in the calculations for the June 30, 2013 and December 31, 2013 invoices. The unit number used for the main account calculations (4,536) was the number of units shown on the EBMUD invoice for the period November 14, 2012 to December 17, 2012, which was a higher unit number than usual. Instead of using the units for each of the three months, CCCSD used this one -month number and multiplied by 3 to get the quarter unit number. It is clearly shown on the CCCSD invoices (see attached invoices and sample portion below): CitYSD SMN R SERVICE CHARGr CALCULA riON FOR ST. 11A111 "S COLLEGE-2013 131LLINC (.1111) 1, 201.1 - December 11. 2013 %emi Anniml [Filling Perind� it lacrl is 13133SO -00011 1VlILR(o \S. 111111v, 1\11 \1 1 R 141E \11114 1 \11 \I'tit t%I1S111(F) IMS irll!W MIS %to`.!If 11(F1 11 - 1217"1'2 41)6 t{ 11715 ! 42e1 ,r UTA r ::ill it 11 1 � 24:2 - 1717 21 : 4536 tit I F? 3S JA`.F.rA!tY 11 !62)!2.1 ?•17 ?)12 4536 ;{ F17 ;5 .3 3.345'1 1 I DRUARi i 0T l2 3'11 i' Ir'I Since EBMUD was not able to provide invoices for January and February due to problems with meter readings, CCCSD should have used the invoice for the billing period from December 17, 2012 to March 20, 2013 for the unit numbers, because these most closely reflect the unit numbers of December, January and February. Using that invoice, you will see that the college used a total of 8,462 units, for an average of 2,821 units per month. This is a more accurate figure to use for the billing, and more in line with our normal usage for the period. If we use the 2,821 units for the three months, we find that the total amount due is closer to our previous bills. I am attaching a spreadsheet showing CCCSD calculations as well as ours. In summary, the billing should be as follows (see Revised column): Saint Mary's College of California :'U Po- -17.1-7 9.1575 1117 925 631 1286 (1 975 7 -1 10337 ...:. ; Fn3 ys rd Vrij Facilities Services Date Actual CCCSD Revised Difference Billed Jan,-June 2013 $ 87,704.15 $ 60,351.48 June- Dec. 2012 $ 95,862.58 $ 65,965.57 Total $ 183,566.73 $ 126,317.05 $ 57,249.68 In conclusion, I am formally requesting a refund or credit for $57,249.68, the difference between the Actual CCCSD Billed and the Revised calculations. We would like the adjustment posted by the end of June 2014; the end of our fiscal year. Thank you for the attention to this matter. Please do not hesitate to contact me or Anne Geiger Should you have any questions regarding the invoices and'or calculations. Anne may be reached at (925) 631-8811 or ad;6 if stmaas- ca.edu. Best regards, Joe Kehoe 1928 St. Mary's Road, Moraga, CA 94556 PMB 4747, Moraga, CA 94575 925 -631 -4053 desk 925 -457 -6360 cell ikehoe &stmarys- ca.edu Central Contra Costa Sanitary District Bill Comparison for Main Account: CCCSD CCCSD Numbers Invoice for January to June 2013 $ 87,704.07 Invoice 14458 for the period Jan. to June 2013 and 14774 for June to December 2013: Water Cons. Billing Main Meter Units per Total Calculated Units for the three month period for all meters: Units HCF Days Da HCF Days Water Cons. Billing Units Per Calendar Units per 33 85.48 Units I HCF Days Da HCF Days Month fHCF) 11/15/2012- 12/17/2012 4536 33 137.45 31 4,261.09 11/15/2012- 12/17/2012 4536 33 137.45 31 4,261.09 11/15/2012-12/17/2012 4536 33 137.45 28 3,848.73 12,370.91 HCF With Our Revised Calculations: CCCSD Numbers Invoice for January to June 2013 $ 87,704.07 Main Meter Water Cons. Billing Units Per Calendar Units per Total Calculated Units for the three month period for all meters: Units HCF Days Da HCF Days Month (HCF1 12/17/12- 3/20/13 divided by 3 2821 33 85.48 31 2,650.03 12/17/12- 3/20/13 divided by 3 2821 33 85.48 31 2,650.03 12/17/12- 3/20/13 divided by 3 2821 33 85.48 28 2,393.58 (8463/3 =2821) Meter # 11397900001 42.83 7,693.64 HCF This will result in the following changes CCCSD Numbers Invoice for January to June 2013 $ 87,704.07 Invoice for June to December 2013 $ 95,862.68 CCCSD Sewer Service Charge Calculations Total Calculated Units for the three month period for all meters: Main Meter 12,370 91 HCF Res. Hall N. 454.02 Res. Hall S. 333.12 New Res. Hall 329.73 Meter #52092700001 164.78 Meter #52965000001 266.90 Meter #52965100001 - GAMMA HALL 1,035.00 Meter # 11397900001 42.83 14,997.29 Three Month Total x 4= 12 Month Total 14,997.29 x4 59,989.16 15% Credit 8,998.37 50,990.79 Divided by 2 For half year 25,495.39 HCF x Billing rate for June to Dec. 2013 $ 3.44 $ 87,704.15 x Billing rate for Jan to June 2014 $ 3.76 $ 95,862.68 Actual CCCSD Date Billed Revised Difference Jan. -June 2013 $ 87,704.15 $ 60,351.48 June - Dec. 2012 $ 95,862.58 $ 65,965.57 Total $ 183,566.73 $ 126,317.05 $ 57,249.68 Revised Numbers $ 60,351.41 $ 65,965.57 7,693.64 454.02 333.12 329.73 164.78 266.90 1,035.00 42.83 10,320.02 (Note there are some minor rounding differences) 10,320.02 x4 41, 280.08 17,544.03 HCF $ 60,351.48 $ 65,965.57 EASTBAYMUNICIPAL UTIL17YDISTRICT -EBMUD 7-866-40-EBMUD YOUR ACCOUNT NO. IS: 13033500001 Next Read Date Is 04/19/2013 Your Payment Is Due by 04/30/2013 Most account requests can be handled faster on-line ai www.ebrrtud.com, Go to "Acbouht Mana gi4mont;-Ways to Pay" to see a list of pay station locatfons,to sign up fbrDIrect Payment, v. I n to view and pay Yo'br bill on'lf ine With iI e-Bilfortolirlake" An Immediate payment y credit card. St Marys College PO BOX 4440 ll Peribd MORAGA, CA 94575-4440 FQr• 200,4 TOTA W. ;k. :7 r i. 1r OREVI[Oi.!S�V •9 '4' g PLEASE SEE REVERSE SIDE FOR BILLING EXPLANATION Please Pay This Amount.Now Du V329 PLEASE DETACH AND RETURN THIS PAYMENT STUB WITH CHECK OR MONEY ORDER 'PAYABLE TO EBMLID•'- 200 St Marys Rd, Moraga, CA 94575 12/17/12 3120/13 ACCOUNT NO.: 13033500001 53 Pay by crediVATM/e-check for a fee. Mail payment to: Call 1-800-690-4798 TOTAL PREVIOUS 0.00 TOTAL CURRENT 34,729.41 EBMUD PAYMENT CENTER PO BOX 1000 OAKLAND CA 94649 -0001 P lease Pay This Amount Now Due 130335000019003472941000000000003 EAST BAY MUNICIPAL UTILITY DISTRICT 1- 866- 403 -2683 St Marys College PO BOX 4440 MORAGA, CA 94575 -4440 c'159' 3h 't929" 'SYMBOLS LD. & S.D.: Separate dials measuring respectively, large and small fbws through a compound meter. Water used Is the sum of quantities measured by both dials. BTY.: Indicates two (or more) meters In a battery on one service line. Billed at aervice charge for aingle meter of equivalent capacity. ESAWD 1- 866- 40- EFSMU© YOUR ACCOUNT NO. IS: 13033500001 Hig Next Read Date is 01/17/2013 Your Payment is Due by 01/15/2013 Most account requests can be handled faster on -line at www.ebmud.com. Go to "Account Management - Ways to Pay" to see a list of pay station locations, to sign up for Direct Payment, to view and pay your bill online with a -Bill, or to make an immediate payment by credit card. 11' I111I1 'I'II'�II��I�llll'��I�II'llh IIIII Bill Date: 12/31/12 St Marys College Billing Period PO BOX 4440 From To MORAGA, CA 94575 -4440 11/14/12 12/17/12 For: 200 St Marys Rd Schools AMOUNT PREVIOUS CHARGES AND CREDITS PREVIOUS AMOUNT DUE 9,564.87 FULL PAYMENT - 12/13/12 - 9,564.87 WATER CHARGES - EBMUD WATER SERVICE CHARGE 786.28 �4,15W WATER FLOW CHARG ITS @3,17 14,379.12 SEISMIC IMPROVEMENT P SURCHARGE 772.91 WATER ELEVATION CHARGE 4536 UNITS @0.46 2,086.56 �<< 01 J. LI JAN ° 3 20(3 I I S1. TOTAL i 0.00 i 18, 024.87 r ) -Al PLEASE SEE REVERSE SIDE y'j�t.`°�' FOR BILLING EXPLANATION Please Pay This Amount Now Due 18 = 24>7 t 7p METER ELEV. METER READINGS CONSUMPTION INFORMATION SIZE Band Current Previous UNITS Gallons Days Gel /Day 4,336 3,392,928 33 51,408 0_5 LAST YEAR—'-69,373 155,500,972 31 5,016,160 PLEASE SEE ENCLOSED STATEMENT — _ _ _ _ _ _ _ _ _ 01 lq- I I jJ�I 8 . _ "t7r` ` 4W.._ PLEASE DETACH AND RETURN THIS PAYMENT STUB WITH CHECK OR MONEY ORDER PAYABLE TO EBM D 200 St Marys Rd, Moraga, CA 94575 11/14/12 12/17/12 ACCOUNT NO.: 13033500001 53 Pay by credit/ATM/e- check for afee. Call 1- 800 -690- Mail payment to: 4798 TOTAL PREVIOUS 0.00 TOTAL CURRENT 18,024.87 EBMUD PAYMENT CENTER PO BOX 1000 OAKLAND CA 94649 -0001 n Please Pay This Amount Now Due 18;Q24 87;. 130335000019001802487000000000003 4i513EAST BAY MUNICIPAL UTILITY DISTRICT 1- 866 -403 -1683 St Marys College PO BOX 4440 MORAGA, CA 94575 -4440 200 St Marys Rd, Moraga, CA 94575 11114/1 METER NOS. SYMBOLS* Meter 31916227 Meter 31916232 LD SD LD SD 2 12/17/12 ACCOUNT NO.: 13033500001 8200 METER READINGS C. CUBIG FT. METER Current Previous USED SIZE 121,285.00 121,280.00 5.00 12 85,663.00 84,152.00 1,511.00 12 5,000.00 5,000.00 0.00 12 79,320.00 76,300.00 3,020.00 12 AMOUNT c -1s9 • mn (sr>sst `SYMBOLS L.D. & S.D.: Separate dials measuring respectively, large and small flows through a compound meter. Waterused Is the sum of quantities measured by troth dials. STY.: Indicates two (or more) meters In a battery on one service line. Billed at service charge for single meter of equivalent capacity. INVOICE ATTACHMENT B CENTRAL CONTRA COSTA SANITARY DISTRICT 5019 IMHOFF PLACE MARTINEZ, CA 94553 (925) 229 -7391 TO: ST. MARY'S COLLEGE INVOICE NO: 13938 P.O. BOX 4440 DATE: 10/05/12 MORAGA, CA 94575 CUSTOMER NO: 205/1293 TYPE: SX - SPECIAL SEWER SVC BILLING ---------------------------------------------------------------------------- QUANTITY DESCRIPTION UNIT PRICE EXTENDED PRICE ----- - - - - -- ------------------- - - - - -- -------- - - - - -- --------- - - - - -- 1.00 ST. MARY'S COLLEGE 65,015.41 65,015.41 SPECIAL SEWER SVC BILLING PER ATTACHED CALCULATION WORKSHEET FOR THE PERIOD OF: JANUARY 1 - JUNE 30, 2012 pol' DELINQUENT CHARGE AFTER 30 DAYS 1101 -11/99 TOTAL DUE: $65,015.41 PLEASE DETACH AND SEND THIS COPY WITH REMITTANCE DATE: 10/05/12 DUE DATE:10 /30/12 NAME: ST. MARY'S COLLEGE CUSTOMER NO: 205/1293 TYPE: SX - SPECIAL SEWER SVC BILLING REMIT AND MAKE CHECK PAYABLE TO: CENTRAL CONTRA COSTA SANITARY DISTRICT ATTN: ACCOUNTS RECEIVABLE 5019 IMHOFF PLACE MARTINEZ CA 94553 (925) 229 -7106 INVOICE NO: 13938 TERMS: NET 25 DAYS AMOUNT: $65,015.41 CCCSD SEWER SERVICE CHARGE CALCULATION FOR ST. MARY'S COLLEGE - 2012 BILLING (January 1, 2012 - June 30, 2012 Semi - Annual Billing Period) MAIN METER (acct. # 13033500001) NEW RES. HALL (acct. N51540300001) WATER CONS. BILLING UNITS PER CALENDAR UNITS PER UNITS (HCF) DAYS DAY (IICF) DAYS MONTH (IICF) MONTH (IICF) 121116/ 1 1 - 01/18/12 3284 33 9952 94.45 31 3,084.97 DECEMBER 01;18/ 12 - 03119/ 12 266 61 12/16; 11, - 01/18/12 3284 33 9952 31 3,084.97 JANUARY 01/18/12 - 03/19/12 266 61 4.36 29 12/ 16/ 1 1 - 01/18/12 3294 33 9952 29 2,885.94 FEBRUARY TOTAL 9,055.88 HCF RES. MALL NORTII BILLING UNITS PER CALENDAR UNITS PER UNITS (IICF) (acct. # 50948700001) DAY (IICF) DAYS MONTH (HCF) 111'15!11 - 01/18/12 91 64 1.42 WATER CONS. BILLING UNITS PER CALENDAR UNITS PER UNITS (HCF) DAYS DAY (IICF) DAYS 61 MONTH (IICF) 1 1 / 15 11 -01/18!12 832 64 13.00 31 403.00 DECEMBER 01/18/12 - 03/19/12 100 61 1.64 29 47.54 01 / 18 12 - 03 19/12 304 61 4.98 TOTAL 31 154.49 JANUARY 01/18/12 - 03/19/12 304 61 4.98 29 144.52 FEBRUARY TOTAL 702.02 IICF RES. MALL SOUTI4 (acct. # 50948800001) WATER CONS. BILLING UNITS PER CALENDAR I NITS PER UNITS (HCF) DAYS DAY (IICF) DAYS ZION PH (IICF) 11/15/11 -01 18/12 214 6 -1 3.34 31 103.66 DECEMBER 1)1/18/12 -03 19 12 255 61 4.18 31 129.59 JANUARY 01/18/12 - 03/19/12 255 61 4.18 29 121.23 FEBRUARY TOTAL 354.48 14CF NEW RES. HALL (acct. N51540300001) N:\A000UNTING \Todd\Accts Receivable \STMARY Bill 1 of 3 WATER CONS. BILLING UNITS PER CALENDAR UNITS PER UNITS (HCF) DAYS DAY (IICF) DAYS MONTH (IICF) II /I5 /11 - 61/18/12 195 64 3.05 31 94.45 DECEMBER 01;18/ 12 - 03119/ 12 266 61 4.36 31 135.18 JANUARY 01/18/12 - 03/19/12 266 61 4.36 29 126.46 FEBRUARY TOTAL 356.09 HCF iIETER #52092700001 WATER CONS. BILLING UNITS PER CALENDAR UNITS PER UNITS (IICF) DAYS DAY (IICF) DAYS MONTH (HCF) 111'15!11 - 01/18/12 91 64 1.42 31 44.08 DECEMBER 01'18/12 - 03/19112 100 61 1.64 31 50.82 JANUARY 01/18/12 - 03/19/12 100 61 1.64 29 47.54 FEBRUARY TOTAL 142.44 HCF N:\A000UNTING \Todd\Accts Receivable \STMARY Bill 1 of 3 N \ACC0UNTING1Todd\Accls ReceivablelSTMARY Bill 2 of 3 CCCSD SEWER SERVICE CHARGE CALCULATION FOR ST. MARY'S COLLEGE - 2012 BILLING (January 1, 2012 -,June 30, 2012 Semi - Annual Billing Period) METER #52965000001 WATER CONS. BILLING UNITS PER CALENDAR UNITS PER UNITS (HCF) DAYS DAY (HCF) DAYS MONTH (HCF) 01 18/12 - 0' , 19/12 159 61 2.61 31 80.80 DECEMBER 01 18 12 - 03 19/12 159 61 2.61 31 80.80 JANUARY 01/18/12 - 03/19/12 159 61 2.61 29 75.59 FEBRUARY 'TOTAL 237.20 HCF METER #52965100001 WATER CONS. BILLING UNITS PER CALENDAR UNITS PER UNITS (HCF) DAYS DAY (IICF) DAYS MONTH (HCF) oI /I8 /12 -'0/19 12 ll 61 0.00 31 0.00 DECEMBER 01/18/12 03/1912 0 61 0.00 31 0.00 JANUARY 01/18/12 - 03/19/12 0 61 0.01/ 78 0.00 FEBRUARY TOTAL 0.00 IICF GAMINIA HALL #52965800001 WATER CONS. BILLING UNITS PER CALENDAR 1'NITS PER UNITS (HCF) DAYS DAY (IICF) DAYS MONTH (IICF) 01 18 1' - 03/19 12 802 61 13.15 31 407.57 DECEMBER 01 / 18/12 - 03;19/ 12 902 61 13.15 31 407.57 JANUARY 01/18/12 - 03/19/12 802 61 13.15 29 381.28 FEBRUARY TOTAL 1,196.43 HCF i\IETER #11397900001 WATER CONS. BILLING UNITS PER CALENDAR UNITS PER UNITS (HCF) DAYS DAY (IICF) DAYS MONTH (IICF) 10/31/11 - 01/06/12 37 67 0.55 31 17.12 DECEMBER 01/06 12 - 03/(15/12 41 59 0.69 31 21.54 JANUARY 01/06/12 - 03/05/12 41 59 0.69 28 19.46 FEBRUARY TOTAL 58.12 HCF N \ACC0UNTING1Todd\Accls ReceivablelSTMARY Bill 2 of 3 CCCSD SEWER SERVICE CHARGE CALCULATION FOR ST. MARY'S COLLEGE - 2012 BILLING (January 1, 2012 -,Time 30, 2012 Semi - Annual Billing Period) TOTAL CALCULATED UNI'T'S FOR TFIREE MONTH PERIOD FOR ALL METERS: MAIN METER 9,055.88 HCF RES. HALL N. 702.02 RES. HALL. S 354.48 THREE -MONTH TOTAL x 4 = 12- MONTH TOTAL: 12,102.64 HCF x 4 48,410.58 HCF TOTAL CALCULATED WASTEWATER FLOW I-OR CALENDAR YEAR 2012: 48,410.58 HCF 7,261.59 Less 15% 41,148.99 HCF NEW RES.HALL 356.09 METER #52092700001 142.44 METER #52965000001 237.20 METER #52965100001 0.00 GAMMA HALL 1.196.43 METER # 11397900001 58.12 TOTAL 12,102.64 HCF LESS 15 % CREDIT: TOTAL CALCULATED WASTEWATER FLOW FOR THE SEMI - ANNUAL BILLING PERIOD: 41,148.99 /2= 20,574.50 HCF TOTAL CALCULATION FLOW FOR THE JANUARY I, 2012 -.ZUNI 30, 2012 BILLING PERIOD MULTIPLIED BY THE SEWER SERVICE CHARGE RATE EQUALS THE TOTAL SEMI- ANNUAL BILLING AMOUNT DUE: (HCF X Rate) 20,574.50 X $3.16 = $65,015.41 Amount Paid Total Due $65,015.41 N:IA000UNTING \Todd\Accls Receivable\STMARY Bill 3 of 3 48,410.58 HCF x .15 7,261.59 -L 1V V V 1 l--P. CENTRAL CONTRA COSTA SANITARY DISTRICT 5019 IMHOFF PLACE MARTINEZ, CA 94553 (925) 229 -7106 TO: ST. MARY'S COLLEGE INVOICE NO: 13459 P.O. BOX 4440 DATE: 2/06/12 MORAGA, CA 94575 CUSTOMER NO: 205/1293 TYPE: SX - SPECIAL SEWER SVC BILLING ------------------------------------------------------ QUANTITY DESCRIPTION UNIT PRICE EXTENDED PRICE ----- - - - - -- ------------------------- -------------- --------- - - - - -- 1.00 ST. MARY'S COLLEGE 54,391.16 54,391.16 SPECIAL SEWER SVC BILLING PER ATTACHED CALCULATION WORKSHEET FOR THE PERIOD OF: JULY 1, 2011 - DECEMBER 31, 2011 DELINQUENT CHARGE AFTER 30 DAYS 1101 -11/99 TOTAL DUE: $541391.16 PLEASE DETACH AND SEND THIS COPY WITH REMITTANCE DATE: 2/06/12 DUE DATE: 3/02/12 NAME: ST. MARY'S COLLEGE CUSTOMER NO: 205/1293 TYPE: SX - SPECIAL SEWER SVC BILLING REMIT AND MAKE CHECK PAYABLE TO: CENTRAL CONTRA COSTA SANITARY DISTRICT ATTN: ACCOUNTS RECEIVABLE 5019 IMHOFF PLACE MARTINEZ CA 94553 (925) 229 -7106 INVOICE NO: 13459 TERMS: NET 25 DAYS AMOUNT: $54,391.16 CCCSD SEWER SERVICE CHARGE CALCULA'T'ION FOR ST. `IARY'S COLLEGE - 2011 BILLING (July I, 2011 - December 31, 2011 Semi - annual Billing Period) MAIN METER (acct. # 04700071) WATER CONS. BILLING UNITS PER CALENDAR U,N ITS I'NR UNITS (IICF) DA1 S DAY (IICF) D NN S MONTH (IICF) 12/17/10 - 01/1Q/1 1 1775 34 52.29 31 1,621.12 DEC'ENIBC-R 01/20/11 - 02/15/11 2540 30 54.67 31 2,624.07 JANUARY 02/19/11 - 03/21/11 3137 31 101.19 28 2,53342 FEBRUARY -TOTA1. 7,079 20 110. RES. HALL NORTH (acct. # 50026911) NVAT'ERCONS. BILLING UNI IS PER CALENDAR UNITS I, ER UNITS (HCF) DAYS DAY (HCF) DAYS NION" 141 (HCF) 11/16/10 - 01/19/11 265 65 4 12 31 127.82 DLCEIN-IBLR 1/20/11 - 03.21/11 381 61 625 31 193.62 .IANUARY 1/20/11 - 03.21/11 381 61 6.25 28 174.89 FEBRUARY TOTAL 496.32 1-107 RES. HALL SOUTH (acct. # 5002692 1) NVATER CONS. BILLING UNI IS PER C \LE \DAR UNIT'S PER UNITS (IICF) DAYS DAY (IICF) D %YS \ION r1l (IICF) 11/16/10 - 01/19/11 224 65 3.45 31 1116.83 DLCLMBLIt 0 1/2 0/11 - 03/21/11 293 61 480 31 145.90 JANUARY 01/20/11 - 03/21/11 293 of 4.80 28 134.49 FEBRUARY "1'0'1 AI_ 390 22 110- NEW RES. HALL (acct. #50086971) WATER CONS. BILLING UNITS PER CALENDAR UNITS PER UNITS (IICF) DAN'S DAN' (IICF) DAN'S MONT II (IICF) 11 16 10 - 01/19/11 217 65 3.34 31 103.49 DECL=MBFR 01 19 11 - 03/2 1/1 1 314 61 5.15 31 159.57 JANUARY 01 19 11 - 03/21/11 314 61 5.15 28 144.13 1EBRUARY "TOTAL 407.20 HCF METER # 50142961 NVAT'ER CONS. BILLING UNIT'S PER CALENDAR UNITS PER UNITS (HCF) DAYS DAY (IICF) DAYS NION 111 (IICF) 11/16/10 - 01/19/11 107 65 1 65 31 51.03 DEC'LNIB R 01 20/11 - 0321 11 101 61 1.66 31 51.33 JANUARY 01/20/11 - 03/21111 101 61 1 66 28 46.36 FEBRUARY rar \L 148.72 HCF N:\A000UNTING \Todd\Accts Receivable \STMARY Bill 1 of 3 METER # 50231751 UNITS PER CALENDAR WATER CONS. CC'CSD SEWER SERVICE CHARGE CALCULATION FOR ST. 11'IARY'S COLLEGE - 2011 BILLING 0 (Ju1), 1, 2011 - December 31, 2011 Semi - Annual Billing Period) 0.00 NI ETER # 50231711 0 JANUARY 0.00 0112(/ 1 1- 0312 U I I WA'T'ER CONS. BILLING I NITS PFR CA1.EN1) \It UNITS PER GANNNIA HALL #50231821 UNITS (HCF) DAYS D kY (IICF) DAN s MONTH (IICF) 1 1 / 10/ 10 - 01/19/11 175 65 269 3. S3.46 DLC'LNIB1?R UNI I'S PER W 21 10 - 03 22:10 948 01/20/11 - 03/21/11 298 61 4.59 31 151.44 JANUARI' 280.91 METER # 02724116 15 54 01/20/11 - 03/21/11 298 61 4 89 28 136.79 FEBRUARY 21 TOTAL 371.69 I IC F METER # 50231751 UNITS PER CALENDAR WATER CONS. DAIS UNITS (IICF) 11/16/10 -01 II 0 DFC'I:-MBf R 0.00 01�20 i11 -03 2111 0 JANUARY 0.00 0112(/ 1 1- 0312 U I I 0 171-13RL:AItY 0.00 GANNNIA HALL #50231821 0.00 WA'T'ER CONS. TOTA L UNITS (HCF) 11 1610 - 01.19.11 589 CALENDAR UNI I'S PER W 21 10 - 03 22:10 948 JANUARY VO \'I'll (IICF) 01 21 10 - 03,22/10 948 FEBRUARY 280.91 METER # 02724116 15 54 31 WATER CONS. 61 UNITS (HCF) 10 /2S 10 - 01 0/1 1 21 DLC'I 1V113FR 01/7 11 - 03 17 1 1 25 JANUARY UNITS PER 01/7/11 - 03/17 1 1 25 FEBRUARY DAY (HCF) MILLING UNITS PER CALENDAR UNITS PE It DAIS DAY (IICF) DAIS MONTH (IICF) 65 0.00 31 0.00 61 0.00 31 0.00 61 0.00 28 0.00 TOTA L 0.00 1 I CT BILLING UNITS PER CALENDAR UNI I'S PER DAYS DAY (IICF) DAYS VO \'I'll (IICF) 65 9.06 31 280.91 61 15 54 31 481.77 61 15.54 28 43515 TOI'AL 1,197.83 11( 1; MILLING UNITS PER C U EN 1) kit UN IS PER DAYS DAY (HCF) DAYS MON PH (IICF) 71 030 31 9.17 60 0.42 31 12.92 60 0.42 28 11.67 TOTA I 33.75 110- N \ACCOUNTING \Todd\Accts Receivable \STMARY Bill 2 of 3 CCCSD SEWER SERVICE CHARGE CALCULATION FOR ST. MARY'S COLLEGE - 2011 BILLING (July 1, 2011 - December 31, 2011 Semi - Annual Billing Period) TOTAL CALCULATED l NITS FOR THREE MONTH PERIOD FOR ALL METERS: MAIN MUTER 7,079.20 FICF RES. HALL N. 496.32 RES. HALL S. 390.22 NEW RES.HALL 407.20 METER #5014296 148.72 METER #50231741 371.69 METER #50231751 0.00 GAMMA IIAI L 1,197.83 METER# 02724416 33.75 TOTAL 10,124.94 HCF I'I IREE -MONTI I TOTAI x 4 — 12- IvIONTI I TOTAL: 10,124.94 1 ICF x 4 40,499.75 1 ICF fO I-AL CALCULATLD WASTEWATER FLOW FOR CALENDAR YEAR 2011: 40,499.75 I-ICF 6,074.96 Less 15% 34,424.79 I-ICI- LESS 15 % CREDIT TOTAL CALCULATED WASTEWATER FLOW I.Olt THE SEMI - ANNUAL BILLING PERIOD: 34,424.79 /2= 17,212.39 I ICI: TOTAL CALCULATION FLOW I-Olt THE JULY I, 2011 - DECEMBER 31, 201 1 BILLING PERIOD MULTIPLIED BY THE SEWER SL-RVICE CHARGE RATE EQUALS TI IE TOTAL SENII- ANNUAL BILLING AMOUNT DUE: (I ICF x Rate) 17,212.39 X S3.16 = S54,391.16 Amount Paid Total Due 554,391.16 NAACC0UNTING1ToddlAccls Receivable \STMARY Bill 3 of 3 40,499.75 I-ICF x .I5 6,07-4.96