Get documents about "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 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
Related docs
