Bus Safety Worksheets - Excel by gzs18607

VIEWS: 112 PAGES: 30

More Info
									                                                        Instructions



Revised 6/10

                       ANNUAL PUPIL TRANSPORTATION REPORT INSTRUCTIONS
                                     GENERAL INSTRUCTIONS

It is highly recommended that the individual assigned to complete the annual report read all of the
instructions very carefully prior to beginning to record data on the annual report.

Page one of this report must be completed by all administrative units. City units must be separated from
county units.

The following is a list of references that will be helpful in completing the TD-1 Annual Report:
Definition of Transportation Terms
Annual State Funds Transportation Expenditures (503 Data)
Annual Local Funds Transportation Expenditures Reports (PRC 056 & 706)
ZMB19 Print Out of End-of-the-Year Inventory (Quantity and Values)
MCIS Annual Cost/Consumption Report (July-June)
MCIS Annual Miles Report (July-June)                       NOTE: ENTER THE NAME OF THE PERSON RESPONSIBLE
ZMB20 Report for Oil (159000049 + Other Oils)              FOR ENSURING THAT THESE INSTRUCTIONS ARE FOLLOWED
ZMB20 Report for Tires (Group 150)                         AND RESPONSIBLE FOR COMMUNICATING THESE
                                                           INSTRUCTIONS TO ANY INDIVIDUALS ASSOCIATED WITH
ZMB20 Report for Repair Parts (materials)                  PROVIDING FINANCIAL, OPERATIONAL OR INVENTORY DATA
ZMB20 Report for Gasoline (159000055)                      PROVIDED IN THIS REPORT:
ZMB20 Report for Diesel Fuel (159000054)
ZMB20 Report for Lic. & Title Fee/Use Tax (181099035) Electronic Signature:
Motor Fleet Mgt. Vehicle File Folder
Other County Vehicle File Folder                                         Title:
Inventory Sold to Other Counties File Folder
Refund Reports TD-19 (July-June)
Summer School Mileage & Costs Data
Other Special Program Mileage & Costs Data                        Please email copy of report to Steve Beachum
Refund Rates for Special Programs Bus Use

Upon completion and prior to emailing and mailing the report to the Raleigh Office, the cost clerk, transportation
director, finance officer and the superintendent of schools must sign the report. Please mail by August 1 to:
Derek Graham, Section Chief
N. C. Department of Public Instruction
Division of School Support/Transportation
N. C. Education Building
6319 Mail service Center
Raleigh, N. C. 27699-6319


Enter the unit number and unit name. (SELECT FROM DROP DOWN BOX)
                                                        Instructions



BUS DATA

A. Days Operated
Record the number of days the whole fleet operated for the traditional school term. This amount
should not exceed 180 days.

B.   Bus Mileage
    1. Record the total miles operated for the fiscal year for all regular and spare buses used for regular students.
    2. Record the total miles operated for the fiscal year for all buses if used primarily for exceptional students.
C. Break the totals in 1 and 2 down by the following:
    1. Total regular school mileage for regular buses.
    2. Total regular school mileage for exceptional child buses.
    3. Refunded mileage (includes from all sources to PRC 56).
