Opp Efficiency 2021-22
Opp Efficiency 2021-22
Total Milk Sales LPD Coal Kgs Coal ' Kg / KL Fuel rate
Total Milk Sales LPD Coal Kgs Coal ' Kg / KL Fuel rate
0.027
Value
FURNACE OIL QTYFur. Oil QTY BUD FURNACE OIL VAFURNACE OIL VACOAL VALUE Actual Budget
- - 2,193,680 2,193,680 2,100,932
- - 2,639,733 2,639,733 3,059,893
- - 2,217,174 2,217,174 2,629,858
- - 2,470,114 2,470,114 2,860,450
- - 2,723,624 2,723,624 3,117,894
- - 2,429,824 2,429,824 2,898,609
- - 2,646,927 2,646,927 3,117,330
16,000 16,000 624,000 624,000 2,811,052 3,435,052 3,650,229
41,060 41,060 1,601,340 1,601,340 3,789,484 5,390,824 6,248,266
40,000 40,000 1,560,000 1,560,000 4,046,231 5,606,231 5,886,962
- - 5,215,726 4,046,231 5,215,726
- - 6,424,039 4,046,231 6,424,039
- 3,785,340 39,607,608 39,845,645 ###
Value
3,667,865
Cost per Lit
Actual Budget
0.16 0.14
0.20 0.17
0.18 0.15
0.19 0.16
0.20 0.17
0.18 0.17
0.19 0.18
0.22 0.21
0.39 0.35
0.40 0.37
0.36 0.34
0.39 0.37
0.25 0.23
Actual Budget
0.24 0.00
0.21 0.00
0.37 0.00
0.28 0.00
0.25 0.00
0.27 0.00
0.27 0.00
0.24 0.00
0.20 0.00
0.48 0.00
0.29 0.00
0.25 0.00
0.28 0.00
PURCHASED POWER 2020-2021
PURCHASED POWER
Power 2021-2022
Overall Actuals Budget Efficiency Actuals Budget
Month Milk Handled(Ltrs) Units/KL
Apr 12742832 1.00 75 71
May 13000530 1.00 82 77
Jun 13514065.9 1.00 75 71
Jul 13058615.6 1.00 78 74
4.95 Aug 12742832 1.00 80 76
5.85 Sep 12239616 1.00 91 87
Oct 13073594 1.00 75 71
Nov 12087780 1.00 81 77
Dec 15115640 1.00 55 52
Jan 16694100 1.00 54 51
Feb 11826600 1.00 77 73
Mar 12554684 1.00 79 75
Total 158,650,890 - 74 71
Actuals Budget Actuals Budget Actuals Budget Actuals
Units/Consumption Rate Value Cost/Ltr
774360 840,503 6.81 6 5,273,392 5,043,019 0.39
933630 1,226,532 6.77 6 6,318,808 7,359,189 0.48
908770 1,221,642 6.81 6 6,188,724 7,329,855 0.49
934940 1,227,040 6.89 6 6,437,062 7,362,241 0.50
986550 1,279,944 6.80 6 6,703,607 7,679,664 0.49
845280 1,008,360 6.91 6 5,844,266 6,050,159 0.43
899100 1,058,885 6.83 6 6,140,853 6,353,309 0.44
832220 895,924 6.88 6 5,724,009 5,375,543 0.37
876400 1,074,702 6.82 6 5,973,542 6,448,213 0.43
918950 982,708 6.83 6 6,274,591 5,896,245 0.45
757810 976,842 6.83 6 5,174,327 5,861,053 0.46
953860 1,514,405 6.83 6 6,512,956 9,086,432 0.63
10,621,870 13,307,487 6.83 6.00 72,566,136 79,844,922 0.46
6.2560
Budget
Cost/Ltr
#DIV/0!
-
-
-
-
-
-
-
-
-
-
-
-
Cream
Diesel 2020-2021
Genset 'units/ KL
Milk Handled Genset Units Sales Diesel Cons./Ltrs
Actual Budget Actual Budget Actual Budget Actual
Apr 13538433.4 15468251.91 10000 11425 0.74 0.74 2500
May 13195583.8 18247732.94 7820 10814 0.59 0.59 1955
Jun 12603960.2 17835017.5 1780 2519 0.14 0.14 445
Jul 12897514.6 17817938.98 4100 5664 0.32 0.32 1025
Aug 13756534.1 18786992.96 13044 17814 0.95 0.95 3261
Sep 13498141.8 16949829.85 2400 3014 0.18 0.18 600
Oct 13973358.1 17322792.73 6592 8172 0.47 0.47 1648
Nov 15425145.1 17479884.58 2440 2765 0.16 0.16 610
Dec 13853376.7 17882070.74 460 594 0.03 0.03 115
Jan 14085868 15855955.71 1472 1657 0.10 0.10 368
Feb 11296728 15328269.88 1472 1997 0.13 0.13 368
Mar 10270750.2 17164694.13 1472 2460 0.14 0.14 368
Total 158,395,394 206,139,432 53,052 68,895 0.33 0.33 13,263
Diesel 2021-2022
Genset 'units/ KL
Milk Handled Genset Units Sales Diesel Cons./Ltrs
Actual Budget Actual Budget Actual Budget Actual
Apr 12742832 1184 0 0.09 300
May 13000530 5976 0 0.46 1391
Jun 13514065.9 2072 0 0.15 55
Jul 13058615.6 768 0 0.06 60
Aug 12742832 1128 0 0.09 112.5
Sep 12239616 704 0 0.06 212.5
Oct 13073594 384 0 0.03 332.5
Nov 12087780 3760 0 0.31 332.5
Dec 15115640 5712 0 0.38 1451.25
Jan 16694100 2584 0 0.15 844
Feb 11826600 1500 0 0.13 325
Mar 12554684 656 0.05 48
Total 158,650,890 - 26,428 - 0.17 5,464
Diesel Cons./Ltrs Rate Diesel Ltr Cost Units Cons./Ltr Diesel Cost ' Rs. Diesel Cost /ltr' Rs.
Budget Actual Budget Actual Budget Actual Budget Actual Budget
2856 69.14 82.09 4.00 4.00 172850 234471 0.013 0.015
2704 69.14 82.09 4.00 4.00 135169 221923 0.010 0.012
630 73.33 82.09 4.00 4.00 32632 51689 0.003 0.003
1416 73.33 82.09 4.00 4.00 75163 116239 0.006 0.007
4453 80.91 82.09 4.00 4.00 263848 365573 0.019 0.019
753 80.05 82.09 4.00 4.00 48030 61847 0.004 0.004
2043 78.93 82.09 4.00 4.00 130077 167706 0.009 0.010
691 78.93 82.09 4.00 4.00 48147 56743 0.003 0.003
148 78.93 82.09 4.00 4.00 9077 12185 0.001 0.001
414 78.93 82.09 4.00 4.00 29046 34004 0.002 0.002
499 78.93 82.09 4.00 4.00 29046 40989 0.003 0.003
615 78.93 82.09 4.00 4.00 29046 50484 0.003 0.003
17,224 75.56 82.09 48.00 48.00 1,002,131 1,413,854 0.006 0.007
Diesel Cons./Ltrs Rate Diesel Ltr Cost Units Cons./Ltr Diesel Cost ' Rs. Diesel Cost /ltr' Rs.
Budget Actual Budget Actual Budget Actual Budget Actual Budget
0 78.93 3.95 23679 0 0.002
0 78.93 4.30 109792 0 0.008
0 96.51 37.67 5308 0 0.000
0 99.08 12.80 5945 0 0.000
0 98.91 10.03 11127 0 0.001
0 98.91 3.31 21018 0 0.002
0 98.91 1.15 32888 0 0.003
0 98.91 11.31 32888 0 0.003
0 98.91 3.94 143543 0 0.009
0 96.03 3.06 81049 0 0.005
96.03 4.62 31210 0 0.003
13.67 4609 0 0.000
92.06 8.74 - 503,056 - 0.003
Water With Man Power 2020-2021
Water
ETP consumed
Treated water /inRO
Ltr
Milk Handled
Raw water products water
Actual Budget Actual Budget Actual Budget
Apr 13538433.4 16018252.05 44,771,501 15468251.91 - -
May 13195583.8 18445882.69 50,766,056 18247732.94 - -
Jun 12603960.2 18442717.9 58,014,065 17835017.5 - -
Jul 12897514.6 19002439.04 48,902,190 17817938.98 - -
Aug 13756534.1 20133172.7 56,535,400 18786992.96 - -
Sep 13498141.8 18391329.86 45,121,000 16949829.85 - -
Oct 13973358.1 19066292.49 52,544,300 17322792.73 - -
Nov 15425145.1 18506384.5 52,369,500 17479884.58 -
Dec 13853376.7 18823070.53 59,719,000 17882070.74 -
Jan 14085868 16219955.89 62,901,100 15855955.71 - -
Feb 11296728 15390769.83 62,901,100 15328269.88 - -
Mar 10270750.2 17487694.24 62,901,100 17164694.13 - -
Total 158,395,394 215,927,962 657,446,312 206,139,432 - -
Boiler,Water,ETP,P
Electrical ump house DM Prepac
Apr 12742832 477950.1 576963.12 408536 0
May 13000530 253994.6 743238.88 713551 220549
Jun 13514065.9 308976.8 411687.21 394888 64985.21
Jul 13058615.6 232674.7 398945.75 720419 46072.08
Aug 12742832 260661.04 384230.6 153952 95808.11
Sep 12239616 270446.3 156857.38 52143 130776.11
Oct 13073594 156617.4 1697058 118778 121527.04
Nov 12087780 188246.6 317178.67 133656 130996.85
Dec 15115640 130838.3 252588.07 147106 527742.59
Jan 16694100 218174.5 187960 126208 217135.79
Feb 11826600 147172.5 483456.69 74053 86039.02
Mar 12554684 227376.4 463764 371432 37672.76
158650890 2873129 6073928 3414722 1679305
BMC
Total Milk Ltr Consumable Cost
Repairs Maintenance Cost
Months
Actual 2021-22 Budjet 2022-23 Actual 2021-22 Budjet 2022-23 Actual 2021-22
Apr 6828160.50 0 20295 0 29250
May 6756213.30 0 51696 0 1650
Jun 5643666.50 0 0 0 0
Jul 5062166.30 0 75020 0 35490
Aug 4296483.20 0 104884 0 0
Sep 4837086.30 0 0 14300
Oct 6186345.90 0 68689 0 18850
Nov 7521171.80 0 22625 0 7800
Dec 9204054.20 0 72414 0 27650
Jan 0.00 0 #DIV/0!
Feb 0.00 0 #DIV/0!
Mar 0.00 0 #DIV/0!
56335348 0 415623 #DIV/0! 134990
Spares cost Consum
Consumable Cost Spares Cost Total Maint. Cost Total Maint.Cost ' Rs. / Ltr
Budjet 2022-
Budjet 2022-23 Actual 2021-22 Budjet 2022-23 Actual 2021-22 23 Actual 2021-22
0 70313.75 119859 0 0.018
0 42730 96076 Err:522 0.014
0 63183 63183 Err:522 0.011
0 328230 438740 Err:522 0.087
0 16998.5 121883 Err:522 0.028
0 56880.4 71180 Err:522 0.015
0 155527.4 243066 Err:522 0.039
0 128776.74 159202 Err:522 0.021
0 153296.05 253360 Err:522 0.028
#DIV/0! 0 Err:522 #DIV/0!
#DIV/0! 0 Err:522 #DIV/0!
#DIV/0! 0 Err:522 #DIV/0!
#DIV/0! 550613 Err:522 #DIV/0!
Consumable Cost
Budjet 2022-
23
0.000
Err:522
Err:522
Err:522
Err:522
Err:522
Err:522
Err:522
Err:522
Err:522
Err:522
Err:522
Err:522 6017
R&M Man power &labour c
R&M&
Spares Consumables Labour
Apr 1600664.99 315770.21 1307309.59
May 2669883.28 350025.71 1066222.36
Jun 1622254.22 517866.29 1959401.66
Jul 1842953.12 468903.78 1507021.66
Aug 984296.39 524773.07 1318812.51
Sep 827243.01 667945.56 1010616.28
Oct 2271872.92 635655.45 2183427
Nov 1228242.62 405025.5 792332
Dec 1351845.2 960604.2 831470.18
Jan 1021709.63 435273.51 1642008
Feb 955195.27 612019.81 281753
Mar 1364087.16 734447.54 530431
17740247.81 6628310.63 14430805.24
Over All
2021-2022
1.03 1.03
1.09 0.06
1.21 0.13
1.18 -0.03
1.09 -0.09
1.29 0.20
1.34 0.05
0.83 -0.50
0.86 0.02
1.06 0.20
0.98 -0.07
1.06 0.08
1.08
MONTH STEAM POWER WATER DEISEL REPAIR &MAINTENANCE
2020-2021 2021-2022 2020-2021 2021-2022 2020-2021 2021-2022 2020-2021 2021-2022 2020-2021 2021-2022
April 0.16 0.24 0.39 0.51 0.02 0.026 0.013 0.002 0.253 0.25
May 0.20 0.21 0.48 0.52 0.03 0.026 0.010 0.008 0.314 0.31
June 0.18 0.37 0.49 0.51 0.03 0.024 0.003 0.000 0.303 0.30
July 0.19 0.28 0.50 0.54 0.03 0.061 0.006 0.000 0.292 0.29
Aug 0.20 0.25 0.49 0.55 0.02 0.063 0.019 0.001 0.222 0.22
Sep 0.18 0.27 0.43 0.75 0.02 0.065 0.004 0.002 0.205 0.20
Oct 0.19 0.27 0.44 0.61 0.02 0.063 0.009 0.003 0.389 0.39
Nov 0.22 0.24 0.37 0.33 0.02 0.063 0.003 0.003 0.201 0.20
Dec 0.39 0.20 0.43 0.38 0.02 0.053 0.001 0.009 0.314 0.22
Jan 0.40 0.48 0.45 0.34 0.02 0.047 0.002 0.005 0.303 0.19
Feb 0.36 0.29 0.46 0.48 0.03 0.052 0.003 0.003 0.292 0.16
Mar 0.39 0.25 0.63 0.51 0.03 0.050 0.003 0.000 0.222 0.25
0.25 0.28 0.46 0.50 0.03 0.05 0.01 0.00 0.28 0.25