Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2004-2005 Cambridge Budget
�' �• L� � � 1� .. .. . .� j,.....r ....�� . .. .._ .,.. d. .. .�.... . .. i[C r �' � � � ,�� � �r I� � �., � �.� t � �'dF � Wa f > 2 04-20 5 IJ 'I' , � a ! INVESTMENT • IlIANAGE�4ENT • DEVELOPR3E\T 1800 Bering Drive� Suite 320�° Houston TX 77057� P 713-782-58Q0� F 713-268-5111 www.assetcampus.com CAMBRIDGE @ COLLEGE STATION WEEKLY TRAFFIC REPORT 715/20Q4 MOM TUE WED THUR FRI SAT SUN T07AL TRAFFIC Q' 2 2 i ' 3 1 3 4 11 SIGNED,4PPL: t�' 1 3 5 1 0 Q 10 CLOSING RATIO 91% ' iVET LEASING ACTIVIT(ES: NEW APPS THIS WEEK 10 #OF CANCELS 2 NET GP;IN/LQSS THIS WEEK 8 TFIIS WEEK 29Q sq,ft. 290 sq.ft. 800 sq.ft. 800 sq.ft. 9197 sq.f�. , �, B C D E TYPE OF UNIT: Eff.Single Eff.Double 2 x 2 Singie 2 X 2 Double 4 X2 TOTAL BASE RENTS: 10,91Q 7,30d 9,712 6,90d 8,900 Tt?TAL BEDS: 14 6Q 67 226 164 531 #OF APPS RECEIVEd THIS WEEK: ; 0 $ ' 4 0 2 10 %OF TOTAL BEDS: 0.0%0 13.3%0 0.0% 0.4% 1.2% 1.9% #OF BEDS LEASED THIS WEEK: 4 5 ' l 0 Q 1 6 °lo LEASED: 0.0% 8.3%0 0.0% Q.d% 0.6% 1.1% , TQTAL 290 sq.ft. 230 sq.ft. 800 sq.ff. 8Q0 sq.ft. 19?7 sq.ft. A B C Q E TYPE OF UNIT: Eff.Single Eff.Double 2 x 2 Single 2 X 2 Doubie 4 X2 TOTAl. BASE RENTS: 10,910 7,300 9,712 6,904 8,900 ' TOTAL BEDS: 14 60 67 226 164 531 #OF APPS RECEIVED TO DATE 14 53 �7 226 14'1 ' 501 %BEDS W!APPLICATIONS: 100.U°!o 88.3% 100.Q% 100.0% 86.Q% 94.4% #OF LEASED BEDS TO DATE: 14 37" 67 226 113 ' 457 %LEASED: 100.0% 61.7% 1 Q0.0% 100.0% 68.9% 86.1% #QF BEDS REMAINING(unleased&un-apped) 0 7 0 0 23 30 T � a ri e Ile e t t6on 2004-2005 uc9get arr�tive Overwiew of the 20Q4 - 2Q05 udc�et The attached budget is based on newfy revised rental rates and a marketing plan designed to achieve a maximum occupancy as early in the leasing season as possible. This budget : maintains all s�nrice levels per the original project's vision. Revenues are calculated on 530 leased residents during fihe academic year and 100 ' residenfis during the summer 2005 session. Additianal revenue is derived from outside board plans and summer camp and conference revenue as well as telecam fees and ' vending commissions. , The significant changes from the previaus year include lowering of overail rentaf rates and elimination of parking fees. Telecom fees remain fihe same. Expenses have increased in proportion to anticipated occupancy leveis, particularly payrall and food costs. The average food cost, per meal is projected at $2.25 per meal. The Cambridge @College Station Managed by Asset Campus Housing Proprietary&Confidential Opera4ing Budget-Detail Revenues Contract Revenues Sep•04 OctA4 Nov-04 Dec-04 Jan-05 Feb-OS Mar-05 Apr-05 May-05 JunAS JulA5 Aug-05 TOTAL % Per Unit Per Bed PSF Potential Room Revenue 426,427 442,708 357,023 242,776 293,057 358,858 281,961 384,491 212,678 238,907 187,325 303,339 3,737,550 897% $19,039 $6,512.30 $27.96 PotentialFoodRevenue 180,929 186,960 150,775 t02,527 123,738 151,563 119,085 762,389 93,906 121,212 95,041 134,128 1,622,252 30.3% $8277 $283116 $1216 TotalPotenttalRevenue 609,356 629,666 507,798 345,302 416,795 510,427 401,046 546,880 306,584 360,119 282,366 437,468 5,353,802 10D.0% $27,315 $9,343.46 $40.72 Vacancy Loss Ftoom -6,053 -6,255 -5,045 -3,430 -3,228 -5,650 -4,439 •6,053 -30,436 -193,080 -151,392 -100,379 -515,441 -9.6% -$2,630 -$899.55 -$3.86 Vacancy loss Food •4,561 -4,719 -3,806 •2,588 -2,436 -4,262 -3,349 -4,567 -16,763 -100,100 -78,488 -50,393 •276,035 -5.2% -$1 408 -$48174 -$2 07 Total Vacancy toss -1Q620 -10,974 -6,850 -6,078 •5,664 -9,912 -7,788 -10,620 -47,199 •293,180 429,879 -150,772 •79�,476 -14.8% -$4,038 -$1,38128 -$5.93 Payplan Charge/Discount -17,716 -18,306 -14,763 -10,039 -12,165 -14,BQ9 -11,636 -15,867 -7,405 0 0 4,742 •117,963 -2 2% -$602 -$205 87 -$D 88 Total Budget Contract Rev. 581,020 600,388 484,185 329,245 398,966 485,700 381,622 520,393 251,980 66,939 52,486 291,437 4,444,363 $22,675 $7,156.31 $33.30 Totai Contract Revenue 581,020 600,388 484,185 329,245 398,966 485,700 387,622 520,393 251,980 66,939 52,486 291,437 4,444,363 83.0% �y22,675 $7,756.31 $33.30 Olher Revenues Parking Lot-Cnntract BBO 880 880 880 880 880 880 880 880 0 0 7,920 02% $40 $13.82 $0.06 Conference/Camp-Food 0 0 0 0 0 0 0 0 12,000 29,575 29,575 29,575 100,725 2.0% $574 $175.79 $0.75 Conference/Camp-Room 0 0 0 0 0 0 0 0 72,000 29,575 29,575 29,575 100,725 2.0% g514 $775.79 $0.75 Apartments 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 Resitlential�ony Distance 2,083 2,083 2,083 2,083 2,083 2,083 2,083 2,083 2,083 2,083 2,083 2,083 25,000 0.5% $128 $43.63 $0.19 Telecom Fee 28,047 28,982 23,373 15,894 21,503 26,778 20,568 28,047 15,407 3,733 2,715 17,967 232,414 4.6% $1,186 $405.61 $174 Outside Board Contracts 4,017 4,151 3,347 2,276 3,053 3,7�7 2,920 3,982 1,327 0 0 1,741 30,532 0.6% $756 $53.28 $0.23 CashFoodSales 2,400 2,480 2,000 1,360 1,840 2,240 1,760 2,400 1,360 1,760 1,280 1,760 22,640 0.4% $116 $39.57 $0.17 VendingCommissions I.OD6 1.000 1,000 7.D00 1,OOD 1p00 L000 1,i�pf3 �I,00�} 1,000 �,pUO 1,Op0 12,000 0.2% $61 $20.94 $0.09 Wash Mach COmmissions �.n79 2,07� 'L,0'9 2,q7<J 2,079 2,(?7J 2,C179 2,O79 2,p75 377 ;i77 1,°1f, 21,216 0.4% $108 $37.03 $0.16 InteresUncome 3.600 2.50iJ 1,000 4,5O0 3,500 2.500 1.QOQ S00 Sq0 SOQ 3,500 4,506 28.000 0.6% $143 $48.87 $0.21 Catering 0 0 0 0 0 0 0 0 0 0 D 0 0 0.0% $0 $0.00 $0.00 Retumed ChecWLate Fees 200 ?On 2bD 2O0 20i) 200 'LOQ 2(tD 20r 2pU 200 200 2,A00 0.0% $12 $4.19 $0.02 Application Pees ±) 0 0 0 0 2,'<'OD '1,20U 2.ZOG 2.200 2,200 2,200 6 13,200 0.3% $67 $23.04 $0.10 TotalOtherRevenue 44,206 44,355 35,962 30,272 36,136 43,077 34,691 43,372 50,973 71,003 72,505 90,217 596,771 11.8% $3,045 $1,047.49 $4.47 TotalRevenue 625,227 644,743 520,147 359,51� 435,105 528,776 416,313 563,765 302,953 137,942 124,992 381,654 5,041,134 100.0°/, $25,720 38,797.79 $37.77 Rental Payroll Sep-04 OctA4 Nov-04 Dec-04 Jan-05 Fe6-05 Mar-05 AprA5 May-05 Jun-05 JulAS Aug-OS TOTAL % Per Unit Per Bed PSF SalarieslWages 7,864 7,864 7,864 11,614 7,864 7,864 7,664 7,864 7,864 7,864 11,614 7,864 101,868 2.0% $520 $177.78 $0.76 Benefits&Taxes 2,803 2,803 2,803 3,663 2.803 2,803 2,803 2,803 2,803 2,803 3,663 2,803 35,358 0,79; $180 $61.71 $026 Holiday Pay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 TptalPayroll t0,6fi7 10,667 10,667 15,277 10,667 10,667 10,667 10,667 10,667 10,667 15,277 iQ,667 137,226 2.7% $700 $239.49 $1.03 Cambndge @ College Station 7/76/2004 Page 7 of5 _ _ _ __ __ _ _. . _ . _. _ Food Department Food Cost Sep-64 OctA4 NovA4 Dec-04 Jan-OS Feb-05 Mar-05 AprA5 MayAS Jun-05 Jul•OS Aug-95 TOTAL % Per Unit Per Bed PSF Beverages 3,941 4,102 3,312 2,212 3,209 3,904 3,069 4,770 2A28 1,451 2,937 2,591 36,926 0.7% $788 $64.44 �0.28 Baked Goods 2,255 2,347 1,895 1,266 1,836 2,234 1,756 2,387 1,161 837 1,680 1,483 21,132 0.4% $108 $36.88 $0.16 Dairy 4,637 A,826 3,897 2,603 3.775 4,593 3,611 4,907 2,386 1,708 3,455 3,049 43,447 0.9% $222 $75.82 $0.33 Milk 1,21� 7,266 1,022 683 991 1,205 948 1,287 626 448 907 800 11,400 0,2% $58 $19.89 $0.09 Meats 14,029 14,029 14,029 14,029 14,029 14,029 14,029 14p29 74,029 14,029 14,029 74,029 168,353 3.3% $859 $293.81 $1.26 Frozen Goods 2,638 2,638 2,636 2,638 2,638 2,638 2,638 2,638 2,638 2,638 2,638 2,638 31.651 0.6% $161 $5524 $0.24 Accompaniment, 6,823 6,823 6,823 6,823 6,823 6,823 6,823 6,823 6,823 6,823 6,823 6,823 81,876 t.6% $478 $142.89 $0.61 Produce 4,315 4,491 3,626 2,422 3,513 4,274 3,360 4,566 2,221 1,589 3,275 2,837 40,430 0.$% $206 $70.56 $0.30 TotalFoodCost 39,854 40,523 37,243 32,676 36,815 39,700 36,235 40,807 31,912 29,577 35,684 34,250 435,216 8.6% $2,220 $759.54 �326 Food Department Payroll Sep�04 Oct-04 NovA4 �ecA4 JanAS Peb•05 Mar-OS Apr-OS May-05 Ju�-05 Jul-05 Aug-05 TOTAL % Per Unit Per 8ed PSF SalanesNVages 26,797 26,797 25,109 15,555 16,946 26,797 21,635 26,567 21,452 26,797 26,797 22,560 283,809 5.6% $1,448 $495.30 $2.13 Bene(its&Taxes 8,210 7.630 9,210 9,797 6,260 7,585 8,218 7,531 7,247 7,645 8,628 6,553 94,512 �.9% $482 $164.94 3071 Vacation Pay 0 0 0 3,053 0 0 1,804 0 0 0 0 0 4,857 0.1 l $25 $8.48 $0.04 Holiday Pay 579 0 1,992 1,744 948 0 0 0 948 0 1,043 0 7,254 0.1% $37 $12.66 $0.05 SickPay 107 105 81 53 46 60 73 59 0 120 60 0 764 0.0% $4 $1.33 $0.01 TotalPayroll 35,693 34,532 36,392 30,202 24,200 34,442 37,730 34,157 29,647 34,562 36,528 29,719 391,196 7.8% $t,996 $682.72 $2.93 Food Department Food Department Sep�04 Oct-04 NovA4 Dec-04 Jan-O5 Fe6A5 Mar-05 P,pr-05 May-05 Jun-05 JulAS Aug-05 TOTAI % Per Unit Per Bed PSF Pest Control ��30 230 230 230 230 23� 230 230 230 230 230 2.;0 2,760 q.1% $14 $4.82 $0.02 Un=n Laundry/Rental 500 500 5U0 SOU 50C1 50U 500 5�J0 500 500 500 500 6,000 0.1% $31 $10.47 $0.04 Unifortns 150 750 0 0 1,900 20U 0 �100 0 0 0 100 2,600 0.1% $73 $4.54 $0.02 Dining Room Supplies 500 500 550 300 35U 500 500 500 560 dpp 9p0 600 5,800 0.1% $30 $10.12 $0.04 Decorations 150 350 150 450 15Q 450 15Q 300 300 0 0 Q 2,450 A.0% $13 $428 $0.02 Kitchen Supplies 0p� ,00 400 300 i pil 4D0 300 E00 50� J00 dOQ 400 5,500 0.1% $28 $9.60 $0.04 China/GlasslSiiv�r 600 0 20p 0 500 0 2U0 0 600 0 p 6p0 2,700 0.1% $14 $4.71 $0.02 Cieaning Supplies sS00 800 700 a00 a00 6D0 600 700 400 "706 7UQ 400 7,200 0.1% $37 312.57 $0.05 ContractCleaning 150 180 �150 150 750 150 150 150 15� 150 t5p 150 1,800 0.0% $9 $3.14 $0.01 Total Other Ezpense 3,680 3,180 2,880 2,330 4,880 3,030 2,630 3,080 3,180 2,380 2,560 2,980 36,810 0.7% $188 $6424 $028 Total Food Expense 79,228 78,235 �6,515 65,2�8 65,894 77,172 70,595 78,044 64,739 66,459 74,792 66,343 863,222 17.1% 34,404 51,506.50 56.47 Gen&Admn Dept Payroli SepAA Oct-04 Nov-04 Dec-04 JanAS Feb-05 Mar-05 AprAS MayAS Jun-05 Jui-05 Aug�05 TOTAI % Per Unit Per Betl PSF Salaries/VJages 10,316 10,316 t0,316 15,318 10,316 10,3�6 10,316 10,316 10,316 10,316 15,318 10,316 733,796 2.7% $683 $233,50 $1.00 Benefits&Taxes 3,883 3,115 3,371 4,390 3,243 3,115 3,115 3,175 3,115 3,175 4,390 3,115 47,087 0.8% $210 $7t.71 $0.31 VacationPay 640 0 0 0 0 0 0 0 0 0 0 0 640 0.0% $3 $1.12 $0.00 Holiday Pay 128 0 256 128 128 0 0 0 0 0 128 0 768 p.0% $4 $1.34 $0.01 TotalPayroll 14,967 13,431 73,943 19,836 13,687 13,437 13,431 13,431 13,431 13,431 19,836 13,431 176,297 3.5% $899 $307.66 $1.32 Cambndge @ College S(ation �/76/2004 Page 2 0/5 Management Fee SepA4 OctA4 Nov-04 Dec�04 Jan-05 Feb-05 MarAS AprAS May-05 JunAS Jul-05 AugA5 70TAL % PerUnit PerBed PSF ManagementPee 31,5(Y7 37,5O7 3L607 37,507 31,5D7 3�,50� 31,507 :?t,50; 31,5O7 3i,507 3�,607 91,507 378,085 7.5% $1,929 $659.83 $2.83 Gen&Admn Dept Other Expense Sep-04 Oct-04 Nov-04 Dec-04 JanA5 Feb-05 Mar-OS Apr-05 May-05 Jun-05 Jul-05 Aug-05 TOTAL % Per U�it Per Bed PSF EquipmentLease ?32 �32 '32 �:52 732 7:52 732 732 73£: 732 732 732 8,783 0.2% $45 $15.33 $0.07 Legal 417 A17 417 A�7 41i d77 d17 417 A17 a17 .�17 417 5,000 0.1% $26 $8.73 $0.04 Audit 500 500 500 500 500 500 500 900 500 50U 5U0 500 6,000 0.1% $31 $10.47 $0.04 OtherProfessionalExpense 120 i20 72� 120 120 120 1'LO 110 �120 12�� 120 120 1,440 0.0% $7 $2.51 $0.01 Taxes,Licenses&Fees 27P. 21& 21fl 218 21& 2�a 218 219 218 21� 218 218 2,614 0,1% $13 $4.56 $0.02 Telephone-Ld 256 250 250 250 25U 250 �,0 250 2:�0 25p 25G 250 3,000 o.i% $15 $524 $0.02 Telephone•Local 167 107 t�i7 167 to; �IF7 �15i ta7 167 107 167 157 2,000 0.0% $10 $3.49 $0.01 O(fice Supplies 450 a50 450 450 450 d50 d5U 450 450 450 450 �350 5,400 0.7% $28 $9.42 $0.04 Postage 100 100 100 100 iG0 100 10'v 100 100 100 100 1Q0 1,200 OA! $6 $2.09 $0.01 Dues/Subscriptions 14d 1d6 �140 146 146 14f 146 14f 146 1�lii i46 14G 1,750 0.0% $9 $3A5 $0.01 7ravel-LocalSupervision 75 15 75 t5 15 15 t5 15 �I5 1> 15 15 175 0.0% $1 $0.31 $0.00 TSHAAdminFee 11,994 12,388 5.998 6.083 &.1�5 10,OG9 7,91:? 10,7GP, 5,552 <,?59 2,:i0G 7,126 95,753 1.9% $489 $167.11 $0.72 RelocationExpense 41? dl7 d17 417 417 41,' 417 417 4'17 417 417 d17 5,000 0.1% $26 $8.73 $0.04 Recruiting Expense t50 150 150 1,0 150 150 15U 1,50 150 15U 15G 150 1,800 0.0% $9 $3.14 $0.01 Bad DebtExpense 695 719 574 380 467 5�5 445 619 283 84 66 333 5,239 0.1% $27 $9.t4 $0.04 OtherG&AExpense 52 52 52 .�� 52 S2 52 52 52 ,52 52 52 627 0.0% $3 $7.09 $0.00 BankServiceCharges 100 100 100 100 100 100 100 iQ0 100 100 10U �p0 1,200 0.0% $6 $2.09 $0.01 Courtesy Officer 4,034 d,0:4 4 03d �A34 4,034 4,G34 4,034 4,03d J,034 h,034 4,034 4,034 48,409 1.0% $247 $84.48 $0.36 CreditCartlFee, 1,500 1,548 7,237 835 tp24 1,259 977 1,346 694 345 312 891 11,959 0.2% $61 $20.89 $0.09 TotalOtherExpense 22,059 22,522 19,573 15,765 17,553 19,769 17,108 20,600 14,396 11,054 10,744 16,216 207,359 4.1% $1,058 $361.88 $L55 Total G&A Expenses 37,026 35,953 33,516 35,602 31,240 33,200 30,540 34,031 27,827 24,485 30,587 �29,647 363,650 7.6% 31,957 $669.55 $2.87 Marketing Dept Payroll Sep•04 OctA4 Nov-04 DecA4 JanA5 Feb-OS Mar-05 Apr-05 MayA5 Jun-05 Jul-OS Aug-05 TOTA� % Per Unit Per Bed PSF Sala�esNYages 0 0 0 0 0 0 0 0 0 0 0 0 0 A.0% $0 $0.00 $0.00 Bene(its&Taxes 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 VacationPay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 50 $0.00 $0.00 Holiday Pay 0 0 0 0 0 0 0 0 0 0 0 0 D 0.0% $0 $0.00 $0.00 SickPay 0 0 0 0 0 0 0 0 0 0 0 0 0 4.0% $0 $0.00 $0.00 Olher Benefits 0 0 0 0 0 0 0 0 0 0 0 0 0 $0 $0.00 $0.00 Total Payroll 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% CamAridge @ Colfege Station 7/16/2004 Page 3 015 MarkeUng Dept Ofher Ezpense Sep-04 Oct-04 Now04 Dec-04 Jan-05 Feb-05 MarAS Apr•05 MayOS Jun-OS Ju145 Aug•OS TOTAL °(, Per Unit Per Bed PSF OutdoorAdvertising 0 .. 0 0 ii U 0 q n r p O 0 0.0% $0 $0.00 $0.00 DirectMail D D '25G 1,50i� I:SDO I.S�Jn 1.500 I,500 1.500 1:50<i 1.,50i1 15f±) 13,750 0.3% $70 $24.00 $0.�0 News/Magazines B"15 f306 7,2H4 t575 0 �00 1,a75 fi g00 Gi5 8qq 900 9,084 02% $46 $15.85 $0.07 Radb/Tv Advertistng i) 0 (7 0 0 p p U 0 0 0 0 0 0.0% $0 $0.00 $0.00 Brochures (1 1Qfj 11,000 Eiq D p 0 p r.l 0 D 0 11,160 0.2% $57 $19.48 $0.08 Promolion-Extemal 150 350 g00 2,50u 200 750 0 2,b 250 3,350 H00 25(i 9,750 0.2% $50 $77.02 $0.07 Lease Comm.-Residential p p 0 [1 G 0 q 0 0 �3 0 (1 0 0.0% $0 $0.00 $0,00 WebAdv/Presence . [5tl f 0 0 �,0 p 0 0 0 ._ 25D 750 0.0% $4 $7.31 $O.Ut Other Expense 450 4:ii a50 2H5 2£35 2£i5 ;35 �35 .535 ,3; 285 35 4,665 0.1% $24 $8.14 $0.03 Tota101herExpc;nse 7,275 1,950 13,884 5,020 1,985 3,685 3,510 2,285 3,185 6,060 3,385 2,935 49,159 1.0% $251 $8579 $0.37 Total Marketing t�xpense 1,275 1,950 13,884 5,020 1,985 3,685 3,510 2,285 3,185 6,060 3,385 2,935 49,159 1,0% $251 $85.79 $0.37 Residence Life d�Student Development Other Expense Sep-04 Oct�04 NovA4 DecA4 Jan-05 Feb•05 MarAS Apr-OS May-05 JunAS Jui-05 Aug-OS TOTAL °<, Per Unit Per Bed PSF Res.li(e&Dev. 2.500 2.000 1,f67 1,6fi 2.00p 1,6G7 1.667 1,6u7 1,u"6? 1.667 1,ufi7 1,607 21,500 0.4% $110 $3Z52 $0.16 Total Res.Life 2,500 2,000 1,667 1,667 2,000 1,667 1,667 1,667 1,667 1,667 1,667 1,667 27,500 0.4% $170 $37.52 $0.16 Telecom Expenses Sep-04 Oct•04 Nov-04 Dec-04 Jan-05 Feb-OS MarA5 Apr•OS May-05 Jun-05 Jul•05 Aug-05 TpTAL 90 Per Unit Per Bed PSF Telecom 8,820 8,820 8,820 8,820 8,820 8,820 8,820 8,820 8,820 8,820 8,620 8,820 105,840 2.1% $540 $t84.71 $0.)9 ResidentialLongDistanr,e 1,000 1,000 1,000 1,000 1,000 1,�00 1,000 1,000 1,000 1,000 1,000 1,000 12,000 0.2% $61 $20.94 $0.09 Data 5,600 5,600 5,600 5,600 5,600 5,600 S,60D 5,600 5,600 5,600 5,600 5,600 67,200 1.3% $343 $11728 $0.50 CabieN 7,828 7,828 7,828 7,828 7,828 7,828 7,828 7,828 7,828 7,828 7,828 7,828 93,936 1.9°/, $a79 $t63.94 $0.70 Total Telecom Expense 23,248 23,248 23,248 23,248 23,248 23,248 23,248 23,248 23,248 23,248 23,248 23,248 278,976 5.5% $1,423 $486.87 $2.09 Utilities/Energy Expenses SepA4 Oct-04 Nov-04 DecA4 Jan-05 Feb-OS MarAS Apr-05 May-05 Jun-OS JulAS Aug•05 TOTAL % Per Unit Per Bed PSF Elecinc-Public N,113 10,106 12,679 10,314 8,945 9,734 9,703 10,667 9,924 10,793 10,417 12,767 126,502 25% $645 $220.77 $0.95 Electric-Residential 8,704 9,803 75,246 12,200 9,030 7,223 7,959 11,413 9,820 12,749 8,894 10,888 123,329 2.4% �629 $21523 $0.92 Electric-Resident Payments 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% g0 50.00 $0.00 Fuel(Gas) 5,099 5,099 5,099 5,099 5,099 5,099 5,09�3 5,099 5,099 5,099 5,099 5,099 61,185 1.2% $312 �106.78 $0.46 Sewer 4,232 4,232 4,232 4,232 4,232 4,232 4,232 4,232 4,232 4,232 4.232 4,232 50,779 1.0% $259 $88.62 $0.38 Water 1,194 7,606 2,587 2,083 1,689 1,038 1,275 1,749 1,606 2,147 1,289 7,321 19,586 0.4% $100 $34.18 $0.15 Total Utility Expense 29,742 30,846 39,783 33,928 28,994 27,325 27,667 33,160 30,680 35,020 29,930 34,307 381,381 7.6% 51,946 $665.59 $2.86 Rep/Maint Dept Payroll Sep-04 Oct-04 Nov-04 DecA4 Jan-05 Feb-05 Mar-05 Apr-05 May-05 JunA5 Jul-05 AugAS TOTAI. % Per UNt Per Bed PSF Salaries/Wages 6,052 6,052 6,052 9,078 6,052 6,052 6,052 6,052 6,052 6,052 9,078 6,052 78,676 1.6% $401 $137.31 $0.59 Benefits&Taxes 1,763 7,763 1,763 2,457 7,763 1,763 1,763 1,763 1,763 1,763 2,457 1,763 22,540 0.4% $175 $39.34 $0.17 HolidayPay 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0� $0 $0.00 $0.00 Tofal Payroli 7,815 7,815 7,815 11,535 7,815 7,815 7,815 7,815 7,815 7,815 11,535 7,815 101,216 2.0°/, $516 $776.64 $0.76 Cambntlge @ College Sfation 7/16/2004 Page 4 ot 5 _ _ _ _ _ __ _ _ __ . Rep/Maint Dep4 Olher Ezpenses Sep-04 Oct-04 Nov-04 Dec-04 Jan-05 Feb-05 Mar-05 AprAS May-OS Jun•OS Jui•05 Aug-05 TOTAL % Per Unit Per Bed PSF Waste Removal 7,168 7,168 1,168 1,168 1,168 7,168 7,168 1,168 1,168 7,168 1,166 1,168 14,018 0.3% $72 - $24.46 $0.11 Unifortns �1 0 0 U 0 0 Ci 0 0 0 l) �i 0 �.0% $0 $0.00 $0.00 Rooms Supplies 75C ?50 7�0 75U �,Q 750 750 75�1 750 7BG 750 756 9,000 0.2% $46 $15.71 $0.07 CleaNngSuppii�s BC�� 50q �I,OOQ 1,Op0 1,000 350 1,200 aG0 76Ct t,C100 i,G00 1,000 10,000 0.2% $51 $17.45 $0.07 ContractCleaning ;G6 0 0 0 p 0 0 0 .500 p 0 0 1,000 D.0% $5 $175 $O.D1 EquipmentRental p 0 0 0 0 0 0 0 0 0 0 p 0 0.0% $0 $0.00 $0.00 Pest Control ,24 f2a 62d "v?.a 62d o2d 624 ti2d 624 62�} 624 524 7,488 $38 $13.07 $0.06 Other Expense 42 42 42 d2 42 d2 a2 d2 a2 d2 q2 42 500 0.0% $3 $0.87 $0.00 Buildings Maintenance 25v' 250 250 ?50 250 250 250 250 250 250 2fi0 250 3,000 0.1% $15 $5.24 $OA2 Food Service Equip Repair 4 t 7 417 a17 41? •177 a i 7 �t 7 417 d 17 a17 417 4 t 7 5,000 0.1% $26 $8.73 $0.04 Dnve/ParkLotMaint. iG0 tOQ 100 100 100 100 100 100 I00 10U 100 100 1,200 0,0% $6 $2.09 50.01 ElevatorMaintenance 630 030 f3Q u30 f36 G's0 030 630 030 f30 F,30 630 7,560 0.1% $39 $13.19 $0.06 � LauodryEquip.Maint. 70 70 70 70 70 70 70 7p i0 '0 70 70 836 0.0% $4 $1.46 $0.01 Hvac Maintenance 20P, 208 208 208 �09 208 2p8 208 208 208 ?.OS 20R 2,500 0.0% 513 $4.36 30.02 CarpeUDraperyCleaning 0 0 0 q D 0 0 0 0 0 0 0 0 0.0% $0 $0.00 $0.00 Water Treatment 0 0 tt 0 G 0 0 0 0 0 0 0 0 0.0% $0 �0.00 $0.00 Grounds/Landscaping 1,90D 1,9G0 1.900 �,900 I�00 1,900 1,9O0 1,Si00 7,9p0 1,900 1,900 1,E00 22,800 0.5% $116 $39.79 $0.17 Swimming Pool 1;i7 1fi7 to7 16? 167 IFi7 ifi7 1"v7 167 107 167 1U7 2,000 0.0% $10 �3.49 $0.01 FumitureRep/Repiace 5� 50 50 50 50 50 50 50 50 50 50 50 600 0.0% $3 $tA5 $0.00 Mainl.Equip.Repair 112 7'17_ 112 112 112 112 �I72 112 1�2 112 112 1�12 1,345 0.0% $7 $2.35 $0.01 FireEquipmentRepair to7 16; IF7 1t7 167 18� 1�i' 1Gi 15? t�.i7 ir7 io7 2,000 0.0% $10 $3.49 $0.01 Carpet Repl./Repair 453 453 d53 453 459 453 453 453 453 a53 453 4,53 5,435 0.1% $28 59.49 $0.04 Rec.Equip.Repair II7 Y,% 87 H7 Si S7 87 87 E7 87 &7 87 1,046 0.0% $5 $1.83 $0.01 MaintenanceSupplies 66i ou7 fi67 G67 f67 ,67 �07 G87 087 Go"� 567 fi67 8,000 0.2% $41 $13.96 $0.06 Light 8Wb5 20�J 265 209 204 209 209 209 2Q9 205 209 209 209 2,509 0.0% $13 $4.38 $0.02 PainVDecorating SOU 500 500 ,00 SGO 500 SOG 500 5D0 ;00 500 50p 6,000 0.1% $31 $10.47 $0.04 Pest Control D 0 G 0 0 0 0 p 0 0 0 0 0 0.0% $0 $0.00 $0.00 Damages Recovered -500 -500 -500 -500 -5G0 -500 -600 -500 -500 -5G0 -50Q -500 -6,000 A.1% -$31 -$10.47 -$0.04 OtherExpense 292 292 292 292 2P2 2�2 252 292 29'L 2�2 292 292 3,500 0.1% $18 $6.71 $0.03 Uniforms 44 44 43 a4 44 J4 44 44 h4 44 4�1 4d 523 0.0% $3 $0.91 $0.00 Appliences 25 25 25 25 25 2F, 25 25 ^_5 25 25 2Ci 300 0,0% $2 $0.52 $0.00 Fences&Gates 0 0 0 0 0 0 0 0 0 0 0 Q 0 0.0% $0 $0.00 $0.00 Locks&Keys 75 75 75 7; 75 75 75 75 75 75 75 75 900 �.0% $5 SL57 $0.01 Total Other Expenses 9,805 9,005 9,505 9,505 9,505 8,855 9,705 8,905 9,755 9,505 9,505 9,505 113,060 2.2% $577 $197.31 $0.85 Total ReplMaint.Expenses 77,620 16,820 77,320 21,040 77,320 16,670 17,520 16,720 17,570 77,320 21,040 17,320 214,276 4,3% $7,093 $373.95 $1.61 TaxesJlnsurance/Reserves TOTAL % Repair&ReplacemeMReserves 4AO�i 4,G00 4,000 J,OGU 4,000 4,OD0 4,60G 4,OGD 4,G00 4;OG0 4,OOU 4.D00 48,000 1.0% �245 $83.77 $0.36 Property Taxes C i i p p 0 p 0 p �) D 0 0 0 0.0% $0 $0.00 $0.00 Insurance �,5n,3 o,5E3 5,56� 3,533 6,5t33 u,5�3 G,593 6.5F73 8,5Ct3 6,503 5,5£33 d,583 79,000 1.6% $403 $137.87 $0.59 TotalReserves,Taxes andlnsurancE 10,583 70,583 10,583 10,583 10,583 10,583 10,583 10,583 10,563 10,583 10,583 10,583 127,000 2.5% $648 $221.64 $0.95 Summary Sep•04 OctA4 Nov-04 Dec•04 Jan•05 Feb-05 Mar-05 Apr-05 May-OS Jun-OS Jul•OS Au9-05 TOTAL % PerUnit PerBed PSF Total Revenue 625,227 644,743 520,147 359,517 435,105 528,776 416,373 563,765 302,953 137,942 124,992 38'1,654 5,041,134 100.0% $25,720 $8,797.79 $37.77 TotalExpenses 243,396 241,809 258,691 243,079 223,439 235,724 227,504 241,912 221,673 227,016 242,009 228,224 2,834,476 56.2% �14,462 $4,946.73 $2124 Net Opereting Pncome 361,831 402,934 261,456 116,A38 211,666 293,052 188,809 321,853 81,280 �89,074 -117,018 153,431 2,206,658 43.8% $17,258 $3,851,06 $16.53 Scholarships TSHA Full Scholarship(20) -14,600 -14,600 -14,600 •14,600 -14,600 •14,600 •14,600 •14,600 -14,600 -14,600 -146,000 -2.7% -$745 -$254.80 -$1.09 TSHA Incremen[al Sch.(43) -10,75tl -10,750 -10,750 -10,750 -10,750 •10,750 -10,750 -10,750 •10,750 0 0 �10,750 -107,500 -2.0% -$548 -$787.61 -$0.81 Total loss to Scholarships •25,350 -25,350 -25,350 •25,350 -25,350 •25,350 -25,350 -25,350 •25,350 0 0 -25,350 453,500 -$1,293 -$442.41 -$7.90 Cambndge @ Collec�e Stafion 7/16/2004 . Page 5 of5 ; The a ri e Ble � ta�ion 2004-2005 udge# arrat��e P2EVEPdUES Description of Budgef Item Total Contract Rev�nue Revenue based upon 530 rooms and/or 93%. See attached detail. OtherRevenues Parking Lot-Contract Parking fees. No parking fees are planned in current rate structure. ' Conference(Camp-Food Dining revenue from summer camps and conferences. Conference/Camp-Room Roam revenue from summer camps and conferenees. Residentia!Long Distance Estimated long distance revenue for 530 residents. Telecom Fee Estimated telecom fees for 530 residents. Outside Board Contracts Estimated non resident meai plans to be so(d in second year of operations. Cash Food Sates Estimated walk in cash food sales,mostiy guests of residents Vending Commissions Estimated commissions from sale of soda and snack machines Wash Mach Commissions Estimated revenue from washers and dryers Telephone Commissions No budget aliocation for this category Interest Income interest income estimated at 6% Catering Esfimated revenue from catering special functions Returned Check/Late Fees Estimated revenue from NSF fees Application Fees Application fees for 530 residents @$25 per applicant. EX�ENSES ' Rental Pavroll Payrofl for four housekeepers,one porter and 12 resident assistants. See payroll schedules for more defail. Food DeparEment Juices,soft drinks,coffee,etc. Beverages Bread, pies,bakery goods Baked Goods Dairy Cheese,ice cream,yogurt,etc. Milk Milk ' Meats All meats,including poultry,fish, etc. Frozen Goods Frozen vegetabies, bases,etc. Accompaniments Ketchup,relish, mayonnaise,spices,salad dressings,etc. Produce Lettuce,onions, etc. - Food Departmenf Pavroii Payroll for 27 full and part time employees in dining services See attached schedules for more detail. Food Department Pesf Gonfroi Exterminator contract for monthly kitchen service Linen Laundry/Rental Tabie linens and kitchen dish toweis Uniforms Dining services uniforms Dining Room Supplies Napkins,salt and pepper shakers, condiments, paper products. Decorations Decorations for theme dinners Kitchen Supplies Ciing wrap,aluminum foii, paper towels,oils,filters,etc. China/GlasslSilver Replacement of china,glass and silverware. Cleaning Supplies Chemicals for cleaning Contract Cleaning Semi annual exhaust vent hood cieaning Gen&,4dmn Dept Payrolf Payroil for a General Manager,Assistant GM, Recepfionist, Resident Director and nightiy late night desk workers. See payroii schedules for more detail. The Cambridge @Coilege Station Managed by Asset Campus Housing Proprietary&Confidentiai T � a ri e 61e � tati n 2004-2005 uclget arr�tiv� Management fee based on calculation method per the management Mana�e�nent Fee agreement. Gen&Admin.Dept Rental of copier,postage equipment,credit card terminals,etc. Equipment Lease Budget allocation for legal needs,consuiting,contract work, etc. �egal Budget ai(ocation for annual audit. Audit Serrice fees for on-line accounting system Other Professionai Expense Budget a(location for renewal and maintenance af elevator and resale permifs,chamber ofi commerce membersnip, betfier business membership,etc. Taxes,Licenses&Fees Long distance service for office Telephone-Ld Telephone service for alarm system and elevators Telephone-Local Ail office supplies Postage for office related matters(no direct mail) Office Supplies Apartment association dues,journal subscriptions,etc. Postage Mileage for local staff travel(bank deposits, etc.) Dues/Subscriptions Caiculated as 2°/o of gross revenues. Travel-Local Supervision Ailocation for corporate visits TSHA Admin Fee Allocation for relocation expenses of new staff hires. Travel-Field Supervision Ailocation for running newspaper ads for new employees. Relocation Expense Bad debt estimated at 0.11 %of gross contract revenues. Recruiting Expense Fire alarm monitoring serrice. Bad Debt Expense Bank charges from NSFs and check processing. Other G&A Expense Unarmed,uniformed security officer,eight hours daily{late night desk) Bank Service Charges Expense associated with accepting credit cards for rent. Courtesy Officer Credit Card Fees ' Marketinq Dept No budget ailocation for outdoor signage. Outdoor Advertising Postage and handling fees for direct mail of applications to Direct Mail prospective residents and parents. NewslMagazines Radio/TV Print ads in apartment guides,etc. Advertising Brochures No ailocation for N or Radio advertising. Annual reprint of updated brochures Promotion-E�ernai Lease Props and events for TAMU Housing fair,orienfatians,parents' Comm.-Residentiai Web weekend,etc. Adv/Presence Other Expense No lease commissions budgeted. Maintenance and upkeep of property website. Allocation for misceilaneous marketing expenses. Residence Life&Student Programming and activities for residents{pool parties,educational Development seminars,etc)Internal Marketing. 'Telecom Expense for two T-1 lines and one local LD T-1 Telecom Residential Long Distance Long distance service Data Direct bandwidth for Internet Service Cabie TV Cable television services with HBO UtilitieslEnerqv Electric-Pubiic Electricity expense for pubiic areas, kitchen, parking lot,etc. Elecfric-Residentiai Electricity expense for resident apartments i The Cambridge @Coilege Station Managed by Asset Campus Housing Proprietary&Confidentiai T � a r� e olle e tat6 n 2004-2005 �ud��t Narra�6ve Fuel(Gas) Naturai Gas far heat, hot water,heated swimming pool,kitchen Sewer equipment. Water Waste water Domestic water,irrigation,sprinkler system Rep/Mainf�ept Payroll Payroii includes Maintenance supervisor,and two maintenance helpers. See attached payroii worksheets for more detail. Rep/Maint Dept Trash collection Waste Removal Maftress pads,shower curtains, Rooms Supplies Chemicals and su lies for hausekee in services in rooms Cleaning Suppfies pp p g , Contract Cleaning Pressure washing,window cleaning, upholstery cieaning,etc. Pest Control Exterminator service Qther Expense Allocation for miscelianeous expenses. Buildings Maintenance Windows,roof repairs,exterior repair,etc. Food Service Aliocafion for service on food service equipment Equip Repair Allocation for repainting,replacement of signage for parking lot. Drive/Park Lot Maint. Elevator service contract. Elevator Maintenance Ailocation for repair and serrice of laundry equipment. Laundry Equip. Maint. Air-conditioning filters and repairs of HVAC systems. , Hvac Maintenance Landscaping contract. Grounds/Landscaping Pool chsmicals and maintenance parts. Swimming Pool Aliocation for furniture repair and replacement. Furniture Rep/Replace Allocation for new tools. Maint. Equip. Repair Fire alarm system repair Fire Equipment Repair Allocation for repair of carpeting. Carpet Repl.iRepair Allocation for replacement of recreation equipment(voileybail net, pool cues,etc.) Rec. Equip. Repair Ail consumable maintenance suppiies not categorized. Maintenance Suppiies All lighting needs, including parking iot lights. Light Bulbs Ailocation for painting and upkeep of rooms and common areas. Paint/Decorating Damages that are recovered from students for damages.This is a Damages Recovered negative expense. Other Expense Allocation for miscelianeous maintenance needs. Uniforms Replacemenf and service of uniforms. Allocation for repair of microwaves and refrigeratars, ice makers, Appiiances etc. Fences&Gates No budgeted aliocation.No fences or gates. Locks&Keys Ailocation for service of lock and key systems. The Cambridge @College Station - Managed by Asset Gampus Housing Proprietary& Confidential �he Gambridge @ College Stafiion Revenue Overview(911/04-5/11/05) based on unlimited meai plan so/ so^/ 2o^r, Unit Type #oF uni4s Contract Singie Contract Semester Con4ract Ten Payment Insfallment Payment �nstaliments Payment Installments A-Eff. 14 $ 10,91d $ 152,740 $ 11,238 $ 157,332 $ 11,560 $ 161,840 B-Eff.Double 60 $ 7,300 $ 438,000 $ 7,520 $ 451,200 $ 7,740 $ 464,400 C-2x2 Single 67 $ 9,712 $ 650,704 $ 10,OQ4 $ 670,268 $ 10,290 $ 689,430 D-2x2 Doubie 226 $ 6,900 $1,559,400 $ 7,108 $1,606,408 $ 7,310 $1,652,060 E-4x2 164 $ 8,900 $1,459,640 $ 9,16& $1,503,552 $ 9,43G $1,546,520 531 T07ALS $4,260,444 $4,3$8,760 $4,514,250 Plus R/A's Ren4 Aflowance 73,000 75,200 77,400 (based on aI!eff.doubles) Less 8/25l04-8131104 ��3 j.gg� �j��g���, 4 r, a 1 u9,7-6 �COt81 POt2ntial ReVe91Ue 4,2d1,557 4,328,100 4,451,904 ; 70% Rent Revenue 2,928,485 3,016,686 3,102,977 30% Food RevenuE 1,273,072 1,311,414 1,348,927 Less Meal Assumption 31,649 16,365 Z,7g2 (based on split of 75%,20%,5%) $ 1,278.133 $ 2,194,380 $ 902,850 Avg. $ 4,375,363 income Caiculation,per Budget: Revenue per Day(use semester instailments): Semester Totai: $2,194,380 Fall 20d4-110 Days Revenue per Day @ $ 1 g 859 Spring 2005-106 Days @ $ 20,702 Summer 1 -100 students @ $ 2,231 Summer 2-94 students @ $ �,958 Month Days Amount RA's Rents Sep-04 30 $ 595,759 $ 7,740 $ 603,499 Oct-04 31 $ 615,618 $ 7,740 $ 623,358 Nov-04 25 $ 496,466 $ 7,740 $ 504,206 Deo-04 1� $ 337,597 $ 7,740 $ 345,337 Jan-05 13 $ 269,122 $ 7,74Q $ 2�6,862 Feb-05 28 $ 579,648 $ 7,740 $ 587,388 Mar-05 24 $ 496,841 $ 7,740 $ 504,581 Apr-05 29 $ 600,349 $ 7,740 $ 608,089 ' May-05 12 $ 248,420 $ 7,74d $ 256,160 1 $ 2,231 $ 2,231 $ 258,391 Jun-05 28 $ 62,468 $ - $ 62,468 Jul-05 25 $ 48,950 $ - $ 48,950 Aug-05 12 $ 23,496 $ 23,496 Fa1106 $ 260,201 $ - $ 26Q,201 $ 283,697 TOTAL $4,595,408 Less: Estimated Pay Plan Credits $ (117,963) ' Meai Plan Credit $ (33,083) TOTAL GONTRACT REVENUE $4,444,363 Application Fee $25 Administration Fee None! Redecoration Fee Nane! Security Deposit None! Utili4y Deposits iVone! Accommodation ��als Single 5emester Ten P�r Week Instaliment{1) Installments(2) Installments{10) Four Bedroom Unlimited $8,900 $4,584 $943 14 Meals $8,705 $4,483 $923 7 Meais $8,51Q $4,383 $902 Efficiency Unlimited $10,910 $5,619 $1,156 {Single Occupancy) 14 Meals $10,715 $5,518 $1,136 7 Meals $10,520 $5,418 $1,115 ��,���r�a�� ���s�€��� ��;��� �3,�E�� �7�°� (�ct;�se�c;ce:;�ancy} � '����.-"c"N�� ��J'��� ��;��� �!'��� ..... 2��6����� ��y�'��} wr�y°.P�� ���,� �'�.��..._sa�.�£tE:E F_4<�.(f��'5,�;-'�t# z'.`���, ,'r _5?? . °_".L� :c.'..''� � �,��� .CC' '3� _, � - . �l' ..G�:� �"' ..�,��s_ ��� , ��r� .,.. : _ �t-....<t�'� w � .�r �_�;--:=t€',''s ��.:�.:'�� Two Bedroam Unlimited $6,900 $3,554 $731 (Double Occupancy) 14 Meals $6705 $3,453 $711 ' 7 Meals $6,510 $3,353 $690 1'elecam(Mandatary Fee} $400 $20d $40 Reserved Parking(Optional} $20d $100 $2Q Non Resenred Parking Free! ����� ���� �� ���� ����� , "Prices subject to change without notice Property�The Cambridge(¢,�College Station . Location: College Station,TX Payrofl T�ix%, 0.1195 401K% 1 Group Health per employee 250 �-erife':6 ull[re.�tinn per month 1i�mn[StidgetJ)aYe lile. �.. �, �. : , �`Aoors' �"Resi�ent� , ; . BUDGET YEpR ' . �� � �MPLOYE� STATUS"w•orked gCr ' itouriy � Employr¢ ; �, . .Se t„ -Oct-:, ,lYov: ,Uec':,, 7an '. Feb.�:. `Mar,f �p r{ � Mu" �r ,Tun l ,Jui�i Ao...� '�"oial ��-Departpretit� ' JOSTTI'I,ElpOSLTION I+1.A11TE � '�:,FT/p'�'` : week� Rate, (YfNj,: °'('otalSal�ry 0.0789 0.0769 0,0769 �01154 0.0788 0.0769 0.0789 .��0.0769 0.0769 0.0768 �0:1154 0.0783 I.00, AdminisMation General Mana er�� Jason�Fort �FT� 40 25;00. N �.52;000.���� 84,000 34,000 $4,000 $6,000 $4,000 54,000 $4,000 �,4,000 � Ass[.�Mana er. � $4,000 $4,000 $6,000 54,000 552,000� Lac Moore FT 40 t3.00 N 27,040 � $2,030 52,080 52,080 $3,120 $2,030 52,080 52,080 52,080 52,080 $2,080 53,120 52,080 $27,0q0 Leasin �Director . JessicaHemandez� FT 40 I6:58. � .��N ..22,000 ,� $t,692 51,692 $1,692 52,538 51,692 51,692 $1,692 51,692 St,692 51,692 52,538 �1,692 $22,000 �Rece[ionist-Ni�ht ��TBA FT 40 . 8..17� N .I7�,000 - $1,308 51,308 5I,308 $1,962 $1,308 S1,308 51,308 5t,308 51,308 ,�1,308 $1,962 51,308 $17,000 Rec tionist-Da�� �:TBA PT 20 6.73 .N 7;000� $538 5533 5538 5808 5538 5538 $538 Resideni Director. . Camille I{icks PT 20 4 81 � N : 5538 5538 $538 5808 5538 $7,000 5,000 $385 �385 5385 5577 5385 $385 $385 �385 5385 $38S 5577 $385 $5,000 � � � � .. ... . .��.�: 50 $0 ,T�O SO $0 $0 SO EO 50 $0 ^�0 SO $0 Towls 510,003 5I0,003 $10,003 5t5,005 SI0,003 510,OU3 $t0,003 5t0,003 $I0,003 510,Q03 $15,005 SI0,003 S(30,040 RentPayroli HeadHpusekec er: GloriaWilli�uns FT . 40� . .t0.50 N . 21,840�..� � £1,G80 �1,630 S�,G80 $2,520 51,650 St,680 51,680 51,b80 $1,630 51,680 52,520 $I,680 521,840 4 Housekee ers TBA FT . 40 .6:50 � N 54�,080 �.� $4,160 54,160 54,I60 b6,24U S4,Ifi0 54,160 �4,160 S4,160 $4,160 54,Iti0 p0n�' Jason�.B an � FT 40 7:50 N (5�,600. .� E1,200 SI,200 51,200 �1,800 51,200 SI,200 � ���2`�� 84,t60 $54,080 (IO R/A,'sSti end'. . Various pT i . �� 5�,200 $1,..00 5t,200 51,200 51,800 �1,200 $15,600 :�.#DN/0. .6;000�.-. $462 $4G2 5462 $692 $462 S4G2 $462 �462 5462 5462 $692 $462 $6,000 Totals 57,502 57,502 �7,502 511,252 57,502 $7,50? $7,502 57,502 S7,SU2 $7,502 $11,252 s,7,502 $97,520 Maintenance CeadMainlenance. Robert'Smit . P7 40 .t6:83� N� � 35,000�� . $2,G92 52,692 $2,692 £4,U38 52,692 52,692 52,692 52,692 2�ASSL.Main4� � THD�� :FT � 40 10:50 . N �A3,680�.;.. 53,360 $3,360 53,360 $5,040 $3,3G0 53,360 S3,3G0 $3,360 S3,360 53,360 $5,040 $3,360 g43,6S0 1'otals $6,052 $6,052 $6,05? $9,0�8 56,052 $6,052 56,052 56,052 $6,052 56,052 59,078 $6,052 $98,680 SO SO $0 $0 $0 SO $0 SO $0 $0 $0 $0 gp � $0 $0 $0 $0 $0 $0 $0 $0 $0 � SO SO £0 $0 $0 $0 SO $0 b0 SO SO 80 50 SO $0 $0 $0 P 50 50 $0 $0 SO $0 $0 $0 ;h0 $0 $0 $0 � 50 SO £0 SO SO SO ^y0 $0 X $0 SO $0 50 SO $0 �y " . 80 ^y0 $0 fip SO $0 $0 $0 $0 50 $0 $0 $o SO 50 �0 SO 50 $0 a0 $0 50 SO SO SO $0 � � $� �+� 50 $0 SO SO $0 SO 50 $0 $0 $0 $0 SO $0 50 � SO SO $0 $0 $0 50 SO SO $0 $0 � SO �0 $0 $0 SO $0 SO $0 SO $0 $0 � SO SO SO SO $0 $0 �0 $0 � S� SO SO $0 $0 $0 $0 � . $0 SO $0 �0 �0 SO �0 $0 ^�0 $0 ^y0 $0 $0 ' y . .. SO SO $0 SO SO $0 80 $0 .SO SO 50 80 $D 50 $0 $0 50 SO SO $0 SO $0 $0 $0 .SO $0 � 50 SO $0 50 SO SO $0 $0 50 $0 $0 $0 � $0 . $0 $0 SO 50 SO 50 $0 SO SO $0 SO �0 $0 s . . SO $0 ^�0 $0 SO $0 EO SO $0 SO T�0 $0 SO :.. �0 �� SO $0 $0 .SO SO 50 SO �0 $0 $0 $0 To[als... 50 SO FO $0 $0 SO $0 SO SO 50 30 .$0 $0 Miscellaneous Conunlssions . $4700 $3G2 5362 $362 5542 5Jti2 5362 $362 5362 $3G2 5362 Lauin eonus 5542 $3C2 $4,700 .�.$3,760�..... 5313 $3L3 5313 5313 5313 �313 $3(3 5313 $313 5313 $313 $3I3 $3,760 Totals S675 5675 5675 �856 Sfi75 5675 $675 $675 3G75 $675 $856 5615 $8,460 Totai 548,464 548,464 548,464 $72,382 $46,464 548,464 548,464 $a8,464 F48,464 548,464 $72,382 �48,4fi4 $314,700 Fuli Time Employees 9 FTEs (0 Days In Month 3D 31 Holidays #VALUE! Weekdays 22 22 Empipyees 29 Payroil Detail Weekend Days e g Rate Hrs Days Hrs Hrs Hrs Hrs Total $ $ $ $ Month Emp NA�9E Per Day Worked Reg Vac Hol Sick Hrs Reg Vac Nol Sick Totai Meals FS.MGR 4,416.67 1 1 1 1 4,416.67 - - - 4,416.67 20.00 AS M6R 2,333.00 1 1 1 1 2,333.00 - - - 2,333.00 20_00 S.VISOR - 1 7 1 - 1 - - - - - 20.00 COOK I 9.50 8 20 160 - - - 160 1,520.00 - - - 1,520.00 20.00 COOK II 9.50 8 20 160 - - - 160 1,520.00 - - - 1,520.00 20.00 COOIt III �J25 8 20 155 - - - 155 1,433.75 - - - 1,433J5 20.00 F!T GRILL CK AM 7,OQ 8 `LO 160 - - - 160 1,120.00 - - - 1,120.00 20.00 �?T SALADS 7.50 8 20 160 - - - 160 1,200.00 - - - 1,200.00 20.00 BAKER 9.25 8 20 160 - 160 1,480.00 - - - 1,480.00 F,�T SRVR/STRFRY 7.50 8 20 155 - - - 155 1,162.50 - - - 1,162.50 20.00 F/T SRVR.:STRFRY 2 7.50 8 20 155 - - - 155 1,162.50 - - - 1,162.50 - FrT RUNNER 6.25 8 20 160 - - - 160 1,000.00 - - - 1,000.00 - F!T GRI�LiSERVER P�'vt ^0]5 8 20 160 - - - 160 1,080.00 - - - 1,0$0.00 - F/T GRETlCHECKER 6-75 8 20 150 - - - 150 1,012.50 - - - 1,012.50 20.00 P/T GRET/CHECI<ER o.75 G 20 120 - - - 120 810.00 - - - 810.00 - F?T DISHES&POTS 6.25 8 ZO 160 - - - 160 1,000.00 - - - 1,000.00 20.00 FiT RUNNER 6,25 8 20 160 - - - 160 1,000.00 - - - t,0U0.00 20.00 Fi1 DISHES&POTS 625 8 20 160 - - - 160 1,000.00 - - - 1,000.00 - F;T DISHES&POTS 6.25 8 20 160 - - - 160 1,000.00 - - - 1,OQ0.00 - P%T CHECKER 6.50 11 4 42 - - - 42 273.00 - - - 273.00 - P!T CHECKER C.50 11 4 42 - - - 42 273.00 - - - 273.00 - PiT DISHES&POTS 6.25 8 2D 160 - - 160 1,000.00 - - - 1,000.00 - PT DISH NVFA - - 20 - - � _ _ P!T DISH MiFA - . zq _ _ . PiT POT W/A - - 10 - - - - - - - - - P,T DISH W.'P - - 10 - - - _ _ _ _ _ _ _ P/T POT W/P - - 10 - - - - - - - - - - Add Fuli Time 1 - - 20 - _ _ Add Full Time 2 - - 20 - . _ TotalslAverages 237.50 460 2,741 0 0 0 2,741 26,797 0 0 0 26 797 240 0 Days In Month 30 Holidays 1 NAME Weekdays 21 Employees 32 FS.MGR Weekend Days g �> Nourly Hrs Days Hrs Hrs Hrs Hrs Total $ $ $ $ Month Emp NAME Rate Per Day Worked Reg Vac Hoi Sick Hrs Reg Vac Hol Sick Total Meals FS.MGR 4,4�16.67 1 1 1 1 4,416.67 - - - 4,416.67 23.00 AS,MGR 2,333.OD 1 1 1 1 2,333.00 - - - 2,333.00 23.00 S.VISOR - 1 1 1 1 - - - - - 23.00 COOK I 9.50 8 20 160 - - - 160 1,520.00 - - - 1,520.OD 23.00 COOK II 9,50 8 20 160 - - 2 162 1,520.00 - - 19.00 1,539.00 23.00 COOK ill �J.25 8 20 155 - - 2 157 1,433.75 - - 18.50 1,452.25 23.00 F;T GRILL CK AA4 7.00 8 20 160 - - - 160 1,120.00 - - - 1,120.00 23.00 F?T SALA05 7.50 8 ZO 160 - - 2 162 1,200.00 - - 15.00 1,215.00 23.00 BAKER 9.25 8 20 160 - - 160 1,480.00 - - - 1,480.00 - F,'T SRVR/STRFRY 7.50 8 20 155 - - - 155 1,162.50 - - - 1,182.50 23.00 F!T SRVR/STRFRY 2 7.5Q 8 20 155 - - - 155 1,162.50 - - - 1,1G2.50 - F!T RUNNER 6.25 S 20 160 - - 160 1,000,00 - - - 1,000.00 - F;T GRI�USERVER PM 6J5 8 20 160 - - 160 1,080.00 - - - 1,080.00 - F/T GRET�CHEGKER 6]5 8 2D 15D - - 4 154 1,012.50 - - 27.00 1,039.50 23.00 Pr'T GRET(CHECKER 6.75 6 20 120 - - 120 810.00 - - - 810.00 - F�T DISHES&POTS 6.25 8 20 160 - - 2 162 1,000.00 - - 12.50 1,012.50 23.00 F!T RUNNER 625 8 20 16Q - - 2 162 1,000.00 • - 12.50 1,012.50 23.00 Fi7 DISHES&POTS G.25 8 20 160 - - 160 1,000.00 - - - 1,000.00 - F/T DISHES&POTS 6.25 8 20 160 - 160 1,000.00 - - - 1,000.00 - PiT CHECKER 6.50 11 4 42 - - - 42 273.00 - - - 273.00 - P/T CHECKER 6.50 11 d 42 - - - 42 273.00 - - - 273.00 - P/T OISHES&POTS 6.25 8 20 160 - - - 160 1,000.00 - - - 1,000.00 - PT DISH M/FA - - 20 - - - . _ _ _ _ _ _ P;`T DISH M/FA - - 20 - - - - - - - - - - PIT POT WiA - - 10 - - - _ . _ . _ . _ PiT DISH V�,'iP - - 10 - - - - - - - - - - P,rf POT W/P - - 10 - - - Add Fuli Time 1 - - 20 - . _ Add Fuli Time 2 - - 20 - - - - - - - • - - 20.00 237.50 2,741 0 0 14 2,755 26,747 0 0 105 28 901 296 0 Days In Month 27 Holidays 2 NAME Weekdays 20 Employees 29 FS.MGR Weekend Days 7 , �.,z Hourly Hrs Days Hrs Hrs Hrs Hrs Total $ $ $ $ Month Emp NAME Rate Per Day N.�orked Reg Vac Hol Sick Hrs Reg Vac Hol Sick Total Meals FS.MGR 4,416.ti7 1 1 1 1 4,416.67 - - - 4,416.67 21.00 AS.h9GR 2,333.00 1 1 1 1 2,333.00 - - - 2,333.00 21.00 S.VISOR - 1 1 1 - 1 - - 96.00 - 96.00 21.00 COOI<I 9.50 7 2Q 145 - 16 - 161 1,377.50 - 152.00 - 1,529.50 21.00 COOK II 9.50 7 20 145 - 16 1 162 1,377.50 - 152.00 9.50 1,539.00 21.00 COOK III 925 7 20 145 - 16 1 162 1,341.25 - 148.00 925 1,49$.50 21.00 FiT GRILL CK AM 7.D0 7 20 145 - 16 - 161 1,015.00 - 112.p0 - 1,127,00 21.00 F/T SALADS 7.50 7 ZD 145 - 16 - 161 1,087.50 - 120.00 - 1,207.50 - BAKER 9.25 7 20 145 - 16 161 1,341.25 - 148.00 - 1,48925 21.00 F;T SRVR/STRFRY 7.50 7 20 145 - 16 i 162 1,087.50 - 120.00 7.50 1,215.00 21.00 F!T SRVRiSTRFRY 2 7.50 7 20 145 - 16 2 163 1,087.50 - 120.00 15.00 1,222.50 21.00 FtT RUNNER 6.25 7 20 145 - 1G - 161 906.25 - 100.00 - 1,006.25 21.00 Fi?GRILLlSERVER PM 6J5 7 20 145 - '16 - 161 978.75 - 108.00 - 1,08675 - F.'T GRET/CHECKER 6.75 7 20 145 - 16 - 161 978.75 - 108.b0 - 1,086.75 - P.T GRET/CHECKER 6.75 6 20 120 - 16 4 140 810.00 - 108.D0 27.00 945.00 - F�?DISHES&POTS 6.25 7 20 145 - 16 - 161 90625 - t00.00 - 1,006.25 21.00 F!T RUNNER 625 7 20 145 - 16 1 162 906.25 - 100.00 6.25 1,012.50 - FIT DISHESE.POTS 6.25 7 20 145 - 16 1 162 906.25 - 100.00 "u.25 1,012.50 21.00 F;'�'DISHES&POTS G.25 7 20 145 - '16 - 161 906.25 - 100.00 - 1,006.25 21.00 PrT CHECKER 6.50 11 4 42 - - - 42 273.00 - - - 27C3.00 - P!T CHECKER 6.50 11 4 42 - - - 42 273.00 - - - 273.00 - P/T DISHES&POTS 6.25 8 16 128 - - - 128 800.00 - - - 800.00 - PT DISH MiFA - - 20 - - - - - - - - - - - P!T DISH M/FA - - 20 - - - - - - - - - - - P!T POT W,'A - - 10 - ' - - - - - - - - - PiT DISH b�/1P - - 10 - - - - - - - - - - - P'T POT W!P - - 10 - - - - - - - - - - - Add Full Time 1 - - 20 - - - - Acid Full Time 2 - - 20 - - - - TotaislAverages 237.50 456 2,509 0 256 11 2,776 25,109 0 1,992 81 27,182 294 0 Days In Month 97 Holidays 1 NAME Weekdays 13 Employees 32 FS.MGR Weekend Days 0. �... , , ��.., Hourly Hrs Days Hrs Nrs Hrs Hrs Totai $ $ $ $ Month Emp NAME Rate Per Day Worked Reg Vac Hol Sick Hrs Reg Vac Hol Sick Total Meals FS.MGR 4,416.67 1 1 1 1 4,416.67 - - • 4,416.67 9.00 AS.tviGR 2.333.00 1 1 1 1 2,333.00 - - - 2,333.00 9.00 S.VISOR - 1 1 1 - - 1 • - 95.8A - 95.84 9.00 COOK I 9.50 � 13 104 30 �16 - 150 988.00 2t35.00 152.00 - 1,425.00 9.00 COOK II 9.50 8 13 104 30 16 1 151 988.00 285.00 15200 9,50 1,434.50 9.00 COOK III 9.25 8 13 101 30 16 1 148 931.94 277,50 1a8.D0 925 1,366.69 9.00 F/T GRILL CK Alvi 7.00 t3 13 104 30 16 - 150 728.00 210.00 112.00 - 1,050.00 9.00 F!T SALADS 7.50 8 13 104 30 16 1 151 780.00 225.00 120.00 7.50 1,132.50 - BAKER �3.25 8 13 104 - - - 104 962.00 - - - 962.00 9.00 F!T SRVRlSTRFRY 7.50 & 13 101 - 16 1 118 755.63 - 120.00 7.50 883.13 9.00 F/T SRVR/STRFRY 2 7.50 8 13 101 30 16 - 147 755.63 225.00 120.G0 - 1,100.63 9.00 F!T RUNNER 6.25 8 13 104 30 16 - 150 650.00 187.50 t00.D0 - 937.50 9.00 FiT GRILUSERVER Pf�� 6.75 8 13 104 30 16 - 150 702.00 202.50 108.00 - 1,012.50 - F/T GRET/CHECKER &.75 8 13 98 30 16 - 144 658.13 202.50 108.00 - 968.63 - P,'7 GRET,�CHECKER &]5 6 13 78 30 16 1 125 526.50 202.50 108,00 675 843.75 - F;T DISHES&POTS 6.25 8 13 104 30 - - 134 650.00 187.50 - - 837.50 9.00 F!T RUNNER 6.25 8 13 104 30 16 1 151 650.00 187.5D 100.00 6.25 943.75 - FIT DISHES&POTS 6.25 8 13 104 30 16 1 151 650.00 187.50 100.00 625 943.75 9.00 Fr7 DISHES&POTS 625 S 13 104 104 650,00 - - - 65d.00 9.00 PiT CHECKER 6.50 11 4 42 - - - 42 273.00 - - - 273.00 - P/T CHECKER 6.50 11 4 42 - - - 42 273.00 - - - 273.00 - P!T DISHES&POTS 6.25 8 13 104 30 16 - 150 650.00 187.50 100.00 - 937.50 - PT DISH M/FA - - 2p - - - - - - - - - _ _ P!T DISH M/FA - - 20 - - - - - - - - - _ _ P/T POT N,UA - - 10 - - - - - - - - - - - PrT DISH W/P - - 10 - - - - - - - - - - - P;'T POT W/P - - 10 - - - - - - - - - - - Add Full Time 1 - - 20 - - - - . Add Full Time 2 - - 20 - - - - - #REF! #REFI #REFI #REF! #REFI nREF! #REF! #REF! #REF! #REFI �tREF: #REFi #REF! #REF! TotalsiAverages 88.24 340 1,811 420 224 7 2,462 15,555 3,053 �,744 53 20,404 117 0 Days In Month 14 Holidays 1 NAME Weekdays 10 Employees 32 FS.MGR Weekend Days 4 Nourly Hrs Days Hrs Hrs Hrs Hrs Totai $ $ $ $ Month Emp NAN1E Rate Pei Day Worked Reg Vac Hol Sick Hrs Reg Vac Nol Sick Total Meais FS.M�R 4,416.67 1 1 1 1 4,416.67 - - - 4,418.67 17.00 AS.MGR 2.333.00 1 1 1 1 2,333.00 - - - 2,333.00 17.00 S VISOR - 1 1 1 • - 1 - - - - - 17.00 COOK I 9.50 8 10 80 - 8 88 760.00 - 76.00 - 836.00 17.00 COQK II 9.50 8 10 80 - 8 1 89 760.00 - 76.00 9.50 $45.50 17.00 COOK Iil 9.25 8 10 78 - 8 1 87 716.88 - 74.00 9.25 800.13 17.00 FiT GRILL CK Ah4 7.OQ 8 10 80 - 8 - 88 560.00 - 56.00 - 616.00 17.00 F/T SALADS 7.50 8 10 80 - 8 1 89 600.00 - 60.Q0 7.50 667.50 - BAKER 9.25 8 10 80 - 8 - 88 740.00 - 74.00 - 814.00 17.00 Fr'T SRVR/STRFRY 7.50 8 10 78 - 8 1 87 581.25 - 60.00 7.50 648.75 17.00 F!T SRVRtSTRFRY 2 7.50 8 70 78 - 8 - 86 581.25 - 60.00 - 641.25 17.00 f=/T RUNNER 6.25 8 10 80 - 8 - 88 500.00 - 50.00 - 550.00 17.Op F;T GRILLiSERVER PM 6.75 8 1U 80 - 8 - 88 540.00 - 54.00 - 594.00 - FtT GRETiCHECKER 6.75 8 10 75 - 8 - 83 50625 - 54.00 - 560.25 - PJT GRET/CHECKER 6.75 6 10 60 - 8 - 68 405.00 - 54.00 - 45�3.00 - F,�"( DISHES&POTS 6.25 8 10 80 - 8 - 88 500.00 - 50.00 - 550.00 17.00 F/T RUNNER 6.25 8 10 80 - 8 1 89 500.00 - 50.00 6.25 556.25 - FIT DISHES&POTS 6,25 8 10 80 - 8 1 89 500.00 - 5Q.00 6.25 556.25 - F,Jf 61SHES3POTS 6.25 8 10 80 - 8 - 88 500.00 - 50.00 - 550.00 17.00 PiT CHECKER 6.50 11 4 42 - - - 42 273.00 - - - 273.00 17.00 PiT CHECKER 6.5D 11 d 42 - - - 42 273.00 - - - 273.00 - P/T DISHES&POTS 625 8 8 64 - - - 64 400.00 - - - 40Q.00 - PT QISH M/FA - - 20 - - - - - - - - - - - P,`T DISH M/FA - - 20 - - - - - - - - - - - P/T POT+N;A - • 10 - - - - - - - - - - - PiT DISN Vb�/P - - iD - - - - - - - - - - - P;'T POT W/P - - 10 - - - - - - - - - - - Add Fuli Time 1 - - 20 - - - - Add Fuli Time 2 - - 20 - - - - #REF! ;REFI rREFi #REF! - - - #REF! t{REF! #REF! #REF! �REF! #REF! #REF! TotalslAverages 237.50 288 1,398 0 128 6 1,532 16,946 0 948 46 17,941 238 0 Days In Month 28 Holidays 0 NAME Weekdays 20 Employees 32 FS.MGR Weekend Days 8 Hourly Hrs Days Hrs Hrs Nrs Hrs Total $ $ $ $ Month Emp NAME Rate Per Day Worked Reg Vac Hal Sick Hrs Reg Vac Hoi Sick Total Meals FS.P�nGR 4,416.G7 1 1 1 1 4,416.87 - - - 4,416.67 20.00 AS.h96R 2,333.00 1 'I 1 1 2,333.00 - - - 2,333.00 20.00 S,VISOR - 1 1 1 - - 1 - - - - - 20.00 COOK I 9.50 8 20 160 - - 160 1,520.00 - - - 1,520.00 20.00 COOK II 9.50 8 20 160 - - 1 161 1,520.00 - - 9.50 1,529.50 20.00 C004<III 9.25 8 20 155 - - i 156 1,433.75 - - 925 1,443.00 20.00 F;T GRILL CK AA�1 7.00 8 20 160 - - - 160 1,120.00 - - - 1,120.00 20.00 F!T SALADS 7.50 B 20 160 - - 1 761 1,200.00 - - 7.50 1,207.50 - BAKER 9.25 8 20 160 - - - 160 1,480.00 - - - 1,480.00 20.00 Fi'f SRVRlSTRFRY 7.50 8 20 155 - - 1 156 1,162.50 - - 7.50 1,170.00 20.00 F!T SRVRiSTRFRY 2 7.50 8 20 155 - - - 155 1,162.50 - - - 1,162.50 20.00 FiT RUNNER G.25 8 20 160 - - - 160 1,000.00 - - - 1,000.00 20.00 FTGRIWSERVERPti� 8.75 8 20 160 - - - 160 1,080.00 - - - 1,080.00 - F.�T GRETlCHECKER 6.75 8 ZO 150 - - - 150 1,012.50 - - - 1,012.50 - P,'T GRETICNECKER 6.75 6 20 120 - - 2 122 810.00 - - 13.50 823.50 - F,'T DISHES&POTS 6.25 8 20 160 - - - 160 1,000.00 - - - 1,000.00 20.00 F!T RUNNER 6.25 8 20 160 - - - 160 1,000.00 - - - 1,000.00 - F/T DISHES&POTS 6.25 8 20 160 - - 1 161 1,000.00 - - 6.25 1,006.25 - F;T DISHES&POTS 625 8 20 160 - - I 161 1,000.00 - - 0.25 1,006.25 20.00 P;7 GHECKER 6.50 11 4 42 - - - 42 273.00 - - - 273.00 20.00 P.�T CHECKER 6.50 11 4 42 - - - 42 273.00 - - - 273.00 - P!T DISHES&POTS 6.25 8 20 160 - - - 160 1,000.00 - - • 1,000.00 - PT DISH MlFA - - 20 - - - - - - - - - - - P.rf DISH M/FA - - 20 - - • - - - - - - - - P!T POT WiA - - 10 - - - - - - - - - - - PiT DISH WiP - - 10 - - - - - - - - - - - P!T POT W1P - - 10 - - - - - - - - - - - Add Full Time 1 - - 20 - - - - Adtl Full Time 2 - - 20 - - - - #REFI #REF! i#REFI #REF! - - - #REF! #REF! #REF! #REF! #REF! #REF! #REF! Totais/Averages 237.50 A60 2,741 0 0 8 2,749 26,797 0 0 60 2G,857 280 0 Days In Mon4h 22 Holidays 0 NAME Weekdays 18 Employees 32 FS.MGR Weekend Days 4 Houriy Hrs Days Hrs Hrs Hrs Hrs Total $ $ $ $ Month Emp NA�AE Rate Per Day Worked Reg Vac Hol Sick Hrs Reg Vac Hol Sick Total Meals FS.MGR 4,�1'16.67 1 1 1 1 4,416.67 - - - 4,416.67 16.00 AS.b9GR 2,333.00 1 1 1 1 2,333.00 - - - 2,333.00 16.00 S.VISOR - 1 1 1 - - 1 - - - - - 16.00 COOK I 9.50 8 15 120 - - 120 1,140.00 - - - 1,140.00 16.00 COQK II 9.50 8 15 120 - - 1 121 1,140.00 - - 9.50 1,14y.50 16.00 COOt<III 9.25 8 15 116 - - 1 117 1,075.31 - - 925 1,084,56 16.00 F7T GRIL�CK AM 7.OG II 15 120 - - - 120 840.00 - - - 84Q.00 16.00 F1T SALADS 7.56 8 15 120 - - 1 121 900.00 - - 7.50 907.50 - BAKER 9.25 8 15 120 - - - 120 1,110.00 - - - 1,110,00 18.00 FiT SRVRISTRFRY 7.50 8 15 116 - - 1 117 871.88 - - 7.50 879.38 16.00 F!T SRVRlSTRFRY 2 7.50 8 15 116 - - - 116 871.88 - - - 87'1.88 . 16.00 FiT RUNNER 625 8 15 120 - - - 120 750.00 - - - 750.00 16.00 FrT GRILL/SERVER PM 675 8 15 120 - - - 120 810.00 - - - 810.00 - F!T GRET!CHECKER 6.75 8 15 113 - - - 113 759.38 - - - 759.38 - P!T GRETlCHEGKER 675 6 15 90 - - 4 94 607.50 - - �7.OD 63A.50 - F,T DISHES&POTS 6.25 8 15 120 - - - 120 750,00 - - - 750.00 16.00 F!T RUNNER 6.25 8 15 120 - - 1 121 750.00 - - 6.25 75625 - F!T DISHES&POTS 625 8 15 120 - - 1 121 750.00 - - 625 756.25 - F�'T DISHESSPOTS 6.25 8 15 120 - - - 120 750.00 - - - 75Q00 16.00 PiT CHECKER 6.50 11 3 32 - - - 32 204.75 - - - 204.75 16.00 P,r(CNECKER 6.50 11 3 32 - - - 32 204.75 - - - 204.75 - P/T DISHES&POTS 625 F3 12 96 - - - 96 600.00 - - - 600.00 - PT DISH M(FA - - 20 - - - - - - - ' ' ' " p�T DISH MiFA - - 2� - - ' ' ' " " " - ' " P/T POT WiA - - 10 - - - - - - - - - - - PiT DISH W/P - - 10 - - - - - - - - - - - P(T POT WtP - - 1� - - - - - - - - - - - Add Full Time 1 - - 2� - ' ' " Add Full Time 2 - - 2� - ' ' " #REF! �iREF! #REF! #REF! � - - #REF! #REF! #REF! #REFI #REF! #REF! #REF! Totals/Averages 237.50 370 2,032 0 0 10 2,042 21,635 0 0 73 21,708 224 0 Days In Month 30 Holidays 1 NAPvtE Weekdays 2� Employees 32 FS.MGR Weekend Days 9 Hourly Hrs D2ys Hrs Hrs Hrs Hrs Total $ $ $ $ Montih Emp NAME Rate Per Day Worked Reg V�c Hol Sick Hrs Reg Vac Hol Sick Total Meals FS.MGR 4,416.67 1 t 1 1 4,416.67 - - - 4,416.67 21.00 AS.MGR 2.333,00 1 1 1 1 2,333,00 - - - 2,333.00 21.00 S.�/ISOR - 1 1 1 - - 1 - - - - - 21.00 COOK I 9.50 8 20 160 - - 160 1,520.00 - - - 1,52Q.00 21.00 CUOK II 9.50 8 20 160 - - 1 161 1,520.00 - - 9.50 1,529.50 21.00 COOK III 9.25 8 20 155 - - 1 156 1,433.75 - - 925 1,443.00 21.00 FiT GRILL CK AN9 7.U0 8 20 160 - - - 160 1,120.00 - - - 1,120.00 21.00 F!T SALADS 7.50 8 20 160 - - - 160 1,200.00 - - - 1,200.00 - BAKER 9.25 II 20 160 - - - 160 1,480.00 - - - 1,48d.00 21.00 F�T SRVR!STRFRY 7.50 8 2D 155 - - 1 156 1,162.50 - - 7.50 1,170.00 21.00 F/T SRVRISTRFRY 2 7.50 8 20 155 - - - 155 1,162.50 - - - 1,162.50 21.00 F/T RUNNER 6.25 8 20 160 - - - 160 1,000.00 - - - 1,000.00 21.00 F,rf GRIL�!SERVER PNI "0.75 $ 20 160 - - - 160 1,080.00 - - - 1,080.00 - F/T GRET/CHECKER 6.75 8 20 150 - - - 150 1,012.50 - - - 1,012.50 - PiT GRET!CHECKER 6.75 6 20 120 - - 2 122 810.00 - - 13.50 823.50 - F/T DISHES&POTS 6.25 8 20 160 - - 160 1,000.00 - - - 1,000.00 21.00 F�T RUNNER 6.25 8 20 160 - - 1 161 1,000.00 - - 12.50 1,012.50 - F/T DISHES&POTS 625 8 20 160 - - 1 161 1,000.00 - - 6.25 1,006.25 - FiT DISHES&POTS 6.25 8 20 160 - - 160 1,000.00 - - - 1,000.00 21.00 PrT CHECKER 6.50 11 4 42 - - 42 273.00 - - - 273.00 21.00 PrT CHECKER 6.50 11 4 42 - - - 42 273.00 - - - 273.00 - PJT DISHES&POTS 6.25 8 16 128 - - - 128 800.00 - - - 80U.00 - PT�ISH M/FA - - ZO - - - - - - - - - - - P;'T D15H M/FA - - 2� - - - - - - - - - - - P/T POT b11;A - - �fl - - - - - - � - - - - PiT DISH WiP - - 1� - - - - - - - - - - - P,�T POT W/P - - 10 - - - - - - - - - - - Add Fuil Time 1 - - �� - ' - - Add Full Time 2 - - L� - " - #REF! #REFI #REF! #REF! - - - #REF! #REF! #REF! #REF' #REFi #REF! #REF! TptalslAverages 237.50 456 2,709 0 0 7 2,716 26,597 0 0 59 26,655 294 0 Days i�Month 13 Holidays 1 NAME Weekdays 9 Employees 32 FS.MGR Weeke�d Days q ;,:, . Hourly Hrs Days Hrs Hrs Hrs Hrs Total $ $ $ $ Month Emp NAME Rate Per Day Worked Reg Vec Hol Sick Hrs Reg Vac Hol Sick Total Meals FS.MGR 4,4'16.G7 1 1 1 1 4,416.67 - - - 4,416.67 9.00 AS.ti7GR 2,333.00 1 1 1 1 2,333.00 - - - 2,333.00 9.00 S.VISOR - 1 1 1 - - 1 - - - - - 9.00 COOK I 9.50 8 10 80 - 8 88 760.00 - 76.OQ - 83G.00 9,00 COUK il 9,50 8 10 80 - 6 - 88 760.00 • 76.00 - 836.00 9.00 COOK III 925 8 10 78 - 8 - 86 716.88 - 74.00 - 790.88 9.00 F/T GRILL CK AAq 7.U0 S 10 80 - II - 88 560.00 - 56.00 - 616.00 9.00 F!T SALA�S 7.50 8 10 80 - S - 88 600.00 - 60.00 - 660.00 - BAf<F_R 925 8 10 80 - 8 - SS 740.00 - 74.00 - 814.00 9.00 FiT SRVR(STRFRY 7.50 H 10 78 - 8 - 86 581.25 - 60.00 - 641.25 9.00 FIT SRVR;STRFRY 2 7.50 8 10 78 - 8 - 86 581.25 - 60.00 - 641.25 9.00 F/T RUNNER G.25 8 10 80 - 8 - 88 500.00 - 50.00 • 550.00 9.00 F;-f GRILUSERVER PM 6.75 8 10 80 - 8 - 88 760.00 - 54.00 - 814.00 - F!T GRET/CHECKER 6.75 8 �0 80 - 8 - 88 760.00 - 54.00 - 814.00 - P,�T GRET,�CHECKER 6.75 6 10 78 - 8 - 86 716.88 - 54.D0 - 77p,gg _ F;T DISHES&POTS 6.25 8 70 80 - 8 - 88 560.D0 - 50.00 - 610.00 9.00 F!T RUNNER 6.25 8 10 80 - 8 - 88 600.00 - 50.00 - 650.00 - F/T pISHES&POTS G25 8 10 80 - 8 - 88 740.00 - 50.00 - 790.00 � - F(T DISHES&POTS 625 8 70 78 8 86 581.25 50.00 631.25 9.00 PiT CHECKER 6.50 11 2 78 - 86 581.25 - 581.25 9.00 P!T CHECKER 6.50 11 2 80 - - - 88 500.00 - - - 500,00 - P!T pISHES&POTS "0.25 S 8 80 - - - 88 540.00 - - - 540.00 - PT DISH MiFA - - 20 75 - - - 88 540.00 - - - 540.00 - P'T DISH MJFA - - 2p 60 - - - 86 523.13 - - - 523.13 - P/T POT WiA - - 10 BO - - - 88 500.00 - - - 500.00 - Pt?DISH W;P - - 10 80 - - - 88 500.00 - - - 500.00 - P/T POT W/P - - 10 80 - - - 88 500.00 - - - 500.00 - Add Full Time 1 - - 20 - _ _ Add Full Tirne 2 - - �p _ _ _ . #REF! #REF! �REF! #REF! - - - #REF! #REF! #REFI #tREF� #REF! #REF� #REF� Totais/Averages 237.50 284 1,882 0 128 0 2,097 2�,452 0 948 0 22,400 126 0 Days in Month 30 Ho�idays p NAME Weekdays 22 Employees 32 FS.MGR Weekend Days g Hourly Hrs Days Hrs Hrs Hrs Hrs Total $ $ $ $ Month Emp NAME Rate Per Day Worked Reg Vac Hol Sick Hrs Reg Vac Hol Sick Total Meals FS.MGR 4,a16.67 1 1 1 1 4,416.67 - - 4,416.67 20.00 AS.MGR 2,333.OQ 1 1 1 1 2,333.00 - - 2,333,Op 20.00 S.VISOR - 1 1 1 - - 1 - - - 20.00 COOK I 9.50 8 20 160 - COOK II g 50 8 L ' 160 1,520.00 - - - 1,520.00 20.00 0 160 - - 2 162 1,520.00 - - 19.00 1,539.00 20.00 COOK III 9,25 8 20 155 - - 2 157 1,433.75 - - 1�.50 1,452.25 - F1T GRIL�CK AAi 7,OU 8 20 160 - - - 160 1,120.00 - - 1,120.00 20.00 F!T SALADS 7.50 8 20 160 - - - 160 1,200.00 - - - 1,200.00 BAKER 9.25 8 20 160 - - - 160 1,480.00 FiT SRVR/STRFRY 7.50 8 20 155 - - 2 157 1,162.50 - - 15.00 1,177.50 20.00 F!T SRVR!STRFRY 2 7.50 8 20 155 - - 2 157 1,162.50 - - 15.00 1,177.50 20.00 FiT RUNNER 6.25 8 20 160 - - - 160 1,000.00 - - - 1,OOO.pO 20.00 F;T GRILLISERVER PM 6.75 8 20 160 - - - 180 1,080.00 - - - 1,O8b.00 F/T GRET!CHECKER 6.75 8 20 150 - - - 150 1,012,50 - - - 1,012.50 P.�T GRET.�CHECKER 6.75 6 20 120 - - 4 124 810.00 - - 27.00 837.00 F,T DISHES&POTS 625 8 20 160 - - - 160 1,000.00 - - - 1,000.00 20.00 F!T RUNNER 6.25 B 2D 160 - - 2 162 1,000.00 - - 12.50 1,012.50 F/T DISHES&POTS 6.25 8 20 160 • - 2 162 1,000.00 - - 72,50 1,012.50 F;T DISHES&POTS 6 25 8 20 160 - - - 160 1,000.00 - - - 1,OOD.00 20.00 P;T CHECKER 6.56 11 4 42 - - - 42 273.00 - - - 273.00 20.00 I''T CNECKER 6.5U 11 4 42 42 273.00 P!T DISFIES&Pp75 6.25 8 20 160 - - - 160 1,000.00 - - - 1,000.00 - PT DISH MiFA - - �p - - - - - - - P,(T DISH M/FA _ _ 20 � P/T POT b'V;A - - 10 - - - - - - - PrT DISH WiP - - 10 - - - - - . , _ - - PrT POT W!P - - �0 - - - - Add Full Time 1 _ _ Zp _ � Add Full Time 2 _ _ �p #REF! #REFI #REF! #REF! - - - #REF! #REF! #REF! #REF! #REF! #REF! #REF! Totals/Averages 237.50 460 2,741 0 0 16 2,757 26,797 0 0 120 25,163 240 � �ays In Month 30 Halidays � NAME Weekdays 21 Empioyees g2 FS.MGR Weekend Days g j Hourly Hrs Days Hrs Hrs Hrs Hrs Total $ $ $ $ Month Emp NAME Rate Per pay Worked Reg Vac Hol Sick Hrs Reg Vac Hol Sick Total Meals FS.MGR 4,416.67 1 1 1 1 4,416.67 - 4,416.67 16.00 AS.MGR 2,333 00 1 1 1 1 2,333.00 2,333.00 16.00 S VISOR - 1 1 1 - - 1 - - 95.00 95.00 16.00 CC)OK I 9.50 8 20 160 - H 168 1,520.Q0 - 76.00 1.596.00 16.00 GGOK II 9.50 8 20 160 - & 1 169 1,520.00 - 76.00 9 50 1,605.50 16.00 CpOK ill 9.25 8 20 155 - 8 1 164 1,433.75 - 74.00 925 1,517.00 16.00 FrT GRILL CK AN1 Z00 8 20 160 - 8 - 168 1,120.00 - 56A0 1,176.00 16.00 F/T SALADS 7.50 8 20 160 - 8 1 169 1,200.00 - 60.00 7.50 1,267,50 BAKER 9.25 8 'LO 160 - 8 - 168 1,480.00 - 74.00 - 1,554.00 16.00 FrT SRVRlSTf2FRY 7.50 8 20 155 - F3 1 164 1,162.50 - 60.00 7.50 1,230.00 16,00 F�`T SRVRISTRFRY 2 7.5p 8 20 155 - S - 163 1,162.50 - 60.00 1,222.50 16,00 F/7 RUNNER 625 8 20 160 - 8 - 168 1,000.00 - 50.00 - 1,050.00 16.00 F;T GRILL/SERVER PM 6.75 8 20 160 - 8 - 168 1,080.00 - 54.00 1,134.00 F!T GRET/CHECKER 6.�5 8 2D 150 - 8 - 158 1,012.50 - 54.00 - t,Ofi6.50 P.'T GRETrCHECKER 6.75 6 20 120 - 8 2 130 810.00 - 54.00 13.50 877.50 Fr?DISHES&POTS 6.25 8 20 160 - 8 - 168 1,000.00 - 50.00 1,050.00 16.00 F!T RUNNER 625 8 ZO 160 - 8 1 169 1,000.00 - 50.00 6.25 1,056.25 FiT DISHES&POTS 6.25 8 20 160 - 8 1 169 1,000.00 - 50.00 6.25 1,056.25 16.00 FrT DISHES&POTS 625 $ 20 160 - 8 - 168 1,000.00 - 50.U0 1,050.00 16.00 PiT CHECKER 6.5p 11 � 42 - - - 42 273.00 - - 273.00 P.'T CHECKER 6.50 11 4 42 - - - 42 273.00 - - 273.00 P/T pISHESt�POTS o.25 8 20 160 - - - 160 1,000.00 - - 1,000.00 PT pISH MiFA _ . •`0 _ " - P,�DISN MiFA - - 20 - - _ - - - - - - - PIT POT WiA - • 10 - - - � - PiT DISH Vb'r'P - - 10 - - - _ - - - - - - - PiT POT W/P - - 10 , Add Full Time 1 _ _ Zp _ " ' Add Fuii Time 2 _ - �0 - ' #REF! r+REF! #REF! #REF! Totals/Averages 237,50 460 2,741 0 128 8 2,877 26,797 0 1,043 60 27,900 224 Days In Month 24 Holidays � NAME Weekdays 18 Employees 32 FS.MGR Weekend Days g �.i:��.}-t� Hourly Hrs Days Hrs Hrs Hrs Hrs Total $ $ $ $ Month Emp NAME Rate Per Dav VVorked Reg Vac Hol Sick Hrs Reg Vac Hol Sick Totai Meals FS.MGR 4,416.67 1 1 1 �, 1 4,416.67 - - - 4,416.67 22.00 AS.h9GR 2,333.00 1 I 1 1 2,333.00 - - - 2,333.00 22.00 S.VISOR - 1 1 1 . - 1 - - - - - 22.00 COOK I 9.50 8 1ei 128 - - 128 1,216.00 - - - 1,216.00 22.00 COOK II 9.50 8 16 128 - - - 128 1,216.00 - - - 1,216.00 22.00 COOK III 9.25 8 16 124 - - - 124 1,147.00 - - - 1,147.00 - F;T GRILL CK AA+1 7.00 8 76 128 - - - 128 896.00 - - • 896.00 22.00 F.�T SALAD.�'i 7.50 8 16 128 - - - 128 960.00 - - - 960.00 - 6AKER 9.25 & 16 128 - - - 128 1,154.00 - - - 1,184.00 22.00 F;T SRVR/STRFRY 7.50 B 76 124 - - - 124 930.00 - - - 930.00 - F!T SRVRiSTRFRY 2 7.50 8 16 124 - - - 124 93p.00 - - - 930.00 - F!T RUNNER 6.25 8 16 128 - - - 128 800.00 - - - 800.00 22.00 F;?GRI�L/SERVER FM 6J5 8 16 128 - - - 128 864.00 - - - 864.00 - F/TGRET/CHECKER 6.75 8 1� 120 - - - 120 810.00 - - - 810.00 - P1T GRETICHECKER 6.75 6 16 96 - - - 96 648.00 - - - 648.00 - F�`T piSHESc�PO7S 6.25 II 76 128 - - - 128 800.00 - - - 800.00 - F/T RUNNER 6.25 8 16 128 - - - 128 800.00 - - - 8p0.00 - FiT DISHES&P07S 6.25 8 16 128 - - - 128 800.00 - - - 8q0.00 Fi I'DISNES&POTS 6.25 8 76 128 - - - 128 800.00 - - - 800.00 22.00 P!T CHECKER 6.50 17 3 32 - - - 32 204.75 - - - 204.75 - P!T CHECKER 6.50 11 3 32 - - - 32 204.75 - - - 204.75 - P/T DISHES�POTS 6.25 8 72 96 - - - 96 600.00 - - - 600.00 - PT DISH MiFA - _ �p _ . _ _ _ _ _ _ P/T DISH M(FA - - 20 - - - _ _ , _ . _ _ _ P7T POT UViA - - 10 - - - - - - - - - - - PiT DISH WiP - - 10 - - - - - - - - - - - P!T POT W!P - - 10 - - - - - - - - - - - Add Fuli Time 1 . _ Zp _ _ . Add Full Tirne 2 - - 20 - - - #REF! �REF: MREF! #REF! - - - #REF! #REF! #REF! #REF: rREFI i #REF #REF! TotalslAverages 237.50 386 2,157 0 0 0 2,157 22,560 0 0 0 22,560 198 TOTAL REG LABOR 283,839