DD-MFG-002
Work Orders, Materials and Production Variance
Decide whether the variance between standard and actual cost comes from material prices, material usage or the hours spent, and which plant carries it.
- Manufacturing
- 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-MFG-002_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-MFG-002_Data_Dictionary.xlsx
- Business Introduction PDF DD-MFG-002_Business_Introduction.pdf
- Relationship Diagram PDF DD-MFG-002_Relationship_Model.pdf
- Raw fact data DD-MFG-002_FactWorkOrders.csv
- Dimension / supporting data DD-MFG-002_Dimensions.zip
Questions
Open one to discuss it- Q001 Easy Total order volume
- Q002 Easy Total produced quantity
- Q003 Easy Total scrap quantity
- Q004 Easy Total standard cost
- Q005 Easy Total actual cost
- Q006 Easy Total cost variance
- Q007 Easy Total run minutes
- Q008 Easy Total downtime minutes
- Q009 Easy Total on-time orders
- Q010 Easy Top work centre by order volume
- Q011 Easy Top work centre by produced quantity
- Q012 Easy Top work centre by scrap quantity
- Q013 Easy Top work centre by standard cost
- Q014 Easy Top work centre by actual cost
- Q015 Easy Top work centre by cost variance
- Q016 Easy Top work centre by run minutes
- Q017 Medium Monthly trend of order volume
- Q018 Medium Monthly trend of produced quantity
- Q019 Medium Monthly trend of scrap quantity
- Q020 Medium Monthly trend of standard cost
- Q021 Medium Monthly trend of actual cost
- Q022 Medium Monthly trend of cost variance
- Q023 Medium Monthly trend of run minutes
- Q024 Medium Monthly trend of downtime minutes
- Q025 Medium Monthly trend of on-time orders
- Q026 Medium Year-on-year change in order volume
- Q027 Medium Year-on-year change in produced quantity
- Q028 Medium Year-on-year change in scrap quantity
- Q029 Medium Year-on-year change in standard cost
- Q030 Medium Year-on-year change in actual cost
- Q031 Medium Year-on-year change in cost variance
- Q032 Medium Year-on-year change in run minutes
- Q033 Medium Year-on-year change in downtime minutes
- Q034 Medium Year-on-year change in on-time orders
- Q035 Medium Scrap rate by month
- Q036 Medium Actual cost per unit by month
- Q037 Hard Work centres driving change in order volume
- Q038 Hard Work centres driving change in produced quantity
- Q039 Very Hard Forecast method selection for order volume
- Q040 Very Hard Forecast method selection for produced quantity
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.