Bus depreciation forecasting
This presentation is the property of its rightful owner.
Sponsored Links
1 / 36

Bus Depreciation Forecasting PowerPoint PPT Presentation


  • 89 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….

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 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 201112

Go to the FleetHistory sheet:

Bus Depreciation Forecasting May 6, 2011


Bus depreciation forecasting may 6 201113

FleetHistory Worksheet

Bus Depreciation Forecasting May 6, 2011


Bus depreciation forecasting may 6 201114

Open:

Bus Depreciation Forecasting May 6, 2011

FleetData20April2011.xlsx


Bus depreciation forecasting may 6 201115

Use the drop down list:

Bus Depreciation Forecasting May 6, 2011


Bus depreciation forecasting may 6 201116

Drag and Copy …

Bus Depreciation Forecasting May 6, 2011


Bus depreciation forecasting may 6 201117

Go Back to DistrictFleetForecast.xlsx

Bus Depreciation Forecasting May 6, 2011


Bus depreciation forecasting may 6 201118

… and paste…

Bus Depreciation Forecasting May 6, 2011

OSPI

Student Transportation


Bus depreciation forecasting may 6 201119

Go to the Summary sheet:

Bus Depreciation Forecasting May 6, 2011


Bus depreciation forecasting may 6 201120

Check your results:

Bus Depreciation Forecasting May 6, 2011


Bus depreciation forecasting may 6 201121

Compare to the website:

Bus Depreciation Forecasting May 6, 2011


Bus depreciation forecasting may 6 201122

So, not too bad …

Bus Depreciation Forecasting May 6, 2011


Bus depreciation forecasting may 6 201123

But what if you see something like this?

Bus Depreciation Forecasting May 6, 2011


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 201126

www.k12.wa.us/tranportation

Bus Depreciation Forecasting May 6, 2011

Click here


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 201128

In DistrictFleetForecast.xlsx

Go to the FleetFuture sheet

Bus Depreciation Forecasting May 6, 2011


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 201131

Forecast shows on Summary sheet

Bus Depreciation Forecasting May 6, 2011


Bus depreciation forecasting may 6 201132

Keep Interest Rates and Inflation Adjusted

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


  • Login