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