Input

Document Sample
Input Powered By Docstoc
					ANCIL HOFFMAN GOLF SHOP CONSOLIDATED FINANCIAL STATEMENT For the Twelve Months Ending June 30, 2009 Current Month Actual ROUNDS COUNT INCOME GREEN FEES GOLF CAR RENTALS DRIVING RANGE LESSONS EQUIPMENT RENTALS MERCHANDISE SALES WHOLESALE SALES OTHER INCOME
160,354.66 50,523.00 17,058.50 15,457.52 1,133.00 59,746.07 5,694.79 106.00 168,750.00 52,200.00 19,875.00 15,000.00 1,500.00 68,250.00 1,500.00 0.00 174,582.71 56,561.59 18,277.50 15,648.99 1,497.80 54,533.93 5,506.58 105.25 1,507,319.11 450,959.45 172,786.50 140,740.11 11,996.00 575,082.83 15,767.99 1,336.85 1,564,875.00 484,068.00 184,308.00 139,100.00 13,910.00 632,905.00 18,000.00 0.00 1,595,132.31 488,425.57 195,746.11 134,342.33 13,388.30 645,516.99 19,205.37 1,302.00

Current Month Budget 7,500

Current Month Last Year 7,670

Year - to - Date Actual 67,792

Year - to - Date Budget 69,550

Year - to - Date Last Year 71,614

6,994

TOTAL INCOME COST OF GOODS PURCHASES-MERCHANDISE FREIGHT IN PURCHASES DISCOUNTS NET PS INVENTORY CHANGE

310,073.54

327,075.00

326,714.35

2,875,988.84

3,037,166.00

3,093,058.98

24,409.09 1,023.55 (1,060.91) 21,514.97

48,458.00 0.00 0.00 0.00

6,988.32 137.22 (1,538.47) 38,653.92

392,618.94 10,896.48 (7,355.54) 28,894.35

449,365.00 0.00 0.00 0.00

511,956.92 12,789.33 (11,562.52) (55,093.74)

TOTAL COST OF GOODS

45,886.70
70%

48,458.00
69%

44,240.99
74%

425,054.23
72%

449,365.00
69%

458,089.99
69%

GROSS PROFIT EXPENSES PRO SHOP WAGES WAGES-GOLF ACADEMY PAYROLL TAXES WORKMEN'S COMP HEALTH INSURANCE 401K EMPLOYER CONTRIBUTION TOTAL PRO SHOP CARTS/RANGE WAGES PAYROLL TAXES WORKMEN'S COMP HEALTH INSURANCE 401K EMPLOYER CONTRIBUTION TOTAL CARTS/RANGE GENERAL MANAGER WAGES PAYROLL TAXES WORKMEN'S COMP HEALTH INSURANCE 401K EMPLOYER CONTRIBUTION TOTAL GEN'L MANAGER ADMIN WAGES PAYROLL TAXES WORKMEN'S COMP HEALTH INSURANCE 401K EMPLOYER CONTRIBUTION TOTAL ADMIN

264,186.84

278,617.00

282,473.36

2,450,934.61

2,587,801.00

2,634,968.99

14,086.08 10,617.00 2,172.39 381.77 733.18 296.19

12,344.00 10,500.00 2,284.00 404.00 1,500.00 350.00

11,631.51 10,294.40 1,854.84 (1,601.21) 1,166.99 267.07

144,175.29 98,428.60 22,219.77 4,257.49 8,670.22 3,244.45

136,146.00 97,370.00 23,351.00 4,131.00 18,500.00 4,200.00

148,752.65 100,143.69 22,598.06 5,826.78 17,512.84 3,066.76

28,286.61
7,417.12 902.07 173.51 0.00 0.00

27,382.00
7,929.00 793.00 193.00 75.00 0.00

23,613.60
6,778.61 837.50 (545.56) 0.00 15.49

280,995.82
78,797.18 9,408.33 1,664.53 0.00 144.81

