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

DD-MFG-004

Manufacturing Network Performance and Capacity Planning

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

  • Manufacturing
  • 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-MFG-004_Question_Book.pdf 1.3 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-MFG-004_Data_Dictionary.xlsx 15.4 KB · v1.0
  • Business Introduction PDF DD-MFG-004_Business_Introduction.pdf 614.4 KB · v1.0
  • Relationship Diagram PDF DD-MFG-004_Relationship_Model.pdf 619.2 KB · v1.0
  • Raw fact data DD-MFG-004_FactProductionTransactions.parquet 267.4 MB · v1.0
  • Dimension / supporting data DD-MFG-004_Supporting_Tables.zip 159.1 MB · v1.0

Questions

Open one to discuss it
  1. Q001 Easy Total order volume
  2. Q002 Easy Total produced quantity
  3. Q003 Easy Total scrap quantity
  4. Q004 Easy Total standard cost
  5. Q005 Easy Total actual cost
  6. Q006 Easy Total cost variance
  7. Q007 Medium Monthly trend of order volume
  8. Q008 Medium Monthly trend of produced quantity
  9. Q009 Medium Monthly trend of scrap quantity
  10. Q010 Medium Monthly trend of standard cost
  11. Q011 Medium Monthly trend of actual cost
  12. Q012 Medium Monthly trend of cost variance
  13. Q013 Medium Monthly trend of run minutes
  14. Q014 Medium Monthly trend of downtime minutes
  15. Q015 Medium Monthly trend of on-time orders
  16. Q016 Medium Year-on-year change in order volume
  17. Q017 Medium Year-on-year change in produced quantity
  18. Q018 Medium Year-on-year change in scrap quantity
  19. Q019 Medium Year-on-year change in standard cost
  20. Q020 Medium Year-on-year change in actual cost
  21. Q021 Medium Year-on-year change in cost variance
  22. Q022 Hard Work centres driving change in order volume
  23. Q023 Hard Work centres driving change in produced quantity
  24. Q024 Hard Work centres driving change in scrap quantity
  25. Q025 Hard Work centres driving change in standard cost
  26. Q026 Hard Work centres driving change in actual cost
  27. Q027 Hard Work centres driving change in cost variance
  28. Q028 Hard Work centres driving change in run minutes
  29. Q029 Hard Work centres driving change in downtime minutes
  30. Q030 Hard Work centres driving change in on-time orders
  31. Q031 Hard Work centres explaining 80% of growth in order volume
  32. Q032 Hard Work centres explaining 80% of growth in produced quantity
  33. Q033 Hard Work centres explaining 80% of growth in scrap quantity
  34. Q034 Hard Work centres explaining 80% of growth in standard cost
  35. Q035 Hard Work centres explaining 80% of growth in actual cost
  36. Q036 Hard Work centres explaining 80% of growth in cost variance
  37. Q037 Hard Work centres explaining 80% of growth in run minutes
  38. Q038 Hard Machine capacity utilisation by plant
  39. Q039 Hard Actual cost against budget
  40. Q040 Very Hard Forecast method selection for order volume
  41. Q041 Very Hard Forecast method selection for produced quantity
  42. Q042 Very Hard Forecast method selection for scrap quantity
  43. Q043 Very Hard Forecast method selection for standard cost
  44. Q044 Very Hard Forecast method selection for actual cost
  45. Q045 Very Hard Forecast method selection for cost variance
  46. Q046 Very Hard Forecast method selection for run minutes
  47. Q047 Very Hard Rate and mix decomposition of downtime minutes
  48. Q048 Very Hard Rate and mix decomposition of produced quantity
  49. Q049 Very Hard Rate and mix decomposition of scrap quantity
  50. Q050 Very Hard Rate and mix decomposition of standard cost
  51. Q051 Very Hard Rate and mix decomposition of actual cost
  52. Q052 Very Hard Rate and mix decomposition of cost variance
  53. Q053 Very Hard Rate and mix decomposition of run minutes
  54. Q054 Very Hard Outlier months in order volume
  55. Q055 Very Hard Outlier months in produced quantity
  56. Q056 Very Hard Outlier months in scrap quantity
  57. Q057 Very Hard Outlier months in standard cost
  58. Q058 Very Hard Cost gap to budget and required saving
  59. Q059 Very Hard Demand forecast accuracy by plant
  60. Q060 Very Hard Maintenance 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