0% found this document useful (0 votes)
85 views24 pages

Opp Efficiency 2021-22

The document contains monthly data on coal and fuel oil usage, costs, and efficiency metrics for a dairy plant from 2020-2021 and 2021-2022. In 2020-2021, actual milk production was lower than budgeted each month while coal usage was also lower than budgeted most months. Power usage efficiency was higher than budgeted each month. In 2021-2022, while no budgeted figures are provided, coal usage and power efficiency were both higher than the previous year.

Uploaded by

Dasari Venkatesh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
85 views24 pages

Opp Efficiency 2021-22

The document contains monthly data on coal and fuel oil usage, costs, and efficiency metrics for a dairy plant from 2020-2021 and 2021-2022. In 2020-2021, actual milk production was lower than budgeted each month while coal usage was also lower than budgeted most months. Power usage efficiency was higher than budgeted each month. In 2021-2022, while no budgeted figures are provided, coal usage and power efficiency were both higher than the previous year.

Uploaded by

Dasari Venkatesh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 24

Coal and Furnace Oil 2020-2021

Total Milk Sales LPD Coal Kgs Coal ' Kg / KL Fuel rate

Actual Budget Actual Budget Actual Budget Actual Budget


Apr 13538433.4 15468252 322,600 350,155 23.83 22.64 6.80 6.00
May 13195583.8 18247733 388,196 509,982 29.42 27.95 6.80 6.00
Jun 12603960.2 17835018 326,055 438,310 25.87 24.58 6.80 6.00
Jul 12897514.6 17817939 363,252 476,742 28.16 26.76 6.80 6.00
Aug 13756534.1 18786993 400,533 519,649 29.12 27.66 6.80 6.00
Sep 13498141.8 16949830 357,327 426,266 26.47 25.15 6.80 6.80
Oct 13973358.1 17322793 389,254 458,431 27.86 26.46 6.80 6.80
Nov 15425145.1 17479885 413,390 445,034 26.80 25.46 6.80 6.80
Dec 13853376.7 17882071 557,277 683,372 40.23 38.22 6.80 6.80
Jan 14085868 15855956 595,034 636,318 42.24 40.13 6.80 6.80
Feb 11296728 15328270 595,034 767,019 52.67 50.04 6.80 6.80
Mar 10270750.2 17164694 595,034 944,712 57.93 55.04 6.80 6.80
Total 158,395,394 ### 5,302,986 ### 33.48 32.29

Coal and Furnace Oil 2021-2022

Total Milk Sales LPD Coal Kgs Coal ' Kg / KL Fuel rate

Actual Budget Actual Budget Actual Budget Actual Budget


Apr 12742832 382,279 - 30.00 28.50 6.80
May 13000530 410,626 - 31.59 30.01 6.80
Jun 13514065.9 470,859 - 34.84 33.10 6.80
Jul 13058615.6 427,113 - 32.71 31.07 6.80
Aug 12742832 467,786 - 36.71 34.87 6.80
Sep 12239616 486,292 - 39.73 37.74 6.80
Oct 13073594 526,627 - 40.28 38.27 6.80
Nov 12087780 421,780 - 34.89 33.15 6.80
Dec 15115640 435,464 - 28.81 27.37 6.80
Jan 16694100 668,600 - 40.05 38.05 6.80
Feb 11826600 418,300 - 35.37 33.60 6.80
Mar 12554684 462,450 - 36.83 34.99 6.80
Total 158,650,890 - 5,578,176 - 35.16 #DIV/0!

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

FURNACE OIL Fur. Oil QTY FURNACE OIL FURNACE OIL


QTY Actual BUDGET Budget VALUE Actual VALUE Budget COAL VALUE Actual Budget
6,660 439,560 2,599,497 3,039,057 -
- - 2,792,257 2,792,257 -
27,165 1,792,890 3,201,841 4,994,731 -
11,700 772,200 2,904,368 3,676,568 -
- - 3,180,945 3,180,945 -
- - 3,306,786 3,306,786 -
- - 3,581,064 3,581,064 -
- 2,868,104 2,868,104 -
- - 2,961,155 2,961,155 -
82,045 - 3,413,892 - 4,546,480 7,960,372 -
11,000 574,310 2,844,440 3,418,750 -
- - 3,144,660 3,144,660 -
- 6,992,852 37,931,597 44,924,449 -

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

