Summary of GWC - Bawal

With April 20 Cost

YTD Nov 20 20-21 19-20
Production (in KL ) 30976 36474
Mandays 0 75155
GWC Cost (in Lacs ) 390 488
CPL 1.26 1.34

Min Wages 653 633

Min Wages Impact (in Lacs ) 0.00

Productivity #DIV/0! 485

Mandays ( Excess / Short ) #DIV/0!
Gain from Productivity Incr #DIV/0!

Covid-19 Impact April'20 49.62

Net Impact ( in Lacs ) #DIV/0!

CPL Impact #DIV/0!

working Days 26
GL GL Description Apr
Man days Cost in lacs
687863 GWC - RM/PM/Engg Stores 1734 10.94
687864 GWC - Production/QC 4677 29.69
687865 GWC - F2B/Work off 256 1.79
687866 GWC - Engineering 467 3.31
687867 GWC - EHS/ETP 211 1.47
687868 GWC - House Keeping 925 5.76
687869 GWC - Gardening 104 0.63
Total 8373 54

Working Days
GL GL Description Apr-21
Man days Cost in lac
687863 GWC - RM/PM/Engg Stores 1482 9.16
687864 GWC - Production/QC 4267 39.24
687865 GWC - F2B/Work off 307 1.32
 687866 GWC - Engineering 418 2.55
687867 GWC - EHS/ETP 219 1.11
687868 GWC - House Keeping 938 5.34
687869 GWC - Gardening 96 0.67
TOtal 7,727 59

Working Days 5
GL GL Description Apr-20
Man days Cost in lac
687863 GWC - RM/PM/Engg Stores 1570 10.46
687864 GWC - Production/QC 4354 27.44
687865 GWC - F2B/Work off 177 1.08
687866 GWC - Engineering 405 2.55
687867 GWC - EHS/ETP 177 1.20
687868 GWC - House Keeping 990 6.24
687869 GWC - Gardening 101 0.64
TOtal 7,775 50
 15%

27 25 27 24
May June July Aug
Man days Cost in lacs Man days Cost in lacsMan daysCost in lacsMan days
1788 10.93 1736 10.93 1862 10.94 1697
4734 29.88 4209 25.78 4779 29.41 4320
259 1.64 242 1.48 261 1.45 216
485 3.06 466 2.85 480 3.07 444
225 1.42 203 1.44 223 1.41 167
1013 6.39 925 5.67 1080 6.37 984
108 0.63 94 0.63 111 0.63 98
8612 54 7875 49 8795 53 7926

May-20 Jun-20 Jul-20 Aug-20

Man days Cost in lacs Man days Cost in lacsMan daysCost in lacsMan days
 - - - - - - -

21 26 27 19 23
May-20 Jun-20 Jul-20 Aug-20
Man days Cost in lacs Man days Cost in lacsMan daysCost in lacsMan days
431 2.89 728 4.66 1216 8 1188
595 3.75 1081 6.92 3369 22 3241
76 0.46 70 0.45 177 1 168
26 0.16 273 1.75 513 5 480
89 0.57 177 1.36 177 1 192
271 1.71 481 3.08 709 5 711
101 0.64 100 0.64 101 1 96
1,589 10 2,910 19 6,263 42 ###
 25 22 25 22
Sept Oct Nov Dec
Cost in lacsMan days Cost in lacs Man days Cost in lacs Man days Cost in lacs Man days
10.95 1681 10.95 1526 10.43 1775 10.93 1611
27.18 5250 32.54 5030 31.90 4601 29.64 4620
1.41 276 1.50 260 1.68 257 1.65 261
3.08 400 2.76 353 2.67 485 3.12 415
1.27 112 1.31 126 1.21 173 1.12 127
6.41 950 5.97 924 5.95 1076 6.93 902
0.63 99 0.63 97 0.63 100.00 0.63 88
51 8767 56 8316 54 8466 54 8024
75155 425
565

#DIV/0!

