Appendix B
2007 Operating Status Report  -  Actual vs Budget  -  Expenditures / Revenues
As of March 31, 2007
                 
  Expenditures   Revenues
   Annual Budget    1st Qrt Budget  1st Qrt  Actual  %   Spent    Annual Budget    1st Qrt Budget 1st Qrt  Actual  % Received
   $000    $000  $000  %    $000    $000  $000  %
                   
Elected Officials          10,163           2,541            2,211 87%                      -                    -                  -   -
                   
City Manager             5,814           1,079               991 92%                   (40)                  -                  -   -
                   
Office of the Auditor General             1,761              236               228 97%                      -                    -                  -    
                   
Corporate Services                  
Chief Corporate Services Officer              1,881               470                419 89%                      -                    -                  -   -
Client Services & Public Information              9,171            2,199             2,243 102%                 (305)                (76)                (5) 7%
Financial Services            37,809            9,452             9,154 97%              (2,439)              (640)            (467) 73%
Real Property Asset Management            39,383            9,587             9,084 95%              (8,375)           (2,094)         (2,187) 104%
Legal Services              5,282            1,341             1,398 104%                 (250)                (63)                -   -
Information Technology Services            42,551          13,093           13,070 100%                   (57)                (14)              (11) 79%
City Clerk's Branch            15,446            3,264             3,313 102%              (2,263)              (497)            (440) 89%
Employee Services            17,081            4,099             4,172 102%                 (235)                (59)                -   -
Total        168,604         43,505          42,853 99%           (13,924)         (3,443)        (3,110) 90%
                   
Planning, Transit & the Environment                  
Deputy City Manager                 857               214                235 110%                      -                    -                  -   -
Building Services - Ontario Building Code            14,548            3,454             2,498 72%            (18,432)           (3,871)         (7,486) 193%
Building Services - Other Permits                 644               161                123 76%                 (644)              (161)            (184) 114%
Planning & Infrastructure Approvals            10,731            2,669             2,319 87%              (6,531)           (2,515)         (2,664) 106%
Planning, Environment & Infra. Policy              8,242            2,052             1,720 84%                 (544)              (136)              (27) 20%
Economic  Development & Strategic Planning              3,185               795                792 100%                      -                    -                (14) -
Transit Services          301,961          68,626           66,526 97%          (147,301)         (38,041)       (37,826) 99%
Total        340,168         77,971          74,213 95%        (173,452)       (44,724)     (48,201) 108%
                   
                   
Committee Of Adjustment                950              238               202 85%                (950)             (238)           (211) 89%
                   
Community & Protective Services                  
Deputy City Manager              3,123               781                675 86%                      -                    -              (161) -
Paramedic Services            51,656          12,640           12,276 97%            (28,828)           (7,207)         (8,957) 124%
By-law Enforcement            14,878            3,720             3,220 87%            (18,874)           (4,476)         (3,793) 85%
Emergency Measures Unit              1,788               422                343 81%                   (97)                (24)              (21) 88%
Fire Services          107,134          25,595           24,674 96%                 (649)              (162)            (219) 135%
Housing          127,213          33,871           29,919 88%            (48,052)         (13,215)       (12,867) 97%
Parks & Recreation          168,883          38,312           33,896 88%          (104,836)         (26,600)       (27,772) 104%
Public Health            40,676            9,624             8,626 90%            (32,203)           (7,933)         (6,968) 88%
Employment & Financial Assistance          262,410          65,457           59,807 91%          (150,544)         (37,636)       (37,338) 99%
Cultural Services & Community Funding            33,319            9,876             9,837 100%              (2,131)              (496)            (729) 147%
Long Term Care            45,199          11,360           11,496 101%            (45,199)         (11,300)         (9,156) 81%
Total        856,279      211,658       194,769 92%        (431,413)     (109,049)   (107,981) 99%
2007 Operating Status Report  -  Actual vs Budget  -  Expenditures / Revenues
As of March 31, 2007
   
  Expenditures   Revenues
   Annual Budget    1st Qrt Budget  1st Qrt  Actual  %   Spent    Annual Budget    1st Qrt Budget 1st Qrt  Actual  % Received
   $000    $000  $000  %    $000    $000  $000  %
Ottawa Public Library          34,592           8,617            8,377 97%             (3,495)             (529)           (567) 107%
                 
Ottawa Police Services        198,730         49,489          48,971 99%           (11,686)       (2,922)        (2,047) 70%
                 
Public Works & Services                
Deputy City Manager              3,134               782                571 73%                      -                  -                  -   -
Surface Operations          119,130          40,169           36,422 91%              (1,674)            (760)              (83) 11%
Traffic & Parking Operations            36,312            8,274             6,481 78%            (16,441)         (3,348)         (2,979) 89%
Waste Water & Drainage Services            41,373            8,951             6,463 72%              (3,464)         (1,701)            (238) 14%
Drinking Water Services            43,187            9,928             8,654 87%              (1,964)            (290)            (415) 143%
Solid Waste Services            47,355            7,924             6,506 82%            (16,090)            (875)            (333) 38%
Infrastructure Services            11,325            3,238             2,792 86%              (2,967)            (565)            (767) 136%
Fleet Services - Operational Expenditures                    -            32,953           32,244 98%                      -                  -                  -   -
Fleet Services - Recoveries / Revenues                 654         (37,121)          (36,055) 97%                 (654)            (163)            (121) 74%
Total        302,470         75,098          64,078 85%           (43,254)       (7,702)        (4,936) 64%
                 
