360 likes | 526 Views
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….
E N D
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