OTTAWA MUNICIPAL CAMPGROUND | ||||||||||||||
Operating Summary | ||||||||||||||
May Operating Detail | ||||||||||||||
YTD 42% | ||||||||||||||
(1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11) | ||||
Total Adjusted Plan | YTD Actuals | Accruals | Total Actuals & Accruals | % Actuals & Accruals / Plan | Balance | YTD Plan * | YTD Surplus (Deficit) | Forecasted Actuals to Year End | Forecasted Year-End Actuals | Forecasted Year End Balance | Notes | |||
(2) + (3) | (4) / (1) | (1) - (4) | 42% | (7) - (4) | (4) + (9) | (1) - (10) | ||||||||
Campsite Operations | ||||||||||||||
Compensation | 151,334 | 25,908 | 25,908 | 17% | 125,426 | 63,056 | 37,148 | 125,426 | 151,334 | - | ||||
Purchased Services | 37,234 | 5,693 | 5,693 | 15% | 31,541 | 15,514 | 9,821 | 31,541 | 37,234 | - | ||||
Contracts | - | - | na | - | - | - | - | - | - | |||||
Materials & Supplies | 25,055 | 3,267 | 3,267 | 13% | 21,788 | 10,440 | 7,173 | 21,788 | 25,055 | - | ||||
Fixed Assets | 2,000 | 606 | 606 | 30% | 1,394 | 833 | 227 | 1,394 | 2,000 | - | ||||
Financial | 3,900 | (109) | (109) | -3% | 4,009 | 1,625 | 1,734 | 4,009 | 3,900 | - | ||||
Operating Negative Costs | - | na | - | - | - | - | - | - | ||||||
Secondary Expenses | 7,485 | 5,011 | 5,011 | 67% | 2,474 | 3,119 | (1,892) | 2,474 | 7,485 | - | ||||
Subtotal | 227,008 | 40,376 | - | 40,376 | 18% | 186,632 | 94,587 | 54,211 | 186,632 | 227,008 | - | |||
Recoveries | - | - | na | - | - | - | - | - | - | |||||
Revenue | (225,800) | (37,312) | - | (37,312) | 17% | (188,488) | (94,083) | (56,771) | (188,488) | (225,800) | - | |||
Net | 1,208 | 3,064 | - | 3,064 | 2.54 | (1,856) | 503 | (2,561) | (1,856) | 1,208 | - | |||
Camspite Store | ||||||||||||||
Materials & Supplies | 13,000 | 3,803 | 3,803 | 29% | 9,197 | 5,417 | 1,614 | 9,197 | 13,000 | - | ||||
Recoveries | - | (1,138) | - | (1,138) | na | 1,138 | - | 1,138 | 1,138 | - | - | |||
Revenue | (19,200) | - | 0% | (19,200) | (8,000) | (8,000) | (19,200) | (19,200) | - | |||||
Net | (6,200) | 2,665 | - | 2,665 | -43% | (8,865) | (2,583) | (5,248) | (8,865) | (6,200) | - | |||
Ottawa-Nepean Campsite | ||||||||||||||
Compensation | 151,334 | 25,908 | - | 25,908 | 17% | 125,426 | 63,056 | 37,148 | 125,426 | 151,334 | - | |||
Purchased Services | 37,234 | 5,693 | - | 5,693 | 15% | 31,541 | 15,514 | 9,821 | 31,541 | 37,234 | - | |||
Contracts | - | - | - | - | na | - | - | - | - | - | - | |||
Materials & Supplies | 38,055 | 7,070 | - | 7,070 | 19% | 30,985 | 15,856 | 8,786 | 30,985 | 38,055 | - | |||
Fixed Assets | 2,000 | 606 | - | 606 | 30% | 1,394 | 833 | 227 | 1,394 | 2,000 | - | |||
Financial | 3,900 | (109) | - | (109) | -3% | 4,009 | 1,625 | 1,734 | 4,009 | 3,900 | - | |||
Operating Negative Costs | - | - | - | - | na | - | - | - | - | - | - | |||
Secondary Expenses | 7,485 | 5,011 | - | 5,011 | 67% | 2,474 | 3,119 | (1,892) | 2,474 | 7,485 | - | |||
Subtotal | 240,008 | 44,179 | - | 44,179 | 18% | 195,829 | 100,003 | 55,824 | 195,829 | 240,008 | - | |||
Recoveries | - | (1,138) | - | (1,138) | na | 1,138 | - | 1,138 | 1,138 | - | - | |||
Revenue | (245,000) | (37,312) | - | (37,312) | 15% | (207,688) | (102,083) | (64,771) | (207,688) | (245,000) | - | |||
Net | (4,992) | 5,729 | - | 5,729 | -1.15 | (10,721) | (2,080) | (7,809) | (10,721) | (4,992) | - | |||
* | Assumes spending and revenue occur evenly throughout the year, and therefore the plan is evenly distributed throughout the year (i.e. at 50% of the year expired, targeted spending and revenues are 50% of the plans). | |||||||||||||
Notes | ||||||||||||||
Forecast: | ||||||||||||||
Actuals/Accruals: | ||||||||||||||