Sep-20 Oct-20 Nov-20 Dec-20

Cost in lacsMan days Cost in lacs Man days Cost in lacs Man days Cost in lacs Man days
 - - - - - - - -

26 28 26 27
Sep-20 Oct-20 Nov-20 Dec-20
Cost in lacsMan days Cost in lacs Man days Cost in lacs Man days Cost in lacs Man days
8 1508 10.25 1652 10.90 1,508.00 10.25 1,566
22 4394 28.12 5068 32.44 4,030.00 25.79 4,509.00
1 260 1.66 308 1.97 208.00 1.33 216.00
3 572 3.66 616 3.94 572.00 3.66 594.00
1.29 182 1.30 196 1.36 177.00 1.28 189.00
5 910 5.82 1008 6.45 832.00 5.72 945.00
1 104 0.67 112 0.72 104 0.67 108.00
41.13 ### 51.49 8,960.00 57.78 7,431.00 48.71 7,074.00
 25 24
Jan Feb
Cost in lacs Man days Cost in lacs Man days Cost in lacs
10.94 1745 10.94 1750 10.94
29.71 4805 31.53 4618 30.22
1.60 255 1.67 223 1.46
3.05 445 2.92 412 2.70
1.28 147 1.36 136 1.29
5.79 1013 7.06 984 6.88
0.63 95 0.63 90 0.63
53 8505 56 8214 54

Jan-21 Feb-21
Cost in lacs Man days Cost in lacs Man days Cost in lacs
 - - - - - -
Equipment cleaning 4
Total 4.00

24 24
Jan-21 Feb-21
Cost in lacs Man days Cost in lacs Man days Cost in lacs
10.65 1,392.00 10.67 766.21 1,392.00 10.67 766.21
28.86 4,056 29.70 732.33 4,248.00 31.09 731.77
1.38 216 1.46 677.04 240 1.62 673.33
3.80 528 3.58 677.88 528.00 3.58 677.88
1.21 168.00000 1.21 720.24 168 1.21 720.24
6.05 936.00 6.19 661.37 960.00 6.34 660.83
0.69 96.00 0.66 692.08 96.00 0.66 692.08
52.64 7,392.00 53.48 ### 7,632.00 55.16
 15 287 69.46524
Mar Grand Total
Man days Cost in lacs Man days Cost in lacs
1033 10.94 19937 131 655.97
2922 30.34 54566 358 655.75
197 2.04 2962 19 653.94
243 2.92 5095 36 697.22
101 1.05 1950 16 801.23
804 8.34 11578 78 669.58
78 0.63 1163 8 650.16
5377 56 97250 644 662.41 478

Mar-21 Total
Man days Cost in lacs Man days Cost in lacs21-22 mandays % incr in Rs
1,482.00 9.16 1,556.10 5% 1,009,890
4,267.00 39.24 5,120.40 20% 4,944,240
307.00 1.32 322.35 5% 145,530
 418.00 2.55 418.00 0% 267,750
219.00 1.11 219.00 0% 116,550
938.00 5.34 938.00 0% 560,700
96.00 0.67 96.00 0% 70,350
- - 7,727.00 59.39 8,669.85 7,115,010
643.92 722.49 71
25.76 34 28.90 54
93 125
276 56 55.33333333333
Mar-21 Total
Man days Cost in lacs Man days Cost in lacs
1,392.00 10.67 15,542.91 107.84
4,672.80 34.14 43,617.54 291.69
240.00 1.62 2,356.61 15.29
528.00 3.58 5,635.00 38.35
168.00 1.21 2,060.62 14.56
960.00 6.34 9,713.24 63.34
96.00 0.66 1,215.63 7.94
8,056.80 58.22 80,141.54 539.01
 438 590.2884

Minwage r,@5% increase

618 649 - - - -
920 966 - - - -
430 451 - - - -
610 641 - - - -
507 532 - - - -
569 598 - - - -
698 733 - - - -

60