bus depreciation forecasting
Download
Skip this Video
Download Presentation
Bus Depreciation Forecasting

Loading in 2 Seconds...

play fullscreen
1 / 36

Bus Depreciation Forecasting - PowerPoint PPT Presentation


  • 124 Views
  • Uploaded on

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

PowerPoint Slideshow about 'Bus Depreciation Forecasting' - kerri


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 depreciation forecasting

Bus DepreciationForecasting

WASBO Workshop

May 6, 2011

OSPI

Student Transportation

bus depreciation forecasting may 6 2011
The Big Question:

Bus Depreciation Forecasting May 6, 2011

What’s happening with the depreciation system?

OSPI

Student Transportation

bus depreciation forecasting may 6 20111
We Don’t Know…

Bus Depreciation Forecasting May 6, 2011

… but this forecast tool

(or one like it)

will work regardless.

OSPI

Student Transportation

bus depreciation forecasting may 6 20112
The little Question:

Bus Depreciation Forecasting May 6, 2011

What happened to the previous Forecast Tool?

Answer: That sales tax thing

OSPI

Student Transportation

bus depreciation forecasting may 6 20113
The Solution:

Bus Depreciation Forecasting May 6, 2011

Excel workbooks

with cut-and-paste district data entry

OSPI

Student Transportation

bus depreciation forecasting may 6 20114
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

bus depreciation forecasting may 6 20115
Depending???

what do you mean “depending”

Bus Depreciation Forecasting May 6, 2011

OSPI

Student Transportation

bus depreciation forecasting may 6 20116
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

bus depreciation forecasting may 6 20117
Here’s one bus grid

Category D84D, September, 2010:

Bus Depreciation Forecasting May 6, 2011

OSPI

Student Transportation

bus depreciation forecasting may 6 20118
Here’s one year…

Bus Depreciation Forecasting May 6, 2011

Detail from Prior Slide

bus depreciation forecasting may 6 20119
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

bus depreciation forecasting may 6 201110
Where

can you get the files?

Bus Depreciation Forecasting May 6, 2011

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

(public access)

OSPI

Student Transportation

bus depreciation forecasting may 6 201111
Open:

Bus Depreciation Forecasting May 6, 2011

DistrictFleetForecast.xlsx

bus depreciation forecasting may 6 201114
Open:

Bus Depreciation Forecasting May 6, 2011

FleetData20April2011.xlsx

bus depreciation forecasting may 6 201118
… and paste…

Bus Depreciation Forecasting May 6, 2011

OSPI

Student Transportation

bus depreciation forecasting may 6 201124
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

bus depreciation forecasting may 6 201125
Where do I get help?

Bus Depreciation Forecasting May 6, 2011

Your Regional Transportation Coordinator

OSPI

Student Transportation

bus depreciation forecasting may 6 201127
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

bus depreciation forecasting may 6 201129
One Grid for

each year out to 2025

Bus Depreciation Forecasting May 6, 2011

Year in upper left

bus depreciation forecasting may 6 201130
Enter your proposed bus purchases …

by category and expected delivery month

Bus Depreciation Forecasting May 6, 2011

bus depreciation forecasting may 6 201133
Current assumptions

on OSPI Bus System web page

Bus Depreciation Forecasting May 6, 2011

bus depreciation forecasting may 6 201134
That’s it….

Thanks for all you do …

Any Questions?

Bus Depreciation Forecasting May 6, 2011

OSPI

Student Transportation

ad