Skip to main content
Data Dare logistics L4 sticker: the findi360 mascot analysing Fleet Network Performance and Capacity Planning.

DD-LOG-004

Fleet Network Performance and Capacity Planning

Decide where the network is short of vehicle hours, which depots run over budget and why, and how far next year's demand can be met from the evidence.

  • Logistics
  • L4 · PARQUET
  • ~6,000,000 rows
  • 18 tables
  • 60 questions
Get the data 60 questions

Get the data

v1.0 · 6 files

Files are for members. A free account takes a minute, and you come straight back here.

Create a free account Sign in
  • Question Book PDF DD-LOG-004_Question_Book.pdf 1.3 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-LOG-004_Data_Dictionary.xlsx 15.5 KB · v1.0
  • Business Introduction PDF DD-LOG-004_Business_Introduction.pdf 614.6 KB · v1.0
  • Relationship Diagram PDF DD-LOG-004_Relationship_Model.pdf 618.6 KB · v1.0
  • Raw fact data DD-LOG-004_FactFleetTransactions.parquet 242.5 MB · v1.0
  • Dimension / supporting data DD-LOG-004_Supporting_Tables.zip 58.7 MB · v1.0

Questions

Open one to discuss it
  1. Q001 Easy Total shipment volume
  2. Q002 Easy Total delivered units
  3. Q003 Easy Total distance driven
  4. Q004 Easy Total delay hours
  5. Q005 Easy Total planned delivery cost
  6. Q006 Easy Total actual delivery cost
  7. Q007 Medium Monthly trend of shipment volume
  8. Q008 Medium Monthly trend of delivered units
  9. Q009 Medium Monthly trend of distance driven
  10. Q010 Medium Monthly trend of delay hours
  11. Q011 Medium Monthly trend of planned delivery cost
  12. Q012 Medium Monthly trend of actual delivery cost
  13. Q013 Medium Monthly trend of delivery cost variance
  14. Q014 Medium Monthly trend of fuel consumed
  15. Q015 Medium Monthly trend of on-time deliveries
  16. Q016 Medium Year-on-year change in shipment volume
  17. Q017 Medium Year-on-year change in delivered units
  18. Q018 Medium Year-on-year change in distance driven
  19. Q019 Medium Year-on-year change in delay hours
  20. Q020 Medium Year-on-year change in planned delivery cost
  21. Q021 Medium Year-on-year change in actual delivery cost
  22. Q022 Hard Routes driving change in shipment volume
  23. Q023 Hard Routes driving change in delivered units
  24. Q024 Hard Routes driving change in distance driven
  25. Q025 Hard Routes driving change in delay hours
  26. Q026 Hard Routes driving change in planned delivery cost
  27. Q027 Hard Routes driving change in actual delivery cost
  28. Q028 Hard Routes driving change in delivery cost variance
  29. Q029 Hard Routes driving change in fuel consumed
  30. Q030 Hard Routes driving change in on-time deliveries
  31. Q031 Hard Routes explaining 80% of growth in shipment volume
  32. Q032 Hard Routes explaining 80% of growth in delivered units
  33. Q033 Hard Routes explaining 80% of growth in distance driven
  34. Q034 Hard Routes explaining 80% of growth in delay hours
  35. Q035 Hard Routes explaining 80% of growth in planned delivery cost
  36. Q036 Hard Routes explaining 80% of growth in actual delivery cost
  37. Q037 Hard Routes explaining 80% of growth in delivery cost variance
  38. Q038 Hard Vehicle-hour utilisation by depot
  39. Q039 Hard Delivery cost against budget
  40. Q040 Very Hard Forecast method selection for shipment volume
  41. Q041 Very Hard Forecast method selection for delivered units
  42. Q042 Very Hard Forecast method selection for distance driven
  43. Q043 Very Hard Forecast method selection for delay hours
  44. Q044 Very Hard Forecast method selection for planned delivery cost
  45. Q045 Very Hard Forecast method selection for actual delivery cost
  46. Q046 Very Hard Forecast method selection for delivery cost variance
  47. Q047 Very Hard Rate and mix decomposition of fuel consumed
  48. Q048 Very Hard Rate and mix decomposition of delivered units
  49. Q049 Very Hard Rate and mix decomposition of distance driven
  50. Q050 Very Hard Rate and mix decomposition of delay hours
  51. Q051 Very Hard Rate and mix decomposition of planned delivery cost
  52. Q052 Very Hard Rate and mix decomposition of actual delivery cost
  53. Q053 Very Hard Rate and mix decomposition of delivery cost variance
  54. Q054 Very Hard Outlier months in shipment volume
  55. Q055 Very Hard Outlier months in delivered units
  56. Q056 Very Hard Outlier months in distance driven
  57. Q057 Very Hard Outlier months in delay hours
  58. Q058 Very Hard Cost gap to budget and required saving
  59. Q059 Very Hard Shipment forecast accuracy by depot
  60. Q060 Very Hard Breakdown support pool allocation

General discussion

Anything about this dataset that is not one question — loading the files, which tool, how you set it up.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in