+1 (951) 902-6107 info@platinumressays.com

P&L mock Exercise

The instructions are provided in the last sheet of the excel file attached. Please provide the reasoning for the workings and why they have been done. 

SUMMARY

Current Period Year to Date
Actual Adjusted Budget Original Budget Actual Adjusted Budget Original Budget
COA $ % POR $ % POR $ % POR $ % POR $ % POR $ % POR
SUMMARY
AVAILABLE ROOMS 4774 4774 4774 32648 32648 32648
ROOMS SOLD 3391 3391 2821 17212 17212 18655
OCCUPIED ROOMS 3406 3406 2821 17319 17319 18655
OCCUPANCY % 71.03 71.03 59.09 52.72 52.72 57.14
AVERAGE DAILY RATE 119.36 119.36 112.1 115.53 115.53 110.46
REVPAR 84.78 84.78 66.24 60.91 60.91 63.12
# DAY IN PERIOD 31 31 31 212 212 212
DEPARTMENTAL REVENUE
ROOMS MULTIPLE 404740.32 0.9106538041 118.8315678215 404740.32 100 118.8315678215 316225.27 0.8872765645 112.0968699043 1988541.45 0.9085453135 114.8184912524 1988541.45 100 114.8184912524 2060608.77 0.884925383 110.4587922809
FOOD & BEVERAGE MULTIPLE 25704.58 0.0578345482 7.546852613 25704.58 100 7.546852613 32449.09 0.0910468575 11.5026905353 141043.98 0.0644416273 8.1438870605 141043.98 100 8.1438870605 216773.13 0.0930928995 11.620108818
MINOR OPERATED DEPARTMENTS MULTIPLE 14005.36 0.0315116477 4.1119671169 14005.36 100 4.1119671169 7725.53 0.021676578 2.7385785183 59123.73 0.0270130591 3.4138073792 59123.73 100 3.4138073792 51185.92 0.0219817175 2.7438177432
TOTAL DEPARTMENTAL REVENUE 444450.26 100 130.4903875514 444450.26 100 130.4903875514 356399.89 100 126.3381389578 2188709.16 100 126.376185692 2188709.16 100 126.376185692 2328567.82 100 124.8227188421
DEPARTMENTAL EXPENSES
ROOMS MULTIPLE 89836.74 0.2219614295 26.3760246624 105435.13 0.8520569947 30.9557046389 94011.43 0.2972925914 33.3255689472 567132.54 0.2852002607 32.7462636411 558942.58 1.0146525963 32.2733749062 623432.83 0.3025478873 33.4190742428
FOOD & BEVERAGE MULTIPLE 12457.24 0.4846311436 3.6574398121 15542.69 0.8014854572 4.5633264827 14066.29 0.4334879653 4.9862779156 67726.43 0.4801795156 3.9105277441 91899.08 0.7369652667 5.3062578671 95636.64 0.4411830931 5.1265955508
MINOR OPERATED DEPARTMENTS MULTIPLE 3772.95 0.2693932894 1.1077363476 3212.32 1.1745249539 0.943135643 3173.58 0.4107912337 1.1249840482 11289.95 0.1909546302 0.6518823258 14629.17 0.7717423477 0.8446890698 20986.98 0.4100147072 1.1250056285
TOTAL DEPARTMENTAL EXPENSES 106066.93 0.2386474698 31.1412008221 124190.14 0.8540688496 36.4621667645 111251.3 0.3121530144 39.436830911 646148.92 0.2952191784 37.308673711 665470.83 0.9709650534 38.4243218431 740056.45 0.3178161459 39.6706754221
DEPARTMENTAL PROFIT
ROOMS 314903.58 0.7780385705 92.4555431591 299305.19 1.0521153342 87.8758631826 222213.84 0.7027074086 78.7713009571 1421408.91 0.7147997393 82.0722276113 1429598.87 0.9942711482 82.5451163462 1437175.94 0.6974521127 77.0397180381
FOOD & BEVERAGE 13247.34 0.5153688564 3.8894128009 10161.89 1.3036295414 2.9835261304 18382.8 0.5665120347 6.5164126196 73317.55 0.5198204844 4.2333593164 49144.9 1.4918648731 2.8376291934 121136.49 0.5588169069 6.4935132672
MINOR OPERATED DEPARTMENTS 10232.41 0.7306067106 3.0042307692 10793.04 0.94805634 3.1688314739 4551.95 0.5892087663 1.61359447 47833.78 0.8090453698 2.7619250534 44494.56 1.0750478261 2.5691183094 30198.94 0.5899852928 1.6188121147
TOTAL DEPARTMENTAL PROFIT 338383.33 0.7613525302 99.3491867293 320260.12 1.0565890314 94.0282207868 245148.59 0.6878469856 86.9013080468 1542560.24 0.7047808216 89.0675119811 1523238.33 1.0126847583 87.951863849 1588511.37 0.6821838541 85.15204342
UNDISTRIBUTED EXPENSES
ADMINISTRATIVE & GENERAL MULTIPLE 27363.4 0.0615668444 8.0338813858 33364.55 0.8201339446 9.7958162067 35056.18 0.0983619271 12.4268628146 238281.55 0.1088685305 13.7583896299 212784.26 1.1198269552 12.2861747214 244027.08 0.1047970679 13.0810549451
SALES & MARKETING MULTIPLE 24665.58 0.0554968288 7.2418027011 34190.01 0.721426522 10.0381708749 29424.96 0.0825616416 10.4306841546 165825.37 0.0757640042 9.5747658641 193897.22 0.8552230403 11.1956360067 200397.02 0.0860602033 10.7422685607
REPAIRS & MAINTENANCE MULTIPLE 8470.92 0.0190593206 2.4870581327 10131.6 0.8360890679 2.9746330006 9390.58 0.0263484369 3.3288124778 156234.17 0.0713818779 9.0209694555 62338.7 2.5062147591 3.5994399215 64214.8 0.0275769507 3.4422299652
UTILITIES MULTIPLE 10951.26 0.0246400126 3.2152847915 24736.72 0.4427126959 7.2626893717 21572.98 0.0605302656 7.647281106 112873.77 0.0515709314 6.5173376061 117593.89 0.9598608397 6.7898775911 122784.54 0.0527296388 6.5818568748
SUPPORT FEES MULTIPLE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL UNDISTRIBUTED EXPENSES 71451.16 0.1607630064 20.9780270112 102422.88 0.6976093623 30.0713094539 95444.7 0.2678022712 33.833640553 673214.86 0.307585344 38.8714625556 586614.07 1.1476282183 33.8711282407 631423.44 0.2711638607 33.8474103458
GROSS OPERATING PROFIT 266932.17 0.4805895238 78.3711597181 217837.24 1.2253743667 63.9569113329 149703.89 0.4200447144 53.0676674938 869345.38 0.3971954775 50.1960494255 936624.26 0.9281687621 54.0807356083 957087.93 0.4110199934 51.3046330742
MANAGEMENT FEES MULTIPLE 22186.42 0.0499187918 6.5139224897 22331.53 0.9935020126 6.5565267176 17819.99 0.0499999874 6.3169053527 109306.1 0.0499408976 6.3113401467 109708.49 0.9963321891 6.3345741671 116428.39 0.0499999996 6.2411358885
INCOME BEFORE NON-OPERATING INCOME & EXPENSES 244745.75 0.550670732 71.8572372284 195505.71 1.2518598562 57.4003846154 131883.9 0.370044727 46.7507621411 760039.28 0.34725458 43.8847092788 826915.77 0.9191253905 47.7461614412 840659.54 0.3610199938 45.0634971857
NON-OPERATING INCOME & EXPENSE
NON-OPERATING INCOME & EXPENSE MULTIPLE 9522.75 0 0 0 0 0 0 115305.13 0.0526817962 6.6577244645 0 0 0 0 0 0
RENOVATIONS MULTIPLE 0 0 0 0 0 0 0 0 0 8692 0.0039712905 0.5018765518 443.96 19.578340391 0.0256342745 443.96 0.000190658 0.0237984455
TOTAL NON-OPERATING INCOME & EXPENSE 9522.75 0.0214259071 2.7958749266 0 0 0 0 0 0 123997.13 0.0566530868 7.1596010162 443.96 279.2979772953 0.0256342745 443.96 0.000190658 0.0237984455
EBITDA 235223 0.5292448248 69.0613623018 195505.71 1.2031515601 57.4003846154 131883.9 0.370044727 46.7507621411 636042.15 0.2906014932 36.7251082626 826471.81 0.7695872289 47.7205271667 840215.58 0.3608293359 45.0396987403
REPLACEMENT RESERVES 13268.1 0.0298528344 3.8955079272 13333.51 0.995094315 3.9147122725 10692 0.0300000093 3.7901453385 65497.46 0.0299251546 3.7818268953 65661.27 0.9975052264 3.7912852936 69857.03 0.029999998 3.7446813187
EBITDA LESS REPLACEMENT RESERVES 221954.9 0.4993919905 65.1658543746 182172.2 1.218379643 53.4856723429 121191.9 0.3400447177 42.9606168026 570544.69 0.2606763386 32.9432813673 760810.54 0.749916911 43.9292418731 770358.55 0.3308293378 41.2950174216

