Laserfiche WebLink
CURRENT MONTH <br />DESCRIPTION <br />YEAR -TO -DATE <br />CURRENT <br />FORECAST <br />ANNUAL <br />BUDGET <br />ACTUAL <br />PCT <br />BUDGET <br />PCT <br />VARIANCE <br />LAST YEAR <br />VARIANCE <br />ACTUAL <br />PCT <br />BUDGET <br />PCT <br />VARIANCE <br />LAST YEAR <br />VARIANCE <br />1.646 <br />1550 <br />96 <br />356 <br />1.290 <br />TOTAL FACILITY ROUNDS <br />3A02 <br />2,450 <br />952 <br />356 <br />3 .046 <br />35.952 <br />35.000 <br />1,313 <br />1.170 <br />143 <br />190 <br />1.123 <br />TOTAL GREEN FEE ROUNDS <br />1548 <br />1524 <br />24 <br />190 <br />1858 <br />28.652 <br />28.628 <br />115 <br />0 <br />115 <br />0 <br />115 <br />TOTAL RESTAURANT COVERS <br />115 <br />f <br />115 <br />0 <br />115 <br />18.115 <br />18.000 <br />102 <br />0 <br />102 <br />0 <br />102 <br />TOTAL BANQUET COVERS <br />102 <br />f <br />102 <br />0 <br />102 <br />1.502 <br />1.400 <br />Revenues <br />0 <br />0% <br />0 <br />0% <br />0 <br />0 <br />0 <br />MEMBERSHIP DUES GOLF SOCIAL <br />0 <br />0% <br />0 <br />0 <br />0 <br />0 <br />0 <br />LI <br />7,897 <br />11% <br />4,700 <br />6% <br />3,197 <br />1,610 <br />0,287 <br />LOYALTY PASS INITIATION FEES <br />16,388 <br />14% <br />7,520 <br />8, <br />20110 <br />13,978 <br />88,768 <br />79,900 <br />8,305 <br />11% <br />11,235 <br />14% <br />(2,930) <br />09,7 <br />7 410 <br />ANNUAL PASS INITIATION FEES <br />22,140 <br />18% <br />17,695 <br />4,447 <br />4,070 <br />17,470 <br />76,370 <br />71,925 <br />35,207 <br />47% <br />35,460 <br />45% <br />(253) <br />0,400 <br />20,007 <br />GREEN FEES <br />41,336 <br />24% <br />46, <br />6400 <br />34,936 <br />886,931 <br />891,725 <br />8,620 <br />12% <br />6,580 <br />8% <br />2,032 <br />1,610 <br />7,002 <br />DRIVING RANGE <br />13,587 <br />1131. <br />10,414 <br />3,173 <br />2,772 <br />10,815 <br />151,927 <br />148,754 <br />7,773 <br />10% <br />9,455 <br />12% <br />(1,682) <br />2 ,571 <br />5,202 <br />GOLF CART RENTALS <br />13,159 <br />11% <br />14,945 <br />2,071 <br />10,588 <br />211,715 <br />213,501 <br />0 <br />0% <br />0 <br />0% <br />0 <br />0 <br />0 <br />TRAIL FEES <br />0 <br />1% <br />0 <br />0 <br />0 <br />i I <br />0 <br />n <br />0 <br />0% <br />0 <br />0% <br />0 <br />0 <br />0 <br />LOCKER RENTAL FEES <br />0 <br />LII <br />0 <br />0 <br />0 <br />LI <br />0 <br />LI <br />(2,098) <br />-3% <br />980 <br />1% <br />(3,086) <br />26 <br />OTHER& MSCELLANEOUS GOLF <br />(2„ <br />1,214 <br />(140) <br />18,208 <br />21,754 <br />3,417 <br />5% <br />6,588 <br />8% <br />(3,171) <br />955 <br />2,462 <br />GOLF SHOP MERCHANDISE <br />8,083 <br />755 <br />104E <br />S, <br />2,291 <br />7,792 <br />14642:3 <br />14 ,752 <br />3,078 <br />4% <br />2,945 <br />4% <br />133 <br />22 <br />3,076 <br />F&B ON-COURSE <br />5,679 <br />5% <br />4,657 <br />1023 <br />22 <br />6,657 <br />67,725 <br />66,703 <br />734 <br />1% <br />0 <br />0% <br />734 <br />477 <br />257 <br />F &B RESTAURANT <br />734 <br />I% <br />0 <br />724 <br />538 <br />196 <br />12,276 <br />121,502 <br />1,821 <br />2% <br />0 <br />0% <br />1,821 <br />0 <br />'1,021 <br />F &B BANQUET <br />1,821 <br />2% <br />0 <br />1,821 <br />'125 <br />1,606 <br />25,022 <br />20,002 <br />(300) <br />0% <br />0 <br />0% <br />(3001 <br />0 <br />OTHER F88(ROOM EQUIPMENT. ETC.) <br />(224) <br />0% <br />0 <br />0 <br />(224, <br />0 <br />74,453 <br />1001, <br />77,959 <br />100", <br />13.5061 <br />14.574 <br />59.879 <br />TOTAL REVENUES <br />120.371 <br />100 <br />112.987 <br />100 <br />7.384 <br />21,651 <br />98.720 <br />1.799.702 <br />1.792318 <br />Less: Cost of Sales <br />2,650 <br />78% <br />4,914 <br />5% <br />2264 <br />639 <br />GOLF SHOP MERCHANDISE <br />6,967 <br />7,768 <br />0 01 <br />1,813 <br />110,167 <br />110,908 <br />1,805 <br />34% <br />1,007 <br />57% <br />745 <br />FOOD BEVERAGE <br />3,036 <br />1,71 7 <br />57'. <br />418 <br />52,22,1 <br />00,012 <br />4.454 <br />6.001 <br />1.547 <br />1.384 <br />(3.070) <br />TOTAL COST OF SALES <br />10.003 <br />9 .485 <br />1518) <br />2.731 <br />(7.272) <br />192.398 <br />191.880 <br />69.999 <br />71.958 <br />11.959) <br />13.190 <br />56.809 <br />GROSS PROFIT <br />110.368 <br />103.502 <br />6.866 <br />18.920 <br />91.448 <br />1.607.304 <br />1.600.438 <br />P3060110014 Benefits <br />11,240 <br />15% <br />12,389 <br />16% <br />1,149 <br />5,147 <br />(6,095) <br />GOLF OPERATIONS <br />23,948 <br />20% <br />28,342 <br />25% <br />4,393 <br />13,354 <br />110,554) <br />176,795 <br />181,188 <br />0 <br />0% <br />0 <br />0% <br />0 <br />LI <br />0 <br />GOLF SHOP MERCHANDISE <br />0 <br />0% <br />0 <br />0% <br />0 <br />B <br />0 <br />0 <br />0 <br />12,731 <br />17% <br />16,339 <br />21% <br />3,608 <br />15,'207 <br />3,176 <br />GOLF COURSE MAINTENANCE <br />31,678 <br />26% <br />34,979 <br />31% <br />3,301 <br />40,023 <br />8,340 <br />297,961 <br />301,262 <br />0 <br />0% <br />0 <br />0% <br />0 <br />LI <br />0 <br />LANDSCAPING <br />0 <br />0% <br />0 <br />0% <br />0 <br />0 <br />11 <br />0 <br />0 <br />2,397 <br />3% <br />5,359 <br />7% <br />2,962 <br />5,915 <br />3,518 <br />FOOD BEVERAGE <br />2,922 <br />2% <br />5,359 <br />5% <br />2437 <br />15,343 <br />12,421 <br />76,355 <br />78,792 <br />6,163 <br />8% <br />14,312 <br />18% <br />8,149 <br />11,331 <br />5,168 <br />GENERAL ADMNISTRATIVE <br />36,654 <br />30% <br />42,935 <br />38% <br />6,282 <br />28,954 <br />165,459 <br />171,741 <br />0 <br />0% <br />0 <br />0% <br />0 <br />0 <br />0 <br />MARKETING <br />0 <br />0% <br />0 <br />0% <br />0 <br />5421 <br />5,421 <br />0 <br />0 <br />0 <br />0% <br />0 <br />0% <br />0 <br />II <br />0 <br />CLUBHOUSE <br />II <br />0% <br />0% <br />0 <br />0 <br />0 <br />0 <br />0 <br />32,531 <br />44% <br />48,399 <br />62% <br />15,868 <br />38,293 <br />5,767 <br />TOTAL PAYROLL AND BENEFITS <br />95201 <br />79'% <br />111.615 <br />99% <br />16,413 <br />103085 <br />7.884 <br />716.570 <br />732,983 <br />Opel'afino Expenses <br />2,075 <br />4% <br />1,750 <br />2% <br />1 925, <br />430 <br />GOLF OPERATIONS <br />3,356 <br />050 <br />1,750 <br />2% <br />(1,606) <br />1,639 <br />2,421 <br />22,025 <br />0 <br />0% <br />0 <br />0% <br />0 <br />Li <br />9 <br />GOLF SHOP MERCHANDISE <br />LI <br />0% <br />(5) <br />LI <br />5 <br />0 <br />7,221 <br />10% <br />7,075 <br />9% <br />3,646 <br />GOLF COURSE MAINTENANCE <br />10,505 <br />9% <br />10,945 <br />10% <br />(20) <br />7 ,757 <br />143,165 <br />143,145 <br />0 <br />0% <br />0 <br />0% <br />0 <br />C <br />LANDSCAPING <br />0 <br />054 <br />0 <br />0% <br />0 <br />0 <br />0 <br />0 <br />401 <br />1% <br />2,000 <br />3% <br />1,539 <br />I I <br />COURSE ELECTRIC WATER PUMPING <br />269 <br />0% <br />4,000 <br />4% <br />3,731 <br />1,360 <br />1,091 <br />21,260 <br />25,000 <br />2,821 <br />4% <br />4,010 <br />5% <br />1,189 <br />2. <br />FOOD BEVERAGE <br />4,132 <br />3% <br />5,000 <br />4% <br />948 <br />676 <br />21,727 <br />22,675 <br />3,132 <br />4% <br />4,536 <br />6% <br />1404 <br />.=,f <br />GENERAL &ADMNISTRATIVE <br />9,986 <br />0,0 <br />0194 <br />8% <br />(892) <br />5,005 <br />72442 <br />71,550 <br />7,637 <br />10% <br />3,275 <br />4% <br />(4,362) <br />1,5 <br />MARKETING <br />15,268 <br />1'336 <br />10,475 <br />9% <br />(4,793) <br />2,228 <br />611093 <br />55,300 <br />3,819 <br />5% <br />4,882 <br />6% <br />1063 <br />3,749 <br />CLUBHOUSE <br />11,104 <br />9% <br />17296 <br />12% <br />2,192 <br />8,518 <br />67,342 <br />69,534 <br />28.065 <br />38% <br />27,528 <br />35', <br />1537) <br />12.834 <br />231) <br />TOTAL OPERATING EXPENSES <br />55.106 <br />46'( <br />54.660 <br />48' <br />1446) <br />25.013 <br />(30.093) <br />409.675 <br />409.229 <br />60.5% <br />81% <br />75.927 <br />97', <br />15.331 <br />51. <br />164) <br />TOTAL PAYROLL AND OPERATING EXPENSES <br />150.307 <br />125 <br />166.275 <br />147', <br />15.968 <br />128.098 <br />122.209) <br />1.126.244 <br />1.142.212 <br />9.403 <br />13% <br />13.969) <br />-5% <br />13.372 <br />47.345 <br />NET OPERATING INCONE <br />1,111: <br />22,833 <br />1 "-.1 `2:. <br />69.239 <br />481.059 <br />458.226 <br />1,523 <br />2% <br />0 <br />0% <br />),52 -3, <br />0 <br />MANAGEMENT FEE <br />(62,755) <br />-52.7 <br />0 <br />0% <br />62,795 <br />0 <br />62,795 <br />(62,795) <br />0 <br />0% <br />0 <br />0% <br />0 <br />0 <br />MANAGEMENT INCENTIVE FEE <br />LI <br />0 <br />0 <br />0% <br />0 <br />0 <br />U <br />0 <br />3490 <br />5% <br />3,200 <br />4% <br />(290) <br />LI <br />MAINTENANCE EOUIPNENT LEASES <br />10,6,166 <br />9% <br />9,600 <br />8% <br />(1,026) <br />1117,146 <br />106,120 <br />0 <br />0% <br />0 <br />0% <br />0 <br />0 <br />GOLF CART LEASES <br />0 <br />0% <br />0 <br />0% <br />0 <br />0 <br />71,660 <br />71,660 <br />3,998 <br />5% <br />4,000 <br />5% <br />2 <br />3,990 <br />INSURANCE (NON WORKERS' COUP) <br />11,994 <br />10% <br />12,000 <br />11% <br />6 <br />7,996 <br />47,994 <br />47,000 <br />392 <br />1% <br />0 <br />0% <br />(392) <br />LI <br />INTEREST AND DEPRECIATION (DEBT SERVICE <br />2315 <br />x% <br />0 <br />0% <br />(235) <br />0 <br />180,235 <br />130000 <br />0 <br />0% <br />0 <br />0% <br />0 <br />0 <br />PERSONAL AND PROPERTY TAXES <br />0 <br />0 °6 <br />0 <br />0% <br />0 <br />0 <br />0 <br />0 <br />0 <br />0% <br />0 <br />0% <br />0 <br />LI <br />ASSESSMENTS <br />LI <br />u-, <br />0 <br />0% <br />0 <br />0 <br />LI <br />9 <br />LI <br />0 <br />0% <br />0 <br />0% <br />0 <br />0 <br />MSCELLANEOUS <br />0 <br />020 <br />0 <br />9'% <br />0 <br />0 <br />0 <br />0 <br />9,403 <br />7200 <br />9% <br />(2,203) <br />3,998 <br />15,405) <br />TOTAL OPERATING EXPENSES <br />(39.939) <br />-33', <br />21.000 <br />191, <br />61,539 <br />7596 <br />47,935 <br />324,241 <br />385.780 <br />0 <br />0% <br />111.169) <br />-14:7 <br />11.169 <br />1415401 <br />41,940 <br />NET INC ONE <br />0 <br />=55 <br />84,373 <br />1117.1741 <br />117,174 <br />156.819 <br />72.440 <br />0% <br />0% <br />-14% <br />0% <br />14% <br />0% <br />0% <br />NET INC ONE" <br />0', <br />75% <br />0% <br />0% <br />0 <br />0 <br />0 <br />0 <br />0 <br />NEW NENEERSHIP DEPOSITS -GROSS <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />NEW NENBERSHIP DEPOSITS I CASH) <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />FINANCED DEPOSITS REC'D <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />(LESS: NENEERSHIP REFUNDS) <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />TOTAL CASH RECEIVED <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />0 <br />COAL CREEK GOLF COURSE <br />CONSOLIDATED INCOME STATEMENT <br />FOR THE PERIOD ENDED <br />March 2011 <br />