D. Record the total annual miles for all state funded service vehicles (type 3, 4, 5, 6).
E. Buses Operated
    1. Record the number of buses operated 91 days or more (regular and E. C.)
    2. Record number of regular buses operated daily (buses assigned to routes and used for regular students.
        Note: Do not include spare buses.
    3. Record number of exceptional child buses operated daily.
F. Record the number of buses operated for summer school (type 0, 1, & 2).
G. Record the number of buses equipped with two-way radios.
H. Record the number of buses equipped with cellular phones.
I. Record the number of buses that have a safety assistant/monitor on board.
J. Record the number of buses with anolog Camera Systems
    1. Record the number of buses with one camera
    2. Record the number of buses with two or more cameras
K. Record the number of buses with Digital Camera Systems
    1. Record the number of buses with one camera
    2. Record the number of buses with two cameras
    3. Record the number of buses with three cameras
    4. Record the number of buses with four or more cameras
L. Record the number of buses with GPS/Automatic Vehicle Locating System
SURPLUS PROPERTY
M. Record Number of Surplus School Buses sold
N. Record Number of Surplus State Service Vehicles sold
O. Record Number of Pounds (lbs.) Scrap metal sold
STATE SURPLUS CONTRACTS
P. Record Number of Scrap Tires sold
Q. Record Number of Gallons of Used Oil Recycled
R. Record Number of Gallons of Used Anti-freeze Recycled
S. Record Number of Gallons of Bio-Diesel Purchased

State expenditures used in the allotment formula will be accounted for through the State Public School
Fund for PRC 056. The local expenditures that you report in the next three sections of this report represent
funds that the local board of education provides to supplement the operation of the yellow school bus fleet
(I.e. driver and personnel supplements, shop supplies, utilities, etc.). These local expenditures are restricted
to basic "to-and-from-school" transportation for K-12 students for their regular school term. These expenditures
should be accounted for through your Local PRC 056 - Fund 2.
Please have the chief financial officer at each respective LEA certify these stipulations in regard to the local funds
documented on this report.
                                                                     Instructions



Local expenditures for the following are excluded or restricted: (See "Reporting Local Expenditures" tab)
. use of the yellow buses for which the state transportation budget was reimbursed
. capital purchases or improvements
. driver incentive or bonus pay
. transportation safety assistants or monitors
. "Other Expenditures" are restricted to those costs that are applicable to the
existing object codes in State PRC 056
NOTE: Report all dollar amounts to the nearest whole dollar.

BUS DRIVERS - LOCAL EXPENDITURES

1.Record the amount of local funds that was expended to provide driver salaries including any pay supplement. The salary
  supplement must apply to all drivers and be paid on a regular basis (i.e. hourly, daily, monthly) in additional to the driver's state pa
  This salary is not associated with any incentive or bonus plan.


2.Record the amount of local funds that was expended to provide drivers incentive pay or performance bonuses.
  This payment could be monthly, semi-annual or annual. An incentive pay is not paid to all drivers but rather
   to those drivers whom have achieved some predetermined goal such as perfect attendance or an accident-free
  driving record. (Although you are reporting this amount, this local pay will not be included in the allotment
  formula process).

3.Using the total compensation (state salary and local supplements from number 1 above) each driver
  received for the year and the total hours worked for the year, please determine if any drivers were paid in
  excess of $15.10 per hour (note examples below). The total compensation should be based on regular pay only,
  do not include any overtime pay in the calculation. Record the number of drivers that apply.

  If any drivers did receive average compensation in excess of $15.10 per hour, please record the total
  excess amount for all drivers.

4.Subtract the excess amount in number 3 from the amount in number 1. This "net" total will be the actual
  local funds for driver salaries used in the allotment formula process.

5.Record the matching benefits for drivers applicable to the salary amounts in number 1, 2 and 3.

Examples of Driver Salary Total Compensation in Excess of $15.10

                (1)         (2)      (3)         (4)       (5)       (6)       (7)        (8)        (9)

                                                                            Total        Annual         Excess
                State      Local    Total Annual Annual Other Annual                       Salary          Over
                Hourly     Hourly Hourly Hours Salary Local                 Salary       @15.10         $15.10
                Salary     Supl. Salary Paid             (3x4) Comp. (5+6)              (4x15.10) (7-8)
               --------   -------- -------- -------- -------- -------- ---------   ---------      --------
Example 1        8.75         0.75      9.50      810 7695.00          0     7695.00 11655.90               .00
Example 2       15.10         2.12    17.22       710 12226.20         0 12226.20 10721.00 1505.20
Example 3        9.95         0.00      9.95      920 9154.00 1000 10154.00 13238.80                        .00

Example 3 represents a $100 supplement paid monthly for 10 months.
                                                          Instructions



TRANSPORTATION PERSONNEL

1.Record to the nearest half position the number of administrative personnel paid from state funds.
  Administrative would typically include director, supervisor, office staff and all other non "wrench-turning"
  personnel.

2.Record to the nearest half position the number of mechanics paid from state funds. Mechanics
  should reflect true "wrench turning" personnel.

3.Record same as number 1 but from local funds.

4.Record same as number 2 but from local funds.

5.Personnel Salaries (local funds)
  A. Record information as noted for the transportation director. If the director does not receive any
     salary from local funds, please indicate "none".
  B. Record information as noted for all other transportation personnel receiving salary from local funds.
     The salaries listed for these personnel must represent duties directly attributable to the day-to-day school bus
     operations.

OTHER LOCAL EXPENDITURES

1.If local funds were used to purchase fuel to finish the regular school term, please indicate the
  number of days the buses operated on this fuel and the amount expended.

2.If local funds were used for contract transportation, please record the amount of funds expended. There must
  be sufficient TD 24A forms on file at the DPI to support these local expenditures as well as the state funds
  spent on contract transportation per the State Public School Fund.

3.If local funds were used in other areas to support the basic school bus operation, record these items and
  amounts. The items might include utilities, shop supplies, drug testing or any other cost that corresponds
  to the existing object codes in state PRC 56 and can be traced back to your local PRC 056 expenditure account.
Please note: Costs that cannot not be traced back to your local PRC 056 account will not be allowed . Costs
reported as miscellaneous or other will not be allowed.

BUDGET RESTRICTION CLARIFICATIONS:

1. NA


2. NA



                                        TD-1 Inventory Sheet Instructions

Primarily you will be using ZMB19 and ZMB20 in SAP to complete the TD-1 Inventory page.
                                                              Instructions



Time Sensitive Data:
You must have pulled Line A data on the first working day of July 2009. If you do not have this
information, you may use your Actual inventory number from last year’s TD-1.

You must have completed physical inventory by June 30, 2010.

You must pull Line D data on the last working day of June 2010 in the evening, or the first working day of
July 2010 first thing in the morning before any work is entered.

411 – Supply Value

Line A - Record your beginning value for supplies for July 1 (Same as actual inventory from last year's report.)

Line B - Record total value of supply item purchases during the fiscal year. (Add all supply invoices to obtain total.

Line C - Record total value of all supply items used during the fiscal year (Estimated amount used).

Line D - Record your actual inventory value for supplies for June 30 (actual estimated value of supply
      items on hand).

Line E - Record any supply adjustment values.


424 – Oil Quantity and Value

Line A – Beginning Inventory:
This information should be taken from either the ZMB19/21 spreadsheet that you saved last year, or from last year’s TD-1 actual
inventory.

Line B – Inventory Purchased:
Open Transaction ZMB20.
Input the date range 07/01/2009 to 06/30/2010
Input your plant into the Issuing Plant Field
Input input material 159000049 and then use the multiple selection box to enter any other material numbers used for oil (10W30, 5W20,
etc)
Input Movement Type 101 to 102 for parts
LEAVE THE REST BLANK
Execute the transaction
Select the “transaction quantity” and “total transaction value columns” and click on the Total button

Line C – Inventory Used:
Open Transaction ZMB20.
Input the date range 07/01/2009 to 06/30/2010
Input your plant into the Issuing Plant Field
Input input material 159000049 and then use the multiple selection box to enter any other material numbers used for oil (10W30, 5W20,
etc)
Input Movement Type 261 to 262
LEAVE THE REST BLANK
                                                             Instructions



Execute transaction
Select the “transaction quantity” and “total transaction value columns” and click on the Total button

Line D – End of Year Actual Inventory:
You must pull Line D data on the last working day of June 2010 in the evening, or the first working day of July 2010 first thing
in the morning.
Note: If you do not have time to do this one material set at a time then pull the list of all materials, export to excel, and work
using excel later to figure out the dollars and quantity by material group.

Open Transaction ZMB19
Input your Plant
Using multiple selection on the Material field input material 159000049 and any other material numbers used for oil (10W30, 5W20, etc)
Change Period for Total Usage to be 12/2010 to 12/2010 (If you don’t it will just slow the transaction down)
Execute the transaction
Select the “unrestricted use stock” and “total value” columns and click on the Total button

Line E – Inventory Adjustments:
Open Transaction ZMB20
Input the date range 07/01/2009 to 06/30/2010
Input your plant into the Issuing Plant Field
Input input material 159000049 and then use the multiple selection box to enter any other material numbers used for oil (10W30, 5W20,
etc)
Input Movement Type 701 to 702
LEAVE THE REST BLANK
Execute the transaction
Select the “transaction quantity” and “total transaction value columns” and click on the Total button

NOTE: ANY ADJUSTMENT GREATER THAN 1% MUST HAVE A WRITTEN EXPLANATION TO JUSTIFY THE PROBLEM
(1% of Line C - Inventory used)


425 – Tire Quantity and Value

Much of this work will need to be done in excel. You will need to do this so that you can separate out material numbers you use
for new tires and material numbers you use for recap tires

Line A – Beginning Inventory:
This information should be taken from either the ZMB19/21 spreadsheet that you saved last year, or from last year’s TD-1 actual
inventory.

Line B – Inventory Purchased:
Open Transaction ZMB20.
Input the date range 07/01/2009 to 06/30/2010
Input 150000000 to 150999999 in the Material Fields
Input your plant into the Issuing Plant Field
Input Movement Type 101 to 102 for parts
LEAVE THE REST BLANK
Execute the transaction
Export the data to an excel spreadsheet and manipulate as needed for the three tires columns. In addition, you should eliminate any parts
in the 150 group which are not tires.
                                                             Instructions




Line C – Inventory Used:
Open Transaction ZMB20.
Input the date range 07/01/2009 to 06/30/2010
Input 150000000 to 150999999 in the Material Fields
Input your plant into the Issuing Plant Field
Input Movement Type 261 to 262
LEAVE THE REST BLANK
Execute transaction
Export the data to an excel spreadsheet and manipulate as needed for the three tires columns. In addition, you should eliminate any parts
in the 150 group which are not tires.

Line D – End of Year Actual Inventory:
You must pull Line D data on the last working day of June 2010 in the evening, or the first working day of July 2010 first thing
in the morning.
Note: If you do not have time to do this one material set at a time then pull the list of all materials, export to excel, and work
using excel later to figure out the dollars and quantity by material group.

Open Transaction ZMB19
Input your Plant
Input 150000000 to 150999999 in the Material Fields
Change Period for Total Usage to be 12/2010 to 12/2010 (If you don’t it will just slow the transaction down)
Execute the transaction
Select the “unrestricted use stock” and “total value” columns and click on the Total button

Line E – Inventory Adjustments:
Open Transaction ZMB20
Input the date range 07/01/2009 to 06/30/2010
Input 150000000 to 150999999 in the Material Fields
Input your plant into the Issuing Plant Field
Input Movement Type 701 to 702
LEAVE THE REST BLANK
Execute the transaction
Export the data to an excel spreadsheet and manipulate as needed for the three tires columns. In addition, you should eliminate any parts
in the 150 group which are not tires.

Line F – Obsolete Inventory Removed
This must be kept track of during the year as you remove stock which is obsolete. If you are not aware of what stock was obsolete and
sold then you cannot enter anything in this field and it will appear as a plain inventory adjustment. Numbers should always be positive
numbers.

LINE MAY ONLY BE USED FOR STOCK WHICH YOU NO LONGER HAVE IN YOUR POSSESSION AND SOLD DUE
TO OBSOLESCENCE

NOTE: ANY ADJUSTMENT GREATER THAN 1% MUST HAVE A WRITTEN EXPLANATION TO JUSTIFY THE PROBLEM
(1% of Line C - Inventory used)


422 – Repair Parts Value
                                                            Instructions



Line A – Beginning Inventory:
This information should be taken from either the ZMB19/21 spreadsheet that you saved last year, or from last year’s TD-1 actual
inventory.

Line B – Inventory Purchased:
Open Transaction ZMB20.
Input the date range 07/01/2009 to 06/30/2010
Input your plant into the Issuing Plant Field
Input the material range: 155000000 to 155999999
Using multiple selection on the Material field choose the Green Dot “Ranges” tab
Input a second material range: 180000000 to ZZZ999999
Input Movement Type 101 to 102 for parts (Include 122 as well if you have used MIGO Return Delivery this year)
LEAVE THE REST BLANK
Execute the transaction
Select the “total transaction value” column and click on the Total button

Line C – Inventory Used:
Open Transaction ZMB20.
Input the date range 07/01/2009 to 06/30/2010
Input your plant into the Issuing Plant Field
Input the material range: 155000000 to 155999999
Using multiple selection on the Material field choose the Green Dot “Ranges” tab
Input a second material range: 180000000 to ZZZ999999
Input Movement Type 261 to 262
LEAVE THE REST BLANK
Execute transaction
Select the “total transaction value” column and click on the Total button

Line D – End of Year Actual Inventory:
You must pull Line D data on the last working day of June 2010 in the evening, or the first working day of July 2010 first thing
in the morning.
Note: If you do not have time to do this one material set at a time then pull the list of all materials, export to excel, and work
using excel later to figure out the dollars and quantity by material group.

Open Transaction ZMB19
Input your Plant
Using multiple selection on the Material field choose the Green Dot “Ranges” tab
Input two ranges: 155000000 to 155999999 and 180000000 to ZZZ999999
Change Period for Total Usage to be 12/2010 to 12/2010 (If you don’t it will just slow the transaction down)
Execute the transaction
Select the “total value” column and click on the Total button

Line E – Inventory Adjustments:
Open Transaction ZMB20
Input the date range 07/01/2009 to 06/30/2010
Input your plant into the Issuing Plant Field
Input the material range: 155000000 to 155999999
Using multiple selection on the Material field choose the Green Dot “Ranges” tab
Input a second material range: 180000000 to ZZZ999999
Input Movement Type 701 to 702
                                                             Instructions



LEAVE THE REST BLANK
Execute the transaction
Select the “total transaction value” column and click on the Total button

Line F – Obsolete Inventory Removed
This must be kept track of during the year as you remove stock which is obsolete. If you are not aware of what stock was obsolete and
sold then you cannot enter anything in this field and it will appear as a plain inventory adjustment. Numbers should always be positive
numbers.

LINE MAY ONLY BE USED FOR STOCK WHICH YOU NO LONGER HAVE IN YOUR POSSESSION AND SOLD DUE
TO OBSOLESCENCE

NOTE: ANY ADJUSTMENT GREATER THAN 1% MUST HAVE A WRITTEN EXPLANATION TO JUSTIFY THE PROBLEM
(1% of Line C - Inventory used)


421 – Fuel Quantity and Value

Line A – Beginning Inventory:
This information should be taken from either the ZMB19/21 spreadsheet that you saved last year, or from last year’s TD-1 actual
inventory.

Line B – Inventory Purchased:
Open Transaction ZMB20.
Input the date range 07/01/2009 to 06/30/2010
In the Material field input 159000054 to complete the diesel fuel section or 159000055 to complete the gasoline columns
Input your plant into the Issuing Plant Field
Input Movement Type 971 to 972 for parts
LEAVE THE REST BLANK
Execute the transaction
Select the “transaction quantity” and “total transaction value columns” and click on the Total button

Line C – Inventory Used:
Open Transaction ZMB20.
Input the date range 07/01/2009 to 06/30/2010
In the Material field input 159000054 to complete the diesel fuel section or 159000055 to complete the gasoline columns
Input your plant into the Issuing Plant Field
Input Movement Type 261 to 262
LEAVE THE REST BLANK
Execute transaction
Select the “transaction quantity” and “total transaction value columns” and click on the Total button

Line D – End of Year Actual Inventory:
You must pull Line D data on the last working day of June 2010 in the evening, or the first working day of July 2010 first thing
in the morning.
Note: If you do not have time to do this one material set at a time then pull the list of all materials, export to excel, and work
using excel later to figure out the dollars and quantity by material group.

Open Transaction ZMB19
Input your Plant
                                                            Instructions



In the Material field input 159000054 to complete the diesel fuel section or 159000055 to complete the gasoline columns
Change Period for Total Usage to be 12/2010 to 12/2010 (If you don’t it will just slow the transaction down)
Execute the transaction
Select the “unrestricted use stock” and “total value” columns and click on the Total button

Line E – Inventory Adjustments:
Open Transaction ZMB20
Input the date range 07/01/2009 to 06/30/2010
In the Material field input 159000054 to complete the diesel fuel columns or 159000055 to complete the gasoline columns
Input your plant into the Issuing Plant Field
Input Movement Type 701 to 702
LEAVE THE REST BLANK
Execute the transaction
Select the “transaction quantity” and “total transaction value columns” and click on the Total button

YOU WILL USE THIS 421 PROCEDURE TWICE, ONCE FOR DIESEL AND ONCE FOR GASOLINE
                                                              Instructions




NOTE: ANY ADJUSTMENT GREATER THAN 1% MUST HAVE A WRITTEN EXPLANATION TO JUSTIFY THE PROBLEM
(1% of Line C - Inventory used)

NOTE: ALL BULK STORAGE GASOLINE AND DIESEL METERS AND ALL FUEL TRUCK METERS ARE REQUIRED TO BE
CALIBRATED EACH YEAR.

                                            LOWER SECTION OF THE SPREADSHEET

Lines G and H – Inventory Sold/Purchased from other counties
These lines also have to be kept track of manually. Stock sold to another county may only appear in one line (Line F or Line G), not
both. If it is purchased it should show up on a PO and thus also be contained in Line B. If it is sold, it will not show up anywhere and
thus it will be contained as part of Line E.
Line I - Non-Stock Inventory Purchased and Used this year
Select Transaction ZMB36B - Enter Plant and the date range 07/01/2009 to 06/30/2010
Execute the transaction
Look at the top line of the report and Record the totals for Quantity and Amount in Local Currency

Summary Analysis
The bottom section is a calculation of the change in inventory level for the year, and the amount of inventory adjustments (Line
E - Line F - Line G). It also verifies whether A and E were pulled on the correct dates (or if there is some other problem such
that the numbers do not add up)

Note:
TRUE = All Numbers Add Up Properly

FALSE = Continuity problem with the numbers. Numbers in the line don't make sense. Issue most likely related to improper data pull d
Instructions
Instructions
Instructions
Instructions
Instructions
Instructions
Instructions
Instructions
Instructions
Instructions
Instructions
 28-Sep-04
MEMORANDUM

TO:            LEA Superintendents, Finance Officers, and                                                                 1
               Transportation Directors

FROM:          Philip Price, Associate Superintendent
               Financial and Business Services

               Derek Graham, Section Chief
               Transportation Services

SUBJECT:       Reporting Local Transportation Expenditures

In an effort to more accurately report local transportation expenses, two changes to the Uniform
implemented effective July 1, 2004.
      1.      PRC 056 in Fund 2 is designated to record all Eligible local transportation expenditures. The available
            account codes for Fund 2, PRC 056 will be the same as the Fund 1, PRC 056 account codes.

      2.   PRC 706 in Fund 2 is being designated to record Other / Ineligible local transportation expenditures.

ELIGIBLE EXPENDITURES
Eligible local expenditures are those expenditures that local boards of education provide to supplement the operation
of the yellow school bus fleet. They are "eligible" to be included in the state transportation funding formula.
These local expenditures are restricted o the basic “to-and from-school” transportation for K-12 students for their
regular school term and restricted or limited to those costs that are applicable to the existing PRC 056 account codes
set forth in the current state uniform chart of accounts. These expenditures include transportation personal and driver
supplements, shop and office supplies, utilities costs, communication cost, etc. (See – PRC 056 Chart of Accounts).


INELIGIBLE EXPENDITURES
Other local transportation expenditures should be paid from Program Report Code (PRC) 706 or other state, federal
local PRC and not PRC 056. Ineligible local expenditures include, but are not limited to the following:

      1)    SALARIES
           a)   Transportation safety assistants or monitors salaries.
           b)   Driver incentive or bonus pay (e.g., perfect attendance, safe driving record, etc.)
           c)   Transportation Director’s salary.
           d)   That portion of split-funded personnel salary cost that is not transportation related.
           e)   Salary Differential Pay (Additional payments above State Salary Schedule amount).
           f)   Transportation employees assigned to maintain or schedule local vehicles.
           g)   Driver salary for routes serving only local pre-k programs, Head Start, Summer School, Pre-K EC programs.
           h)   Summer Interns.
      2)    BENEFITS
           a)   Insurance Benefits other than Social Security, Retirement and Hospitalization.
           b)   Longevity Pay.
      3)    SUPPORT
           a)   Capital purchases or improvements.
           b)   Field trips.
           c)   Employee’s CDL Costs/Reimbursement.
           d)   Utilities for facilities that are not separately metered.
           e)   Banquet Costs.
           f)   Drug-Testing Program for employees other than yellow bus drivers and transportation staff.
           g)   Costs associated with transportation services provided for at-risk programs (state, local or federal).
           h)   Mileage costs to reimburse state for yellow bus use.
           i)   Costs for transportation purchases that are state reimbursed through contingency funding.
           j)   Costs for bus driver or transportation personnel physical exams.
      4)    VEHICLES
           a)   Purchase of Vehicles.
           b)   Purchase of Activity Buses
           c)   Maintenance and operation of activity buses and all other local vehicles.
           d)   Costs associated with Driver Education Program vehicles.