283,698.00
86,889.00 8,689.00 2,112.00 900.00 0.00

297,900.78
77,573.17 9,081.42 2,232.00 139.03 161.68

8,492.70
4,209.54 307.95 72.10 355.93 118.84

8,990.00
5,750.00 575.00 16.00 500.00 70.00

7,086.04
4,352.54 309.13 152.57 610.75 118.84

90,014.85
60,422.01 4,859.92 929.93 4,283.92 1,746.43

98,590.00
72,000.00 7,200.00 200.00 6,250.00 840.00

89,187.30
68,398.49 5,253.75 1,381.83 6,904.96 1,993.69

5,064.36
450.00 33.35 7.64 0.00 0.00

6,911.00
430.00 43.00 1.00 0.00 0.00

5,543.83
1,124.09 77.99 28.29 0.00 0.00

72,242.21
6,988.67 636.17 103.22 0.00 0.00

86,490.00
5,160.00 516.00 12.00 0.00 0.00

83,932.72
7,897.61 644.86 151.73 0.00 0.00

490.99

474.00

1,230.37

7,728.06

5,688.00

8,694.20

TOTAL WAGES & BENEFITS

42,334.66

43,757.00

37,473.84

450,980.94

474,466.00

479,715.00

11/1/2009 at 1:54 AM

For Management Purposes Only

Page: 1

ANCIL HOFFMAN GOLF SHOP CONSOLIDATED FINANCIAL STATEMENT For the Twelve Months Ending June 30, 2009 Current Month Actual PRO SHOP EXPENSES CLUB REPAIR SUPPLIES DISPLAY EQUIP/SUPPLIES EDUC/DUES/FEES MISCELLANEOUS RENTAL EQUIPMENT R&R REPAIR & MAINTENANCE SHIPPING STAFF UNIFORMS STARTER SUPPLIES SUPPLIES CASH SHORT/OVER TOTAL PRO SHOP RANGE OPERATIONS RANGE BALLS MISCELLANEOUS REPAIR & MAINTENANCE STAFF UNIFORMS SUPPLIES/SMALL EQUIP TOTAL RANGE GOLF CARS GOLF CAR LEASE REPAIR & MAINTENANCE STAFF UNIFORMS SUPPLIES/MISC TOTAL GOLF CARS GOLF ACADEMY ADVERTISING EQUIPMENT OFFICE SUPPLIES TOTAL GOLF ACADEMY ADMINISTRATION ADVERTISING/PROMO REWARDS CLUB ALARM ARMORED CAR TRANSPORT AUTO-GM BANK FEES/DISCOUNT BLDG. REPAIR & MAINTENANCE COMPUTER RPR/MAINT EMPLOYEE RETENTION INSURANCE INTEREST LEGAL INSURANCE MISCELLANEOUS OFFICE SUPPLIES OUTSIDE SERVICES POSTAGE SMALL EQUIP & SOFTWARE TAXES/LICENSES/FEES TRAVEL UTILITIES TOTAL ADMIN
3,235.60 81.75 161.94 411.95 250.00 3,041.55 0.00 330.00 0.00 1,187.03 272.94 0.00 0.00 0.00 1,067.21 144.00 254.60 146.74 150.00 1,413.10 3,750.00 0.00 150.00 350.00 250.00 3,689.00 0.00 250.00 50.00 1,275.00 275.00 0.00 25.00 350.00 400.00 50.00 0.00 225.00 100.00 1,100.00 3,199.90 81.55 0.00 389.75 250.00 3,044.00 624.66 330.00 0.00 1,264.74 321.99 0.00 29.00 92.34 610.57 101.34 101.29 187.88 150.00 1,172.97 40,785.68 994.13 3,104.95 4,627.41 3,000.00 36,209.20 219.84 4,937.46 0.00 12,691.70 3,343.19 0.00 0.00 2,053.20 5,175.43 611.12 2,590.24 5,609.59 1,800.00 12,577.62 45,000.00 0.00 1,800.00 4,200.00 3,000.00 34,258.00 0.00 3,000.00 2,050.00 15,300.00 3,300.00 0.00 300.00 4,200.00 4,800.00 600.00 0.00 2,700.00 1,200.00 13,200.00 41,950.36 1,125.02 2,211.36 4,492.70 3,000.00 36,440.51 1,063.98 5,947.00 0.00 15,269.82 3,638.15 0.00 501.46 3,931.92 4,467.03 323.34 371.37 3,343.88 1,800.00 11,474.76 0.00 175.00 0.00 0.00 0.00 0.00 0.00 0.00 133.27 56.01 700.00 174.28 0.00 0.00 0.00 263.97 668.81 550.35 5,145.88 737.88 0.00 0.00 5,345.00 250.00 150.00 25.00 5,329.15 1,010.37 0.00 0.00 61,502.60 4,387.66 0.00 210.93 64,140.00 3,000.00 1,800.00 300.00 63,182.01 4,171.56 824.59 242.74 0.00 555.79 267.40 0.00 0.00 0.00 10.00 25.00 100.00 250.00 0.00 0.00 57.68 494.34 567.02 11,850.00 712.16 1,005.78 729.04 3,119.47 30,000.00 120.00 300.00 1,200.00 3,000.00 24,966.00 27.32 2,056.64 1,638.41 2,396.79 26.57 248.77 1,461.00 81.99 0.00 0.00 59.81 203.25 151.92 55.45 134.14 150.00 100.00 250.00 25.00 150.00 125.00 125.00 0.00 100.00 10.00 0.00 234.27 0.00 1,155.00 77.83 0.00 250.00 91.48 0.00 0.00 0.00 99.67 1,600.08 625.57 2,935.00 652.42 574.61 308.80 1,491.07 563.25 1,127.75 3,879.41 173.91 1,800.00 2,200.00 3,000.00 300.00 1,800.00 1,500.00 1,500.00 1,000.00 1,200.00 120.00 0.00 1,369.64 624.38 5,353.50 833.57 87.21 1,084.28 1,176.70 1,221.15 136.72 3,397.62 2.42

