Loading...
2012-2013 Cambridge BudgetCAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Revenues Contract Revenues Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF Potential Room Revenue 429,949 429,949 429,949 429,949 429,949 429,949 429,949 429,949 428,949 428,949 429,949 429,949 5,157,393 70.2%$26,313 $26,313.23 $38.64 Potential Food Revenue 182,090 182,090 182,090 182,090 182,090 182,090 182,090 182,090 182,090 182,090 182,090 182,090 2,185,075 29.8%$11,148 $11,148.34 $16.37 Total Potential Revenue 612,039 612,039 612,039 612,039 612,039 612,039 612,039 612,039 611,039 611,039 612,039 612,039 7,342,468 100.0%$37,462 $37,461.57 $55.02 Non-Rev/Vacancy Loss Room -20,274 -20,274 -20,274 -20,274 -20,274 -20,274 -20,274 -20,274 -20,274 -424,660 -424,660 -20,274 -1,052,060 -14.3%-$5,368 -$5,367.65 -$7.88 Non-Rev/Vacancy Loss Food -8,606 -8,606 -8,606 -8,606 -8,606 -8,606 -8,606 -8,606 -8,606 -180,269 -180,269 -8,606 -446,601 -6.1%-$2,279 -$2,278.58 -$3.35 Total Non-Rev/Vacancy Loss -28,880 -28,880 -28,880 -28,880 -28,880 -28,880 -28,880 -28,880 -28,880 -604,929 -604,929 -28,880 -1,498,661 -20.4%-$7,646 -$7,646.23 -$11.23 Budget Contract - Room 409,675 409,675 409,675 409,675 409,675 409,675 409,675 409,675 408,675 4,289 5,289 409,675 4,105,332 55.9%$20,946 $20,945.57 $30.76 Budget Contract - Food 173,483 173,483 173,483 173,483 173,483 173,483 173,483 173,483 173,483 1,821 1,821 173,483 1,738,474 23.7%$8,870 $8,869.77 $13.03 Concessions -5,000 -5,000 -5,000 -5,000 -5,000 -5,000 -5,000 -5,000 -5,000 -5,000 -50,000 TSHA Incremental Sch. (50)-19,050 -19,050 -19,050 -19,050 -19,050 -19,050 -19,050 -19,050 -19,050 -19,050 -190,500 -3.2%-$972 -$350.18 -$1.43 Payplan Charge/Discount -26,688 -26,688 -26,688 -26,688 -26,688 -26,688 -26,688 -26,688 -26,688 -29,149 -269,344 -3.7%-$1,374 -$1,374.20 -$2.02 Total Contract Revenue 532,420 532,420 532,420 532,420 532,420 532,420 532,420 532,420 531,420 6,110 7,110 529,960 5,333,963 72.6%$27,214 $27,214.10 $39.97 Other Revenues Parking Lot - Contract 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 0 0 4,000 40,000 0.7%$204 $73.53 $0.30 Conference/Camp - Food 0 0 0 0 0 0 0 0 0 122,500 111,000 6,500 240,000 4.0%$1,224 $441.18 $1.80 Conference/Camp - Room 0 0 0 0 0 0 0 0 0 122,500 111,000 6,500 240,000 4.0%$1,224 $441.18 $1.80 Damages Recovered 500 1,000 500 250 300 300 300 300 6,000 5,000 1,000 500 15,950 0.3%$81 $29.32 $0.12 Application Fess 0 0 0 500 500 1,000 2,000 5,000 5,000 0 0 0 14,000 0.2%$71 $25.74 $0.10 Accelertated Rent 0 0.0%$0 $0.00 $0.00 Cancellation Fess 0 0 0 2,500 1,500 500 0 0 0 1,500 7,000 13,000 0.2%$66 $23.90 $0.10 Late Charges 125 125 125 125 125 125 125 125 125 125 125 125 1,500 0.0%$8 $2.76 $0.01 Outside Board Contracts 0 0.0%$0 $0.00 $0.00 Cash Food Sales 0 0.0%$0 $0.00 $0.00 Vending Commissions 100 100 100 100 100 100 100 700 0.0%$4 $1.29 $0.01 Wash Mach Commissions 1,300 1,300 900 900 1,000 1,100 900 500 500 0 0 1,600 10,000 0.2%$51 $18.38 $0.07 Telephone Commissions 0 0.0%$0 $0.00 $0.00 Interest Income 90 200 190 140 0 0 0 100 100 100 100 0 1,020 0.0%$5 $1.88 $0.01 Catering 0 0 0 0 500 500 500 500 0 0 0 0 2,000 0.0%$10 $3.68 $0.01 Returned Check/Late Fees 25 25 25 25 25 25 25 25 25 25 25 25 300 0.0%$2 $0.55 $0.00 Banquets 0 0.0%$0 $0.00 $0.00 Other - Food 0 0.0%$0 $0.00 $0.00 Guest/Transient Income 5,500 1,500 1,500 1,500 2,250 2,250 1,000 1,300 1,034 250 100 15,000 33,184 0.6%$169 $61.00 $0.25 Retained Fees 0 0.0%$0 $0.00 $0.00 Miscellaneous Income 100 100 100 100 100 100 100 100 100 100 100 100 1,200 0.0%$6 $2.21 $0.01 Transaction Fee 500 200 200 200 200 200 200 200 500 1,000 1,000 650 5,050 0.1%$26 $9.28 $0.04 0.0%$0 $0.00 $0.00 Total Other Revenue 12,240 8,450 7,640 10,240 10,600 10,100 9,250 12,150 17,384 251,700 226,050 42,100 617,904 10.4%$3,153 $1,135.85 $4.63 Total Revenue 544,660 540,870 540,060 542,660 543,020 542,520 541,670 544,570 548,804 257,810 233,160 572,060 5,951,867 100.0%$30,367 $10,940.93 $44.60 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Food Department Food Cost Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF Beverages 5,915 5,138 4,370 2,960 2,968 4,957 4,180 5,070 2,493 3,683 3,683 2,961 48,378 0.8%$247 $88.93 $0.36 Baked Goods 2,457 2,336 2,072 1,356 1,340 2,254 1,855 2,301 1,134 1,685 1,685 1,357 21,832 0.4%$111 $40.13 $0.16 Dairy 5,895 4,827 4,669 2,264 2,835 3,826 3,136 4,369 2,565 2,830 2,830 2,266 42,312 0.7%$216 $77.78 $0.32 Milk 2,141 1,684 1,494 1,031 1,082 1,816 1,335 2,166 830 1,515 1,498 1,031 17,623 0.3%$90 $32.40 $0.13 Meats 15,611 15,423 15,395 9,709 10,407 16,167 13,461 16,167 9,270 12,630 12,630 10,507 157,377 2.6%$803 $289.30 $1.18 Frozen Goods 7,471 5,965 5,349 3,779 3,687 7,058 4,769 5,860 4,104 5,826 6,947 3,781 64,596 1.1%$330 $118.74 $0.48 Accompaniments 10,944 9,952 9,702 4,891 4,905 9,359 6,836 9,546 4,121 6,224 6,247 4,894 87,621 1.5%$447 $161.07 $0.66 Produce 4,704 3,993 4,134 2,309 3,385 4,613 3,034 4,358 1,869 2,860 2,735 2,310 40,304 0.7%$206 $74.09 $0.30 Total Food Cost 55,138 49,318 47,185 28,299 30,609 50,050 38,606 49,837 26,386 37,253 38,255 29,107 480,043 8.1%$2,449 $882.43 $3.60 Food Department Payroll Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF Salaries/Wages 31,500 31,500 41,254 30,145 12,098 27,011 31,079 29,001 29,073 40,001 31,092 29,023 362,777 6.1%$1,851 $666.87 $2.72 Benefits & Taxes 8,975 8,745 10,988 9,008 4,858 7,713 8,648 8,170 8,417 10,700 8,881 8,175 103,279 1.7%$527 $189.85 $0.77 Employee Meals 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Vacation Pay 0 0 0 3,200 0 0 3,200 0 876 876 0 0 8,152 0.1%$42 $14.99 $0.06 Holiday Pay 1,000 0 0 2,500 2,500 0 0 0 1,000 0 1,000 0 8,000 0.1%$41 $14.71 $0.06 Sick Pay 0 0 496 424 440 472 424 410 119 1,500 440 0 4,725 0.1%$24 $8.69 $0.04 Bonus 0 5,000 0 0 0 0 0 0 0 0 0 5,000 0.1%$26 $9.19 $0.04 Contract Labor 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Total Payroll 41,475 45,245 52,738 45,277 19,896 35,196 43,351 37,581 39,485 53,077 41,413 37,198 491,933 8.3%$2,510 $904.29 $3.69 Food Department Food Department Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF Pest Control 110 110 110 110 110 110 110 110 110 110 110 110 1,320 0.0%$7 $2.43 $0.01 Linen Laundry/Rental 350 350 350 255 170 350 350 350 255 350 350 255 3,735 0.1%$19 $6.87 $0.03 Uniforms 0 0 0 0 1,200 0 0 0 0 0 0 1,000 2,200 0.0%$11 $4.04 $0.02 Dining Room Supplies 1,200 350 350 350 350 350 350 350 350 350 350 650 5,350 0.1%$27 $9.83 $0.04 Decorations 100 100 100 100 100 100 100 100 100 100 100 100 1,200 0.0%$6 $2.21 $0.01 Kitchen Supplies 600 450 450 100 600 450 300 450 100 450 450 400 4,800 0.1%$24 $8.82 $0.04 China/Glass/Silver 1,500 0 0 0 1,000 0 0 0 0 500 0 1,500 4,500 0.1%$23 $8.27 $0.03 Cleaning Supplies 1,350 1,200 1,000 600 935 800 800 800 1,200 750 750 900 11,085 0.2%$57 $20.38 $0.08 Contract Cleaning 450 350 300 500 1,000 300 100 250 400 0 0 1,350 5,000 0.1%$26 $9.19 $0.04 Paper 500 500 500 250 250 500 500 500 350 500 500 350 5,200 0.1%$27 $9.56 $0.04 Equipment Rental 300 300 300 300 300 300 300 300 300 300 300 300 3,600 0.1%$18 $6.62 $0.03 Other Expense 500 500 500 500 1,000 500 500 500 500 500 1,000 500 7,000 0.1%$36 $12.87 $0.05 Total Other Expense 6,960 4,210 3,960 3,065 7,015 3,760 3,410 3,710 3,665 3,910 3,910 7,415 54,990 0.9%$281 $101.08 $0.41 Total Food Expense 103,573 98,773 103,883 76,641 57,520 89,006 85,367 91,128 69,536 94,240 83,578 73,720 1,026,966 17.3%$5,240 $1,887.80 $7.70 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Gen & Admn Dept Payroll Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF Salaries/Wages 14,435 14,435 14,435 21,652 14,435 14,435 14,435 14,435 14,435 21,652 14,435 14,435 187,650 3.2%$957 $344.94 $1.41 Benefits & Taxes 3,840 3,840 3,840 5,500 3,840 3,840 3,840 3,840 3,840 5,500 3,840 3,840 49,400 0.8%$252 $90.81 $0.37 Employee Meals 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Vacation Pay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Holiday Pay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Bonus 0 0 7,000 0 0 0 0 0 0 0 0 0 7,000 0.1%$36 $12.87 $0.05 Total Payroll 18,275 18,275 25,275 27,152 18,275 18,275 18,275 18,275 18,275 27,152 18,275 18,275 244,050 4.1%$1,245 $448.62 $1.83 Management Fee Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF Management Fee 23,400 23,400 23,400 23,400 23,400 23,400 23,400 23,400 23,400 23,400 23,400 23,400 280,800 4.7%$1,433 $516.18 $2.10 Gen & Admn Dept Other Expense Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF Equipment Lease 1,400 1,000 2,300 1,300 2,700 1,000 1,500 2,500 1,900 1,200 1,100 2,100 20,000 0.3%$102 $36.76 $0.15 Computer & Software Maint 200 200 200 200 200 1,250 200 200 200 200 200 200 3,450 0.1%$18 $6.34 $0.03 Audit 3,150 7,150 10,300 0.2%$53 $18.93 $0.08 Other Professional Expense 100 100 100 100 100 100 100 100 100 100 100 100 1,200 0.0%$6 $2.21 $0.01 Taxes, Licenses & Fees 500 200 200 200 200 200 200 200 200 2,100 0.0%$11 $3.86 $0.02 Resident Screening 500 500 600 600 600 600 600 500 500 5,000 0.1%$26 $9.19 $0.04 Hotel Tax Expense 0 0.0%$0 $0.00 $0.00 Property Insurance 0 0.0%$0 $0.00 $0.00 Telephone - Ld 400 400 400 400 400 500 700 700 700 500 500 400 6,000 0.1%$31 $11.03 $0.04 Telephone - Local 650 650 650 650 650 700 700 700 800 800 800 650 8,400 0.1%$43 $15.44 $0.06 Office Supplies 900 900 900 500 500 900 900 900 900 900 900 900 10,000 0.2%$51 $18.38 $0.07 Postage 150 150 700 700 600 700 700 700 700 700 700 300 6,800 0.1%$35 $12.50 $0.05 Dues/Subscriptions 75 75 75 75 75 75 75 75 75 75 75 75 900 0.0%$5 $1.65 $0.01 Travel-Local Supervision 500 150 500 150 150 500 150 500 150 150 150 500 3,550 0.1%$18 $6.53 $0.03 TSHA Admin Fee 10,270 10,270 10,270 10,270 10,270 10,270 10,270 10,270 10,270 3,219 3,219 3,219 102,084 1.7%$521 $187.65 $0.76 Legal Fees 8,500 8,500 8,500 8,500 8,500 8,500 8,500 8,500 8,500 8,500 8,500 8,500 102,000 1.7%$520 $187.50 $0.76 Recruiting Expense 0 0.0%$0 $0.00 $0.00 Training Expense 1,500 1,000 2,500 0.0%$13 $4.60 $0.02 Security Service 0 0.0%$0 $0.00 $0.00 Collection Expense 0 0.0%$0 $0.00 $0.00 Bad Debt Expense 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000 2.0%$612 $220.59 $0.90 Other G&A Expense 50,000 200 200 200 200 200 200 200 200 200 200 200 52,200 0.9%$266 $95.96 $0.39 Uniforms 1,500 2,500 4,000 0.1%$20 $7.35 $0.03 Bank Service Charges 1,320 1,161 1,000 500 700 700 300 1,000 600 500 500 400 8,681 0.1%$44 $15.96 $0.07 Courtesy Officer 4,200 4,200 4,200 5,300 4,800 4,150 4,150 4,150 5,100 4,200 4,200 4,200 52,850 0.9%$270 $97.15 $0.40 Credit Card Fees 0 0.0%$0 $0.00 $0.00 Rent Refunds/Prepaids 1,000 1,000 1,000 0 0 1,000 1,000 5,000 0.1%$26 $9.19 $0.04 Total Other Expense 91,165 38,956 39,995 43,995 48,695 40,345 39,245 41,295 42,495 32,044 32,844 35,944 527,015 8.9%$2,689 $968.78 $3.95 0.0%$0 $0.00 $0.00 Total G&A Expenses 109,439 57,230 65,269 71,146 66,969 58,619 57,519 59,569 60,769 59,196 51,119 54,219 771,064 13.0%$3,934 $1,417.40 $5.78 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Marketing Dept Other Expense Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF Outdoor Advertising 500 4,500 5,000 0.1%$26 $9.19 $0.04 Direct Mail 3,000 4,000 5,000 8,000 3,000 23,000 0.4%$117 $42.28 $0.17 News/Magazines 350 550 550 1,000 2,500 2,500 2,500 2,500 750 0 0 0 13,200 0.2%$67 $24.26 $0.10 Radio/Tv Advertising 3,500 3,500 0.1%$18 $6.43 $0.03 Brochures/Promo Items 2,000 15,000 750 17,750 0.3%$91 $32.63 $0.13 Promotion - External 1,200 5,000 100 6,300 0.1%$32 $11.58 $0.05 Lease Comm. - Residential 0 0.0%$0 $0.00 $0.00 Web Adv/Presence 800 800 800 800 800 800 800 800 800 800 800 800 9,600 0.2%$49 $17.65 $0.07 Other Expense 11,500 200 200 300 300 300 300 13,100 0.2%$67 $24.08 $0.10 Total Marketing Expenses 15,150 1,550 17,750 2,100 6,300 16,850 12,900 11,600 4,850 800 800 800 91,450 1.5%$467 $168.11 $0.69 Residence Life & Student Development Other Expense Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF Res. Life & Dev.2,100 2,100 2,100 1,000 3,600 2,500 1,700 1,650 1,600 1,900 20,250 0.3%$103 $37.22 $0.15 Total Res. Life 2,100 2,100 2,100 1,000 3,600 2,500 1,700 1,650 1,600 1,900 20,250 0.3%$103 $37.22 $0.15 Telecom Expenses Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF 0.0%$0 $0.00 $0.00 Telecom 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Residential Long Distance 0 0.0%$0 $0.00 $0.00 Data 5,800 5,800 5,800 5,800 5,800 5,800 5,800 5,800 5,800 5,800 5,800 5,800 69,600 1.2%$355 $127.94 $0.52 Cable TV 6,250 6,250 6,250 6,250 6,250 6,250 6,250 6,250 6,250 6,250 6,250 6,250 75,000 1.3%$383 $137.87 $0.56 Total Telecom Expense 12,050 12,050 12,050 12,050 12,050 12,050 12,050 12,050 12,050 12,050 12,050 12,050 144,600 2.4%$738 $265.81 $1.08 Utilities/Energy Expenses Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF 0.0%$0 $0.00 $0.00 Electric - Public 27,458 25,345 27,012 11,390 10,087 16,784 15,175 18,390 20,478 25,897 24,741 28,471 251,228 4.2%$1,282 $461.82 $1.88 Electric - Residential 13,679 10,658 11,078 7,112 7,456 8,856 8,278 9,727 10,124 12,412 12,088 12,547 124,015 2.1%$633 $227.97 $0.93 Electric - Resident Payments 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Fuel (Gas)4,000 4,000 4,000 3,450 2,000 3,050 3,550 3,050 3,050 2,550 4,150 4,150 41,000 0.7%$209 $75.37 $0.31 Sewer 3,750 3,500 3,500 3,750 3,000 3,750 3,500 3,250 3,500 3,250 3,275 3,175 41,200 0.7%$210 $75.74 $0.31 Water 3,750 4,000 3,900 3,300 2,750 3,500 3,000 3,600 2,600 2,700 2,500 2,500 38,100 0.6%$194 $70.04 $0.29 Total Utility Expense 52,637 47,503 49,490 29,002 25,293 35,940 33,503 38,017 39,752 46,809 46,754 50,843 495,543 8.3%$2,528 $910.92 $3.71 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Rep/Maint Dept Payroll Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF Salaries/Wages 7,942 7,942 7,942 11,913 7,942 7,942 7,942 7,942 7,942 11,913 7,942 7,942 103,250 1.7%$527 $189.80 $0.77 Benefits & Taxes 2,607 2,607 2,607 3,520 2,607 2,607 2,607 2,607 2,607 3,520 2,607 2,607 33,108 0.6%$169 $60.86 $0.25 Employee Meals 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Vacation Pay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Holiday Pay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Sick Pay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Other Benefits 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Total Payroll 10,549 10,549 10,549 15,434 10,549 10,549 10,549 10,549 10,549 15,434 10,549 10,549 136,358 2.3%$696 $250.66 $1.02 Housekeepers Payroll Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF Salaries/Wages 1,247 1,247 1,247 1,871 1,247 1,247 1,247 1,247 1,247 1,871 1,247 1,247 16,212 0.3%$83 $29.80 $0.12 Benefits & Taxes 287 287 287 430 287 287 287 287 287 430 287 287 3,729 0.1%$19 $6.85 $0.03 Contract Housekeeping 11,100 11,100 11,100 11,100 11,100 11,100 11,100 11,100 11,100 11,100 11,100 11,100 133,200 2.2%$680 $244.85 $1.00 Vacation Pay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Holiday Pay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Sick Pay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Other Benefits 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Total Payroll 12,634 12,634 12,634 13,401 12,634 12,634 12,634 12,634 12,634 13,401 12,634 12,634 153,141 2.6%$781 $281.51 $1.15 Rep/Maint Dept Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF 0.0%$0 $0.00 $0.00 Waste Removal 1,330 1,330 1,330 1,330 1,330 1,330 1,330 1,330 1,330 1,330 1,330 1,330 15,960 0.3%$81 $29.34 $0.12 Rooms Supplies 0 0.0%$0 $0.00 $0.00 Cleaning Supplies 900 850 1,100 1,100 1,100 750 1,100 750 2,650 2,650 2,650 900 16,500 0.3%$84 $30.33 $0.12 Contract Cleaning 0 0.0%$0 $0.00 $0.00 Equipment Rental 0 0.0%$0 $0.00 $0.00 Pest Control 300 300 300 300 300 300 300 300 300 300 300 300 3,600 0.1%$18 $6.62 $0.03 Other Expense 40 40 40 40 40 40 40 40 40 40 40 40 480 0.0%$2 $0.88 $0.00 Buildings Maintenance 2,000 350 350 350 350 350 350 350 2,000 2,000 2,000 200 10,650 0.2%$54 $19.58 $0.08 Food Service Equip Repair 1,000 1,000 1,000 1,000 1,600 1,000 1,000 1,000 1,000 1,600 1,000 1,000 13,200 0.2%$67 $24.26 $0.10 Drive/Park Lot Maint.100 100 100 100 100 100 100 100 100 4,500 100 100 5,600 0.1%$29 $10.29 $0.04 Elevator Maintenance 1,750 630 800 1,750 800 800 1,750 630 800 1,750 800 630 12,890 0.2%$66 $23.69 $0.10 Laundry Equip. Maint.0 0.0%$0 $0.00 $0.00 Hvac Maintenance 1,700 1,000 800 800 800 1,100 1,100 1,100 1,600 1,600 1,600 1,700 14,900 0.3%$76 $27.39 $0.11 Carpet/Drapery Cleaning 500 0 500 0 500 0 500 0 5,000 5,000 5,000 0 17,000 0.3%$87 $31.25 $0.13 Plumbing 200 200 200 200 200 210 215 215 215 215 215 215 2,500 0.0%$13 $4.60 $0.02 Grounds/Landscaping 2,000 2,000 2,000 2,000 2,000 3,000 2,000 2,000 2,000 2,000 2,000 2,500 25,500 0.4%$130 $46.88 $0.19 Swimming Pool 800 400 400 400 400 400 400 400 800 400 400 800 6,000 0.1%$31 $11.03 $0.04 Furniture Repair 2,500 2,500 1,500 6,500 0.1%$33 $11.95 $0.05 Maint. Equip. Repair 175 175 175 175 175 175 175 175 175 175 175 175 2,100 0.0%$11 $3.86 $0.02 Fire Equipment Repair 1,300 150 150 150 150 150 150 1,500 150 150 150 150 4,300 0.1%$22 $7.90 $0.03 Carpet Repl./Repair 0 0.0%$0 $0.00 $0.00 Rec. Equip. Repair 500 200 500 200 500 200 500 200 500 200 200 500 4,200 0.1%$21 $7.72 $0.03 Maintenance Supplies 700 700 700 400 700 500 500 500 900 1,000 1,000 1,000 8,600 0.1%$44 $15.81 $0.06 Light Bulbs 750 350 350 350 350 350 350 350 750 750 750 550 6,000 0.1%$31 $11.03 $0.04 Paint/Decorating 100 100 100 100 1,000 100 100 100 8,000 8,000 8,000 100 25,800 0.4%$132 $47.43 $0.19 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Other Expense 0 0.0%$0 $0.00 $0.00 Uniforms 500 500 1,000 0.0%$5 $1.84 $0.01 Appliances 175 175 175 175 175 175 175 175 175 175 175 175 2,100 0.0%$11 $3.86 $0.02 Boilers 500 500 1,000 1,000 1,000 1,000 1,000 500 500 500 500 1,000 9,000 0.2%$46 $16.54 $0.07 Locks & Keys 100 100 100 100 100 100 100 100 100 100 100 100 1,200 0.0%$6 $2.21 $0.01 0 0.0%$0 $0.00 $0.00 Total Other Expenses 16,920 10,650 12,170 12,020 14,170 12,130 13,235 11,815 31,585 36,935 29,985 13,965 215,580 3.6%$1,100 $396.29 $1.62 0.0%$0 $0.00 $0.00 Total Rep/Maint. Expenses 40,103 33,833 35,353 40,854 37,353 35,313 36,418 34,998 54,768 65,769 53,168 37,148 505,078 8.5%$2,577 $928.45 $3.78 Operating Reserve 88,485 0 50,000 138,485 Total Operating Reserve 88,485 0 0 50,000 0 0 0 0 0 0 0 138,485 2.3%$707 $254.57 $1.04 Taxes/Insurance/Reserves TOTAL %Per Unit Per Bed PSF Repair & Replacement Reserves 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Operating Reserve 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Property Taxes 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Sales Tax 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Hotel Tax 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0%$0 $0.00 $0.00 Insurance 5,181 5,181 5,181 5,181 5,181 5,181 5,181 5,181 5,181 5,181 5,181 5,171 62,162 1.0%$317 $114.27 $0.47 Total Reserves, Taxes and Insurance 5,181 5,181 5,181 5,181 5,181 5,181 5,181 5,181 5,181 5,181 5,181 5,171 62,162 1.0%$317 $114.27 $0.47 Net Operating Income before Other Operating Expenses 181,027 170,765 225,584 281,285 255,355 263,662 273,632 266,977 276,898 -49,635 -42,890 312,808 2,415,468 40.6%$12,324 $4,440.20 $18.10 Other Expenses Bad Debt - Prior Year 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000 2.0%$612 $220.59 $0.90 Net Operating Income 171,027 160,765 215,584 271,285 245,355 253,662 263,632 256,977 266,898 -59,635 -52,890 302,808 2,295,468 38.6%$11,712 $4,219.61 $17.20 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Summary Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 TOTAL %Per Unit Per Bed PSF Total Revenue 544,660 540,870 540,060 542,660 543,020 542,520 541,670 544,570 548,804 257,810 233,160 572,060 5,951,867 100.0%$30,367 $10,940.93 $44.60 Total Expenses 363,633 370,105 314,476 261,375 287,666 278,859 268,038 277,593 271,906 307,446 276,050 259,251 3,536,398 59.4%$18,043 $6,500.73 $26.50 Net Operating Income 181,027 170,765 225,584 281,285 255,355 263,662 273,632 266,977 276,898 -49,635 -42,890 312,808 2,415,468 40.6%$12,324 $4,440.20 $18.10 TOTAL Repair & Replacement Reserve 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 113,400 1.9%$579 $208.46 $0.85 Less: Proposed Capital Update Lobby 50,000 50,000 0.8%$255 $91.91 $0.37 Update Cyber Lounge 50,000 50,000 0.8%$255 $91.91 $0.37 Deep Fryer for Kitchen 10,000 10,000 0.2%$51 $18.38 $0.07 Washer and Dryer Upgrades 60,000 60,000 1.0%$306 $110.29 $0.45 Resurface Benches in Café 0 0.0%$0 $0.00 $0.00 Carpet Replacement 7500 7,500 0.1%$38 $13.79 $0.06 Furniture 7500 7,500 0.1%$38 $13.79 $0.06 Redecorate Café 0 0.0%$0 $0.00 $0.00 0 0.0%$0 $0.00 $0.00 Total Capital Disubursements 170,000 - - - - - - - - - 0 15,000 185,000 3.1%$944 $340.07 $1.39 NET REPAIR/REPLACEMENT (160,550)9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 -5,550 -71,600 -1.2%-$365 -$131.62 -$0.54