Waste Management

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)