Current Month Budget

Current Month Last Year

Year - to - Date Actual

Year - to - Date Budget

Year - to - Date Last Year

2,422.90

1,035.00

1,908.25

13,931.87

14,420.00

15,287.19

823.19

385.00

1,119.04

17,416.45

34,620.00

31,085.16

5,883.76

5,770.00

6,339.52

66,101.19

69,240.00

68,420.90

175.00

0.00

133.27

930.29

0.00

1,483.13

12,148.41

12,289.00

11,951.98

140,330.76

138,908.00

141,352.66

11/1/2009 at 1:54 AM

For Management Purposes Only

Page: 2

ANCIL HOFFMAN GOLF SHOP CONSOLIDATED FINANCIAL STATEMENT For the Twelve Months Ending June 30, 2009 Current Month Actual BASE FEE PERFORMANCE BONUS INCENTIVE BONUS CLEARING ACCOUNT TOTAL MANAGEMENT FEES TOTAL EXPENSES NET PROFIT (LOSS)
4,624.07 1,955.42 0.00 0.00

Current Month Budget
4,273.00 1,979.00 0.00 0.00

Current Month Last Year
4,189.17 1,579.96 0.00 0.00

Year - to - Date Actual
54,619.04 16,393.75 30,301.86 0.00

Year - to - Date Budget
51,276.00 18,355.00 31,000.00 0.00

Year - to - Date Last Year
50,270.04 22,185.10 33,290.57 0.00

6,579.49 70,367.41 193,819.43

6,252.00 69,488.00 209,129.00

5,769.13 64,695.03 217,778.33

101,314.65 791,006.15 1,659,928.46

100,631.00 832,285.00 1,755,516.00

