Loading...
2008-2009 Cambridge BudgetCAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget - -- Contract Revenues Sep -08 Oc11-08 Nov-08 Dec -08 Jan -09 Feb -09 Mar -09 Apr -09 May-09 Jun -09 Jul -09 Aug -09 TOTAL % Per Unit Per Bed PSF Potential Room Revenue Potential Food Revenue 415,522 163,655 390,522 163,655 390,522 163,655 390.522 163,655 400,522 163,655 390,522 163,655 390,522 163,655 390,522 163,655 385,522 163.655 390.522 163,655 365.522 163,655 405,522 163,655 4,726,267 1,963,857 70.6% 29A% $24,114 $10,020 $24,113.61 $10,019.68 $3541 $14.72 Total Potential Revenue 579,177 554,177 554,177 $54,177 564,177 554,177 554,177 554,177 549,177 554,177 549,177 569,177 6,690,124 100.0% $34,133 $34,133.29 $50.13 Non - RevNacancy Loss Room - 17,732 - 17,732 - 17,732 - 17,732 - 17,732 - 17,732 - 17,732 - 17,732 - 17,732 - 373,957 - 373,957 - 17,732 - 925,237 -13.8% - $4,721 - $4.720.60 -$6.93 Non - RevNacancy Loss Food -7,527 -7,527 -7.527 -7,527 -7.527 -7,527 -7,527 -7,527 -7.527 - 158,745 - 158,745 -7 527 - 392,764 -5.9% - $2,004 - $2,003.90 42.94_._ Total Non - RevNacancy Loss - 25,260 - 25,260 - 25,260 - 25,260 - 25,260 - 25,260 - 25,260 - 25,260 - 25,260 - 532,702 - 532,702 - 25,260 - 1,318,001 •19.7% - $6,724 - $6,724,50 -$9.88 Budget Contract - Room 397,790 372,790 372,790 372,790 382,790 372,790 372,790 372.790 367,790 16,566 11,566 387,790 3,801,030 56.8% $19,393 $19,393.01 $28.48 Budget Contract - Food 155,127 156,127 156,127 156,127 156,127 156,127 156,127 156,127 156,127 4,910 4,910 156,127 1,571,093 23,5% $8,016 $8,015.78 $1117 TSHA Incremental Sch. (20) -4,495 -4,495 -4495 -4,495 -4,495 -4,495 -4,495 4,495 •4,495 0 0 - 4,495 - 44,950 -0.8% 4229 - $82.63 -$0.34 Payplan Charge/Discount - 16,138 •16,138 - 16,138 - 16,136 - 16,138 - 16,138 - 16,136 - 16,138 - 16,138 -6,800 _ _ -6,800 _ _ •44,831 •203,676 _ _ -3.0 %. •$1,039 _ - $1.039.16 -$1.53 Total Contract Revenue 533,284 508,264 508,284 508,284 518,284 508,284 508,284 506,284 503,284 14,675 9,675 494,591 5,123,497 76.6% $26,140 $26,140.29 $38.39 Parking Lot - Contract 1,167 1,167 1,167 1,167 1,167 1,167 1,167 1,167 1,167 0 0 0 10,503 0.2% $54 $19.31 $0.08 ConferencelCamp - Food 0 0 0 0 0 0 0 0 5,500 100,000 100,000 0 205,500 3.6% $1,048 $377.76 $1.54 ConferencelCamp - Room 0 0 0 0 0 0 0 0 5,500 100,000 100,000 0 205,500 3.6% $1,048 $377.76 $1.54 Damages Recovered 3,000 1,000 2,000 6,000 0.1% $31 $11.03 $0.04 Apartments 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $O.00 Residential Long Distance 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $000 $0,00 Telecom Fee 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 MOO Retail Rental 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 Outside Board Contracts 309 309 309 309 309 309 309 309 309 0 0 0 2,781 0.0% $14 $5 11 $0.02 Cash Food Sales 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 1,648 1,648 1,648 26,544 0.5% $135 $48.79. $0.20 Vending Commissions 350 350 350 350 350 350 350 350 350 220 220 220 3.810 0.1% $19 $7.00 $0.03 Wash Mach Commissions 2,122 2,122 2,122 2.122 2,122 2.122 2,122 2.122 2,122 8R3 883 883 21,746 0.4% $111 $39.97 $0.16 Telephone Commissions 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 Interest Income 6,437 6,437 6,437 6,437 6,437 6,437 6,437 6,437 6,437 3,863 3,863 3,863 69,522 1.2% $355 $127.80 $0.52 Catering 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 Returned Check/Late Fees 343 343 343 343 343 343 343 343 343 206 206 206 3.705 0,11% $19 $6,81 $0.03 Banquets 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 Other - Food 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 GuesVTransient Income 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 Retained Fees 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 Processing Fees 0 0 0 0 5,180 5,180 5,180 5,180 5,180 5,180 5,180 0 36,260 0.6% $185 $66.65 $0.27 Transaction Fee 1,500 300 300 300 300 300 300 200 400 3,000 1,500 400 8,800 0.2% $45 $16 18 $0.07 0.0% $0 $000 $0.00 Total Other Revenue 17,628 13,428 13,428 13,428 18,608 18,608 18,608 18,508 29,708 214,999 214,499 9,219 600,671 10.5% $3,065 $1,104.17 $450 Total Revenue 550,912 521,712 521,712 521,712 536,892 526,692 526,892 526,792 532,992 219,675 224,175 503,811 5,724,168 100.0% $29,205 $10,522.37 $42.89 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Food Department Food Cost Sep -07 Oct -07 Nov -07 Dec -07 Jan -08 Feb -08 Mar -08_ _ _Apr -08_ May -08. Jun -08_ Jul -06 _ _ Aug -08 TOTAL % Per Unit Per Bed PSF Beverages 4,341 4,393 3,890 2,432 2.439 4.230 3,441 4,322 2,012 3,083 3,083 2,434 40.100 0.7% $205 $73.71 $0.30 Baked Goods 2,128 2,154 1,907 1,192 1.196 2,074 1,687 2,119 986 1,511 1,511 1.193 19,657 0.3% $100 $36.13 $0.15 Dairy 3,617 3,661 3,241 2,027 2,033 3,525 2,867 3,602 1,677 2,569 2,569 2.028 33,417 0.6% $170 $61 A3 $0.25 Milk 1,489 1,508 1,335 835 637 1.452 1181 1,483 690 1,058 1,058 835 13,760 0.2% $70 $25.29 $0.10 Meats 15,107 15,291 13,538 8,465 8,490 14,723 11,975 15,042 7,002 10,731 10,731 8,471 139,565 2.4% $712 $256.55 $1.05 Frozen Goods 4.596 4,652 4,119 2,575 2,563 4,479 3,643 4,576 2,130 3.265 3,265 2,577 42,459 0.7% $217 $78.05 $0.32 Accompaniments 7,873 7,969 7,055 4,411 4,424 7,673 6.240 7,839 3,649 5,592 5,592 4,414 72,731 1.3% $371 $133.70 $0.54 Produce 3,404 3,446 3,051 1,908 1,913 3,318 2,699 3,390 1,578 2,418 2,418 1,909 31,451 0.5% $160 $57.81 $0.24 Total Food Cost 42.555 43,073 38,135 23,845 23.915 41,473 33.732 42,372 19,725 30,227 30,227 23,861 393,140 6.9% $2,006 $722.68 $2.95 Food Department Payroll Sep -07 Oct -07 Nov -07 Dec -07 Jan -08 Feb -08 Mar -o8 Apr -08 May -08 Jun -08 Jul -08 Aug -08 TOTAL % Per Unit Per Bed PSF SalariesrWages 30,758 43,622 28,841 25,071 10,619 26,520 31,373 22.889 36,041 29,678 29,909 28,343 343,664 6.0% $1.753 $631.74 $2.58 Benefits 8 Taxes 8,869 11,533 8,133 7,881 4,557 7,600 8,716 6,764 9,789 8,633 8,686 8.019 99,180 1.7% $506 $182.32 $014 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 4,210 0 0 3,500 0 876 0 0 0 8,586 0.11"e $44 $15.78 $0.06 Holiday Pay 1,280 0 0 2.671 2,671 0 0 0 0 1,336 1,336 0 9,294 0.2% $47 $17.08 $0.07 Sick Pay 0 0 496 424 440 472 424 410 1,744 119 440 0 4,969 0,1% $25 $9.13 $0.04 Bonus 0 0 6,000 0 0 0 0 0 0 0 0 0 6,000 0.1% $31 $1103 $0.04 Contract Labor 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $OAO Total Payroll 40,907 55,155 43,470 40,257 18,287 34,592 44,013 30,063 48,450 39,766 40,371 36,362 471,693 8.2% $2,407 $867.08 $153 Food Department Food Department Sep -07 Oct -07 Nov -07 Dec -07 Jan -08 Feb -08 Mar -08 Apr -08 May -08 Jun -08 Jul -08 Aug -08 TOTAL % Per Unit Per Bed PSF Pest Control 85 85 85 85 65 85 B5 85 85 85 85 85 1,020 0.0% $5 $1,88 $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 150 150 150 100 100 150 150 150 150 150 150 340 1,890 0.0% $10 $347 $0.01 Decorations 100 100 100 100 0 100 0 0 0 0 100 100 700 0.0% $4 $1,29 $0.01 Kitchen Supplies 600 400 400 100 600 400 300 400 100 400 400 400 4,500 0.1% $23 $8.27 $0.03 China /Glass /Silver 0 0 0 0 1,000 0 0 0 0 500 0 1,000 2,500 0.0% $13 $4.60 $0.02 Cleaning Supplies 850 800 600 800 535 600 800 800 800 650 650 900 9,185 01% $47 $16.88 $0.07 Contract Cleaning 0 0 0 0 1,000 0 0 0 400 0 0 0 1,400 0.0% $7 $2.57 $0.01 Paper 500 500 500 250 250 500 500 500 350 500 500 350 5,200 0.1% $27 $9.56 $004 Equipment Rental 700 750 750 500 300 750 650 750 650 600 600 600 7,600 0.1% $39 $13.97 $0.06 Other Expense 200 200 200 200 1,000 200 200 200 200 2DO 1,000 200 4,000 0.1% $20 $7.35 $0.03 Total Other Expense 3.535 3,335 3,335 2,390 6,040 3,335 3,035 3,235 2,990 3,435 3,835 5.030 43,530 0.8% $222 $8002 $033 Total Food Expense 86,997 101,563 84,940 66,492 48,242 79,400 80,780 75,670 71,165 73,428 74,433 65,253 906,363 15.9% $4,635 $1,669.79 $681 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Gen & Admn Dept - - _- Payroll Sep -07 Oct -07 Nov -07 Dec -07 Jan -08 Feb -08 Mar48 Apr -08 May -08 Jun -08 Jul -08 Aug -08 TOTAL °1 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,9% $1,433 $516.18 $2.10 SalariesANages 12,745 12,745 21,745 19,118 12,745 12,745 12,745 12,745 12,745 19,118 12,745 12,745 174,690 3.1% $891 S321. 12 $1.31 Benefits & Taxes 3.451 3,451 3,451 4,917 3,451 3.451 3,451 3,451 3,451 4,917 3,451 3.451 44,349 0.8% $226 $81 52 $0.33 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% SO $0.00 $0.00 Holiday Pay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $000 Bonus 0 0 7,000 0 0 0 0 0 0 0 0 0 7,000 0.1% $36 512.87 $0.05 otal Payroll 16,197 16,197 32,197 24,035 16,197 16,197 16,197 16,197 16,197 24,035 16,197 16.197 226,039 3.9% $1,153 $41551 $1.69 Management Fee Sep -07 Oct -07 Nov -07 Dec -07 Jan -08 Feb -08 Mar -08 Apr -08 May -08 Jun -08 Jul -O8 Aug -08 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,9% $1,433 $516.18 $2.10 Gen & Admn Dept Other Expense Sep -07 Oct -07 Nov07 Dec -07 Jan -08 Feb -08 Mar -08 Apr -08 May-08 Jun•08 Jul -08 Aug -08 TOTAL % Per Unit Per Bed PSF Equipment Lease 875 875 875 2,000 875 875 2.000 875 875 1,500 875 875 13,375 0.2% $68 $24,59 $0.10 Computer & Software Maint 55 55 55 55 55 55 55 55 55 55 55 55 660 0.0% $3 Si 21 $0.00 Legal 8,333 8,333 8,333 8,333 8.333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 99,996 1.7% $510 $183.82 $015 Audit 500 500 500 500 9,500 500 Soo 500 500 500 500 500 15,000 0.3% $77 $27.57 $0.11 Other Professional Expense 7,500 7,500 110 110 110 110 110 110 110 110 110 110 16,100 0.3% $82 $29.60 $0.12 Taxes, Licenses & Fees 218 218 218 218 218 218 218 218 218 218 218 218 2,614 0.0% $13 $4.81 $0.02 Sales Tax 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $000 $0.00 Hotel Tax Expense 0 0 0 0 0 0 0 0 0 0 0 Property Insurance 0 0 0 Telephone. Ld 800 800 800 0 600 0 800 0 800 0 800 0 800 0 800 0 0 0 0 0.0% so $0.00 $0.00 Telephone - Local 550 550 550 550 550 550 800 800 800 9,600 0.2% $49 $17.65 $0.07 Office Supplies 550 550 550 550 550 550 6,600 0.1% $34 $12.13 $0.05 800 800 800 600 800 800 800 800 800 800 800 800 9,600 0.2% S49 $17.65 $0.07 Postage 150 150 1,500 1,000 600 1,200 1,200 1,200 700 500 1,000 300 9,500 0.2% $48 $17.46 $0.07 Dues /Subscriptions 150 150 150 150 150 150 150 150 150 150 150 150 1,800 0.0% S9 $3,31 $0.01 Travel -Local Supervision 50 50 50 50 50 50 50 50 50 50 5o 50 600 0,0% $3 $1.10 $0.00 TSHA Admm 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,064 1.8% $521 $187.65 $0.76 Legal Fees 50,000 0 0 0 50,000 0 0 0 0 0 Recruiting Expense 80 80 80 80 0 0 100,000 1.7% $510 S 183 82 $0.75 Training Expense 80 80 80 80 80 80 80 80 960 0.0% $5 $1.76 $0.01 Security Service 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% SO $0.00 $0.00 Collection Expense 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $000 $0.00 Bad Debt Expense 695 0 719 0 574 0 0 0 0 0 0 0 0 0 0 0.0% $0 50.00 $000 Other G&A Expense 380 467 575 445 619 283 84 66 333 5,239 0.1% $27 $9.63 $0.04 Trustee Fee 185,000 200 200 200 200 200 200 200 200 200 200 200 187,200 3.3% $955 $344.12 $1.40 Bank Service Charges 655 655 655 655 655 655 655 655 655 655 655 655 7,060 0.1% $40 514.45 $0.06 Courtesy Officer 75 75 75 75 75 75 75 75 75 75 11,000 75 11,825 0,2% $60 $21.74 $0.09 Credit Card Fees 4,650 4,650 4,650 4,650 4,650 4,650 4,650 4,650 4,650 4,650 4,650 4,650 55,800 1,0% $285 $102,57 $OA2 Rent Refunds /Prepaid$ 2,600 634 1,167 2.399 2,155 2.332 2.231 845 694 634 8,570 934 25,195 0.4% $129 $46.31 $0.19 Total Other Expense 25.000 280,724 0 18,982 20,720 10,000 80,702 5,000 20,000 60,000 1.0% $306 $110.29 $0.45 .21,258 21,587 21,356 20,143 19,157 16,647 30,990 31,996 584,263 10.2% $2,981 $1,07401 $438 Total G &A Expenses 296,921 35,179 52,917 45,294 96,898 37.784 37.553 36.340 0.0% $0 $0.00 $0.00 35,354 40,682 47,187 48,193 810,301 14.2% $4,134 $1,489.52 $6.07 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Marketing Dept Other Expense Sep -07 Oct-07 Nov -07 Dec -07 Jan -08 Feb -08 Mar -08 Apr -08 May -08 Jun -08 Jul -08 Aug -08 TOTAL % Per Unit Per Bed PSF Outdoor Advertising 200 200 200 200 300 300 300 300 2,000 0.0% $10 $3.68 $0.01 Direct Mail Expenses 5,000 5,000 Nov-07 5,000 5,000 5.000 Mar -08 Apr -08 25,000 0.4% $128 $45.96 $0.19 NeirslMagazines 350 350 350 350 1,375 1,375 1,375 1,550 350 0 0 0 7,425 0.1% $38 $13.65 $0.06 Radio/Tv Advertising 57,600 0.0% 1.0% $0 $0.00 $0.00 2,000 500 2,000 0 0 4,500 0.1% $23 $827 $0.03 Brochures 18,000 3.3% $294 $105.88 $043 Data 0 18,000 0.3% $92 $33.09 $0.13 Promotion - External 0 0 1,350 0 0 5,000 100 $0.00 $0.00 Fuel (Gas) 6,450 0.1% $33 $11.86 $0.05 Lease Comm. - Residential 5,750 5,750 5,750 250 250 250 250 250 $352 $126.84 1,250 0.0% $6 $2.30 $0.01 Web Adv/Presence 2,598 833 833 833 833 833 833 833 833 833 833 833 11,761 0,2% $60 $21.62 $0.09 Other Expense 6,000 200 3,200 300 300 300 300 300 300 300 11,500 0.2% $59 $21 14 $0.09 Total Marketing Expenses 9,148 1,583 28,933 6,933 3.058 15,058 8,658 10,233 1,483 1,133 833 833 87,886 1,5% $448 $151.56 $0.66 Residence Life & Student Development $0.24 Other Expense Sep -07 00-07 Nov -07 Dec -07 Jan -08 Feb -08 Mar -08 Apr -08 -May-all Jun -08 Jul -08 Aug -00 TOTAL % Per Unit Per Bed PSF Res. Life & Dev. 2,708 2,270 2,807 1,235 3,604 1,807 1,807 2,307 1,320 520 520 1,520 22,425 0A% $114 $41.22 $0.17 Total Res. Life 2.708 2,270 2,807 1,235 3,604 1,807 1,807 2,307 1,320 1,320 520 1,520 23,225 0A 11e $118 $42.69 $0.17 Telecom Expenses Sep•07 Oct -07 Nov-07 Dec-07 Jan -08 Feb -08 Mar -08 Apr -08 May-Go Jun -08 Jul -08 Aug-08 TOTAL % Per Unit Per Bed PSF Telecom 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 57,600 0.0% 1.0% $0 $0.00 $0.00 Residential Lang Distance 0 0 0 0 7,456 7,856 9,324 9,721 189,748 3.3% $294 $105.88 $043 Data 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 Fuel (Gas) 5,750 5,750 5,750 5,750 5,750 5,750 5,750 5,750 5,750 5,750 5,750 5,750 69,000 1.2% $352 $126.84 $0.52 Cable TV 9,986 9,986 9,966 9,986 9,986 9,986 9,986 9,986 9,986 9,986 9,986 9,986 119,832 2.1% $611 $220.28 $0.90 20,536 20,536 20,536 20,536 20,536 20,536 20,536 20,536 20,536 20,536 20,536 20,536 246,432 4,3% $1,257 $45100 $1.65 Utilities /Energy Expenses Sep•07 Oct•07 Nov -07 Dec -07 Jan -08 Feb -08 Mar-Q8 Apr -08 May-08 Jun -08 Jul -08 Aug-08 TOTAL % Per Unit Per Bed PSF Electric •Public 22,345 25,345 16.012 13,390 10,087 14,784 13,157 17,390 15.478 11,793 15,178 14,789 0.0% $0 $0,00 $0,00 Electric - Residential 9,679 9,679 6,990 8,112 7,456 7,856 9,324 9,721 189,748 3.3% $968 $348.80 $1.42 Electric - Resident Payments 0 9,720 12,749 10,094 10,888 112,267 2.0% $573 $206.37 $0.84 Fuel (Gas) 9.890 0 13.112 0 12,130 0 10.225 0 5.799 0- 5,517 0 7,707 0 7,706 0 5,614 0 5,256 0 5,288 0 0 0.0% $0 SO.00 $0.00 Sewer 2.975 2.975 2.975 2.975 2,975 2,975 2,975 2.975 5,195 93,439 1.6% $477 $171,76 $0.70 Water 2,975 2,975 2,975 2,975 35,700 0.6% $182 $65.63 $0.27 3,157 3,292 3,000 2,400 2,190 2,839 2.499 3,412 2,284 2,371 2,206 2,190 31,940 0.6% $162 $58.53 $0.24 Total Utility Expense 48.046 54,403 41,107 37,102 28,507 33.971 35,662 41,204 36,071 35,144 35,741 36,037 462,994 8.1% $2.362 $851.09 $3.47 CAMBRIDGE @ COLLEGE STATION, TEXAS 10,383 10,383 10,363 15,185 10,383 10,383 10,383 10,383 10,383 15,185 10,383 10,383 134,205 2.3% Operating Budget $24610 $1.01 Housekeepers Payroll Rep /Mamt Dept Payroll Sep -07 pct -07 Nov -07 Oec -07 Jan -08 Feb•08 Mar -08 Apr -08 Payroll Sep -07 Oct -07 Nov -07 Dec -07 Jan -OB Feb -08 Mar -08 Apr-08 May -08 Jun 08 Jul 08 Aug 08 TOTAL / Per Unit Per Bed PSF 7,385 7,385 7,3 &5 7,385 11,077 7,385 7,385 96,000 1.7% 5490 $176.47 $0.72 Employee Meals 2,998 2,998 Salaries/Wages 7,808 7.808 Benefits 8 Taxes 2,576 2.576 Employee Meals 0 0 Vacation Pay 0 0 Holiday Pay 0 0 Sick Pay 0 0 Other Benefits 0 0 7.808 2,576 0 0 0 0 0 11,712 3,474 0 0 0 0 0 7.808 2,576 0 0 0 0 0 7,808 2.576 0 0 0 0 0 7,808 2,576 0 0 0 0 0 7,808 2.576 0 0 0 0 0 7,808 2,576 0 0 0 0 0 11,712 3,474 0 0 0 0 0 7,808 2,576 0 0 0 0 0 7,808 101,500 2.576 32,705 0 0 0 0 0 0 0 0 0 0 1.8% 0.6% 0.0% 0.0% 0.0% 0.0% 0.0% $518 $167 $0 $0 $0 $0 $0 $186.56 $60.12 $0.00 $0.00 $0,00 $0.00 $0.00 $0.76 $0.25 $0.00 $0.00 $0,00 $0.00 $0.00 Ot°��ayfVO 10,383 10,383 10,363 15,185 10,383 10,383 10,383 10,383 10,383 15,185 10,383 10,383 134,205 2.3% $685 $24610 $1.01 Housekeepers Payroll Payroll Sep -07 pct -07 Nov -07 Oec -07 Jan -08 Feb•08 Mar -08 Apr -08 May -08 Jun -08 Jul -08 Aug -08 TOTAL % Per Unit Per Bed PSF Salaries/Wages Benefits 8 Taxes 7,385 7,385 7.385 11,077 7,385 7,385 7,385 7,3 &5 7,385 11,077 7,385 7,385 96,000 1.7% 5490 $176.47 $0.72 Employee Meals 2,998 2,998 2,998 3,848 2,998 2,998 2,998 2,998 2,998 3,848 2.998 2,998 37,680 0,7% $192 $6926 $0.28 Vacation Pay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $000 $0.00 Holiday Pay 0 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.00 $0.00 Other Benefits 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0,00 $0.00 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 Total Payroll 10,383 10,383 10,383 14,925 10,383 10,383 10,383 10,383 10,383 14,925 10,383 10.383 133,680 2.3% $682 $245.74 $1 00 ReplMaint Dept Other Expenses Sep -07 Oct -07 Nov -07 Dec -07 Jan -08 Feb -08 Mar -08 Apr -08 May-08 Jun -08 Jul -08 Aug -08 TOTAL % Per Unit Per Bed PSF Waste Removal 825 825 825 825 825 825 0.D% s0 s0.00 $000 Rooms Supplies 500 825 825 825 825 825 825 9,900 0.2% S51 $18.20 $0.07 Cleaning Supplies 100 100 100 900 100 100 100 1,300 1,300 1.300 700 6,600 0.1% $34 51213 $0.05 Contract Cleaning 900 650 1,100 1,100 1,100 450 1,100 650 2,650 2.650 2.650 900 15,900 0.3% $81 $29.23 $0.11 Equipment Rental 0 0 0 0 1,000 0 0 0 9,400 5,000 5,000 0 20,400 0.4% $104 $37.50 $0.15 Pest Control 0 424 0 424 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0 00 $0,00 Other Expense 424 424 424 424 424 424 424 424 424 424 5,088 0.1% $26 $9.35 $0.04 Buildings Maintenance 42 1,100 42 350 42 42 42 42 42 42 42 42 42 42 504 0.0% $3 $0.93 $0.00 Food Service Equip Repair 700 350 350 350 350 350 350 1,000 1,000 1,000 200 6,750 0,1.1 % $34 $12.4 $0.05 Drrve/Park Lot Maint, .700 700 700 700 700 700 700 700 700 700 700 8,400 0 % $43 $15.44 4 $006 Elevator Maintenance 100 100 100 100 100 100 100 100 100 4,500 100 100 5,600 0.9% $29 $10.29 $0.04 Laundry Equip, Maint. 1,800 630 800 1,800 800 800 1,800 630 800 1,130 800 630 12,420 0.2% $63 S22.83 $0.09 Hvac Maintenance 70 575 70 70 70 70 70 70 70 70 70 70 70 836 0.0% $4 $1 54 $0.01 Carpet/Drapery Cleaning 575 575 575 575 575 57.5 575 575 575 575 575 6,900 0.1% $35 $12.68 $005 Water Treatment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $000 $000 Grounds/Landscaping 2,000 0 2,000 0 2,000 0 2,000 0 2.000 0 0 0 0 0 0 0 0 0.0% $0 S000 $0,00 Swimming Pool 250 250 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000 0.4% $122 $44.12 $0.18 Furniture Repair p 0 250 250 250 250 250 250 250 250 250 250 3,000 0.1% $15 $557 $0.01 Maint. Equip, Repair 112 0 112 0 112 0 112 0 0 0 0 2,500 2,500 1,500 0 6,500 0.1 % $33 $11 95 $0.05 Fire Equipment Repair 220 220 220 220 112 112 112 112 112 112 112 112 1,345 0.0 % $7 $2.47 $001 Carpet RepI,IRepair 220 220 220 220 220 220 220 220 2,640 0,0 % $13 $485 $0.02 Rec. Equip. Repair 0 87 0 0 0 500 0 0 0 5.000 3,000 5,000 500 94,000 0.2% 577 $25.74 50.10 Maintenance Supplies 1,000 87 87 87 1,000 87 87 87 1,000 87 87 87 2,872 0.1% S15 $528 $0.02 Light Bulbs 800 800 Boo Boo 800 800 800 1,500 1,500 1,500 900 12,000 0.2% S61 522.06 $0.09 Paint/Decorating 209 209 209 209 209 209 209 209 209 209 209 209 2,509 0.0% $13 $461 $002 0 0 0 0 500 0 0 1,000 2500 2,500 5,000 0 11,500 0.2% $59 $2114 $0.09 CAMBRIDGE @ COLLEGE STATION, TEXAS Operating Budget Pest Control 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% so S000 $000 Other Expense 292 292 292 292 292 292 292 292 292 292 292 292 3,500 01% $18 $6.43 $0.03 Uniforms 50 50 50 50 50 50 50 50 50 50 50 50 600 0.0% $3 $1.10 $0.00 Appliences 25 25 25 25 25 25 25 25 25 25 25 25 300 0.0% $2 $0.55 $0.00 Fences 8 Gates 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $000 Locks 8 Keys 75 75 75 75 75 75 75 75 75 75 75 75 900 0.0% S5 $1.65 $0.01 Repair 8 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 0 0.0% $0 $0.00 $0.00 Total Other Expenses 11,356 8,586 9,206 10,206 12,919 8,556 10,206 9,586 33,619 31,036 29.806 9,886 184,964 3.2% $944 $340.01 $1.39 Exterior Painting Carpet Repairs Exercise Equiptment 0 3.000 20,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 120,000 0 120,000 3,000 0.0% s0 $0.00 $0.00 Total ReplMaint. Expenses 32.122 29,352 29,972 40,315 33,685 29,322 30,972 30,352 54,385 61,145 50,572 30,652 452,849 7.9% $2.310 $832.44 $3.39 Operating Reserve 88,485 0 0 50,000 22,000 0.4% $112 $40.44 $0.16 Total Operating Reserve 88,485 0 0 0 54000 0 0 138,485 0.2% s51 $18.38 50.07 Lobby Renovations 0 0 0 0 0 0 0 0 138,485 2.4% $707 $254.57 $1.04 Taxe sltn s u ran celReserves 37.450 9,450 9,450 31,450 15,850 15.850 15,850 15,850 15,850 15,850 15,850 9,450 208,200 3.6% $1,062 $382.72 $1.56 Summary Sep -08 Oct.08 Nov -08 Dec-08 Jan -09 Feb -09 Mar -09 Apr-09 May-09 Jun-09 Jul -09 Aug -09 TOTAL % Per Unit Per Bed PSF Repair 8 Replacement Reserves Operating Reserve Property Taxes Sales Tax Hotel Tax Insurance 9,450 0 0 0 28.000 %450 0 0 0 0 0 9,450 0 0 0 0 0 9,450 0 0 0 0 22,000 9,450 0 0 0 0 6,400 9,450 0 0 0 0 6,400 9,450 0 0 0 0 6,400 9.450 0 0 0 0 6,400 9.450 0 0 0 0 6,400 9,450 0 0 0 0 6,400 9,450 0 0 0 0 6,400 9,450 0 0 0 0 0 113,400 0 0 0 0 94,800 Z0% 0.0% 0.0% 0.0% 0.0% 1.7% $579 $0 $0 $0 s0 $484 $208.46 $0.00 $0.00 $0.00 $0.00 $17426 $0.85 $0.00 $0.00 $0.00 $000 $0.71 Total eserves, Taxes and Insurance 37.450 9,450 9,450 31,450 15,850 15.850 15,850 15,850 15,850 15,850 15,850 9,450 208,200 3.6% $1,062 $382.72 $1.56 Summary Sep -08 Oct.08 Nov -08 Dec-08 Jan -09 Feb -09 Mar -09 Apr-09 May-09 Jun-09 Jul -09 Aug -09 TOTAL % Per Unit Per Bed PSF Total Revenue 550,912 521,712 521,712 521,712 $36,892 526,892 526,892 526,792 532,992 229,675 224,175 503,811 5,724,168 100.0% - $29,205 $10,522.37 $42.89 Total Expenses 645,813 277,736 294,063 272,757 323,780 257,128 255,218 255,893 259,564 272,638 269,072 235,874 3,619,536 63,2% $18,467 $6,653.56 $27.12 Net Operating Income - 94,901 243,976 227,649 248,955 213,112 269,764 271,674 270,899 273,428 - 42,964 - 44,898 267,937 2,104,632 36.8% $10,738 $3,868.81 $15.77 Repair 8 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 TOTAL 113,400 2.0% $579 S20846 50.85 Less; Proposed Capital Exterior Painting Carpet Repairs Exercise Equiptment 0 3.000 20,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 120,000 0 120,000 3,000 2.1% 0.1% S612 $15 522459 S551 5090 50.02 Recreation Amentily 22.000 20,000 0.3% $102 S3676 50.15 Interior Room Paint 10,000 22,000 0.4% $112 $40.44 $0.16 Tanning Beds Card Entry 0 0 0 0 0 0 0 0 10,000 0.2% s51 $18.38 50.07 Lobby Renovations 0 0 0.0% s0 $0.00 $0.00 Sigoage 5,000 0 0.0% $0 $000 $0.00 Tile Replacement 5,000 0,1% $26 $9.19 $0.04 Furniture 3,000 0 0 0 0 0 0 0 0 0 8,000 0 0 11,000 010% 0.2% $0 $56 $0.00 $20.22 $0.00 $0.08 Total Capital Disubursennents 63,000 8,000 120,000 191,000 3.3% $974 $351.10 $1.43