— of — standards are above limit for this selection (wrapper, laddi, shrink, broken, gas, electricity, manpower). Red is above standard, green is at or below.
Live from the Production sheet. Loading…
Production
—kg
From the Broken tab
Wrapper wastage
—%
Allowed —% Above stdWithin std
Broken
—%
Limit —% Above limitWithin limit
Total sweepage
—%
— kg of production
Gas per MT
—
Std — · vs std —Above stdWithin std
Electricity units per MT
—
Std — · vs std —Above stdWithin std
Manpower cost per kg
₹—
Std ₹— · vs std —Above stdWithin std
Breakdown
—hrs
—% of — running hrs
RM used over BOM
—kg
—% of BOM Over BOMWithin BOM
Wrapper, laddi & shrink wastage %, day wise
Wastage over standard use. Red bars are above the allowed % (dashed tick), green within it.
Broken %, day wise
Broken kg over production kg. Red bars are above the —% limit (dashed).
Gas per MT vs std, day wise
Dashed tick is the day's standard.
Electricity units per MT vs std, day wise
Dashed tick is the day's standard.
Wrapper wastage
—%
Allowed —% · excess — kg Above stdWithin std
Laddi wastage
—%
Allowed —% · excess — kg Above stdWithin std
Shrink wastage
—%
Allowed —% · excess — kg Above stdWithin std
Broken
—%
— kg · limit —% Above limitWithin limit
Wastage % vs allowed, day wise
Red bars are above the allowed % (dashed tick), green within it.
Wastage % vs allowed, month wise
Every month in the sheet, for the shift, SKU and incharge chosen.
Broken %, day wise
Red above the —% limit, green below.
Broken %, month wise
Every month in the sheet, for the shift, SKU and incharge chosen.
Wrapper, laddi & shrink breakdown
Wastage % is red above its allowed %; excess kg is use beyond the allowed quantity.
Date
Wrapper %
Laddi %
Shrink %
Wrapper excess kg
Laddi excess kg
Shrink excess kg
Wrapper used kg
Week
Wrapper %
Laddi %
Shrink %
Wrapper excess kg
Laddi excess kg
Shrink excess kg
Wrapper used kg
Month
Wrapper %
Laddi %
Shrink %
Wrapper excess kg
Laddi excess kg
Shrink excess kg
Wrapper used kg
Shift
Wrapper %
Laddi %
Shrink %
Wrapper excess kg
Laddi excess kg
Shrink excess kg
Wrapper used kg
SKU
Wrapper %
Laddi %
Shrink %
Wrapper excess kg
Laddi excess kg
Shrink excess kg
Wrapper used kg
Incharge
Wrapper %
Laddi %
Shrink %
Wrapper excess kg
Laddi excess kg
Shrink excess kg
Wrapper used kg
Broken breakdown
Date
Production kg
Broken kg
Broken %
Week
Production kg
Broken kg
Broken %
Month
Production kg
Broken kg
Broken %
Shift
Production kg
Broken kg
Broken %
SKU
Production kg
Broken kg
Broken %
Incharge
Production kg
Broken kg
Broken %
Each item as % of production kg. Red above —%, green at or below.
Dough
—%
— kg
Chura
—%
— kg
Floor sweepage
—%
— kg
Cream
—%
— kg
Maida
—%
— kg
Sugar
—%
— kg
Sweepage kg, day wise
Stacked by item.
DoughChuraFloorCreamMaidaSugar
Sweepage breakdown
Date
Production kg
Dough %
Chura %
Floor %
Cream %
Maida %
Sugar %
Total kg
Total %
Week
Production kg
Dough %
Chura %
Floor %
Cream %
Maida %
Sugar %
Total kg
Total %
Shift
Production kg
Dough %
Chura %
Floor %
Cream %
Maida %
Sugar %
Total kg
Total %
SKU
Production kg
Dough %
Chura %
Floor %
Cream %
Maida %
Sugar %
Total kg
Total %
Incharge
Production kg
Dough %
Chura %
Floor %
Cream %
Maida %
Sugar %
Total kg
Total %
Month
Production kg
Dough %
Chura %
Floor %
Cream %
Maida %
Sugar %
Total kg
Total %
Core
—
Maida bags
—
Sugar bags
—
Jar
—
Chemical bags
—
Drum
—
Bottle
—
Scrap per day
Quantities as entered in the Srap tab.
Date
Core
Maida bags
Sugar bags
Jar
Chemical bags
Drum
Bottle
Week
Core
Maida bags
Sugar bags
Jar
Chemical bags
Drum
Bottle
Month
Core
Maida bags
Sugar bags
Jar
Chemical bags
Drum
Bottle
Shift
Core
Maida bags
Sugar bags
Jar
Chemical bags
Drum
Bottle
SKU
Core
Maida bags
Sugar bags
Jar
Chemical bags
Drum
Bottle
Incharge
Core
Maida bags
Sugar bags
Jar
Chemical bags
Drum
Bottle
Variance = actual − BOM. Red is more than BOM, green is BOM or less.
RM as per BOM
—kg
Actual RM used
—kg
Variance
—kg
Over BOMWithin BOM
Variance % of BOM
—%
RM variance %, day wise
All raw materials together; above zero means more used than BOM.
RM variance breakdown
Raw material
BOM
Actual
Variance
Variance %
Date
BOM
Actual
Variance
Variance %
Week
BOM
Actual
Variance
Variance %
Shift
BOM
Actual
Variance
Variance %
SKU
BOM
Actual
Variance
Variance %
Incharge
BOM
Actual
Variance
Variance %
Month
BOM
Actual
Variance
Variance %
Total breakdown
—hrs
—% of — running hrs
Machine
—hrs
Oven
—hrs
Mixing
—hrs
Packing
—hrs
Manpower
—hrs
Electricity
—hrs
Breakdown hours, day wise
Stacked by cause.
MachineOvenMixingPackingManpowerElectricity
Breakdown by day, shift, SKU and incharge
Date
Running hrs
Machine
Oven
Mixing
Packing
Manpower
Electricity
Total hrs
% of running
Week
Running hrs
Machine
Oven
Mixing
Packing
Manpower
Electricity
Total hrs
% of running
Month
Running hrs
Machine
Oven
Mixing
Packing
Manpower
Electricity
Total hrs
% of running
Shift
Running hrs
Machine
Oven
Mixing
Packing
Manpower
Electricity
Total hrs
% of running
SKU
Running hrs
Machine
Oven
Mixing
Packing
Manpower
Electricity
Total hrs
% of running
Incharge
Running hrs
Machine
Oven
Mixing
Packing
Manpower
Electricity
Total hrs
% of running
Red is above standard, green is at or below. Std is weighted by production when several entries are added up.