ROOMS

Current Period Year to Date
Actual Adjusted Budget Original Budget Actual Adjusted Budget Original Budget
COA $ % POR $ % POR $ % POR $ % POR $ % POR $ % POR
ROOMS DEPARTMENT
NO SHOW REVENUE MULTIPLE 0 0 0 0 0 0 0 0 0 2370.2 0.0011919289 0.1368554766 2370.2 1 0.1368554766 0 0 0
ROOM REVENUE 04000 107526.25 0.2656672555 31.5696564885 107526.25 1 31.5696564885 0 0 0 571625.02 0.2874594442 33.0056596801 571625.02 1 33.0056596801 0 0 0
ROOM REVENUE: BAR 04001 111.75 0.000276103 0.0328097475 111.75 1 0.0328097475 77470.52 0.2449852284 27.4620772776 1305.15 0.0006563353 0.0753594318 1305.15 1 0.0753594318 488886.47 0.2372534161 26.2067258108
ROOM REVENUE: DISCOUNTS 04002 54877.77 0.1355876034 16.1120874927 54877.77 1 16.1120874927 77046.25 0.2436435583 27.3116802552 340286.86 0.1711238456 19.6481817657 340286.86 1 19.6481817657 572596.77 0.2778774789 30.694010721
ROOM REVENUE: CORPORATE 04003 73407.3 0.1813688836 21.5523487962 73407.3 1 21.5523487962 36462.55 0.1153056174 12.9253987948 475647 0.2391939077 27.4638835961 475647 1 27.4638835961 178519.46 0.0866343299 9.5695234522
ROOM REVENUE: GOVERNMENT 04004 11990 0.0296239327 3.5202583676 11990 1 3.5202583676 6950.83 0.0219806279 2.4639595888 49940 0.0251138843 2.8835383105 49940 1 2.8835383105 57684.92 0.0279941155 3.092196194
ROOM REVENUE: OTHER (HOTEL SPECIFIC) 04005 3627.25 0.0089619191 1.0649588961 3627.25 1 1.0649588961 62994.5 0.1992076724 22.3305565402 11860.94 0.0059646431 0.6848513194 11860.94 1 0.6848513194 488160.83 0.2369012678 26.1678279282
ROOM REVENUE: GROUP ROOMS 04006 153187 0.3784821833 44.975631239 153187 1 44.975631239 13003.2 0.0411200534 4.6094292804 536798.87 0.26994603 30.9947958889 536798.87 1 30.9947958889 68000.29 0.0330000973 3.6451508979
ROOM REVENUE: SMERF 04007 0 0 0 0 0 0 42297.42 0.1337572421 14.9937681673 0 0 0 0 0 0 206760.03 0.1003392944 11.0833572769
ROOM REVENUE: INDIVIDUAL TOUR/WHOLESALE 04008 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ROOM REVENUE: CONVENTION/ASSOC 04009 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ROOM ADJUSTMENT 04010 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ROOM REVENUE ADJ.: BAR 04011 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ROOM REVENUE ADJ.: DISCOUNTS 04012 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ROOM REVENUE ADJ.: CORPORATE 04013 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ROOM REVENUE ADJ.: GOVERNMENT 04014 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ROOM REVENUE ADJ.: OTHER (HOTEL SPECIFIC) 04015 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ROOM REVENUE ADJ.: GROUP ROOMS 04016 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ROOM REVENUE ADJ.: SMERF 04017 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ROOM REVENUE ADJ.: INDIVIDUAL TOUR/WHOLESALE 04018 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ROOM REVENUE ADJ.:CONVENTION/ASSOC 04019 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CANCELLATIONS 04020 13 0.0000321194 0.0038167939 13 1 0.0038167939 0 0 0 -1292.59 -0.0006500191 -0.0746342168 -1292.59 1 -0.0746342168 0 0 0
ROOM – CWS ONLY 04021 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CANCELLATIONS ADJUSTMENT 04030 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL ROOMS REVENUE 404740.32 1 118.8315678215 404740.32 1 118.8315678215 316225.27 1 112.0968699043 1988541.45 1 114.8184912524 1988541.45 1 114.8184912524 2060608.77 1 110.4587922809
MANUAL, RETURNED CHECK/FUNDS ONLY 05020 0 0 0 0 0 0 0 0 0 521.06 0.0002620312 0.0300860327 0 0 0 0 0 0
EXPENSE – NO BREAKDOWN 09993 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PAYROLL EXPENSES
MANAGEMENT WAGES
FRONT OFFICE MANAGER WAGES 05003 0 0 0 4756.16 0 1.3964063417 4756.16 0.0150404172 1.6859836937 3461.54 0.0017407432 0.1998695075 32526.01 0.1064237513 1.8780535828 32526.01 0.0157846606 1.743554543
ASSISTANT GENERAL MANAGER WAGES 05005 7769.24 0.0191956166 2.2810452143 4900 1.5855591837 1.4386376982 4900 0.0154952828 1.7369727047 44307.76 0.0222815371 2.5583324672 34300 1.2917714286 1.9804838617 34300 0.0166455663 1.8386491557
HOUSEKEEPING MANAGER WAGES 05015 0 0 0 3736.99 0 1.0971785085 3736.99 0.0118174933 1.3247040057 0 0 0 25556.18 0 1.4756152203 25556.18 0.0124022475 1.3699372822
EXECUTIVE HOUSEKEEPER WAGES 05016 0 0 0 0 0 0 0 0 0 6284.67 0.003160442 0.3628771869 0 0 0 0 0 0
REIMBURSEMENT OF EXE HSKPER WAGES 05017 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL MANAGEMENT WAGES 7769.24 0.0191956166 2.2810452143 13393.15 0.5800905687 3.9322225484 13393.15 0.0423531933 4.7476604041 54053.97 0.0271827223 3.1210791616 92382.19 0.5851124551 5.3341526647 92382.19 0.0448324744 4.952140981
NON-MANAGEMENT WAGES
BELL PERSON/DRIVER WAGES 05000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
GUEST SERVICE AGENT WAGES 05001 9517.85 0.0235159423 2.7944362889 9325.25 1.0206536018 2.7378890194 7757.63 0.0245319737 2.7499574619 53651.79 0.0269804736 3.0978572666 47333 1.1334965035 2.733009989 51301.44 0.0248962543 2.7500101849
NIGHT AUDITOR WAGES 05002 2634.92 0.0065101495 0.7736112742 4340 0.607124424 1.2742219612 4340 0.0137243934 1.5384615385 26029.46 0.0130897246 1.5029424332 29680 0.8770033693 1.7137248109 29680 0.0144035105 1.5909943715
FRONT OFFICE SUPERVISOR WAGES 05004 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
VALET WAGES 05006 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ROOM ATTENDANT WAGES 05011 3017.85 0.0074562623 0.8860393423 19396.52 0.1555871878 5.6948091603 16135.87 0.051026504 5.7199113789 13207.84 0.0066419737 0.7626213985 98452.64 0.1341542492 5.6846607772 106706.98 0.0517842016 5.7200203699
LAUNDRY ATTENDANT WAGES 05012 2442.8 0.0060354748 0.7172049325 3051.9 0.8004194109 0.8960364063 2538.86 0.0080286436 0.8999858206 16340.83 0.0082174953 0.9435204111 15490.8 1.0548732151 0.8944396328 16789.56 0.008147864 0.9000032163
HOUSEPERSON WAGES 05013 2936.31 0.0072547998 0.8620992366 3391 0.8659127101 0.995596007 2820.96 0.0089207292 0.9999858206 13017.95 0.0065464816 0.7516571396 17212 0.7563298861 0.9938218142 18655.07 0.0090531838 1.0000037523
INSPECTOR/INSPECTRESS WAGES 05014 648 0.0016010266 0.1902524956 2780.62 0.2330415519 0.8163887258 2313.18 0.0073149752 0.8199858206 2590.74 0.0013028343 0.1495894682 14113.84 0.1835602501 0.8149338876 15297.16 0.007423612 0.8200032163
BREAKFAST ATTENDANT WAGES 05018 0 0 0 3696.19 0 1.0851996477 3074.84 0.0097235746 1.0899822758 167.39 0.0000841773 0.0096651077 18761.08 0.0089221942 1.0832657775 20334.03 0.0098679722 1.0900042884
EVENING SOCIAL ATTENDANT WAGES 05019 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
F&B MANAGER (LIMITED SERVICE) 05021 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
F&B BARTENDER (LIMITED SERVICE) 05022 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OVERTIME WAGES 05050 436.26 0.0010778763 0.1280857311 0 0 0 0 0 0 2587.88 0.0013013961 0.1494243317 0 0 0 0 0 0
TEMP LABOR (CONTRACTED) 05055 18998.88 0.0469409126 5.5780622431 0 0 0 0 0 0 124828.2 0.0627737481 7.2075870431 0 0 0 0 0 0
H2B LABOR (NOT TO BE USED) 05056 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TRAINING – NOT TO BE USED 05098 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
WAGES – NO BREAKDOWN 05099 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL NON-MANAGEMENT WAGES 40632.87 0.1003924442 11.9297915443 45981.48 0.8836790377 13.5001409278 38981.34 0.1232707936 13.818270117 252422.08 0.1269383045 14.5748645996 241043.36 1.0472061126 13.9178566892 258764.24 0.1255765984 13.8710393996
TOTAL PAYROLL EXPENSES 48402.11 0.1195880608 14.2108367587 59374.63 0.8151985116 17.4323634762 52374.49 0.165623987 18.5659305211 306476.05 0.1541210267 17.6959437612 333425.55 0.9191738606 19.2520093539 351146.43 0.1704090728 18.8231803806
OTHER EXPENSES
LAUNDRY CHEMICALS 05100 754.13 0.0018632441 0.2214122137 1017.3 0.7413054163 0.2986788021 846.29 0.0026762251 0.2999964552 5904.25 0.002969136 0.3409117155 5163.6 1.1434367496 0.2981465443 5596.52 0.0027159547 0.3000010721
CLEANING SUPPLIES ROOMS 05101 540.09 0.0013344112 0.1585701703 3051.9 0.1769684459 0.8960364063 2538.86 0.0080286436 0.8999858206 7385.89 0.0037142248 0.4264616895 15490.8 0.4767920314 0.8944396328 16789.56 0.008147864 0.9000032163
COMMISSIONS (TRAVEL AGENT) 05102 10479.28 0.0258913666 3.0767116853 14165.91 0.7397533939 4.1591045214 11067.88 0.0349999859 3.9233888692 63007.2 0.0316851328 3.6380391478 69598.95 0.9052895195 4.0186471505 72121.3 0.0349999966 3.8660573573
GUEST RELATIONS/SERVICE RECOVER 05103 181.5 0.0004484357 0.0532883147 169.55 1.0704806842 0.0497798004 141.05 0.0004460428 0.05 1568.25 0.0007886434 0.0905508401 860.6 1.8222751569 0.0496910907 932.76 0.0004526623 0.050000536
GUEST RELOCATION (OVERBOOK) 05104 0 0 0 0 0 0 0 0 0 344.52 0.0001732526 0.0198926035 0 0 0 0 0 0
GUEST SUPPLIES 05105 2898.98 0.0071625678 0.8511391662 2543.25 1.1398722108 0.7466970053 2115.72 0.0066905469 0.7499893655 12753.25 0.006413369 0.7363733472 12909 0.9879347742 0.7453663606 13991.31 0.0067898915 0.7500032163
GUEST TRANSPORATION – CABS ONLY 05106 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OPERATING SUPPLIES (ROOMS) 05107 630.85 0.0015586537 0.1852172637 1695.5 0.3720731348 0.4977980035 1410.48 0.0044603646 0.4999929103 9938.41 0.004997839 0.5738443328 8606 1.154823379 0.4969109071 9327.54 0.0045265943 0.5000021442
LINEN & TERRY GOODS 05108 2245.87 0.0055489159 0.659386377 2543.25 0.8830708739 0.7466970053 2115.72 0.0066905469 0.7499893655 8715.75 0.0043829863 0.5032478781 12909 0.6751684871 0.7453663606 13991.31 0.0067898915 0.7500032163
ROYALTIES/FRANCHISE FEES 05109 24702.09 0.0610319476 7.25252202 17832.84 1.3852022448 5.2357134469 18973.52 0.060000012 6.7258135413 123096.85 0.0619030848 7.1076188002 84872.77 1.450369182 4.9005583463 123636.53 0.0600000018 6.6275277406
BRAND.COM REDEMPTION & REWARDS 05110 -1826.1 -0.0045117818 -0.5361421022 2023.7 -0.9023570687 0.5941573693 1581.13 0.0050000115 0.5604856434 3707.8 0.0018645827 0.2140885732 9942.71 0.3729164383 0.574092615 10303.05 0.005000003 0.5522942911
BRAND.COM LOYALTIES GOODIE BAGS 05112 676.92 0.0016724798 0.198743394 339.1 1.9962253023 0.0995596007 282.1 0.0008920856 0.1 2365.79 0.0011897112 0.136600843 1721.2 1.3745003486 0.0993821814 1865.52 0.0009053247 0.1000010721
GUEST ROOM APPLIANCES 05113 114.16 0.0002820574 0.0335173224 678.2 0.1683279269 0.1991192014 564.19 0.0017841395 0.1999964552 20041.57 0.0100785277 1.1572013396 3442.4 5.821975947 0.1987643628 3731 0.00181063 0.2
TOTAL OTHER EXPENSES 41397.77 0.1022822979 12.154365825 46060.5 0.8987694445 13.5233411627 41636.94 0.1316686045 14.7596384261 258829.53 0.1301604902 14.9448311103 225517.03 1.147716117 13.0213655523 272286.4 0.1321388145 14.5958938622
FOOD & BEVERAGE EXPENSES
BREAKFAST FOOD EXPENSE (LIMITED SERVICE) 05201 36.86 0.0000910707 0.0108220787 0 0 0 0 0 0 1305.9 0.0006567125 0.0754027369 0 0 0 0 0 0
SOCIAL HOUR FOOD EXPENSE 05202 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SOCIAL HOUR BEVERAGE 05203 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SERVING SUPPLIES (LIMITED SERVICE ONLY) 05204 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
NEWSPAPER 05205 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL FOOD & BEVERAGE EXPENSES 36.86 0.0000910707 0.0108220787 0 0 0 0 0 0 1305.9 0.0006567125 0.0754027369 0 0 0 0 0 0
PROFESSIONAL FEES EXPENSES
H-2B VISA CONSULTING FEES 05335 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL PROFESSIONAL FEES EXPENSES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
EQUIPMENT EXPENSES
DE MINIMIS ACQUISITION EXPENSE 05298 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL EQUIPMENT EXPENSES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL ROOMS EXPENSES 89836.74 0.2219614295 26.3760246624 105435.13 0.8520569947 30.9557046389 94011.43 0.2972925914 33.3255689472 567132.54 0.2852002607 32.7462636411 558942.58 1.0146525963 32.2733749062 623432.83 0.3025478873 33.4190742428
ROOMS DEPARTMENT PROFIT 314903.58 0.7780385705 92.4555431591 299305.19 1.0521153342 87.8758631826 222213.84 0.7027074086 78.7713009571 1421408.91 0.7147997393 82.0722276113 1429598.87 0.9942711482 82.5451163462 1437175.94 0.6974521127 77.0397180381

