Operating Expenditure Category Blue Cells are Data Entry Cells Pink Cells are protected formula Expendi

Document Sample
Operating Expenditure Category Blue Cells are Data Entry Cells Pink Cells are protected formula Expendi Powered By Docstoc
					                                                                                            Operating
Expenditure Category: Blue Cells are Data Entry Cells. Pink Cells are protected formula   Expenditures as   Reimbursable at   Reimbursable at
cells                                                                                        of 6/30/09         100%            Prorated %       Non-Reimbursable

Driver Salaries (Includes Activity and Route)                                                       $0.00                                $0.00
Driver Benefits (Includes Activity and Route)                                                       $0.00                                $0.00
Route Driver Salaries                                                                               $0.00             $0.00
Route Driver Benefits                                                                               $0.00             $0.00
Activity Driver's Salaries                                                                          $0.00                                                   $0.00
Activity Driver's Benefits                                                                          $0.00                                                   $0.00
Substitute Driver Salaries (Includes Activity and Route)                                            $0.00                                $0.00
Substitute Driver Benefits (Includes Activity and Route)                                            $0.00                                $0.00
Substitute Route Driver Salaries                                                                    $0.00             $0.00
Substitute Route Driver Benefits                                                                    $0.00             $0.00
Transportation Supervisor/Director Salary                                                           $0.00                                $0.00
Transportation Supervisor/Director Benefits                                                         $0.00                                $0.00
Dispatcher Salaries                                                                                 $0.00                                $0.00
Dispatcher Benefits                                                                                 $0.00                                $0.00
Mechanic Salaries                                                                                   $0.00                                $0.00
Mechanic Benefits                                                                                   $0.00                                $0.00
Rent on Building                                                                                    $0.00                                $0.00
Utilities - Transportation Barn                                                                     $0.00                                $0.00
Professional Development - Training (Includes Activity and Route)                                   $0.00                                $0.00
Route Driver Professional Development - Training                                                    $0.00             $0.00
Physicals/Drug Testing/CPR                                                                          $0.00                                $0.00
Annual state or national transportation workshops/conferences                                       $0.00             $0.00
Employee Recognition, awards, banquets and ceremonies                                               $0.00                                                   $0.00
Advertising                                                                                         $0.00                                                   $0.00
Districts expenses for furnishing route transportation to another district                          $0.00             $0.00
Districts expenses for furnishing activity transportation to another district                       $0.00                                $0.00
Independent Route Contractors less capital outlay                                                   $0.00             $0.00
Contracts with commercial transportation carriers (taxi)                                            $0.00             $0.00
Public transportation services                                                                      $0.00             $0.00
Districts payments to another district for furnishing route transportation                          $0.00             $0.00
Districts payments to another district for furnishing activity transportation                       $0.00                                $0.00
Tools less than $1,000                                                                              $0.00                                $0.00
Tools more than $1,000                                                                              $0.00                                                   $0.00
Bus Repairs ( Includes Activity and Route )                                                         $0.00                                $0.00
Route Bus Repairs                                                                                   $0.00             $0.00
Building Repairs to restore building to original condition                                          $0.00                                $0.00
Rule 4.01(16) - vehicle owned at least 3 years                                                      $0.00                                $0.00
Rule 4.01(16) - vehicle owned for less then 3 years                                                 $0.00                                                   $0.00
Expenses for extracurricular trips                                                                  $0.00                                                   $0.00
Expenses for field trips                                                                            $0.00                                                   $0.00
Expenses for athletic trips                                                                         $0.00                                                   $0.00
Liability claims                                                                                    $0.00                                                   $0.00
Vehicle's not used for specific student transportation                                              $0.00                                                   $0.00
Expenses for elderly transportation                                                                 $0.00                                                   $0.00
Expenses for recreational transportation                                                            $0.00                                                   $0.00
Parent Mileage Reimbursement                                                                        $0.00             $0.00
Liability/Umbrella Insurance                                                                        $0.00                                $0.00
Vehicle Insurance for student transportation vehicles                                               $0.00                                $0.00
Vehicle Insurance for administrative vehicles                                                       $0.00                                                   $0.00
Worker's Compensation insurance                                                           $0.00                                         $0.00
Unemployment Insurance                                                                    $0.00                                         $0.00
Purchased Services                                                                        $0.00                                         $0.00
Towing                                                                                    $0.00                                         $0.00
Fuel                                                                                      $0.00                                         $0.00
Oil                                                                                       $0.00                                         $0.00
Tires                                                                                     $0.00                                         $0.00
Parts                                                                                     $0.00                                         $0.00
Supplies (IE printing)                                                                    $0.00                                         $0.00
Equipment (IE jack stands: over $1,000)                                                   $0.00                                                                      $0.00


Support Service Expenditures Total Linked From Calculation Sheet:                         $0.00                                         $0.00


Total Expenditures                                                                       $0.00              $0.00                      $0.00                         $0.00

White Fleet (Admin Vehicles) Expenses (enter a whole, positive dollar amount)             $0.00              $0.00

Revenue Category

Grants for tires                                                                          $0.00                                         $0.00
Grants for upgrades                                                                       $0.00                                         $0.00
Grants for fuel                                                                           $0.00                                         $0.00
Additional grants for transportation expenses                                             $0.00                                         $0.00
Summer School revenues for transportation                                                 $0.00                                         $0.00
Pre-school revenues for transportation                                                    $0.00                                         $0.00
Revenue received from other districts to furnish pupil transportation                     $0.00                                         $0.00