Cost per Lit

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

Overall Actuals Budget Efficiency Actuals Budget


Month Milk Handled(Ltrs) Units/KL
Apr 13538433.4 15468251.91 1.00 57 54
May 13195583.8 18247732.94 1.00 71 67
Jun 12603960.2 17835017.5 1.00 72 68
Jul 12897514.6 17817938.98 1.00 72 69
Aug 13756534.1 18786992.96 1.00 72 68
Sep 13498141.8 16949829.85 1.00 63 59
Oct 13973358.1 17322792.73 1.00 64 61
Nov 15425145.1 17479884.58 1.00 54 51
Dec 13853376.7 17882070.74 1.00 63 60
Jan 14085868 15855955.71 1.00 65 62
Feb 11296728 15328269.88 1.00 67 64
Mar 10270750.2 17164694.13 1.00 93 88
Total 158,395,394 206,139,432 67 64

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

Actuals Budget Actuals Budget Actuals Budget Actuals


Units/Consumption Rate Value Cost/Ltr
953,860 - 6.79 6 6,474,930 - 0.51
1,060,200 - 6.42 6 6,807,855 - 0.52
1,011,920 - 6.88 6 6,958,580 - 0.51
1,019,900 - 6.97 6 7,112,781 - 0.54
1,024,300 - 6.88 6 7,049,551 - 0.55
1,119,700 - 8.20 6 9,180,374 - 0.75
975,900 - 8.18 6 7,983,796 - 0.61
984,900 - 6.60 6 4,000,340 - 0.33
829,600 - 6.84 6 5,672,958 - 0.38
904,100 - 6.31 6 5,702,966 - 0.34
911,600 - 6.26 6 5,702,964 - 0.48
992,200 - 6.42 6 6,374,434 - 0.51
11,788,180 - 6.70 #DIV/0! 79,021,529 - 0.50
Budget
Cost/Ltr
0.33
0.40
0.41
0.41
0.41
0.36
0.37
0.31
0.36
0.37
0.38
0.53
0.39

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 - -

Water With Man Power 2021-2022


Water consumed
Milk Handled in Ltr ETP Treated water / RO
Raw water products water
Actual Budget Actual Budget Actual Budget
Apr 12742832 54,000,000 - -
May 13000530 51,000,000 - -
Jun 13514065.9 57,000,000 - -
Jul 13058615.6 54,000,000 - -
Aug 12742832 57,000,000 - -
Sep 12239616 54,000,000 - -
Oct 13073594 54,000,000 - -
Nov 12087780 54,000,000 -
Dec 15115640 58,900,000 -
Jan 16694100 62,000,000 - -
Feb 11826600 56,000,000 - -
Mar 12554684 62,000,000 - -
Total 158,650,890 - 673,900,000 - - -
med in Ltr Milk to water Water Cost Cost /Ltr Cost /Ltr
Total water Ratio
Actual Budget Actual Budget Actual Budget Actual Budget
44,771,501 15,468,252 3.31 3.14 162294 192,219 0.012 0.012
50,766,056 18,247,733 3.85 3.65 167993 221,351 0.013 0.012
58,014,065 17,835,018 4.60 4.37 158541 221,313 0.013 0.012
48,902,190 17,817,939 3.79 3.60 164080 228,029 0.013 0.013
56,535,400 18,786,993 4.11 3.90 168972 241,598 0.012 0.013
45,121,000 16,949,830 3.34 3.18 167190 220,696 0.012 0.013
52,544,300 17,322,793 3.76 3.57 168367 228,796 0.012 0.013
52,369,500 17,479,885 3.40 3.23 161638 222,077 0.010 0.013
59,719,000 17,882,071 4.31 4.10 167595 225,877 0.012 0.013
62,901,100 15,855,956 4.47 4.24 164925 194,639 0.012 0.012
62,901,100 15,328,270 5.57 5.29 165,159 184,689 0.015 0.012
62,901,100 17,164,694 6.12 5.82 165,159 209,852 0.016 0.012
657,446,312 206,139,432 4.15 0.95 1981913 2591136 0.013 0.013

