DD-LOG-002
Delivery Orders, Route Performance and Vehicle Utilisation
Decide whether the gap between planned and actual delivery cost comes from distance, hours or fuel price, and which routes carry it.
- Logistics
- L2 · CSV
- ~30,000 rows
- 8 tables
- 40 questions
Get the data
v1.0 · 6 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-LOG-002_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-LOG-002_Data_Dictionary.xlsx
- Business Introduction PDF DD-LOG-002_Business_Introduction.pdf
- Relationship Diagram PDF DD-LOG-002_Relationship_Model.pdf
- Raw fact data DD-LOG-002_FactDeliveryOrders.csv
- Dimension / supporting data DD-LOG-002_Dimensions.zip
Questions
Open one to discuss it- Q001 Easy Total shipment volume
- Q002 Easy Total delivered units
- Q003 Easy Total distance driven
- Q004 Easy Total delay hours
- Q005 Easy Total planned delivery cost
- Q006 Easy Total actual delivery cost
- Q007 Easy Total delivery cost variance
- Q008 Easy Total fuel consumed
- Q009 Easy Total on-time deliveries
- Q010 Easy Top route by shipment volume
- Q011 Easy Top route by delivered units
- Q012 Easy Top route by distance driven
- Q013 Easy Top route by delay hours
- Q014 Easy Top route by planned delivery cost
- Q015 Easy Top route by actual delivery cost
- Q016 Easy Top route by delivery cost variance
- Q017 Medium Monthly trend of shipment volume
- Q018 Medium Monthly trend of delivered units
- Q019 Medium Monthly trend of distance driven
- Q020 Medium Monthly trend of delay hours
- Q021 Medium Monthly trend of planned delivery cost
- Q022 Medium Monthly trend of actual delivery cost
- Q023 Medium Monthly trend of delivery cost variance
- Q024 Medium Monthly trend of fuel consumed
- Q025 Medium Monthly trend of on-time deliveries
- Q026 Medium Year-on-year change in shipment volume
- Q027 Medium Year-on-year change in delivered units
- Q028 Medium Year-on-year change in distance driven
- Q029 Medium Year-on-year change in delay hours
- Q030 Medium Year-on-year change in planned delivery cost
- Q031 Medium Year-on-year change in actual delivery cost
- Q032 Medium Year-on-year change in delivery cost variance
- Q033 Medium Year-on-year change in fuel consumed
- Q034 Medium Year-on-year change in on-time deliveries
- Q035 Medium Fuel litres per km by month
- Q036 Medium Delivery cost per shipment by month
- Q037 Hard Routes driving change in shipment volume
- Q038 Hard Routes driving change in delivered units
- Q039 Very Hard Forecast method selection for shipment volume
- Q040 Very Hard Forecast method selection for delivered units
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.