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