FOOD & BEVERAGE

Current Period Year to Date
Actual Adjusted Budget Original Budget Actual Adjusted Budget Original Budget
COA $ % POR $ % POR $ % POR $ % POR $ % POR $ % POR
FOOD & BEVERAGE DEPARTMENT
FOOD REVENUE
RESTAURANT FOOD & NON ALCOHOL SALES 04100 -34.89 -0.0013573457 -0.0102436876 -34.89 1 -0.0102436876 7052.39 0.2173370655 2.4999610067 -330.95 -0.0023464312 -0.019109071 -330.95 1 -0.019109071 46637.67 0.2151450689 2.5000091128
RESTAURANT FOOD REVENUE – BREAKFAST 04101 4884.65 0.190030337 1.4341309454 4884.65 1 1.4341309454 4936.67 0.1521358534 1.7499716413 26658.3 0.1890070033 1.5392516889 26658.3 1 1.5392516889 32646.36 0.1506015067 1.7500058965
RESTAURANT FOOD REVENUE – DINNER 04102 2654.05 0.1032520275 0.7792278332 2654.05 1 0.7792278332 2820.96 0.0869349495 0.9999858206 14179.95 0.1005356627 0.8187510826 14179.95 1 0.8187510826 18655.07 0.0860580368 1.0000037523
RESTAURANT FOOD REVENUE – LUNCH 04103 63.75 0.0024801028 0.0187169701 63.75 1 0.0187169701 25 0.0007704376 0.0088621056 133 0.0009429683 0.0076794272 133 1 0.0076794272 175 0.0008072956 0.009380863
IN ROOM DINING FOOD RM SERVICE 04105 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
IN ROOM DINING BEVERAGE RM SERV 04106 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
RESTAURANT FOOD REVENUE – LUNCH. 04114 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BANQUET BREAKS 04205 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BANQUET BREAKFAST 04206 500 0.0194517864 0.1467997651 500 1 0.1467997651 250 0.0077043763 0.0886210564 908 0.0064377083 0.0524279693 908 1 0.0524279693 1750 0.0080729563 0.0938086304
BANQUET LUNCH 04207 625 0.024314733 0.1834997064 625 1 0.1834997064 250 0.0077043763 0.0886210564 947 0.0067142178 0.0546798314 947 1 0.0546798314 1750 0.0080729563 0.0938086304
BANQUET DINNER 04208 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OTHER FOOD REVENUE 04215 1853.6 0.0721116626 0.5442160893 1853.6 1 0.5442160893 1551.53 0.0478142839 0.5499929103 7929.22 0.0562180676 0.4578335932 7929.22 1 0.4578335932 10260.29 0.0473319272 0.5500021442
OTHER BEVERAGE REVENUE 04216 2695 0.1048451288 0.791250734 2695 1 0.791250734 2083.33 0.0642030331 0.7385076214 17094.4 0.1211990756 0.9870315838 17094.4 1 0.9870315838 14583.31 0.067274528 0.7817373358
BANQUET – BEVERAGE – NON ALCOHOL 04217 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL FOOD REVENUE 13241.16 0.5151284324 3.8875983558 13241.16 1 3.8875983558 18969.88 0.5846043757 6.7245232187 67518.92 0.4787082724 3.8985461054 67518.92 1 3.8985461054 126457.7 0.5833642758 6.7787563656
BANQUET REVENUE
MEETING ROOM 04050 2646 0.1029388537 0.776864357 2646 1 0.776864357 5641.91 0.1738695908 1.9999680964 19406 0.1375882898 1.1205034933 19406 1 1.1205034933 37310.12 0.1721159813 2.0000064326
CATERING SERVICE 04104 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CATERING SERVICE. 04115 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BANQUET ROOM RENTAL 04212 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BANQUET AUDIO/VISUAL 04213 0 0 0 0 0 0 41.67 0.0012841654 0.0147713577 0 0 0 0 0 0 291.69 0.0013456004 0.0156360225
BANQUET MISC 04214 420.1 0.0163433909 0.1233411627 420.1 1 0.1233411627 583.33 0.0179767753 0.2067812832 2927.4 0.0207552283 0.1690282349 2927.4 1 0.1690282349 4083.31 0.0188367903 0.2188855535
SERVICE CHARGE 04220 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL BANQUET REVENUE 3066.1 0.1192822446 0.9002055197 3066.1 1 0.9002055197 6266.91 0.1931305315 2.2215207373 22333.4 0.1583435181 1.2895317282 22333.4 1 1.2895317282 41685.12 0.192298372 2.2345280086
OTHER REVENUE
ROOM SERVICE (ALL TYPES) 04120 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
F&B – TIPS 04227 2927.32 0.1138832068 0.8594597769 2927.32 1 0.8594597769 2416.67 0.0744757403 0.8566713931 15252.66 0.1081411628 0.8806894162 15252.66 1 0.8806894162 16916.69 0.078038685 0.9068180113
TIPS – RESTAURANT 04235 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL OTHER REVENUE 2927.32 0.1138832068 0.8594597769 2927.32 1 0.8594597769 2416.67 0.0744757403 0.8566713931 15252.66 0.1081411628 0.8806894162 15252.66 1 0.8806894162 16916.69 0.078038685 0.9068180113
LIQUOR REVENUE
RESTAURANT ALCOHOL BEVERAGES 04110 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
RESTAURANT BEVERAGE – LIQUOR 04112 3352.5 0.1304242279 0.9842924251 3352.5 1 0.9842924251 2820.96 0.0869349495 0.9999858206 18594 0.1318312203 1.0736185692 18594 1 1.0736185692 18655.07 0.0860580368 1.0000037523
BANQUET LIQUOR 04209 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL LIQUOR REVENUE 3352.5 0.1304242279 0.9842924251 3352.5 1 0.9842924251 2820.96 0.0869349495 0.9999858206 18594 0.1318312203 1.0736185692 18594 1 1.0736185692 18655.07 0.0860580368 1.0000037523
BEER & WINE REVENUE
RESTAURANT BEVERAGE – BEER 04111 1738 0.0676144096 0.5102759836 1738 1 0.5102759836 846.29 0.0260805465 0.2999964552 8396 0.0595275318 0.4847854957 8396 1 0.4847854957 5596.52 0.0258174064 0.3000010721
RESTAURANT BEVERAGE – WINE 04113 1379.5 0.0536674787 0.405020552 1379.5 1 0.405020552 1128.38 0.0347738565 0.3999929103 8949 0.0634482946 0.5167157457 8949 1 0.5167157457 7462.03 0.0344232239 0.4000016081
BANQUET BEER 04210 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BANQUET WINE 04211 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL BEER & WINE REVENUE 3117.5 0.1212818883 0.9152965355 3117.5 1 0.9152965355 1974.67 0.060854403 0.6999893655 17345 0.1229758264 1.0015012414 17345 1 1.0015012414 13058.55 0.0602406304 0.7000026802
TOTAL FOOD & BEVERAGE REVENUE 25704.58 1 7.546852613 25704.58 1 7.546852613 32449.09 1 11.5026905353 141043.98 1 8.1438870605 141043.98 1 8.1438870605 216773.13 1 11.620108818
COST OF SALES
BANQUET MULTIPLE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FOOD MULTIPLE 3378.74 0.2551694867 0.9919964768 5256.05 0.6428287402 1.5431738109 4372.48 0.230495923 1.5499751861 26481.72 0.3922118423 1.5290559501 26678.6 0.9926203024 1.540423812 28915.35 0.2286563017 1.5500053605
LIQUOR MULTIPLE 1537.63 0.4586517524 0.4514474457 644.29 2.3865495351 0.1891632413 535.98 0.1899991492 0.1899964552 5468.6 0.2941056255 0.3157572608 3270.28 1.6722115538 0.1888261447 3544.47 0.1900003592 0.1900010721
BEER & WINE MULTIPLE 963.19 0.3089623095 0.2827921315 847.75 1.1361722206 0.2488990018 705.24 0.3571432189 0.2499964552 4851.34 0.2796967426 0.2801166349 4303 1.1274320242 0.2484554535 4663.77 0.3571430212 0.2500010721
TOTAL COST OF SALES 5879.56 0.2581328922 1.726236054 6748.09 0.8712924694 1.981236054 5613.7 0.1869213337 1.9899680964 36801.66 0.2925612037 2.1249298458 34251.88 1.0744420452 1.9777054102 37123.59 0.1857512823 1.9900075047
PAYROLL EXPENSES
MANAGEMENT WAGES
RESTAURANT MANAGER WAGES 05065 2563.2 0.0997176379 0.7525543159 0 0 0 0 0 0 3355.8 0.0237925787 0.1937640741 0 0 0 0 0 0
KITCHEN MANAGER WAGES 05067 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
EXECUTIVE CHEF WAGES 05068 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BANQUET MANAGER WAGES 05073 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BANQUET CAPTAIN WAGES 05074 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL MANAGEMENT WAGES 2563.2 0.0997176379 0.7525543159 0 0 0 0 0 0 3355.8 0.0237925787 0.1937640741 0 0 0 0 0 0
NON-MANAGEMENT WAGES
BANQUET COOK WAGES 05060 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BANQUET SET-UP WAGES 05061 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SERVER WAGES 05062 1860.94 0.0723972148 0.5463711098 4750 0.3917768421 1.3945977686 4750 0.1463831497 1.6838000709 14074.65 0.0997890871 0.8126710549 33250 0.4232977444 1.9198568047 33250 0.1533861692 1.7823639775
BREAKFAST FULL SERVICE WAGES 05063 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TIP WAGES 05064 1489.24 0.0579367568 0.4372401644 2000 0.74462 0.5871990605 2000 0.0616350104 0.7089684509 5830.31 0.0413368227 0.3366424158 14000 0.4164507143 0.8083607599 14000 0.0645836502 0.7504690432
RESTAURANT SUPERVISOR WAGES 05066 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COOK WAGES 05069 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BUS PERSON WAGES 05070 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
UTILITY/DISHWASHER WAGES 05071 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BARTENDER WAGES 05072 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BANQUET SERVER WAGES 05075 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BANQUET HOUSEMAN WAGES 05076 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL NON-MANAGEMENT WAGES 3350.18 0.1303339716 0.9836112742 6750 0.496322963 1.9817968291 6750 0.2080181601 2.3927685218 19904.96 0.1411259098 1.1493134708 47250 0.4212689947 2.7282175645 47250 0.2179698194 2.5328330206
TOTAL PAYROLL EXPENSES 5913.38 0.2300516095 1.7361655901 6750 0.8760562963 1.9817968291 6750 0.2080181601 2.3927685218 23260.76 0.1649184885 1.3430775449 47250 0.4922912169 2.7282175645 47250 0.2179698194 2.5328330206
OTHER EXPENSES
F&B – CHINA, GLASS AND SILVER 05224 0 0 0 135.64 0 0.0398238403 112.84 0.0034774473 0.04 0 0 0 688.48 0 0.0397528726 746.19 0.0034422624 0.039999464
F&B – CLEANING SUPPLIES 05225 0 0 0 339.1 0 0.0995596007 282.1 0.0086936182 0.1 690.83 0.0048979758 0.0398885617 1721.2 0.4013653265 0.0993821814 1865.52 0.0086058637 0.1000010721
F&B – COMPLIMENTARY SUPPLIES 05226 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
F&B – CONTRACT SERVICES 05227 0 0 0 0 0 0 0 0 0 750 0.0053174903 0.0433050407 0 0 0 0 0 0
F&B – DECORATIONS 05228 0 0 0 271.28 0 0.0796476806 225.68 0.0069548946 0.08 0 0 0 1376.96 0 0.0795057451 1492.42 0.0068847094 0.0800010721
F&B – EQUIPMENT LEASE 05229 0 0 0 0 0 0 0 0 0 136.56 0.0009682086 0.0078849818 0 0 0 0 0 0
F&B – LINEN EXPENSE 05230 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
F&B – MEETING ROOM EXPENSE 05231 0 0 0 305.19 0 0.0896036406 253.89 0.0078242564 0.09 0 0 0 1549.08 0 0.0894439633 1678.96 0.0077452404 0.090000536
F&B – MENUS AND STATIONARY 05232 88.91 0.0034589167 0.0261039342 135.64 0.6554851076 0.0398238403 112.84 0.0034774473 0.04 568.74 0.0040323593 0.0328390785 688.48 0.8260806414 0.0397528726 746.19 0.0034422624 0.039999464
F&B – NEWSPAPER 05233 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
F&B – PAPER & PLASTIC SUPPLIES 05234 418.45 0.0162792 0.1228567234 847.75 0.4936007078 0.2488990018 705.24 0.0217337374 0.2499964552 5042.89 0.0357540251 0.2911767423 4303 1.1719474785 0.2484554535 4663.77 0.0215145207 0.2500010721
F&B – RESTAURANT OPERATING SUPPLIES 05235 156.94 0.0061055267 0.0460775103 10 15.694 0.0029359953 10 0.0003081751 0.0035448423 474.99 0.003367673 0.0274259484 70 6.7855714286 0.0040418038 70 0.0003229183 0.0037523452
DE MINIMIS EQP 05299 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL OTHER EXPENSES 664.3 0.0258436434 0.1950381679 2044.6 0.3249046268 0.6002935995 1702.59 0.0524695762 0.6035412974 7664.01 0.0543377321 0.4425203534 10397.2 0.7371224945 0.6003348923 11263.05 0.0519577772 0.6037550255
TOTAL FOOD & BEVERAGE EXPENSES 12457.24 0.4846311436 3.6574398121 15542.69 0.8014854572 4.5633264827 14066.29 0.4334879653 4.9862779156 67726.43 0.4801795156 3.9105277441 91899.08 0.7369652667 5.3062578671 95636.64 0.4411830931 5.1265955508
FOOD & BEVERAGE DEPARTMENT PROFIT 13247.34 0.5153688564 3.8894128009 10161.89 1.3036295414 2.9835261304 18382.8 0.5665120347 6.5164126196 73317.55 0.5198204844 4.2333593164 49144.9 1.4918648731 2.8376291934 121136.49 0.5588169069 6.4935132672