TD-1(elec)                        NORTH CAROLINA PUBLIC SCHOOLS                                        2009-10
Revised 6/10                                                                                            Page 1
                                ANNUAL PUPIL TRANSPORTATION REPORT

UNIT NAME & NO.         (SELECT FROM DROP DOWN BOX)             (Blank)           UNIT NO.   (Blank)

BUS DATA
 A. Number of Days Whole Fleet Operated(maximum 180)
 B. Total Bus Mileage (1+2)                                                              -
  1. Total miles operated fiscal year (Regular Bus)
  2. Total miles operated fiscal year (EC Bus)
 C. Detail of above lines (A&B)
  1. Regular school mileage (Reg Bus)
  2. Regular school mileage (EC Bus)
  3. Refunded miles (all sources)
      (Mileage calculation check: this total must equal zero)                         -
 D. Total miles operated by all service trucks
 E. Buses Operated
    1. Number buses operated (91 days min.)                                          0
    2. Number regular buses operated
    3. Number EC buses operated
 F. Number buses operated summer school
 G. Number buses with 2-way radios
 H. Number buses with cellular phones
 I. Number buses with safety assistants/monitors
 J. Number buses with Anolog Camera Systems                                          0
  1. Number of buses with one camera
  2. Number of buses with two or more cameras
 K. Number buses with Digital Camera Systems                                         0
   1. Number of buses with one camera
   2. Number of buses with two cameras
   3. Number of buses with three cameras
   4. Number of buses with four or more cameras
 L. No. buses with GPS/Automatic Vehicle Locating Systems