105,745.71 843,089.75 1,791,879.24

11/1/2009 at 1:54 AM

For Management Purposes Only

Page: 3

ANCIL HOFFMAN GOLF SHOP 2006-07 Prior Fiscal Year Actual 3,692 3,584 5,988 6,486 7,273 7,526 6,857 7,574 6,780 5,721 3,936 3,200 68,617

Jan 2009 Feb 2009 Mar 2009 Apr 2009 May 2009 Jun 2009 Jul 2008 Aug 2008 Sep 2008 Oct 2008 Nov 2008 Dec 2008 Total

2008-2009 Actual 3,979 3,201 5,224 6,891 7,198 6,994 7,877 7,167 5,897 5,484 4,687 3,193 67,792

2008-2009 Budget 3,000 3,750 5,500 6,900 7,500 7,500 7,600 7,500 6,400 5,600 5,000 3,300 69,550

Variance 979 (549) (276) (9) (302) (506) 277 (333) (503) (116) (313) (107) (1,758)
YTD

2007-2008 Actual 2,765 4,424 7,031 7,070 7,461 7,670 7,597 7,431 6,260 5,619 5,037 3,249 71,614

Variance 1,214 (1,223) (1,807) (179) (263) (676) 280 (264) (363) (135) (350) (56) (3,822)
YTD

Variance (927) 840 1,043 584 188 144 740 (143) (520) (102) 1,101 49 2,997
YTD

ANCIL HOFFMAN GOLF SHOP BALANCE SHEET JUNE 30, 2009

ASSETS CURRENT ASSETS CASH ON HAND CASH IN BANK-UNION BANK CASH IN BANK-UNION BANK P C CASH IN BANK-COUNTY TREASURY ACCOUNTS RECEIVABLE EMPLOYEE ADVANCE PRO SHOP INVENTORY PREPAID EXPENSES PREPAID PROPERTY TAXES PREPAID INSURANCE TOTAL CURRENT ASSETS PROPERTY AND EQUIPMENT PROPERTY & EQUIPMENT CONTRIBUTED EQUIPMENT TOTAL PROPERTY AND EQUIPMENT OTHER ASSETS DEPOSITS DEPOSITS-WORKER'S COMP TOTAL OTHER ASSETS TOTAL ASSETS

5,001.92 (12,011.64) 1,766.77 17,604,737.37 26,658.53 0.00 253,329.98 0.00 440.31 7,781.87 17,887,705.11

28,224.86 28,496.72 56,721.58

6,073.00 3,767.00 9,840.00 17,954,266.69

11/1/2009 at 1:54 AM

Page: 6

ANCIL HOFFMAN GOLF SHOP BALANCE SHEET JUNE 30, 2009

LIABILITIES AND CAPITAL CURRENT LIABILITIES ACCOUNTS PAYABLE SALES TAX PAYABLE GIFT CERTIFICATES PAYABLE CREDIT BOOK PAYABLE ACCRUED EXPENSES ACCRUED SALARY & WAGES ACCRUED PAYROLL TAXES LINE OF CREDIT-UNION BANK DUE TO CI - LOC UNION BANK TOTAL CURRENT LIABILITIES LONG-TERM LIABILITIES TOTAL LONG-TERM LIABILITIES TOTAL LIABILITIES CAPITAL EGI CAPITAL IMPROVEMENTS PREEXISTING GC & CR BOOK RETAINED EARNINGS NET INCOME TOTAL CAPITAL TOTAL LIABILITIES & CAPITAL 0.00 333,684.18

40,278.49 (605.35) 33,883.64 80,168.74 58,623.97 33,640.00 3,454.00 120,240.69 (36,000.00) 333,684.18

28,496.72 (16,848.84) 15,949,006.17 1,659,928.46 17,620,582.51 17,954,266.69

11/1/2009 at 1:54 AM

Page: 7


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:29
posted:11/1/2009
language:English
pages:7