Milk to water Water Cost Cost /Ltr


Total water Ratio
Actual Budget Actual Budget Actual Budget Actual Budget
54,000,000 - 4.24 162294 - 0.013 #DIV/0!
51,000,000 - 3.92 167993 - 0.013 #DIV/0!
57,000,000 - 4.22 158541 - 0.012 #DIV/0!
54,000,000 - 4.14 164080 - 0.013 #DIV/0!
57,000,000 - 4.47 168972 - 0.013 #DIV/0!
54,000,000 - 4.41 167190 - 0.014 #DIV/0!
54,000,000 - 4.13 168367 - 0.013 #DIV/0!
54,000,000 - 4.47 161638 - 0.013 #DIV/0!
58,900,000 - 3.90 171899 - 0.011 #DIV/0!
62,000,000 - 3.71 171899 - 0.010 #DIV/0!
56,000,000 - 4.74 170277 - 0.014 #DIV/0!
62,000,000 - 4.94 169506 - 0.014 #DIV/0!
673,900,000 - 4.25 0.00 2002656 0 0.013 #DIV/0!
Including ETP Water Cost Including ETP Water Cost
Cost /Ltr Cost /Ltr
Actual Budget Actual Budget
331832 520,365 0.025 0.032 169538
337531 568,918 0.026 0.031 169538
328079 568,854 0.026 0.031 169538
333618 580,049 0.026 0.031 169538
338510 602,663 0.025 0.030 169538
336728 567,827 0.025 0.031 169538
337905 581,326 0.024 0.030 169538
331176 570,128 0.021 0.031 169538
337133 576,461 0.024 0.031 169538
334463 524,399 0.024 0.032 169538
334697 507,815 0.030 0.033 169538
334697 549,754 0.033 0.031 169538
4016369 6718559 0.026 0.031 169538

Including ETP Water Cost


Including ETP Water Cost
Cost /Ltr Cost /Ltr
Actual Budget Actual Budget
331832 0.026 #DIV/0! 169538
337531 0.026 #DIV/0! 169538
328079 0.024 #DIV/0! 169538
794518 0.061 #DIV/0! 169538
807050 0.063 #DIV/0! 169538
792708 0.065 #DIV/0! 169538
819915 0.063 #DIV/0! 169538
760796 0.063 #DIV/0! 169538
801437 0.053 #DIV/0! 169538
791437 0.047 #DIV/0! 169538
615577 0.052 #DIV/0! 169538
631306 0.050 #DIV/0! 169538
7812186 0 0.049 0.031
Months Total Milk Sales Ltr Spares cost

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

Processing & Boiler,Water,ETP,Pu


Refrigeration APS Powder Garage Electrical mp house
67736.77 30294 39185 661.5 120285.75
398144.8 10333 304471 25601 441 59680.15
195607 73683 129334 43093 5308.05 121023.03
60943 95773.59 264897 23228 220.5 125019.45
24364 9951.64 23605 31724 4254 126920.6
6903 24178.36 150067.86 35871 0 106204
15931 19400.48 136561 6000 882 107588.5
100215 37939.5 262419 57591 882 43633
14575 5976.24 231888 41131 441 607597.2
104871 1982.34 48233 117145 2700 30000
46164 4696.06 73599 40015 90 90827.2
19924 8749 208290 26879 1982.4 39657
1055379 322957 1833365 487463 17862 1578436

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

Processing & Boiler,Water,ETP,P