SURPLUS PROPERTY
 M. Number of Surplus School Buses sold
 N. Number of Surplus State Service Vehicles sold
 O. Number of Pounds (lbs.) Scrap metal sold
STATE SURPLUS CONTRACTS
 P. Number of Scrap Tires sold
 Q. Number of Gallons of Used Oil Recycled
 R. Number of Gallons of Used Anti-freeze Recycled
 S. Number of Gallons of Bio-Diesel Purchased

Please mail hard copy of PAGES 1-3 with appropriate signatures and
email file to Steve Beachum: sbeachum@dpi.state.nc.us.

SIGNATURES:
______________________________                                  _______________
COST CLERK                                                      DATE
______________________________                                  _______________
DIRECTOR OF TRANSPORTATION                                      DATE
______________________________                                  _______________
FINANCE OFFICER                                                 DATE
______________________________                                  _______________
SUPERINTENDENT                                                  DATE
                                                                                                                                                                            TD-1 2009-10
                                                                                                                                                                                  page 2


BUS DRIVERS - LOCAL EXPENDITURES
1. Driver Salary (except incentive pay/bonuses)                         (exclude benefits)
2. Driver Incentive pay or Bonuses                                      (exclude benefits)
3. Including total compensation from both state funds and the            Finance Officer Certification
    amount in number 1 above, did you have any drivers paid              The only expenditures to be reported on lines 1-5 are limited to payment for
                                                                         drivers transporting students to- and from - school for maximum 180 days
    over $15.10 per hour? YES/NO                                         per year. It does not include payments for field-trips, remediation programs,
