Loading...
HomeMy WebLinkAboutITEM V-ICity of Auburn Work ing Capital Statement 437-Auburn Golf Course June, 2011 Monthly Year-to-Date Variance to Percent of Budget Actual Actual Budget Budget Other 539,500.00 51,812.78 150,396.50 389,103.50 27.9% Green Fees 1,150,000.00 156,205.78 407,214.53 742,785.47 35.4% Total Operating Revenue 1,689,500.00 208,018.56 557,611.03 1,131,888.97 33.0% Salaries & Wages 594,500.00 48,408.68 268,848.90 325,651.10 45.2% Benefits 255,890.00 20,553.97 121,225.50 134,664.50 47.4% Supplies 278,100.00 52,946.83 131,292.60 146,807.40 47.2% Other Service Charges 207,850.00 19,822.86 66,919.07 140,930.93 32.2% Interfund Operating Rentals/Supplies 176,600.00 14,717.00 88,302.00 88,298.00 50.0% Depreciation & Amortization 341,000.00 26,800.46 163,118.92 177,881.08 47.8% Total Operating Expenses 1,853,940.00 183,249.80 839,706.99 1,014,233.01 45.3% Operating Income or loss (164,440.00) 24,768.76 (282,095.96) 117,655.96 171.5% Interest Revenue 500.00 37.60 106.75 393.25 21.4% Miscellaneous Revenue 0.00 3,144.28 9,704.43 (9,704,43) 0.0% Debt Service Interest 188,700.00 94,138.53 94,138.53 94,561.47 49.9% Total Non-operating Revenues (Expenses) (188,200.00) (90,956.65) (84,327.35) (103,872.65) 44.8% Net Income or (loss) (352,640.00) (66,187.89) (366,423.31) 13,783.31 103.9% Depreciation 341,000.00 26,800.46 163,118.92 177,881.08 47.8% Total Items Not Effecting WIG 341,000.00 26,800.46 163,118.92 177,881.08 47.8% Net WIC from Operations (11,640.00) (39,387.43) (203,304.39) 191,664.39 1,746.6% Operating Transfers-in 62,000.00 7,810.29 20,360.73 41,639.27 32.8% Proceeds of Debt Activity 0.00 (350,000.00) 0.00 0.00 0.0% Increase in Restricted Net Assets 54,200.00 0.00 0.00 54,200.00 0.0% Total Resources Other Than Operations 116,200.00 (342,189.71) 20,360.73 95,839.27 17.5% Net Change in Restricted Net Assets 0.00 (352,484.34) (18,433.43) 18,433.43 0.0% Debt Service Principal 226,900.00 0.00 0.00 226,900.00 0.0% Total Uses Other Than Operations 226,900.00 (352,484.34) (18,433.43) 245,333.43 (8.1)% Net Change in WIC $(122,340.00) $(29,092.80) $(164,510.23) $42,170.23 134.5% Working Capital, Beginning of Year $228,668.00 $0.00 $3,751.62 $224,916.38 1.6% Working Capital, End of Period 106,328.00 (29,092.80) (160,758.61) 267,086.61 (151.2)% Net Change in WIC $(122,340.00) $(29,092.80) $(164,510.23) $42,170.23 134.5% 712 012 0 1 1