Budget Projection Worksheet 20082009 by pharmphresh31

VIEWS: 0 PAGES: 2

									                                                               General Ledger

Budget Projection Worksheet 2008/2009
Revenue                                                                 Expense
                                     2008 Final         2009                                                    2008 Final            2009
           Annual Membership                                                            Annual Membership
      Student Membership Fees         $225,300.00      $235,438.00                       Health and Dental       $246,477.04         $246,477.04
              Health and Dental       $239,271.64      $264,529.44                        Sait Athletic Fees      $2,970.00            $3,000.00
                         Total       $464,571.64      $499,967.44                                      Total    $249,447.04         $249,477.04

               Student Services                                                             Payroll: Wages
                        Arthole        $55,566.58       $64,000.00                           Food Services        $71,900.64         $72,000.00
                      Cafeteria       $221,955.84      $225,000.00             Food Services Casual Wages          $3,262.50          $3,000.00
                       Vending         $21,236.69       $21,500.00                            Artawearness         $5,906.96          $6,000.00
                          ATM           $4,682.35        $5,000.00             Artawearness Casual Wages             $400.00            $500.00
                         Total       $303,441.46      $315,500.00                                    Arthole      $21,845.32         $16,000.00
                                                                                     Arthole Casual Wages            $858.78   --
                        Events                                                                       Events       $12,180.13           $5,400.00
               Bar Event Sales          $9,845.76       $21,600.00                   Events Casual Wages             $127.00             $500.00
             Dept. Event Sales            -$567.19           $0.00                                Executive       $66,000.42          $52,000.00
                MNG Openings            $3,690.34        $1,000.00                 Executive Casual Wages          $2,143.00           $2,500.00
      Show and Sale Commision          $37,386.01       $37,500.00                                     Grad        $3,494.40           $3,500.00
                   Ticket Sales        $21,472.89       $18,500.00              Grad Project Casual Wages            $644.00           $1,000.00
             Grad Ticket Sales           --              $2,000.00                                     MNG        $14,433.46          $11,863.00
             Other Ticket Sales          --              $4,000.00                                    Office      $36,046.80          $84,000.00
                         Total        $71,827.81       $84,600.00                     Office Casual Wages            $380.00             $450.00
                                                                                            Show and Sale          $7,292.76           $7,300.00
   Fundraising/Donations/Grants                                               Show and Sale Casual Wages           $3,158.95          $3,200.00
      ArtaWearness Fundraising          $2,304.81        $2,000.00                                Honoraria       $13,149.48         $14,000.00
       ArtaWearness AFA Grant           $6,000.00        --                                           Total     $263,224.60         $283,213.00
               Grad Fundraising         $3,367.00        $9,250.00
                Grad Donations          $1,310.10        $1,000.00                             Payroll: Misc
                MNG AFA Grant          $15,000.00       $20,000.00                          Parking Passes         $5,200.00           $5,600.00
                Other Donations            $20.00       $28,000.00                                  Benefits         $100.00             $200.00
                         Total        $28,001.91       $60,250.00                 Professional Development           $494.10             $500.00
                                                                                                        UIC        $5,853.04           $6,200.00
                   Publications                                                                         CPP        $8,543.34           $8,600.00
          Grad Catalogue Sales          $8,492.75        $5,000.00                                     WCB         $1,372.73           $1,500.00
          Handbook Advertising          $2,351.21        $2,250.00                          Payroll Charges          $389.70             $400.00
              Muse Advertising            $125.00        $1,000.00                                    Total      $21,952.91          $23,000.00
                         Total        $10,968.96        $8,250.00
                                                                                               Payroll Total    $285,177.51         $306,213.00
                Other Revenue
                       Interest         $1,121.28        $1,200.00                     Operating Expenses
                    Over/Short            -$58.39            $0.00                    Administration Costs           $302.00             $300.00
                         Total         $1,062.89        $1,200.00                                Advertising      $13,949.83          $14,250.00
                                                                                                 Artist Fees       $7,285.00           $8,800.00
                Revenue Total         $879,874.67      $969,767.44                                 Supplies       $18,861.19          $19,150.00
                                                                                                    Postage        $1,232.20           $1,416.00
                                                                                                     Printing      $1,815.69           $2,510.00
                                                                                                Photocopies          $233.36             $250.00
                                  Revenue minus Expense 07/08                                Telephone/Fax         $1,567.97           $1,620.00
                                        Revenue        $879,874.67                          Internet Service       $1,638.69           $1,680.00
                                        Expense        $869,046.33              Computer/Technical Support           $372.50             $400.00
                                                                                              Entertainment        $1,605.00           $2,380.00
                                    NET INCOME         $10,828.34                        Equipment Rentals         $5,582.41           $5,625.00
                                                                                  Repairs and Maintanence          $5,029.54           $2,350.00
                                  Revenue minus Expense 08/09                          Insurance Expenses          $6,019.00           $6,200.00
                                        Revenue        $969,767.44                         Food Purchases         $91,125.78          $99,970.00
                                        Expense        $928,365.04                        Liquor Purchases        $16,589.87          $10,800.00
                                                                                             Party Expense         $5,307.05           $5,450.00
                                    NET INCOME         $41,402.40                                 Hospitality        $784.95             $750.00
                                                                                        Coffee Bar Supplies       $22,569.54          $22,500.00
                                                                                      Promotions Expense              $84.50             $200.00
                                                                                       Volunteer Incentives          $963.24           $3,250.00
                                                                                                  Donations            $0.00               $0.00
                                                                                              GST Expense            $100.10             $100.00
                                                                                              Bank Charges         $1,173.02           $1,210.00
                                                                                              POS Charges          $2,476.14           $2,610.00
                                                                                 Accounting and Legal Fees        $10,740.00          $11,000.00
                                                                                        Publication Printing      $19,772.91          $12,750.00
                                                                                              Miscellaneous       $11,328.14          $16,050.00
                                                                                                      Total     $248,509.62         $253,571.00

                                                                              Memberships and Conferences
                                                                                  Membership Fees – CFS            $8,595.00           $8,750.00

                                                                     Page 1
General Ledger

           Membership Fees – ACTISEC           $1,952.08     $2,000.00
               Membership Fees – Other             $0.00         $0.00
                    Delegate Fees – CFS          $950.00     $1,000.00
              Delegate Fees – ACTISEC          $1,050.00     $1,250.00
                 Delegate Feese – Other            $0.00       $800.00
             Travel/Accomodation – CFS           $982.58     $1,000.00
        Travel/Accomodation – ACTISEC          $1,982.50     $2,000.00
            Travel/Accomodation – Other            $0.00         $0.00
                                  Total      $15,512.16    $16,800.00

            Awards/Scholarships/Bursaries
              Student Legacy Scholarship       $5,900.00     $6,000.00
                      Scholarship – Other          $0.00         $0.00
                  Financial Crisis Bursary     $3,000.00     $3,000.00
                        ACADSA Bursary         $1,500.00     $1,500.00
               Teacher's/Technicians Cup           $0.00         $0.00
              Susanne Agopcowicz Award             $0.00         $0.00
                                    Total     $10,400.00    $10,500.00

                             Amortization     $60,000.00    $56,000.00
              Capital Expenditures (1.5%)                   $17,902.00
                        Contingency (2%)                    $17,902.00
                                    Total     $60,000.00    $91,804.00

                          Expense Total      $869,046.33   $928,365.04




   Page 2

								
To top