If no, go to number 4.                                                   pre-K programs, etc.
If yes, how many drivers?
                                                                                                                   INITIAL ________
Of these drivers, what were the total funds expended for wages
     in excess of $15.10 per hour?
4. Subtract the amount in number 3 (if any) from the amount in
    number 1 and enter the difference.                               $0
5. Driver Matching Benefits                                 Salaries       Bonuses Excess Wages
                                                          (No. 1 above) (No. 2 above) (No. 3 above)
                       Social Security
                         Retirement
                        Medical Cost
                       Total Benefits                                $0                $0                   $0
TRANSPORTATION PERSONNEL
1. No. of state-paid administrative positions
2. No. of state-paid mechanic positions
3. No. of local-paid administrative positions
4. No. of local-paid mechanic positions
5. Personnel Salaries (local funds)
 A. Director's Salary - Name, Title                                             Pay Grade           Local Salary Match Benefits

 B. Other Salaries
                  Names and Job Titles                                          Pay Grade           Local Salary Match Benefits




Note: Enter additional personnel on "Additional" sheet.                                TOTAL                      $0                     $0
Finance Officer Certification. All salaries listed in section 5B are directly related to the operation of "yellow" school bus es for transporting students to and from school. Work
performed by these individuals on non-state vehicles is refunded to PRC 056 or not reported in Section 5.                             INITIAL: _________


