1 / 36

Bus Depreciation Forecasting

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

kerri
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Bus DepreciationForecasting WASBO Workshop May 6, 2011 OSPI Student Transportation

  2. The Big Question: Bus Depreciation Forecasting May 6, 2011 What’s happening with the depreciation system? OSPI Student Transportation

  3. We Don’t Know… Bus Depreciation Forecasting May 6, 2011 … but this forecast tool (or one like it) will work regardless. OSPI Student Transportation

  4. The little Question: Bus Depreciation Forecasting May 6, 2011 What happened to the previous Forecast Tool? Answer: That sales tax thing OSPI Student Transportation

  5. The Solution: Bus Depreciation Forecasting May 6, 2011 Excel workbooks with cut-and-paste district data entry OSPI Student Transportation

  6. 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

  7. Depending??? what do you mean “depending” Bus Depreciation Forecasting May 6, 2011 OSPI Student Transportation

  8. 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

  9. Here’s one bus grid Category D84D, September, 2010: Bus Depreciation Forecasting May 6, 2011 OSPI Student Transportation

  10. Here’s one year… Bus Depreciation Forecasting May 6, 2011 Detail from Prior Slide

  11. 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

  12. Where can you get the files? Bus Depreciation Forecasting May 6, 2011 https://eds.ospi.k12.wa.us/BusDepreciation (public access) OSPI Student Transportation

  13. Open: Bus Depreciation Forecasting May 6, 2011 DistrictFleetForecast.xlsx

  14. Go to the FleetHistory sheet: Bus Depreciation Forecasting May 6, 2011

  15. FleetHistory Worksheet Bus Depreciation Forecasting May 6, 2011

  16. Open: Bus Depreciation Forecasting May 6, 2011 FleetData20April2011.xlsx

  17. Use the drop down list: Bus Depreciation Forecasting May 6, 2011

  18. Drag and Copy … Bus Depreciation Forecasting May 6, 2011

  19. Go Back to DistrictFleetForecast.xlsx Bus Depreciation Forecasting May 6, 2011

  20. … and paste… Bus Depreciation Forecasting May 6, 2011 OSPI Student Transportation

  21. Go to the Summary sheet: Bus Depreciation Forecasting May 6, 2011

  22. Check your results: Bus Depreciation Forecasting May 6, 2011

  23. Compare to the website: Bus Depreciation Forecasting May 6, 2011

  24. So, not too bad … Bus Depreciation Forecasting May 6, 2011

  25. But what if you see something like this? Bus Depreciation Forecasting May 6, 2011

  26. 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

  27. Where do I get help? Bus Depreciation Forecasting May 6, 2011 Your Regional Transportation Coordinator OSPI Student Transportation

  28. www.k12.wa.us/tranportation Bus Depreciation Forecasting May 6, 2011 Click here

  29. 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

  30. In DistrictFleetForecast.xlsx Go to the FleetFuture sheet Bus Depreciation Forecasting May 6, 2011

  31. One Grid for each year out to 2025 Bus Depreciation Forecasting May 6, 2011 Year in upper left

  32. Enter your proposed bus purchases … by category and expected delivery month Bus Depreciation Forecasting May 6, 2011

  33. Forecast shows on Summary sheet Bus Depreciation Forecasting May 6, 2011

  34. Keep Interest Rates and Inflation Adjusted Bus Depreciation Forecasting May 6, 2011

  35. Current assumptions on OSPI Bus System web page Bus Depreciation Forecasting May 6, 2011

  36. That’s it…. Thanks for all you do … Any Questions? Bus Depreciation Forecasting May 6, 2011 OSPI Student Transportation

More Related