MINOR OPERATED DEPARTMENTS

Current Period Year to Date
Actual Adjusted Budget Original Budget Actual Adjusted Budget Original Budget
COA $ % POR $ % POR $ % POR $ % POR $ % POR $ % POR
MINOR OPERATED DEPARTMENTS
MINOR OPERATED REVENUE
SHOP MULTIPLE 6792.44 0.4849886044 1.9942571932 6792.44 1 1.9942571932 6347.15 0.8215811731 2.2499645516 30472.67 0.5154050666 1.7594936197 30472.67 1 1.7594936197 41973.89 0.8200280468 2.2500075047
GUEST LAUNDRY MULTIPLE 195 0.0139232408 0.0572519084 195 1 0.0572519084 0 0 0 419 0.007086833 0.0241930827 419 1 0.0241930827 0 0 0
MISCELLANEOUS INCOME MULTIPLE 5293.25 0.3779445869 1.5540957134 5293.25 1 1.5540957134 250 0.0323602394 0.0886210564 14567.39 0.2463882099 0.8411218893 14567.39 1 0.8411218893 1750 0.0341890895 0.0938086304
PARKING FEE MULTIPLE 164.67 0.0117576414 0.0483470346 164.67 1 0.0483470346 0 0 0 164.67 0.0027851761 0.0095080547 164.67 1 0.0095080547 0 0 0
PET FEES MULTIPLE 1000 0.071401235 0.2935995302 1000 1 0.2935995302 1128.38 0.1460585876 0.3999929103 9300 0.1572972477 0.5369825048 9300 1 0.5369825048 7462.03 0.1457828637 0.4000016081
RENT MULTIPLE 560 0.0399846916 0.1644157369 560 1 0.1644157369 0 0 0 4200 0.0710374667 0.242508228 4200 1 0.242508228 0 0 0
MANAGEMENT INCOME MULTIPLE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL MINOR OPERATED REVENUE 14005.36 1 4.1119671169 14005.36 1 4.1119671169 7725.53 1 2.7385785183 59123.73 1 3.4138073792 59123.73 1 3.4138073792 51185.92 1 2.7438177432
MINOR OPERATED EXPENSES
SHOP MULTIPLE 3772.95 0.5554631325 1.1077363476 3212.32 1.1745249539 0.943135643 3173.58 0.4107912337 1.1249840482 10647.95 0.3494262236 0.6148132109 14629.17 0.7278574246 0.8446890698 20986.98 0.4100147072 1.1250056285
GUEST LAUNDRY MULTIPLE 0 0 0 0 0 0 0 0 0 142 0.338902148 0.0081990877 0 0 0 0 0 0
PARKING FEE MULTIPLE 0 0 0 0 0 0 0 0 0 500 3.0363757819 0.0288700271 0 0 0 0 0 0
TOTAL MINOR OPERATED 3772.95 0.2693932894 1.1077363476 3212.32 1.1745249539 0.943135643 3173.58 0.4107912337 1.1249840482 11289.95 0.1909546302 0.6518823258 14629.17 0.7717423477 0.8446890698 20986.98 0.4100147072 1.1250056285
MINOR OPERATED PROFIT
SHOP PROFIT MULTIPLE 3019.49 0.4445368675 0.8865208456 3580.12 0.8434046903 1.0511215502 3173.57 0.4107899393 1.1249805034 19824.72 0.6505737764 1.1446804088 15843.5 1.2512841228 0.9148045499 20986.91 0.4100133396 1.1250018762
GUEST LAUNDRY PROFIT MULTIPLE 195 1 0.0572519084 195 1 0.0572519084 0 0 0 277 0.661097852 0.015993995 419 0.661097852 0.0241930827 0 0 0
MISCELLANEOUS INCOME PROFIT MULTIPLE 5293.25 1 1.5540957134 5293.25 1 1.5540957134 250 0.0323602394 0.0886210564 14567.39 1 0.8411218893 14567.39 1 0.8411218893 1750 0.0341890895 0.0938086304
PARKING FEE PROFIT MULTIPLE 164.67 1 0.0483470346 164.67 1 0.0483470346 0 0 0 -335.33 -2.0363757819 -0.0193619724 164.67 -2.0363757819 0.0095080547 0 0 0
PET FEES PROFIT MULTIPLE 1000 1 0.2935995302 1000 1 0.2935995302 1128.38 0.1460585876 0.3999929103 9300 1 0.5369825048 9300 1 0.5369825048 7462.03 0.1457828637 0.4000016081
RENT PROFIT MULTIPLE 560 1 0.1644157369 560 1 0.1644157369 0 0 0 4200 1 0.242508228 4200 1 0.242508228 0 0 0
MANAGEMENT INCOME PROFIT MULTIPLE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL MINOR OPERATED PROFIT 10232.41 0.7306067106 3.0042307692 10793.04 0.94805634 3.1688314739 4551.95 0.5892087663 1.61359447 47833.78 0.8090453698 2.7619250534 44494.56 1.0750478261 2.5691183094 30198.94 0.5899852928 1.6188121147