OTHER LOCAL EXPENDITURES
1. Fuel                                                                                          0
2. Contract Transportation                                                                       0
   TD-24A forms must be on file at the DPI to support the total expended for both state and local funds.
3. Other Expenditures                                                     Description of Related    Amount
See instructions for "Other Expenditures"& Reporting Local Expenditures." Expenditures Object Code Expended
                                                                        1
                                                                        2
                                                                        3
                                                                        4
                                                                        5
Note: Enter additional expenses on "Additional" sheet.                                    TOTAL             $0

BUDGET RESTRICTION CLARIFICATIONS:

                                                                                                                                                                1




                                                                                                                                                                2
TD-1 (elec)                                    PUBLIC SCHOOLS                                                     2009-10
Revised 06/09                        ANNUAL PUPIL TRANSPORTATION REPORT                                           Page 2a

 B. Other Salaries
                     Names and Job Titles                   Pay Grade        Local Salary        Matching Ben.




10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
                                                            TOTAL                           $0               $0

3. Other Expenditures (continued - See Instructions for)    Description of   Related             Amount
"Other Expenditures"& Reporting Local Expenditures."        Expenditures     Object Code         Expended
                                                        6
                                                        7
                                                        8
                                                        9
                                                       10
                                                       11
                                                       12
                                                       13
                                                       14
                                                       15
                                                       16
                                                       17
                                                       18
                                                       19
                                                       20
                                                                             TOTAL                           $0