Total Revenues                                                                            $0.00              $0.00                      $0.00                        $0.00



Total Operating Expenditures                                                             $0.00              $0.00                      $0.00                         $0.00




How to calculate allocation percentage:                                                           How to calculate current operating expenditures:   Shared Cost Calc:

Total Miles: Line 8 on CDE40: You must know this                                           0.00   Costs at 100%                        $0.00                         $0.00
Non reimbursable Miles: Line 7 CDE40: You must know this                                   0.00   Shared Costs                  #DIV/0!                    #DIV/0!
Reimbursable Miles: Calculated for you (Total Miles minus Non-Reimbursable Miles)         0.00                                                             #DIV/0!
                                                                                                  Current
                                                                                                  Operating
                                                                                                  Expenditures                #DIV/0!
Allocation Percentage(Apply to shared costs)                                        #DIV/0!       Line 1 CDE40:           Amount to CDE 40
Blue Cells: Data Entry
Pink Cells: Locked/Protected
Total Support Service Expenditures: Links to Worksheet
Please see "Support Cost Examples" Sheet for Extra Examples/Guidance

This spreadsheet requires ANNUAL FIGURES: annual salaries, annual benefits, total annual hours worked and annual number of hours devoted to transportation related activities

Employee Name           Position: Job Title (IE    Transportation Related Activity: Annual Salary:      Annual Benefits: Total Annual        Total Annual Hours          Annual Number of       Total Time            Yearly Shared
                        payroll clerk, janitor,    Be Specific on the work being Figures you must       Figures you must Compensation        Worked: This figure is      Hours worked for       Percentage            Reimbursable
                        business manager,          done and how it relates to       know                know                                 something the District      Transportation         (percentage of        Salary: Total Annual
                        superintendent)            transportation (IE "Reviews                                                               needs to track. A           Related Activities.    time devoted to       Compensation
                                                   Driver Time Sheets, Prints                                                                traditional work year is    District must track    transportation        multiplied by Total
                                                   Driver Checks)                                                                            2,080 hours, but this may   this figure.           duties): Total Time   Time Percentage
                                                                                                                                             not apply to everyone                              Divided by Direct
                                                                                                                                                                                                Time

                                                   Cleans the Transportation Barn
                                                   3 hours each week. Works 36
Example: John Doe       Janitor                    weeks per year: 108 Hours                  $32,000             $7,500          $39,500                     1,440.00                 108.00               7.50%                $2,962.50




                                                                                                                                        $0                                                                  0.00%                    $0.00




                                                                                                                                        $0                                                                  0.00%                    $0.00




                                                                                                                                        $0                                                                  0.00%                    $0.00




                                                                                                                                        $0                                                                  0.00%                    $0.00




                                                                                                                                        $0                                                                  0.00%                    $0.00




                                                                                                                                        $0                                                                  0.00%                    $0.00




                                                                                                                                        $0                                                                  0.00%                    $0.00




                                                                                                                                        $0                                                                  0.00%                    $0.00




                                                                                                                                        $0                                                                  0.00%                    $0.00




                                                                                                                                        $0                                                                  0.00%                    $0.00




                                                                                                                                        $0                                                                  0.00%                    $0.00


                                                                                                                                                                                                                                    $0.00
Employee Name      Position: Job Title   Transportation Related              Annual Salary        Annual Benefits     Total Annual     Total Annual Hours          Annual Number of          Total Time         Yearly Shared
                                         Activity: Be Specific on the                                                 Compensation     Worked: This figure is      Hours worked for          Percentage         Reimbursable
                                         work being done and how it                                                                    something the District      Transportation            (percentage of     Salary: Total Annual
                                         relates to transportation                                                                     needs to track. A           Related Activities.       time devoted to    Compensation
                                                                                                                                       traditional work year is    District must track       transportation     multiplied by Total
                                                                                                                                       2,080 hours, but this may   this figure.              duties): Total     Time Percentage
                                                                                                                                       not apply to everyone                                 Time Divided by
                                                                                                                                                                                             Direct Time

                                         Reviewing Driver Time Sheets:
                                         4 hours per week, 36 weeks
Ms. Jane Doe       Payroll Clerk         per year                                       $35,000              $8,000          $43,000                       2,080                    144                 6.92%             $2,976.92


                                         Cleaning Transp. Barn: 10
                                         hours per week, 30 weeks per
John Smith         Janitor               year                                           $30,000              $6,000          $36,000                       1,440                    300                20.83%             $7,500.00



                                         Prepares CDE-40. Works 8
Susan Cordova      Business Manager      hours on it one day each year                  $52,000             $15,000          $67,000                       2,080                         8              0.38%               $257.69
                                         Filled in as a bus driver for two
                                         weeks, dealt with
                                         transportation personnel
Dr. Ben Harrison   Superintendent        issues: 103 hours                              $95,000             $20,300         $115,300                       2,460                    103                 4.19%             $4,827.60


                                                                                                                                                                                                                         $15,562.22
                                                                                                                                                                                                                This figure would
                                                                                                                                                                                                                appear on the
                                                                                                                                                                                                                worksheet