ADMINISTRATIVE & GENERAL

Current Period Year to Date
Actual Adjusted Budget Original Budget Actual Adjusted Budget Original Budget
COA $ % POR $ % POR $ % POR $ % POR $ % POR $ % POR
ADMINISTRATIVE & GENERAL
PAYROLL EXPENSES
MANAGEMENT WAGES
GENERAL MANAGER WAGES 05045 5769.24 0.0129806201 1.6938461538 6250 0.9230784 1.834997064 6250 0.0175364813 2.2155264091 44256.09 0.0202201785 2.5553490386 43750 1.0115677714 2.5261273746 43750 0.0187883727 2.3452157598
CORPORATE WAGES 05047 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
REIMBURSEMENT OF GM WAGES 05058 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL MANAGEMENT WAGES 5769.24 0.0129806201 1.6938461538 6250 0.9230784 1.834997064 6250 0.0175364813 2.2155264091 44256.09 0.0202201785 2.5553490386 43750 1.0115677714 2.5261273746 43750 0.0187883727 2.3452157598
EMPLOYEE BENEFITS
EMPLOYEE BONUSES 05048 0 0 0 1500 0 0.4403992954 1500 0.0042087555 0.5317263382 3058.75 0.0013975132 0.176612391 3600 0.8496527778 0.2078641954 3600 0.0015460147 0.192977754
EMPLOYEES PTO 05049 103.5 0.000232872 0.0303875514 454.81 0.2275675557 0.1335320023 759.79 0.0021318469 0.2693335697 6086.1 0.0027806801 0.3514117443 2991.47 2.0344847182 0.1727276402 5163.76 0.0022175691 0.2768030019
SIMPLE IRA MATCH 05051 657.45 0.0014792431 0.1930270112 454.81 1.4455486907 0.1335320023 759.79 0.0021318469 0.2693335697 5716.27 0.0026117084 0.3300577401 2991.47 1.9108565354 0.1727276402 5163.76 0.0022175691 0.2768030019
EMPLOYEE HEALTH, DENTAL INSURANCE 05052 379.67 0.0008542463 0.1114709336 454.81 0.8347881533 0.1335320023 759.79 0.0021318469 0.2693335697 4489.53 0.0020512227 0.2592257059 2991.47 1.5007772099 0.1727276402 5163.76 0.0022175691 0.2768030019
OWNER'S HEALTH INSURANCE 05054 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
WORKMANS COMPENSATION 05057 0 0 0 454.81 0 0.1335320023 759.79 0.0021318469 0.2693335697 -1277 -0.0005834489 -0.0737340493 2991.47 -0.42688043 0.1727276402 5163.76 0.0022175691 0.2768030019
EMPLOYEES SICK 05077 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL EMPLOYEE BENEFITS 1140.62 0.0025663614 0.3348854962 3319.24 0.3436389053 0.9745273048 4539.16 0.0127361431 1.6090606168 18073.65 0.0082576755 1.043573532 15565.88 1.1611068568 0.898774756 24255.04 0.010416291 1.3001897615
TOTAL PAYROLL EXPENSES 6909.86 0.0155469816 2.02873165 9569.24 0.7220907825 2.8095243688 10789.16 0.0302726244 3.8245870259 62329.74 0.028477854 3.5989225706 59315.88 1.0508103395 3.4249021306 68005.04 0.0292046637 3.6454055213
OTHER EXPENSES
PAYROLL TAXES EXPENSES 05053 4548.22 0.0102333611 1.3353552554 4002.3 1.1364015691 1.1750733999 6686.12 0.0187601629 2.3701240695 25743.59 0.0117619967 1.4864362839 26324.9 0.9779178648 1.5200011548 45441.06 0.0195145959 2.4358649156
BANK CHARGE, ACH & CC INTEREST FEES 05301 0 0 0 0 0 0 0 0 0 12 0.0000054827 0.0006928807 0 0 0 0 0 0
CASH, CREDITCARDS, CLC OVER/SHORT 05302 17.13 0.000038542 0.00502936 0 0 0 0 0 0 -258.51 -0.0001181107 -0.0149263814 0 0 0 0 0 0
CREDIT CARD FEES (MERCHANT) 05303 228.44 0.0005139833 0.0670698767 446.63 0.5114748226 0.1311303582 356.4 0.0010000003 0.126338178 909.21 0.0004154092 0.0524978347 2194.17 0.4143753675 0.1266914949 2328.57 0.0010000009 0.1248228357
CHARGEBACK 05304 595.55 0.00133997 0.1748532002 0 0 0 0 0 0 4374.3 0.0019985753 0.2525723194 0 0 0 0 0 0
CENTRALIZED ACCOUNTING CHARGES 05305 2350 0.0052874308 0.6899588961 2350 1 0.6899588961 2350 0.006593717 0.8330379298 19450 0.0088865165 1.1230440557 19450 1 1.1230440557 19450 0.0083527737 1.0426159207
DECORATIONS & LOBBY MUSIC 05306 0 0 0 200 0 0.058719906 200 0.0005611674 0.0708968451 0 0 0 1400 0 0.080836076 1400 0.0006012279 0.0750469043
DUES AND SUBSCRIPTIONS 05307 912 0.0020519731 0.2677627716 1800 0.5066666667 0.5284791544 1800 0.0050505066 0.6380716058 11974.09 0.0054708457 0.6913846065 10400 1.1513548077 0.6004965645 10400 0.0044662646 0.5574912892
HR (HELP ADS, ETC) 05308 193.08 0.0004344243 0.0566881973 200 0.9654 0.058719906 200 0.0005611674 0.0708968451 245.18 0.0001120204 0.0141567065 1400 0.1751285714 0.080836076 1400 0.0006012279 0.0750469043
INFORMATION SYSTEMS (IT SUPPORT 05309 1256.94 0.002828078 0.3690369935 800 1.571175 0.2348796242 800 0.0022446696 0.2835873804 16760.04 0.0076574998 0.9677256193 5600 2.9928642857 0.3233443039 5600 0.0024049117 0.3001876173
LICENSES AND PERMITS 05314 0 0 0 166.67 0 0.0489342337 166.67 0.0004676489 0.0590818859 5320.6 0.0024309306 0.3072117328 9666.69 0.550405568 0.5581552053 9666.69 0.0041513457 0.5181822568
EMPLOYEE RELATIONS (STAFF) 05315 1.2 0.0000027 0.0003523194 200 0.006 0.058719906 200 0.0005611674 0.0708968451 12487.86 0.0057055822 0.7210497142 2200 5.6763 0.1270281194 2200 0.0009447867 0.1179308496
OPERATING SUPPLIES (OFFICE/CELL) 05316 143.9 0.0003237708 0.0422489724 474.74 0.3031132831 0.139383441 394.93 0.0011081092 0.1399964552 3469.39 0.0015851307 0.2003227669 2409.68 1.4397720859 0.139135054 2611.71 0.001121595 0.140000536
PAYROLL FEES 05317 1131.22 0.0025452117 0.3321256606 1100 1.0283818182 0.3229594833 1100 0.0030864207 0.389932648 8237.82 0.0037637801 0.4756521739 7700 1.0698467532 0.4445984179 7700 0.0033067536 0.4127579737
POSTAGE & DELIVERY 05318 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
EQUIPMENT LEASE & RENTAL 05319 0 0 0 1740 0 0.5108631826 1740 0.0048821564 0.6168025523 4335.46 0.0019808297 0.2503296957 12180 0.3559490969 0.7032738611 12180 0.005230683 0.6529080675
SECURITY – CONTRACTED 05320 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TRAINING 05321 154 0.0003464955 0.0452143277 0 0 0 0 0 0 3732 0.0017051146 0.2154858826 0 0 0 0 0 0
TRAVEL – TRANSPORTATION & HOTEL 05322 0 0 0 0 0 0 0 0 0 3361.88 0.0015360104 0.1941151337 1500 2.2412533333 0.0866100814 1500 0.0006441728 0.0804073975
ENTERTAINMENT 05323 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
EMPLOYEE RELATIONS (CORPORATE) 05324 0 0 0 150 0 0.0440399295 150 0.0004208756 0.0531726338 900 0.0004112013 0.0519660488 1050 0.8571428571 0.060627057 1050 0.0004509209 0.0562851782
MEALS 05325 0 0 0 0 0 0 0 0 0 291.57 0.0001332155 0.0168352676 0 0 0 0 0 0
UNIFORMS 05326 0 0 0 339.1 0 0.0995596007 282.1 0.0007915266 0.1 1194.8 0.0005458925 0.0689878168 1721.2 0.6941668603 0.0993821814 1865.52 0.0008011448 0.1000010721
AUTO 05327 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ACA REPORTING 05330 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
UNCOLLECTED SALES TAXES 05331 10.56 0.0000237597 0.003100411 0 0 0 0 0 0 -107.49 -0.0000491111 -0.0062064784 0 0 0 0 0 0
LATE AND PENALTIES FEES 05332 5 0.0000112499 0.0014679977 0 0 0 0 0 0 217.29 0.0000992777 0.0125463364 0 0 0 0 0 0
COMMISSIONS (CREDIT CARDS) 05333 8906.3 0.0200389128 2.6148854962 9825.87 0.9064133761 2.8848708162 7840.8 0.0220000068 2.7794399149 53025.73 0.0242269421 3.0617085282 48271.74 1.0984839163 2.7872128876 51228.49 0.0219999991 2.7460997052
REIMBURSEMENT OF PAYROLL TAXES 05352 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL OTHER EXPENSES 20453.54 0.0460198628 6.0051497358 23795.31 0.8595618212 6.9862918379 24267.02 0.0680893027 8.6022757887 175676.81 0.0802650316 10.1435885444 153468.38 1.1447101351 8.8612725908 176022.04 0.0755924043 9.4356494237
PROFESSIONAL FEES EXPENSES
ACCOUNTANT FEES 05311 0 0 0 0 0 0 0 0 0 275 0.0001256448 0.0158785149 0 0 0 0 0 0
TOTAL PROFESSIONAL FEES EXPENSES 0 0 0 0 0 0 0 0 0 275 0.0001256448 0.0158785149 0 0 0 0 0 0
TOTAL ADMINISTRATIVE & GENERAL EXPENSES 27363.4 0.0615668444 8.0338813858 33364.55 0.8201339446 9.7958162067 35056.18 0.0983619271 12.4268628146 238281.55 0.1088685305 13.7583896299 212784.26 1.1198269552 12.2861747214 244027.08 0.1047970679 13.0810549451

SALES & MARKETING

Current Period Year to Date
Actual Adjusted Budget Original Budget Actual Adjusted Budget Original Budget
COA $ % POR $ % POR $ % POR $ % POR $ % POR $ % POR
SALES & MARKETING 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PAYROLL EXPENSES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
MANAGEMENT WAGES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SALES MANAGER WAGES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DIRECTOR OF SALES WAGES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
AREA DIR. OF SALES WAGES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
REGIONAL DIR. OF SALES WAGES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SALES REIMBURSEMENT 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL MANAGEMENT WAGES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
NON-MANAGEMENT WAGES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SALES COORDINATOR WAGES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL NON-MANAGEMENT WAGES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL PAYROLL EXPENSES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OTHER EXPENSES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ADVERTISING AND PROMOTION 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COLLATERAL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COMPLIMENTARY SERV & GIFTS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ECOMMERCE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FRANCHISE ADVERTISING 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SALES SUPPORT FEE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PHOTOGRAPHY 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PROMOTION 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TRADE SHOWS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DUES & SUBSCRIPTIONS – SALES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SPONSORSHIPS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SALES SYSTEM SOFTWARE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
REVENUE MANAGEMENT 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL OTHER EXPENSES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL SALES & MARKETING EXPENSES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

REPAIRS & MAINTENANCE

Current Period Year to Date
ActualActual Adjusted BudgetAdjusted Budget Original BudgetOriginal Budget ActualActual Adjusted BudgetAdjusted Budget Original BudgetOriginal Budget
COA $ % POR $ % POR $ % POR $ % POR $ % POR $ % POR
REPAIRS & MAINTENANCE
PAYROLL EXPENSES
MANAGEMENT WAGES
MAINTENANCE MANAGER WAGES 05031 0 0 0 3666.67 0 1.0765325895 3666.67 0.0102880784 1.2997766749 0 0 0 25666.69 0 1.4819960737 25666.69 0.011022522 1.3758611632
CHIEF ENGINEER 05033 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
AREA MAINTENANCE MANAGER 05034 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
MAINTENANCE REIMBURSEMENT 05520 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL MANAGEMENT WAGES 0 0 0 3666.67 0 1.0765325895 3666.67 0.0102880784 1.2997766749 0 0 0 25666.69 0 1.4819960737 25666.69 0.011022522 1.3758611632
NON-MANAGEMENT WAGES
MAINTENANCE TECH WAGES 05030 0 0 0 0 0 0 0 0 0 1606.48 0.0007339851 0.0927582424 0 0 0 0 0 0
FACILITIES ENGINEER WAGES 05032 3076.74 0.0069225744 0.9033294187 0 0 0 0 0 0 22833.39 0.0104323546 1.3184011779 0 0 0 0 0 0
TOTAL NON-MANAGEMENT WAGES 3076.74 0.0069225744 0.9033294187 0 0 0 0 0 0 24439.87 0.0111663397 1.4111594203 0 0 0 0 0 0
TOTAL PAYROLL EXPENSES 3076.74 0.0069225744 0.9033294187 3666.67 0.8391101463 1.0765325895 3666.67 0.0102880784 1.2997766749 24439.87 0.0111663397 1.4111594203 25666.69 0.9522018616 1.4819960737 25666.69 0.011022522 1.3758611632
OTHER EXPENSES
BUILDING MAINTENANCE 05501 0 0 0 339.1 0 0.0995596007 282.1 0.0007915266 0.1 9727.3 0.0044443091 0.56165483 1721.2 5.6514640948 0.0993821814 1865.52 0.0008011448 0.1000010721
ELECTRICAL & MECHANICAL 05502 167.45 0.0003767576 0.0491632413 339.1 0.4938071365 0.0995596007 282.1 0.0007915266 0.1 8860.53 0.0040482903 0.5116074831 1721.2 5.1478793865 0.0993821814 1865.52 0.0008011448 0.1000010721
ELEVATOR REPAIR & MAINT 05503 0 0 0 339.1 0 0.0995596007 282.1 0.0007915266 0.1 10202.85 0.0046615833 0.5891131128 1721.2 5.9277538926 0.0993821814 1865.52 0.0008011448 0.1000010721
ENGINEERING SUPPLIES (TOOLS & E 05504 55.99 0.0001259759 0.0164386377 339.1 0.1651135358 0.0995596007 282.1 0.0007915266 0.1 96.19 0.0000439483 0.0055540158 1721.2 0.0558854288 0.0993821814 1865.52 0.0008011448 0.1000010721
EQUIPMENT RENTAL 05505 1737.45 0.0039092113 0.5101145038 0 0 0 0 0 0 18188.04 0.0083099392 1.0501784168 0 0 0 0 0 0
FLOORING COVERING 05506 211.74 0.0004764088 0.0621667645 339.1 0.6244175759 0.0995596007 282.1 0.0007915266 0.1 4770.21 0.0021794627 0.2754321843 1721.2 2.7714443412 0.0993821814 1865.52 0.0008011448 0.1000010721
FURNITURE & FIXTURES 05507 1048.34 0.0023587341 0.3077921315 0 0 0 0 0 0 5380.42 0.0024582617 0.3106657428 0 0 0 0 0 0
LANDSCAPING & GROUNDKEEPING 05508 975 0.0021937213 0.286259542 300 3.25 0.0880798591 300 0.0008417511 0.1063452676 1231.09 0.0005624731 0.0710832034 2100 0.5862333333 0.121254114 2100 0.0009018419 0.1125703565
LOCK REPAIR & MAINT 05509 86.6 0.0001948475 0.0254257193 339.1 0.2553818932 0.0995596007 282.1 0.0007915266 0.1 908.52 0.000415094 0.0524579941 1721.2 0.5278410411 0.0993821814 1865.52 0.0008011448 0.1000010721
HEATING & AIR CONDITIONING 05510 -361.32 -0.0008129594 -0.1060833823 1017.3 -0.3551754645 0.2986788021 846.29 0.0023745518 0.2999964552 28869.27 0.0131900896 1.6669132167 5163.6 5.5909191262 0.2981465443 5596.52 0.0024034172 0.3000010721
KITCHEN EQUIPMENT 05511 0 0 0 339.1 0 0.0995596007 282.1 0.0007915266 0.1 7958.65 0.00363623 0.459532883 1721.2 4.623896119 0.0993821814 1865.52 0.0008011448 0.1000010721
FIRE & ALARM (LIFE SAFETY) 05512 0 0 0 833.33 0 0.2446652965 833.33 0.0023381882 0.2954023396 1391 0.0006355344 0.0803164155 5833.31 0.2384580967 0.336815636 5833.31 0.0025051063 0.3126941839
PAINTING & DECORATION 05513 0 0 0 169.55 0 0.0497798004 141.05 0.0003957633 0.05 0 0 0 860.6 0 0.0496910907 932.76 0.0004005724 0.050000536
PLUMBING & FIXTURES 05514 312.5 0.0007031158 0.0917498532 508.65 0.6143713752 0.1493394011 423.14 0.0011872619 0.1499964552 22638.15 0.0103431513 1.3071280097 2581.8 8.7683592842 0.1490732721 2798.26 0.0012017086 0.150000536
SWIMMING POOLS & SPA MAINT 05515 476.32 0.001071706 0.1398473282 200 2.3816 0.058719906 200 0.0005611674 0.0708968451 2557.31 0.0011684102 0.1476592182 1300 1.9671615385 0.0750620706 1300 0.0005582831 0.0696864111
TELEPHONE & TVS 05516 0 0 0 125 0 0.0366999413 125 0.0003507296 0.0443105282 3837 0.0017530881 0.2215485883 875 4.3851428571 0.0505225475 875 0.0003757675 0.0469043152
VEHICLE REPAIR & MAIN/LEASE 05517 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PEST CONTROL 05518 504.98 0.0011361901 0.1482618908 598.3 0.8440247368 0.1756605989 598.3 0.0016787323 0.2120879121 3341.81 0.0015268406 0.1929562908 4188.1 0.7979298489 0.2418211213 4188.1 0.0017985733 0.2245028143
LIGHT BULBS 05521 81.43 0.0001832151 0.0239078097 169.55 0.4802713064 0.0497798004 141.05 0.0003957633 0.05 1525.92 0.0006971781 0.0881067036 860.6 1.7730885429 0.0496910907 932.76 0.0004005724 0.050000536
BATTERIES 05522 97.7 0.0002198221 0.0286846741 169.55 0.5762312002 0.0497798004 141.05 0.0003957633 0.05 310.04 0.0001416543 0.0179017264 860.6 0.3602602835 0.0496910907 932.76 0.0004005724 0.050000536
TOTAL OTHER EXPENSES 5394.18 0.0121367462 1.583728714 6464.93 0.8343756236 1.898100411 5723.91 0.0160603585 2.0290358029 131794.3 0.0602155382 7.6098100352 36672.01 3.5938662757 2.1174438478 38548.11 0.0165544287 2.0663688019
TOTAL REPAIRS & MAINTENANCE EXPENSES 8470.92 0.0190593206 2.4870581327 10131.6 0.8360890679 2.9746330006 9390.58 0.0263484369 3.3288124778 156234.17 0.0713818779 9.0209694555 62338.7 2.5062147591 3.5994399215 64214.8 0.0275769507 3.4422299652

UTILITIES

Current Period Year to Date
Actual Adjusted Budget Original Budget Actual Adjusted Budget Original Budget
COA $ % POR $ % POR $ % POR $ % POR $ % POR $ % POR
UTILITIES
ELECTRICITY 05601 4488.07 0.0100980254 1.3176952437 7799.3 0.5754452323 2.2898708162 6488.2 0.0182048317 2.2999645516 46302.83 0.0211553142 2.6735279173 39587.6 1.1696296315 2.2857901726 42906.65 0.0184261973 2.3000080407
INTERNET 05602 2027.98 0.0045628953 0.5954139753 4166.67 0.4867148106 1.2233323547 4166.67 0.0116909969 1.4770187877 5872.25 0.0026829741 0.3390640337 29166.69 0.2013341246 1.6840862636 29166.69 0.0125255918 1.563478424
NATURAL GAS 05603 0 0 0 1525.95 0 0.4480182032 1269.43 0.0035618137 0.4499929103 7588.98 0.0034673314 0.4381881171 7745.4 0.9798047874 0.4472198164 8394.78 0.0036051258 0.4500016081
WATER & SEWAGE 05604 0 0 0 9494.8 0 2.7876688197 7898.68 0.0221624086 2.7999574619 12269.82 0.0056059618 0.7084600728 28844.2 0.4253825726 1.6654656735 30066.42 0.0129119795 1.6117083892
TRASH & WASTE REMOVAL 05605 1242.8 0.0027962634 0.3648854962 916.67 1.3557768881 0.2691338814 916.67 0.0025720266 0.3249450549 19551.63 0.0089329502 1.1289121774 6416.69 3.0469961927 0.3705000289 6416.69 0.002755638 0.3439662289
TELEPHONE 05606 333.98 0.0007514452 0.0980563711 833.33 0.4007776031 0.2446652965 833.33 0.0023381882 0.2954023396 2339.55 0.0010689177 0.135085744 5833.31 0.4010673186 0.336815636 5833.31 0.0025051063 0.3126941839
CABLE 05607 2858.43 0.0064313833 0.8392337052 0 0 0 0 0 0 18948.71 0.0086574819 1.0940995439 0 0 0 0 0 0
TOTAL UTILITIES EXPENSES 10951.26 0.0246400126 3.2152847915 24736.72 0.4427126959 7.2626893717 21572.98 0.0605302656 7.647281106 112873.77 0.0515709314 6.5173376061 117593.89 0.9598608397 6.7898775911 122784.54 0.0527296388 6.5818568748

RENOVATIONS

Current Period Year to Date
Actual Adjusted Budget Original Budget Actual Adjusted Budget Original Budget
COA $ % POR $ % POR $ % POR $ % POR $ % POR $ % POR
RENOVATIONS
OTHER
BUILDING EXTERIOR 08000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
MECH/ELEC/IT UPGRADES 08001 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
INTERIOR FINISHES 08002 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
STRUCTURAL REPAIRS 08003 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PAVING & AREAS LIGHTING 08004 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
UTILITIES IMPROVEMENT 08006 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SPECIAL ASSESSMENTS 08008 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
RENOVATIONS SERVICES 08020 0 0 0 0 0 0 0 0 0 8692 0.0039712905 0.5018765518 0 0 0 0 0 0
RENOVATIONS – SUPPLIES 08021 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DESIGN FEES 08022 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PREOPENING ORDER SUPPLIES 08028 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL OTHER 0 0 0 0 0 0 0 0 0 8692 0.0039712905 0.5018765518 0 0 0 0 0 0
PROFESSIONAL FEES
CONSULTING FEES 05312 0 0 0 0 0 0 0 0 0 0 0 0 443.96 0 0.0256342745 443.96 0.000190658 0.0237984455
SURVEY FEES 08007 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CONSULTING RENO FEES 08023 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL PROFESSIONAL FEES 0 0 0 0 0 0 0 0 0 0 0 0 443.96 0 0.0256342745 443.96 0.000190658 0.0237984455
BUILDING
179D ENERGY TAX DEDUCTION 05297 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL BUILDING 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL RENOVATIONS 0 0 0 0 0 0 0 0 0 8692 0.0039712905 0.5018765518 443.96 19.578340391 0.0256342745 443.96 0.000190658 0.0237984455

PAYROLL-RELATED EXPENSES

Current Period Year to Date
Actual Adjusted Budget Original Budget Actual Adjusted Budget Original Budget
COA $ % POR $ % POR $ % POR $ % POR $ % POR $ % POR
SUMMARY OF WAGES
ROOMS MULTIPLE 48402.11 0.1089033225 14.2108367587 59374.63 0.8151985116 17.4323634762 52374.49 0.1469542822 18.5659305211 306476.05 0.1400259366 17.6959437612 333425.55 0.9191738606 19.2520093539 351146.43 0.1507993141 18.8231803806
FOOD & BEVERAGE MULTIPLE 5913.38 0.0133049309 1.7361655901 6750 0.8760562963 1.9817968291 6750 0.0189393998 2.3927685218 23260.76 0.0106276158 1.3430775449 47250 0.4922912169 2.7282175645 47250 0.0202914425 2.5328330206
ADMINISTRATIVE & GENERAL MULTIPLE 5769.24 0.0129806201 1.6938461538 6250 0.9230784 1.834997064 6250 0.0175364813 2.2155264091 44256.09 0.0202201785 2.5553490386 43750 1.0115677714 2.5261273746 43750 0.0187883727 2.3452157598
SALES & MARKETING MULTIPLE 1754.4 0.0039473483 0.5150910159 6937.5 0.2528864865 2.036846741 6937.5 0.0194654942 2.4592343141 28129.92 0.0128522878 1.6242231076 48562.5 0.5792518919 2.8040013858 48562.5 0.0208550937 2.6031894934
REPAIRS & MAINTENANCE MULTIPLE 3076.74 0.0069225744 0.9033294187 3666.67 0.8391101463 1.0765325895 3666.67 0.0102880784 1.2997766749 24439.87 0.0111663397 1.4111594203 25666.69 0.9522018616 1.4819960737 25666.69 0.011022522 1.3758611632
TOTAL SUMMARY OF WAGES 64915.87 0.1460587963 19.0592689372 82978.8 0.7823187368 24.3625366999 75978.66 0.2131837358 26.933236441 426562.69 0.1948923584 24.6297528726 498654.74 0.8554269232 28.7923517524 516375.62 0.2217567449 27.6802798177
EMPLOYEE BENEFITS
EMPLOYEE BONUSES MULTIPLE 0 0 0 1500 0 0.4403992954 1500 0.0042087555 0.5317263382 3058.75 0.0013975132 0.176612391 3600 0.8496527778 0.2078641954 3600 0.0015460147 0.192977754
EMPLOYEE HEALTH, DENTAL INSURANCE MULTIPLE 379.67 0.0008542463 0.1114709336 454.81 0.8347881533 0.1335320023 759.79 0.0021318469 0.2693335697 4489.53 0.0020512227 0.2592257059 2991.47 1.5007772099 0.1727276402 5163.76 0.0022175691 0.2768030019
EMPLOYEES PTO MULTIPLE 103.5 0.000232872 0.0303875514 454.81 0.2275675557 0.1335320023 759.79 0.0021318469 0.2693335697 6086.1 0.0027806801 0.3514117443 2991.47 2.0344847182 0.1727276402 5163.76 0.0022175691 0.2768030019
EMPLOYEES SICK MULTIPLE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OWNER'S HEALTH INSURANCE MULTIPLE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SIMPLE IRA MATCH MULTIPLE 657.45 0.0014792431 0.1930270112 454.81 1.4455486907 0.1335320023 759.79 0.0021318469 0.2693335697 5716.27 0.0026117084 0.3300577401 2991.47 1.9108565354 0.1727276402 5163.76 0.0022175691 0.2768030019
WORKMANS COMPENSATION MULTIPLE 0 0 0 454.81 0 0.1335320023 759.79 0.0021318469 0.2693335697 -1277 -0.0005834489 -0.0737340493 2991.47 -0.42688043 0.1727276402 5163.76 0.0022175691 0.2768030019
TOTAL EMPLOYEE BENEFITS 1140.62 0.0025663614 0.3348854962 3319.24 0.3436389053 0.9745273048 4539.16 0.0127361431 1.6090606168 18073.65 0.0082576755 1.043573532 15565.88 1.1611068568 0.898774756 24255.04 0.010416291 1.3001897615
TOTAL PAYROLL-RELATED EXPENSES 66056.49 0.1486251577 19.3941544334 86298.04 0.7654460055 25.3370640047 80517.82 0.2259198789 28.5422970578 444636.34 0.2031500339 25.6733264045 514220.62 0.8646801056 29.6911265085 540630.66 0.2321730359 28.9804695792

Instructions

Candidate Instructions:
You are provided with a mock Profit & Loss (P&L) statement across multiple departments.
Your task is to:
1. Calculate Net Operating Income (NOI) in the SUMMARY tab
2. In the FOOD & BEVERAGE tab, Cost of Sales has been set to 0. Calculate the proper % of revenue.
3. In the PAYROLL-RELATED EXPENSES tab, Rooms and Total Wages % values are blank. Calculate Rooms Payroll % of Rooms Revenue and Total Payroll % of Total Revenue.
4. Identify at least 3 unusual, incorrect, or suspicious items in the P&L.
5. Provide a short explanation of why each item stands out.
6. Suggest how you would investigate or resolve each issue.
If you were asked to review 10 hotel P&Ls each month, how would you structure your process to ensure accuracy without falling behind?

Place your order now for a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A+

Order Solution Now

Platinum Essays