DM Prepac Refrigeration APS Powder Garage Electrical ump house
10114 0 42185 0 0 142523.96 82926.2 640453.31
15171 0 154826.4 0 1680 118227.16 184372 599682.36
0 126797.85 106438 0 5070 153229.36 21750 1255707.66
28522 71330.85 106438 0 4505 132867.98 33338 805174.66
10490 108430.75 100713 0 840 173124.72 50104.43 668420.8
68475 240921.4 68074 0 850 183421.16 59380 607308
10490 238679.35 99226 0 13310 165479.6 98796 1194894
0 142544.5 42834 0 850 174282 88819 409690
40214 0 40079 0 22760 249513 87490 536289.18
146060 0 102233 0 23750 130530.51 104834 687408
167109 73386.4 98237 0 6970 175400.21 26200 123075
212451 158570.45 140873 0 1700 179213.69 26200 65696
709096 1160662 1102156 0 82285 1977813 864210 7593799

Maint.Cost ' Rs. / Ltr

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

Processing & Boiler,Water,ETP,P


DM Prepac Refrigeration APS Powder Garage Electrical ump house DM
211379 0 332446.08 0 0 40105 0 0 0
32307 11037 212433 0 1842 24549 0 0 0
321271 0 329333 0 3620 27720 0 0 0
99974 5400 278031 0 267776 17328 0 0 0
81986 0 447709.28 0 51260 19332 0 0 0
71839 2575 215888.28 0 14069 39557 0 0 0
452582 700 263401 0 25396 147658 0 0 0
77348 0 183845 0 10795 21835 0 0 0
44210 0 79598 0 54886 28997 0 0 0
693840 0 79598 0 53233 23095 0 0 0
74466 33750 0 0 8619 15643 0 421490 0
303942 7430 0 0 78977 48186 0 408593 0
2465144 60892 2422283 0 570473 454005
Man power &labour cost Capital Cost

Refriger Processing & Garage Boiler,Water,ETP,Pu


Prepac ation APS Powder toll gate Electrical mp house DM Prepac
0 0 0 0 0 0 320713.64 465313 0
0 0 0 0 0 79961.05 278870.58 2203023 0
0 0 0 0 0 0 0 99000 0
0 0 0 0 0 0 0 47000 0
0 0 0 0 0 366623 0 1014800 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 85596.2 0 0 360906.39
0 0 0 0 0 401006.7 0 58988 273541.35
0 0 0 0 0 322016 0 178968 0
0 0 0 0 0 346015 0 0 0
0 81806 0 0 9395 133254 986229 0 0
0 81806 0 0 9015 44011.5 0 0 0
1778483 1585813 4067092 634448
Capital Cost Total cost without capital

Processing & Boiler,Water,ETP,P


Refrigeration APS Powder Garage Electrical ump house DM Prepac
0 0 0 0 561537.8 1337702.18 630029 0
0 0 8597149 0 438807.6 1402601.39 761029 231586
0 0 0 0 336034.85 1788417.9 716159 191783.06
738646 0 0 0 266233.2 1329139.86 848915 122802.93
0 0 0 0 315019.47 1179572 246428 204238.86
0 0 0 0 329826.3 870369.38 192457 374272.51
0 0 0 0 256295.4 2999540.5 581850 360906.39
0 0 0 0 277947.6 770501.67 211004 273541.35
610465 0 135438 0 218769.3 1396474.45 231530 527742.59
7588 0 0 0 325708.5 905368 966108 217135.79
0 0 112100 0 173462.5 697358.89 315628 193175.42
1499867 0 0 0 255558.8 977710 887825 203673.21
2856566 0 8844687 0 3755201 15654756 6588962 2900858
Total cost without capital Total co

Processing & Boiler,Water,ETP,P


Refrigeration APS Powder Garage Grand Total Electrical ump house DM
442367.85 30294 0 221813.96 3223744.79 561537.8 1658415.82 1095342
765404.2 10333 307993 168377.16 4086131.35 518768.65 1681471.97 2964052
631378 73683 138024 224042.36 4099522.17 336034.85 1788417.9 815159
445412 95773.59 537178 173423.98 3818878.56 266233.2 1329139.86 895915
572786.28 9951.64 75705 224180.72 2827881.97 681642.47 1179572 1261228
290865.28 24178.36 164986.86 258849.16 2505804.85 329826.3 870369.38 192457
378558 19400.48 175267 319137.6 5090955.37 341891.6 2999540.5 581850
326894 37939.5 274064 253708 2425600.12 678954.3 770501.67 269992
134252 231888 309534 319641 3369831.34 540785.3 1396474.45 410498
286702 1982.34 125216 270770.51 3098991.14 671723.5 905368 966108
144401 4696.06 89188 231058.21 1848968.08 306716.5 1683587.89 315628
242603 8749 288967 254278.69 3119364.7 299570.3 569117 887825
4661624 548869 2486123 2919281 39515674 5533685 16831976 10656054
Total cost with capital

