Spreadsheet: 65178d1265895404-print-range-of-cells-factory-kpis-2010-2011new
Sheet: waste

W/C date | MDF m2 | MDF Cost/m2 | MDF Foiled m2 | MDF Foiled Cost/m2 | [NAME] (Beech/Beech Superpan) m2 | [NAME] (Beech/Beech Superpan) Cost/m2 | [NAME] m2 | [NAME] Sided Cost/m2 | [NAME] (Raw/Beech Superpan) m2 | [NAME] (Raw/Beech Superpan) Cost/m2 | [NAME] (Raw/Beech Superpan) Foiled m2 | [NAME] (Raw/Beech Superpan) Foiled Cost/m2 | 22mm MDF | 22mm MDF cost/m2 | 22mm MDF Foiled | 22mm MDF Foiled cost/m2 | Totals
2010-05-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | * denotes an input cell |  |  |  | * Calculation cell |  |  | * Calculated cell |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | W | t
2010-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-05-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Table Breakdown |  |  |  |  |  | Department [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-05-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-05-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | MDF |  |  |  |  |  | Board Cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-06-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-06-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Board Cost |  | 46 | ÷10 | 4.6 |  | "Board cost" displays per 10 square meter, calculation then changes to per square meter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-06-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Staff Cost |  | 10 | ÷4  x  Dep | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-06-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Departments |  | 2 |  |  |  | Staff Costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-07-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 4.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-07-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | MDF Foiled |  |  |  |  |  | Staff costs are worked out at an average hourly rate ÷ 4 (15mins per department) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-07-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-07-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Board Cost |  | 46 | ÷10 | 4.6 |  | Foil Costs
2010-08-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Staff Cost |  | 10 | ÷4  x  Dep | 10
2010-08-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Foil Cost |  | 6 |  | 6 |  | Foil costs are worked out on average price of foil per square meter
2010-08-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Departments |  | 4
2010-08-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 10.6 |  | Departments
2010-08-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | [NAME] (Beech/Beech Superpan)
2010-09-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | Departments are divided into 4 sections, enter the number of departments a panel has to revisit each department.
2010-09-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Board Cost |  | 37.77 | ÷10 | 3.777
2010-09-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Staff Cost |  | 10 | ÷4  x  Dep | 5 |  | Departments Available:
2010-09-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Departments |  | 2
2010-10-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 3.777 |  | Office
2010-10-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | [NAME] |  |  |  |  |  | Router/Beam Saw
2010-10-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | Edgebanding/Sanding
2010-10-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Board Cost |  | 40 | ÷10 | 4 |  | Press
2010-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Staff Cost |  | 10 | ÷4  x  Dep | 5
2010-11-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Departments |  | 2
2010-11-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 4
2010-11-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | [NAME] (Raw/Beech Superpan)
2010-11-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-12-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Board Cost |  | 34.38 | ÷10 | 3.438
2010-12-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Staff Cost |  | 10 | ÷4  x  Dep | 5
2010-12-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Departments |  | 2
2010-12-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 3.438
2011-01-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | [NAME] (Raw/Beech Superpan) Foiled
2011-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2011-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Board Cost |  | 34.38 | ÷10 | 3.438
2011-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Staff Cost |  | 10 | ÷4  x  Dep | 7.5
2011-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Foil Cost |  | 6 |  | 6
2011-02-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Departments |  | 3
2011-02-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 9.438
2011-02-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 22mm MDF
2011-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2011-03-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Board Cost |  | 38.55 | ÷10 | 3.855
2011-03-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Staff Cost |  | 10 | ÷4  x  Dep | 5
2011-03-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Departments |  | 2
2011-03-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 3.855
2011-04-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 22mm MDF Foiled
2011-04-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2011-04-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Board Cost |  | 38.55 | ÷10 | 3.855
2011-04-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Staff Cost |  | 10 | ÷4  x  Dep | 10
Year Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Foil Costs |  | 6 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Departments |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.855
 |  | Monthly Calculation Table's
 |  | MDF |  |  |  | MDF Foiled |  |  |  | [NAME] (Beech/Beech Superpan) m2 |  |  |  | [NAME] m2
 |  |  | [NAME] | Total |  | Height | [NAME] | Total |  | Height | [NAME] | Total |  | Height | [NAME] | Total
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | Click button to clear all contents for the new week
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | Tables to the left are used for entering the sizes of damaged panels for the working month,
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | once the month has finished, input the total values into the main table above and then
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | clear the monthly calculation table by selecting CLEAR.
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  | Total | 0 |  |  | Total | 0 |  |  | Total | 0 |  |  | Total | 0
 |  | [NAME] (Raw/Beech Superpan) m2 |  |  |  | [NAME] (Raw/Beech Superpan) Foiled m2 |  |  |  | 22mm MDF |  |  |  | 22mm MDF Foiled
 |  | Height | [NAME] | Total |  | Height | [NAME] | Total |  | Height | [NAME] | Total |  | Height | [NAME] | Total
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  | Total | 0 |  |  | Total | 0 |  |  | Total | 0 |  |  | Total | 0