Loading...
HomeMy WebLinkAbout2011-2012 Cambridge BudgetCAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Revenues Contract Revenues Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 TOTAL %Per Unit Per Bed PSF Potential Room Revenue 427,123 427,123 427,123 427,123 427,123 427,123 427,123 427,123 417,123 417,123 418,123 418,123 5,087,473 70.5%$25,956 $25,956.50 $38.12 Potential Food Revenue 177,069 177,069 177,069 177,069 177,069 177,069 177,069 177,069 177,069 177,069 177,069 177,069 2,124,831 29.5%$10,841 $10,840.97 $15.92 Total Potential Revenue 604,192 604,192 604,192 604,192 604,192 604,192 604,192 604,192 594,192 594,192 595,192 595,192 7,212,304 100.0%$36,797 $36,797.47 $54.04 Non-Rev/Vacancy Loss Room -19,829 -19,829 -19,829 -19,829 -19,829 -19,829 -19,829 -19,829 -19,829 -412,952 -412,952 -19,829 -1,024,196 -14.2%-$5,225 -$5,225.49 -$7.67 Non-Rev/Vacancy Loss Food -8,418 -8,418 -8,418 -8,418 -8,418 -8,418 -8,418 -8,418 -8,418 -175,299 -175,299 -8,418 -434,773 -6.0%-$2,218 -$2,218.23 -$3.26 Total Non-Rev/Vacancy Loss -28,247 -28,247 -28,247 -28,247 -28,247 -28,247 -28,247 -28,247 -28,247 -588,250 -588,250 -28,247 -1,458,969 -20.2%-$7,444 -$7,443.72 -$10.93 Budget Contract - Room 407,293 407,293 407,293 407,293 407,293 407,293 407,293 407,293 397,293 4,171 5,171 398,293 4,063,277 56.3%$20,731 $20,731.00 $30.45 Budget Contract - Food 168,652 168,652 168,652 168,652 168,652 168,652 168,652 168,652 168,652 1,771 1,771 168,652 1,690,058 23.4%$8,623 $8,622.74 $12.66 Concessions -8,000 -8,000 -8,000 -8,000 -8,000 -8,000 -8,000 -8,000 -8,000 -8,000 -80,000 TSHA Incremental Sch. (50)-18,500 -18,500 -18,500 -18,500 -18,500 -18,500 -18,500 -18,500 -18,500 -18,500 -185,000 -3.2%-$944 -$340.07 -$1.39 Payplan Charge/Discount -28,857 -28,857 -28,857 -28,857 -28,857 -28,857 -28,857 -28,857 -28,857 -29,149 -288,858 -4.0%-$1,474 -$1,473.77 -$2.16 Total Contract Revenue 520,589 520,589 520,589 520,589 520,589 520,589 520,589 520,589 510,589 5,942 6,942 511,296 5,199,477 72.1%$26,528 $26,527.94 $38.96 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 110,000 107,000 6,500 223,500 3.9%$1,140 $410.85 $1.67 Conference/Camp - Room 0 0 0 0 0 0 0 0 0 110,000 107,000 6,500 223,500 3.9%$1,140 $410.85 $1.67 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 1,000 2,000 3,000 5,000 7,000 7,000 0 0 0 25,000 0.4%$128 $45.96 $0.19 Accelertated Rent 0 0.0%$0 $0.00 $0.00 Cancellation Fess 0 0 0 2,500 1,500 500 0 0 0 1,000 6,500 12,000 0.2%$61 $22.06 $0.09 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 8,000 150 1,450 800 2,500 2,500 1,000 1,300 1,034 250 100 14,000 33,084 0.6%$169 $60.82 $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 14,740 7,100 7,590 10,040 12,350 12,350 12,250 14,150 19,384 226,700 217,550 40,600 594,804 10.3%$3,035 $1,093.39 $4.46 Total Revenue 535,329 527,689 528,179 530,629 532,939 532,939 532,839 534,739 529,973 232,642 224,492 551,896 5,794,281 100.0%$29,563 $10,651.25 $43.42 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Food Department Food Cost Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 TOTAL %Per Unit Per Bed PSF Beverages 5,022 5,080 4,312 2,902 2,910 4,899 4,122 5,012 2,435 3,625 3,625 2,903 46,847 0.8%$239 $86.12 $0.35 Baked Goods 2,292 2,318 2,054 1,338 1,322 2,236 1,837 2,283 1,116 1,667 1,667 1,339 21,469 0.4%$110 $39.47 $0.16 Dairy 5,925 4,775 4,617 2,212 2,783 3,774 3,084 4,317 2,513 2,778 2,778 2,214 41,770 0.7%$213 $76.78 $0.31 Milk 1,634 1,665 1,475 1,012 1,012 1,595 1,316 1,628 811 1,190 1,190 1,012 15,540 0.3%$79 $28.57 $0.12 Meats 15,748 15,040 15,012 9,326 10,024 15,784 13,078 15,784 8,887 12,247 12,247 10,124 153,301 2.6%$782 $281.80 $1.15 Frozen Goods 6,578 5,863 5,247 3,677 3,585 5,656 4,667 5,758 4,002 5,724 6,845 3,679 61,281 1.1%$313 $112.65 $0.46 Accompaniments 14,578 9,952 9,702 4,891 4,905 8,359 6,836 8,546 4,121 6,224 6,247 4,894 89,255 1.5%$455 $164.07 $0.67 Produce 3,707 3,749 3,890 2,265 2,271 3,617 2,990 3,692 1,825 2,691 2,691 2,266 35,654 0.6%$182 $65.54 $0.27 Total Food Cost 55,484 48,442 46,309 27,623 28,812 45,920 37,930 47,020 25,710 36,146 37,290 28,431 465,117 8.0%$2,373 $854.99 $3.49 Food Department Payroll Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 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.3%$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.8%$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.5%$2,510 $904.29 $3.69 Food Department Food Department Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 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,000 0 0 0 0 0 0 800 1,800 0.0%$9 $3.31 $0.01 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,000 0 0 0 1,000 0 0 0 0 500 0 1,000 3,500 0.1%$18 $6.43 $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 482 357 312 494 1,000 297 128 295 400 0 0 0 3,765 0.1%$19 $6.92 $0.03 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,492 4,217 3,972 3,059 6,815 3,757 3,438 3,755 3,665 3,910 3,910 5,365 52,355 0.9%$267 $96.24 $0.39 Total Food Expense 103,451 97,904 103,019 75,959 55,523 84,873 84,719 88,356 68,860 93,133 82,613 70,994 1,009,405 17.4%$5,150 $1,855.52 $7.56 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Gen & Admn Dept Payroll Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 TOTAL %Per Unit Per Bed PSF Salaries/Wages 13,385 13,385 13,385 20,077 13,385 13,385 13,385 13,385 13,385 20,077 13,385 13,385 174,000 3.0%$888 $319.85 $1.30 Benefits & Taxes 3,598 3,598 3,598 5,138 3,598 3,598 3,598 3,598 3,598 5,138 3,598 3,598 46,260 0.8%$236 $85.04 $0.35 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 16,983 16,983 23,983 25,215 16,983 16,983 16,983 16,983 16,983 25,215 16,983 16,983 227,260 3.9%$1,159 $417.76 $1.70 Management Fee Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 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.8%$1,433 $516.18 $2.10 Gen & Admn Dept Other Expense Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 TOTAL %Per Unit Per Bed PSF Equipment Lease 750 1,550 1,490 1,035 2,992 2,469 740 1,392 845 740 1,177 2,106 17,286 0.3%$88 $31.78 $0.13 Computer & Software Maint 150 150 150 150 150 1,750 150 150 150 150 150 150 3,400 0.1%$17 $6.25 $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 500 1,000 1,000 1,000 1,000 500 500 6,500 0.1%$33 $11.95 $0.05 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 400 400 400 500 500 500 400 5,100 0.1%$26 $9.38 $0.04 Telephone - Local 650 650 650 650 650 650 650 650 800 800 800 650 8,250 0.1%$42 $15.17 $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 150 150 150 150 150 150 150 150 150 150 150 150 1,800 0.0%$9 $3.31 $0.01 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.8%$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.8%$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.1%$612 $220.59 $0.90 Other G&A Expense 100,000 200 200 200 200 200 200 200 200 200 200 80,000 182,000 3.1%$929 $334.56 $1.36 Uniforms 1,500 2,500 4,000 0.1%$20 $7.35 $0.03 Bank Service Charges 2,100 1,500 1,300 1,100 1,700 1,500 1,100 1,200 1,000 950 550 1,400 15,400 0.3%$79 $28.31 $0.12 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 10,000 1,000 1,000 1,000 0 0 1,000 1,000 15,000 0.3%$77 $27.57 $0.11 Total Other Expense 149,895 39,795 40,085 44,280 49,937 42,514 39,285 40,037 41,990 32,384 32,921 116,350 669,470 11.6%$3,416 $1,230.64 $5.02 0.0%$0 $0.00 $0.00 Total G&A Expenses 166,878 56,778 64,068 69,494 66,920 59,497 56,268 57,020 58,973 57,599 49,904 133,333 896,730 15.5%$4,575 $1,648.40 $6.72 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Marketing Dept Other Expense Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 TOTAL %Per Unit Per Bed PSF Outdoor Advertising 0 0.0%$0 $0.00 $0.00 Direct Mail 3,000 4,000 5,000 8,000 5,000 25,000 0.4%$128 $45.96 $0.19 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,300 3,300 0.1%$17 $6.07 $0.02 Brochures 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 250 250 250 250 250 1,250 0.0%$6 $2.30 $0.01 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,000 200 200 300 300 300 300 12,600 0.2%$64 $23.16 $0.09 Total Marketing Expenses 14,150 1,550 17,750 2,350 6,550 16,900 8,650 11,850 6,850 800 800 800 89,000 1.5%$454 $163.60 $0.67 Residence Life & Student Development Other Expense Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 TOTAL %Per Unit Per Bed PSF Res. Life & Dev.2,100 2,100 2,100 1,000 3,600 2,300 1,700 1,650 1,600 1,900 20,050 0.3%$102 $36.86 $0.15 Total Res. Life 2,100 2,100 2,100 1,000 3,600 2,300 1,700 1,650 1,600 1,900 20,050 0.3%$102 $36.86 $0.15 Telecom Expenses Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 TOTAL %Per Unit Per Bed PSF 0.0%$0 $0.00 $0.00 Telecom 500 500 500 500 500 500 500 500 500 500 500 500 6,000 0.1%$31 $11.03 $0.04 Residential Long Distance 0 0.0%$0 $0.00 $0.00 Data 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.1%$612 $220.59 $0.90 Cable TV 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.1%$612 $220.59 $0.90 Total Telecom Expense 20,500 20,500 20,500 20,500 20,500 20,500 20,500 20,500 20,500 20,500 20,500 20,500 246,000 4.2%$1,255 $452.21 $1.84 Utilities/Energy Expenses Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 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.3%$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)5,033 4,365 4,698 3,703 2,249 3,713 4,061 3,907 3,538 3,036 5,238 5,255 48,796 0.8%$249 $89.70 $0.37 Sewer 3,675 3,375 3,475 3,675 2,975 3,675 3,375 3,175 3,345 3,175 3,275 3,175 40,370 0.7%$206 $74.21 $0.30 Water 3,657 3,938 3,900 3,300 2,700 3,500 2,899 3,600 2,584 2,671 2,500 2,390 37,639 0.6%$192 $69.19 $0.28 Total Utility Expense 53,502 47,681 50,163 29,180 25,467 36,528 33,788 38,799 40,069 47,191 47,842 51,838 502,048 8.7%$2,561 $922.88 $3.76 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Rep/Maint Dept Payroll Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 TOTAL %Per Unit Per Bed PSF Salaries/Wages 8,500 8,500 8,500 12,750 8,500 8,500 8,500 8,500 8,500 12,750 8,500 8,500 110,500 1.9%$564 $203.13 $0.83 Benefits & Taxes 2,735 2,735 2,735 3,712 2,735 2,735 2,735 2,735 2,735 3,712 2,735 2,735 34,775 0.6%$177 $63.92 $0.26 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 11,235 11,235 11,235 16,462 11,235 11,235 11,235 11,235 11,235 16,462 11,235 11,235 145,275 2.5%$741 $267.05 $1.09 Housekeepers Payroll Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 TOTAL %Per Unit Per Bed PSF Salaries/Wages 646 646 646 969 646 646 646 646 646 969 646 646 8,400 0.1%$43 $15.44 $0.06 Benefits & Taxes 149 149 149 223 149 149 149 149 149 223 149 149 1,932 0.0%$10 $3.55 $0.01 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.3%$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 11,895 11,895 11,895 12,292 11,895 11,895 11,895 11,895 11,895 12,292 11,895 11,895 143,532 2.5%$732 $263.85 $1.08 Rep/Maint Dept Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 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,500 1,000 800 800 800 1,000 1,000 1,000 1,500 1,500 1,500 1,500 13,900 0.2%$71 $25.55 $0.10 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 1,000 500 1,000 500 1,000 500 1,000 500 1,000 500 1,000 1,000 9,500 0.2%$48 $17.46 $0.07 Grounds/Landscaping 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000 0.4%$122 $44.12 $0.18 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 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget 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 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 2,000 2,000 2,000 2,000 8,000 0.1%$41 $14.71 $0.06 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 19,020 10,450 11,970 13,320 13,970 10,320 12,920 13,500 31,770 36,620 32,170 13,050 219,080 3.8%$1,118 $402.72 $1.64 0.0%$0 $0.00 $0.00 Total Rep/Maint. Expenses 42,150 33,580 35,100 42,075 37,100 33,450 36,050 36,630 54,900 65,375 55,300 36,180 507,887 8.8%$2,591 $933.62 $3.81 Operating Reserve 88,485 0 0 50,000 138,485 Total Operating Reserve 88,485 0 0 0 50,000 0 0 0 0 0 0 0 138,485 2.4%$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 3,949 3,949 3,949 3,949 3,949 3,949 3,949 3,949 3,949 3,949 3,949 3,949 47,385 0.8%$242 $87.10 $0.36 Total Reserves, Taxes and Insurance 3,949 3,949 3,949 3,949 3,949 3,949 3,949 3,949 3,949 3,949 3,949 3,949 47,385 0.8%$242 $87.10 $0.36 Net Operating Income before Other Operating Expenses 16,764 240,247 208,130 262,722 239,931 251,543 263,815 252,585 250,873 -79,305 -59,816 209,002 2,056,491 35.5%$10,492 $3,780.31 $15.41 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.1%$612 $220.59 $0.90 Net Operating Income 6,764 230,247 198,130 252,722 229,931 241,543 253,815 242,585 240,873 -89,305 -69,816 199,002 1,936,491 33.4%$9,880 $3,559.73 $14.51 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Summary Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 TOTAL %Per Unit Per Bed PSF Total Revenue 535,329 527,689 528,179 530,629 532,939 532,939 532,839 534,739 529,973 232,642 224,492 551,896 5,794,281 100.0%$29,563 $10,651.25 $43.42 Total Expenses 518,564 287,441 320,049 267,907 293,008 281,396 269,023 282,153 279,100 311,947 284,308 342,894 3,737,790 64.5%$19,070 $6,870.94 $28.01 Net Operating Income 16,764 240,247 208,130 262,722 239,931 251,543 263,815 252,585 250,873 -79,305 -59,816 209,002 2,056,491 35.5%$10,492 $3,780.31 $15.41 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 2.0%$579 $208.46 $0.85 Less: Proposed Capital Electronic door locks 73,500 73,500 1.3%$375 $135.11 $0.55 Updating lobby décor and furniture 15,000 15,000 0.3%$77 $27.57 $0.11 Updating café décor 1,000 1,000 0.0%$5 $1.84 $0.01 New computer for the computer lab 16,000 16,000 0.3%$82 $29.41 $0.12 Resurafce pool 10,000 10,000 0.2%$51 $18.38 $0.07 Carpet Replacement 10,000 10,000 0.2%$51 $18.38 $0.07 Furniture 7500 7,500 0.1%$38 $13.79 $0.06 Pool Furniture 40,000 Couch and Sofa Chair 30,000 30,000 0.5%$153 $55.15 $0.22 Total Capital Disubursements 195,500 - - - - - - - - - 0 7,500 203,000 3.5%$1,036 $373.16 $1.52 NET REPAIR/REPLACEMENT (186,050)9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 1,950 -89,600 -1.5%-$457 -$164.71 -$0.67