High Level Design
Overview
Measuring and monitoring the amount of waste a company generates can give it insight into the efficiency and effectiveness of its operations as well as their environmental and social impact.
Understanding trends, main root causes and other insights from analyzing this data will enable the organization to focus on the most crucial improvements that need to be made.
Goals
Minimize the amount of waste we generate.
Objectives
- Lower Waste Reduction Rate, under 100% each month in 2016 for the different units we manufacture.
- Lower Waste Reduction Rate, under 100% each month in 2016 for the different materials we use in production.
KPI Architecture
Objectives |
KPIs |
Measures |
Data Source |
Lower Waste Reduction Rate, under 100% each month in 2016 for the different units we manufacture |
Waste Reduction Rate (Monthly / %) per Unit / Material |
- Wasted raw material cost ($) for current month
- Wasted raw material cost ($) for past periods
- Failed Production Rate (%)
|
Production_Manufacturing, Purchasing_Raw_Material, Production_Unit_Spec |
Data Requirements
# |
Source |
Table Name |
Table Details (type, # rows, key fields) |
1 |
Manufacturing |
Production_Manufacturing |
How many units produced (pass/fail) each month. |
2 |
Billing System |
Purchasing_Raw_Material |
For each material and supplier, the amount of tonnes purchased each month and their price. |
3 |
Product |
Production_Unit_Spec |
Amount of materials needed to produce each unit. |
Data Modeling (Elasticube Design)