See instructions for "Other Expenditures"& Reporting Local Expenditures."
TD-1(elec)                                                          PUBLIC SCHOOLS                                    2009-10
Revised 6/10                                              ANNUAL PUPIL TRANSPORTATION REPORT                           Page 3


POLICY QUESTIONNAIRE (place a X in appropriate cells)

1. Who has the primary responsibility in your LEA for developing school bus routes, establishing bus stops
and assigning students to buses?
        Supt./Asst. Supt.
        Transportation director
        Principals
        TIMS Coordinator
        Trans. supervisor
        Other (please list)

2. Does your LEA use a staggered bell time system? (i.e. do some school start times differ by a half hour or more?)
        yes
        no

If yes, is this primarily to facilitate transportation
          yes
          no

3. Who is involved in establishing school bell times in your LEA? (check all that apply)
       Supt./Asst. Supt.
       Transportation director
       Principals
       TIMS Coordinator
       Trans. supervisor
       Other (please list)

4. Do you permit buses travel to be routed on interstate highways?
        yes
        no
   Does your county have interstate highways?
        yes
        no

5. For what types of alternative programs does your LEA provide transportation?
        At-risk BEP
        Pre-K Handicapped
        Head Start
        At-risk Remediation
        Migrant Education
        DARE Program
        Local Enrichment
        SOS Plus
        VIPERS Program
        Other (please list)

6. What is your district goal for maximum ride times in minutes (one-way trip)?
       None
       Regular Students
       Special Educ. Students


7. What is the goal for earliest student boarding time (time of day)?
       AM
       None

8. What is the goal for latest student arrival at home (time of day)?
       PM
       None

9. Do you pair bus driving duties with any of the following? (estimate % of all drivers)
        Food service/Driver
        Custodial/Driver
        Teacher Asst/Driver
        Other (please list)

10. Do you provide transportation for any charter schools through contract?
       Yes
       No
                TD-1 (elec)                                                                         NORTH CAROLINA PUBLIC SCHOOLS                                                                                            2009-10
                Revised 6/10                                                                      ANNUAL PUPIL TRANSPORTATION REPORT
                                                                                                                                                                                                                             Page 4