Processing & Cost/Ltr Cost/Ltr


Prepac Refrigeration APS Powder Garage Grand Total without capital with capital
0 442367.85 30294 0 221813.96 4009771.43 0.25 0.31
231586 765404.2 10333 8905142 168377.16 15245134.98 0.31 1.17
191783.06 631378 73683 138024 224042.36 4198522.17 0.30 0.31
122802.93 1184058 95773.59 537178 173423.98 4604524.56 0.29 0.35
204238.86 572786.28 9951.64 75705 224180.72 4209304.97 0.22 0.33
374272.51 290865.28 24178.36 164986.86 258849.16 2505804.85 0.20 0.20
721812.78 378558 19400.48 175267 319137.6 5537457.96 0.39 0.42
547082.7 326894 37939.5 274064 253708 3159136.17 0.20 0.26
527742.59 744717 231888 444972 319641 4616718.34 0.22 0.31
217135.79 294290 1982.34 125216 270770.51 3452594.14 0.19 0.21
193175.42 144401 4696.06 201288 231058.21 3080551.08 0.16 0.26
203673.21 1660664 8749 288967 254278.69 4172844.2 0.25 0.33
3535306 7436384 548869 11330810 2919281 58792365 0.249 0.373
Months Total

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

408891.89 122427.73 248678


Amount spent
Steam Power Water Diesel R&M
2021-2022 2021-2022 2021-2022 2021-2022 2021-2022
April 3039057.20 6474930.00 331832.00 23679.00 3223744.79
May 2792256.80 6807855.00 337531.00 109791.63 4086131.35
June 4994731.20 6958580.00 328079.00 5308.05 4099522.17
July 3676568.40 7112781.00 794518.00 5944.80 3818878.56
Aug 3180944.80 7049551.00 807050.00 11127.38 2827881.97
Sep 3306785.60 9180374.00 792708.00 21018.38 2505804.85
Oct 3581063.60 7983796.00 819915.00 32887.58 5090955.37
Nov 2868104.00 4000340.00 760796.00 32887.58 2425600.12
Dec 2961155.20 5672958.00 801437.00 143543.14 3369831.34
Jan 7960372.45 5702966.03 791437.00 81049.32 3098991.14
Feb 3418750.00 5702964.00 615577.00 31209.75 1848968.08
Mar 3144660.00 6374434.00 631306.00 4609.44 3119364.70
Total 44924449.25 79021529.03 7812186.00 503056.03 3292972.87
Cost per Ltr
Steam Power Water Diesel R&M
2021-2022 2021-2022 2021-2022 2021-2022 2021-2022
April 0.24 0.51 0.026 0.002 0.25
May 0.21 0.52 0.026 0.008 0.31
June 0.37 0.51 0.024 0.000 0.30
July 0.28 0.54 0.061 0.000 0.29
Aug 0.25 0.55 0.063 0.001 0.22
Sep 0.27 0.75 0.065 0.002 0.20
Oct 0.27 0.61 0.063 0.003 0.39
Nov 0.24 0.33 0.063 0.003 0.20
Dec 0.20 0.38 0.053 0.009 0.22
Jan 0.48 0.34 0.047 0.005 0.19
Feb 0.29 0.48 0.052 0.003 0.16
Mar 0.25 0.51 0.050 0.000 0.25

Average 0.28 0.50 0.05 0.00 0.25


Total
2021-2022
13093242.99
14133565.78
16386220.42
15408690.76
13876555.15
15806690.83
17508617.55
10087727.70
12948924.68
17634815.94
11617468.83
13274374.14
135554193.18

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

A In 20 -21 cost per Ltr 1.03

B In 21 -22 cost per Ltr 1.08

You might also like