Loading...
HomeMy WebLinkAboutITEM V-FCity of Auburn Working Capital Statement 437-Auburn Golf Course March, 2011 Monthly Year-to-Date Variance to Percent of Budget Actual Actual Budget Budget Other 539,500.00 17,095.25 37,945.92 501,554.08 7.0% Green Fees 1,150,000.00 39,497.66 77,815.85 1,072,184.15 6.8% Total Operating Revenue 1,689,500.00 56,592.91 115,761.77 1,573,738.23 6.9% Salaries & Wages 604,110.00 42,980.31 127,887.93 476,222.07 21.2% Benefits 257,120.00 19,572.27 59,230.98 197,889.02 23.0% Supplies 282,100.00 5,381.84 32,158.89 249,941.11 11.4% Other Service Charges 203,850.00 9,519.63 19,408.04 184,441.96 9.5% Interfund Operating Rentals/Supplies 176,600.00 14,717.00 44,151.00 132,449.00 25.0% Depreciation &Amortization 341,000.00 27,246.11 82,161.87 258,838.13 24.1% Total Operating Expenses 1,864,780.00 119,417.16 364,998.71 1,499,781.29 19.6% Operating Income or Loss (175,280.00) (62,824.25) (249,236.94) 73,956.94 142.2% Interest Revenue 500.00 0.00 0.00 500.00 0.0% Miscellaneous Revenue 0.00 21.10 3,244.57 (3,244.57) 0.0% Debt Service Interest 188,700.00 0.00 0.00 188,700.00 0.0% Total Non-operating Revenues (Expenses) (188,200.00) 21.10 3,244.57 (191,444.57) (1.7)% Net Income or (Loss) (363,480.00) (62,803.15) (245,992.37) (117,487.63) 67.7% Depreciation 341,000.00 27,246.11 82,161.87 258,838.13 24.1% Total Items Not Effecting WIC 341,000.00 27,246.11 82,161.87 258,838.13 24.1% Net WIC from Operations (22,480.00) (35,557.04) (163,830.50) 141,350.50 728.8% Operating Transfers-in 62,000.00 1,974.88 3,890.79 58,109.21 6.3% 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 1,974.88 3,890.79 112,309.21 3.3% Net Change in Restricted Net Assets 0.00 (3,939.43) (7,721.09) 7,721.09 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 (3,939.43) (7,721.09) 234,621.09 (3.4)% Net Change in WlC $(133,180.00) $(29,642.73) $(152,218.62) $19,038.62 114.3% Working Capital, Beginning of Year $228,668.00 $0.00 $3,751.62 $224,916.38 1.6% Working Capital, End of Period 95,488.00 (29,642.73) (148,467.00) 243,955.00 (155.5)% Net Change in WlC $(133,180.00) $(29,642.73) $(152,218.62) $19,038.62 114.3% 4/20/2011