INVENTORY                                         411             424            424              425               425             425            422               423           423           423            423
(Use "arrow" keys to move vertically.           Supplies           Oil           Oil             Tires             Tires           Tires        Repair Parts        Diesel        Diesel       Gasoline       Gasoline        Total
                                                 Value           Quantity       Value          New (quan)       Recap (quan)       Value          Value            Quantity       Value        Quantity        Value          Value
A.   Beginning Inventory 7-01-09                                                                                                                                                                                                       $0.00
B.   Inventory Purchased 2009-10                                                                                                                                                                                                        0.00
C.   Inventory Used 2009-10                                                                                                                                                                                                             0.00
D.   Ending Actual Inventory 6-30-10                                                                                                                                                                                                    0.00
E.   Inventory Adjustment 2009-10                                                                                                                                                                                                       0.00
F.   Obsolete Inventory Removed
                                              Repair Parts        Tires
                                                Value             Value
G.   Inventory Sold to Other Counties
H.   Inventory Purchased from Other Cty.

                                               Quantity           Value
I.   Non-Stock Inventory Purchased

     SUMMARY ANALYSIS                             411             424            424              425               425            425             422               423           423           423            423
                                                Supplies           Oil           Oil             Tires             Tires           Tires        Repair Parts        Diesel        Diesel       Gasoline       Gasoline        Total
                                                 Value           Quantity       Value          New (quan)       Recap (quan)       Value          Value            Quantity       Value        Quantity        Value          Value
     Inventory Level Change                                  0              0             0                 0                  0           0                   0              0            0              0              0                0
     Total Inventory Adjustments                             0              0             0                 0                  0            0                  0              0            0              0              0                0
        Were Lines A and E pulled on the
          proper dates (Or is there any          TRUE            TRUE           TRUE             TRUE             TRUE             TRUE           TRUE             TRUE           TRUE         TRUE           TRUE            TRUE
       abnormality in the numbers entered)

                                                          TRUE = All Numbers Add Up Properly
                                             FALSE = Continuity problem with the numbers. Numbers in the
                                              line don't make sense. Issue most likely related to improper
                                                                    data pull dates.
                                                                                                  Summary                                                                                                                TD-1 2009-10
                                                                                                                                                                                                                               Page 5




                                                                          Inventory
                                                                                        411         424        424           425        425         425           422         423        423           423         423
                               Policy                                                 Supplies      Oil        Oil          Tires      Tires       Tires       Repair Parts Diesel      Diesel       Gasoline    Gasoline    Total
Bus Data       A           0                                                           Value      Quantity    Value       New (quan)Recap (quan)   Value         Value      Quantity    Value        Quantity     Value      Value
               B-1         0   Q1         0    Supt./Asst. Supt.            A.                0           0           0           0           0            0             0          0            0           0           0           0
               B-2         0              0    Transportation director      B.                0           0           0           0           0            0             0          0            0           0           0           0
               C-1         0              0    Principals                   C.                0           0           0           0           0            0             0          0            0           0           0           0
               C-2         0              0    TIMS Coordinator             D.                0           0           0           0           0            0             0          0            0           0           0           0
               C-3         0              0    Trans. supervisor            E.                0           0           0           0           0            0             0          0            0           0           0           0
               D           0              0    Other (please list)          F.                                                    0           0            0             0
               E-1         0   Q2         0    yes
               E-2         0              0    no                          Sold           0.00        0.00
               E-3         0              0    yes                         Purch          0.00        0.00
               F           0              0    no                        Non-Stock        0.00        0.00
               G           0   Q3         0    Supt./Asst. Supt.
               H           0              0    Transportation director
               I           0              0    Principals
               J-1         0
               J-2         0
               K-1         0
               K-2         0
               K-3         0
               K-4         0
               L           0
               M           0
               N           0
               O           0
               P           0
               Q           0
               R           0
               S           0
Drivers        1           0               0   TIMS Coordinator
               2           0               0   Trans. supervisor
               3           0               0   Other (please list)
               4           0   Q4          0   yes
               5           0               0   no
                           0               0   yes
                           0               0   no
                           0   Q5          0   At-risk BEP
                           0               0   Pre-K Handicapped
                           0               0   Head Start
                           0               0   At-risk Remediation
                           0               0   Migrant Education
                           0               0   DARE Program
                           0               0   Local Enrichment
                           0               0   SOS Plus
               1           0               0   VIPERS Program
Personnel      2         0.0               0   Other (please list)
               3         0.0   Q6          0   None
               4         0.0               0   Regular Students
               5A        0.0               0   Special Educ. Students
                           0   Q7       0:00   AM
               5B          0            0:00   None
                           0   Q8       0:00   PM
                     1     0            0:00   None
Fuel                 2     0   Q9        0%    Food service/Driver
Contracts            3     0             0%    Custodial/Driver
Other                1     0             0%    Teacher Asst/Driver
Reversions           2     0             0%    Other (please list)
LocalBailout               0   Q10         0   Yes
                                           0   No
                                                                                 Check here if LEA does not own
              BUSTER THE ROBOTIC BUS                                             or share a BUSTER
                LEA REPORTING FORM

LEA Num #_______                                                        Indicate with a "1" those grades included in the training

                                                          Exhibition/

                    TIME          LOCATION OF   APPROX. # Appearance
      LEA    DATE   (IN HOURS)   PRESENTATION    TRAINED Attendance       PK      K 1 2 3 4 5 6 7-12                Public
  1
  2
  3
  4
  5
  1
  4
  5
 11
  8
  3
  4
  5
  6
  7
  8
  7
  8
  9
 10
 11
 12
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46

								
To top