Corporate Efficiency                
Corporate Efficiency Savings / Sponsorship            (9,823)           (9,823)                  97 -1%              (1,500)           (1,500)            (108) 7%
Corporate Gapping to be Achieved            (3,020)           (3,020)                   -   -                        -                    -                -   -
                 
Total         (12,843)       (12,843)                  97 -1%             (1,500)       (1,500)           (108) 7%
                 
Departmental Total     1,906,688      457,589       436,990 95%        (679,714)   (170,107)   (167,161) 98%
                   
Non-Departmental                  
                   
Corporate Benefit Provisions          19,559           4,448            3,863 87%             (4,588)                  -                  (9) -
                   
Capital Formation Costs                  
Contribution to Capital Reserves          146,621                    -                   -   -                      -                    -                  -   -
Debt Charges            84,960          25,431           25,457 100%                      -                    -                  -   -
Sale of Former Ottawa City Hall - Reserves                    -                      -                   -   -              (4,443)                  -                  -   -
Sale of  Surplus Lands                    -                      -                  43 -                        -                  -           (3,014) -
Ray Friel Reserve Fund                 146                 37                181 489%                        -                  -              (404) -
Development Charges                    -                      -                   -   -                 (774)                  -                  -   -
Provincial Revenues - Long Term Care per diem                    -                      -                   -   -              (1,477)              (369)            (369) 100%
Reserve Fund - Transit                    -                      -                   -   -              (1,303)                  -                  -   -
100 Constellation Lease              5,497            1,699             1,699 100%                        -                  -                  -   -
Sale of Surplus Lands 0%                  -                     -                          -      
           237,224          27,167           27,380 101%              (7,997)            (369)         (3,787) 1026%
                   
Corporate Common Expenditures                  
Contribution to Election Expense Reserve              1,125                    -                   -   -                        -                    -                -   -
Self Insurance              5,972               613                545 89%                 (297)                (19)              (15) 79%
Financial Charges & Other              6,842               488                400 82%                        -                    -                -   -
                   
             13,939            1,101                945 86%                 (297)                (19)              (15) 79%
2007 Operating Status Report  -  Actual vs Budget  -  Expenditures / Revenues
As of March 31, 2007
                       
  Expenditures Revenues
   Annual Budget    1st Qrt Budget  1st Qrt  Actual  %   Spent  Annual Budget    1st Qrt Budget 1st Qrt  Actual  % Received
   $000    $000  $000  %  $000    $000  $000  %
Corporate Common Revenues                
Water Billings                    -                    -                     -   -          (77,202)         (16,850)       (16,888) 100%
Fire Supply Charge                    -                    -                     -   -            (7,803)           (2,251)         (2,314) 103%
Sewer Surcharge Revenues                    -                    -                     -   -        (110,875)         (25,400)       (25,188) 99%
Solid Waste Revenues                    -                    -                     -   -          (22,975)                  -              (106) -
Penalty & Interest                    -                    -                     -   -          (10,599)           (2,650)         (2,591) 98%
Investment Income                    -                    -                     -   -          (23,790)           (3,139)         (2,654) 85%
Ottawa Lands Development                    -                    -                     -   -            (5,000)                  -                  -   -
Hydro Ottawa Dividend                    -                    -                     -   -          (14,000)                  -                  -   -
Ontario Municipal Partnership Fund                    -                    -                     -   -          (10,119)           (2,530)         (2,530) 100%
Provincial Offences Act                    -                    -                     -   -          (11,894)           (2,974)         (3,086) 104%
Rideau Carleton Raceway                    -                    -                     -   -            (3,800)                  -                  -   -
Lottery Fees                    -                    -                     -   -               (904)              (151)            (178) 118%
Tax Rate Stabilization Reserve Fund                    -                    -                     -   -          (31,781)                  -                  -   -
Tax Certificate / New Account Revenues                    -                    -                     -   -            (3,095)              (774)            (594) 77%
Other Miscellaneous Revenues                    -                    -                     -   -            (2,944)              (474)            (310) 65%
                 
                     -                    -                     -   -        (336,781)         (57,193)       (56,439) 99%
                 
Taxation Related Revenues & Expenditures                
Supplemental Assessment                    -                    -                     -   -          (21,217)                  -                  -   -
Payments-in-lieu of Taxation                    -                    -                     -   -        (169,634)         (85,972)       (85,974) 100%
Public Institutions                    -                    -                     -   -            (4,490)                  -                  -   -
Local Improvement Revenue                    -                    -                     -   -            (2,000)                  -                  (6) -
Tax Rebates and Remissions            16,252            3,439             3,545 103%                      -                  -                  -   -
Municipal Property Assessment Corp                    -                     -   0%                    -                  -   0%
Municipal Property Assessment Corporation            10,295            2,574             2,611 101%                      -                  -                  -   -
                 
             26,547            6,013             6,156 102%        (197,341)         (85,972)       (85,980) 100%
                 
Total Non Departmental        297,269         38,729          38,344 99%      (547,004)   (143,553)   (146,230) 102%
                 
Property Tax Bill                
Property Tax Revenues                    -                    -                     -   -      (983,395)     (490,793)   (487,644) 99%
Total City     2,203,957      496,318       475,334 96%     (2,210,113)     (804,453)   (801,035) 100%