Bus depreciation forecasting
Download
1 / 36

Bus Depreciation Forecasting - PowerPoint PPT Presentation


  • 106 Views
  • Uploaded on
  • Presentation posted in: General

Bus Depreciation Forecasting. WASBO Workshop May 6, 2011. OSPI Student Transportation. The Big Question:. Bus Depreciation Forecasting May 6, 2011. What’s happening with the depreciation system?. OSPI Student Transportation. We Don’t Know….

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha

Download Presentation

Bus Depreciation Forecasting

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Bus DepreciationForecasting

WASBO Workshop

May 6, 2011

OSPI

Student Transportation


The Big Question:

Bus Depreciation Forecasting May 6, 2011

What’s happening with the depreciation system?

OSPI

Student Transportation


We Don’t Know…

Bus Depreciation Forecasting May 6, 2011

… but this forecast tool

(or one like it)

will work regardless.

OSPI

Student Transportation


The little Question:

Bus Depreciation Forecasting May 6, 2011

What happened to the previous Forecast Tool?

Answer: That sales tax thing

OSPI

Student Transportation


The Solution:

Bus Depreciation Forecasting May 6, 2011

Excel workbooks

with cut-and-paste district data entry

OSPI

Student Transportation


How close is it?

Bus Depreciation Forecasting May 6, 2011

Depending on your fleet

… often within a few dollars

(once you know the prices and interest rate)

OSPI

Student Transportation


Depending???

what do you mean “depending”

Bus Depreciation Forecasting May 6, 2011

OSPI

Student Transportation


Assumptions

Bus Depreciation Forecasting May 6, 2011

Type A22D buses reflected as A34D (23)

Type A22DL buses reflected as A34DL (8)

Type A22G buses reflected as A34G (21)

Type A22GL buses reflected as A34GL (3)

Plus … C77E (4) …. Out of 7800+

OSPI

Student Transportation


Here’s one bus grid

Category D84D, September, 2010:

Bus Depreciation Forecasting May 6, 2011

OSPI

Student Transportation


Here’s one year…

Bus Depreciation Forecasting May 6, 2011

Detail from Prior Slide


That’s why there’s assumptions …

Bus Depreciation Forecasting May 6, 2011

But we will do the extra work once there’s a budget

OSPI

Student Transportation


Where

can you get the files?

Bus Depreciation Forecasting May 6, 2011

https://eds.ospi.k12.wa.us/BusDepreciation

(public access)

OSPI

Student Transportation


Open:

Bus Depreciation Forecasting May 6, 2011

DistrictFleetForecast.xlsx


Go to the FleetHistory sheet:

Bus Depreciation Forecasting May 6, 2011


FleetHistory Worksheet

Bus Depreciation Forecasting May 6, 2011


Open:

Bus Depreciation Forecasting May 6, 2011

FleetData20April2011.xlsx


Use the drop down list:

Bus Depreciation Forecasting May 6, 2011


Drag and Copy …

Bus Depreciation Forecasting May 6, 2011


Go Back to DistrictFleetForecast.xlsx

Bus Depreciation Forecasting May 6, 2011


… and paste…

Bus Depreciation Forecasting May 6, 2011

OSPI

Student Transportation


Go to the Summary sheet:

Bus Depreciation Forecasting May 6, 2011


Check your results:

Bus Depreciation Forecasting May 6, 2011


Compare to the website:

Bus Depreciation Forecasting May 6, 2011


So, not too bad …

Bus Depreciation Forecasting May 6, 2011


But what if you see something like this?

Bus Depreciation Forecasting May 6, 2011


Tracking Down Problems:

Bus Depreciation Forecasting May 6, 2011

Check your fleet against the assumptions

Check for new buses not in FleetData

Check for buses not on the website (they don’t show if you have disposed of them)

Call for help

OSPI

Student Transportation


Where do I get help?

Bus Depreciation Forecasting May 6, 2011

Your Regional Transportation Coordinator

OSPI

Student Transportation


www.k12.wa.us/tranportation

Bus Depreciation Forecasting May 6, 2011

Click here


So, it worked. That’s nice …

Bus Depreciation Forecasting May 6, 2011

… but how do I build a forecast scenario with future purchases?

OSPI

Student Transportation


In DistrictFleetForecast.xlsx

Go to the FleetFuture sheet

Bus Depreciation Forecasting May 6, 2011


One Grid for

each year out to 2025

Bus Depreciation Forecasting May 6, 2011

Year in upper left


Enter your proposed bus purchases …

by category and expected delivery month

Bus Depreciation Forecasting May 6, 2011


Forecast shows on Summary sheet

Bus Depreciation Forecasting May 6, 2011


Keep Interest Rates and Inflation Adjusted

Bus Depreciation Forecasting May 6, 2011


Current assumptions

on OSPI Bus System web page

Bus Depreciation Forecasting May 6, 2011


That’s it….

Thanks for all you do …

Any Questions?

Bus Depreciation Forecasting May 6, 2011

OSPI

Student Transportation


ad
  • Login