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: