Scribd
Upload
85 views14 pages

Column1 Column2 Column3 Column4 Column5 Column6 Kelectric Vs Genset

The document compares the total monthly cost of using K-Electric power versus operating diesel generator sets. It shows that using generator sets for a 1250KVA, 1400KVA and 810KVA genset would cost PKR 928,200 per month, while using K-Electric would cost PKR 2,666,820 per month, resulting in potential savings of over PKR 1.7 million per month. Daily diesel consumption and costs are also shown for each genset over a month period.

Uploaded by

Ahmed Raza
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
85 views14 pages

Column1 Column2 Column3 Column4 Column5 Column6 Kelectric Vs Genset

The document compares the total monthly cost of using K-Electric power versus operating diesel generator sets. It shows that using generator sets for a 1250KVA, 1400KVA and 810KVA genset would cost PKR 928,200 per month, while using K-Electric would cost PKR 2,666,820 per month, resulting in potential savings of over PKR 1.7 million per month. Daily diesel consumption and costs are also shown for each genset over a month period.

Uploaded by

Ahmed Raza
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/ 14

Column1 Column2 Column3 Column4 Column5 Column6

KElectric VS GENSET
K-Electric GENSET

Total Cost
On-peak hours Per Unit Cost On Peak Units Monthly (Avg)
(Avg) (Month) with taxes (Rs) (Avg) (Rs) Gensets 1400 KVA

Per Hour
Consumption
80 PKR 20.51 130,000.00 PKR 2,666,820.00 (Litre) 180

Diesel
PKR 33,335.25 Consumption
Diesel Cost Per
PKR 86,671.65 Litre (Rs) 85

Operational
Hours For Each
(Daily)
Cost For Each
(Daily) 0
Column7 Column8 Column9 Column10 Column12 Column13

Cost Per Month


1250 KVA 810 KVA 635 KVA Dates Cost Per Day (Rs) (Rs)

130 100 80 6/1/2020 PKR 35,700.00 PKR 928,200.00

350 6/2/2020 PKR 29,750.00

6/3/2020

6/4/2020

29750 0 0 6/5/2020
6/6/2020
6/7/2020
6/8/2020
6/9/2020
6/10/2020
6/11/2020
6/12/2020
6/13/2020
6/14/2020
6/15/2020
6/16/2020
6/17/2020
6/18/2020
6/19/2020
6/20/2020
6/21/2020
6/22/2020
6/23/2020
6/24/2020
6/25/2020
6/26/2020
6/27/2020
6/28/2020
6/29/2020
6/30/2020
Column14 Column15

Saving

Saving per
Month (Rs)

PKR 1,738,620.00 PKR 20,863,440.00


Daily Genset Diesel Consumption
1250 KVA GENSET 1400 KVA GENSET 810 KVA GENSET
Daily Diesel Daily Diesel Daily Diesel
Consumption
Date Consumption Daily Cost Consumption Daily Cost Consumption
per Hour
(Litres) (Litres) (Litres)
6/1/2020 420 PKR 35,700.00 120.00 0 PKR 0.00
6/2/2020 350 PKR 29,750.00 116.67 PKR 0.00
6/3/2020 385 PKR 32,725.00 128.33 PKR 0.00
6/4/2020 350 PKR 29,750.00 116.67 PKR 0.00
6/5/2020 385 PKR 32,725.00 128.33 520 PKR 44,200.00 250
6/6/2020 385 PKR 32,725.00 128.33 PKR 0.00
6/7/2020 PKR 0.00 - PKR 0.00
6/8/2020 385 PKR 32,725.00 128.33 PKR 0.00
6/9/2020 420 PKR 35,700.00 PKR 140.00 PKR 0.00
6/10/2020 385 PKR 32,725.00 PKR 128.33 PKR 0.00
6/11/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/12/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/13/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/14/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/15/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/16/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/17/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/18/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/19/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/20/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/21/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/22/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/23/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/24/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/25/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/26/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/27/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/28/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/29/2020 PKR 0.00 PKR 0.00 PKR 0.00
6/30/2020 PKR 0.00 PKR 0.00 PKR 0.00
Consumption
810 KVA GENSET 635 KVA GENSET Total
Daily Diesel
Monthly Total
Daily Cost Consumption Daily Cost Daily Total Cost
Cost
(Litres)
PKR 0.00 PKR 0.00 PKR 35,700.00 PKR 379,100.00
PKR 0.00 PKR 0.00 PKR 29,750.00 PKR 32,229.17
PKR 0.00 PKR 0.00 PKR 32,725.00 PKR 10,743.06
PKR 0.00 PKR 0.00 PKR 29,750.00 116.666666667
PKR 21,250.00 225 PKR 19,125.00 PKR 117,300.00 120
PKR 0.00 PKR 0.00 PKR 32,725.00 173.333333333
PKR 0.00 PKR 0.00 PKR 0.00 83.3333333333
PKR 0.00 PKR 0.00 PKR 32,725.00 333.67
PKR 0.00 PKR 0.00 PKR 35,700.00 1250 125
PKR 0.00 PKR 0.00 PKR 32,725.00 1400 180
PKR 0.00 PKR 0.00 PKR 0.00 810 90
PKR 0.00 PKR 0.00 PKR 0.00 2240
PKR 0.00 PKR 0.00 PKR 0.00 1500 200
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00 131.666666667
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
PKR 0.00 PKR 0.00 PKR 0.00
Per Day Per Month Per Year Jan
GENSET PKR 26,000.00 PKR 2,464,800.00 PKR 29,577,600.00 GENSET PKR 2,133,000.00
KE PKR 33,333.00 PKR 2,666,820.0 PKR 32,001,840.0 KE PKR 1,830,046.00
1400
1250
810
635
daily monthly 1500
281.25 8437.5 26745.833333333 2139666.66666667 0.2 173.33333333333 41600
405 12150
202.5 6075
75 83.3333333333
KVA KW Total
1190 2252.5 980 833 1320
1062.5 875 743.75
567 481.95
444.5 377.825
1125 956.25
K-Electric GENSET

K-Electric
Hours in Amount Per K-Electric Amount
KW Month KWh / Unit per Month 1400 1250
January 1318.32 67.68 20.51 PKR 1,830,046.00 PKR 974,592.00 PKR 676,800.00
February 1215.82 92.78 20.51 PKR 2,313,590.00 PKR 1,336,032.00 PKR 927,800.00
March 1371.66 84.55 20.51 PKR 2,377,601.00 PKR 1,217,520.00 PKR 845,500.00
April 1552.73 84.84 20.51 PKR 2,701,741.00 PKR 1,221,696.00 PKR 848,400.00
May 1534.94 77.63 20.51 PKR 2,443,870.00 PKR 1,117,872.00 PKR 776,300.00
June
July
August
September
October
November
December
GENSET Saving

Genset Amount
810 635 per Month
PKR 1,651,392.00 PKR 178,654.00
PKR 2,263,832.00 PKR 49,758.00
PKR 2,063,020.00 PKR 314,581.00
PKR 610,848.00 PKR 2,680,944.00 PKR 20,797.00
PKR 558,936.00 PKR 2,453,108.00 -PKR 9,238.00
K-Electric

K-Electric
Amount
Per
Hours in KWh / K-Electric Amount
KW Month KWH / Unit Unit per Month 1500
20-Jan 1318.32 67.68 89,223.90 20.51 PKR 1,830,046.00 PKR 1,082,880.00
20-Feb 1215.82 92.78 112,803.78 20.51 PKR 2,313,590.00 PKR 1,484,480.00
20-Mar 1371.66 84.55 115,973.85 20.51 PKR 2,377,601.00 PKR 1,352,800.00
20-Apr 1552.73 84.84 131,733.61 20.51 PKR 2,701,741.00 PKR 1,357,440.00
20-May 1534.94 77.63 119,157.39 20.51 PKR 2,443,870.00 PKR 1,242,080.00
19-Jul 1867.12 53.32 99,554.84 20.51 PKR 2,041,869.74 PKR 853,120.00
19-Aug 1534.07 70.116 107,562.85 20.51 PKR 2,206,114.10 PKR 1,121,856.00
19-Sep 1666 68.303 113,792.80 20.51 PKR 2,333,890.29 PKR 1,092,848.00
19-Oct 1729.98 74.736 129,291.79 20.51 PKR 2,651,774.52 PKR 1,195,776.00
19-Nov 1603.4 78.385 125,682.51 20.51 PKR 2,577,758.00 PKR 1,254,160.00

GENSET DATA

Diesel
Consump
tion / 70 %
Gensets Hour Capacity
(KVA) (Litres) (KVA) KW Capacity
1500 200 1050 892.5

1400 180 980 833

1250 130 875 743.75


810 80 567 481.95
635 75 444.5 377.825
GENSET

Genset Amount
1400 1250 810 635 per Month Genset Per Unit Cost
PKR 676,800.00 PKR 1,759,680.00 PKR 19.72
PKR 927,800.00 PKR 2,412,280.00 PKR 21.38
PKR 845,500.00 PKR 2,198,300.00 PKR 18.96
PKR 848,400.00 PKR 2,205,840.00 PKR 16.74
PKR 776,300.00 PKR 2,018,380.00 PKR 16.94
PKR 533,200.00 PKR 1,386,320.00 PKR 13.93
PKR 701,160.00 PKR 1,823,016.00 PKR 16.95
PKR 683,030.00 PKR 1,775,878.00 PKR 15.61
PKR 747,360.00 PKR 1,943,136.00 PKR 15.03
PKR 783,850.00 PKR 2,038,010.00 PKR 16.22
Saving
Maintenance

Yearly Saving
Genset 1500 KVA

Major Overhauling
of 810KVA
(Mandatory)
Remaining Cost
(Additional)
Saving

PKR 70,366.00
-PKR 98,690.00
PKR 179,301.00
PKR 495,901.00
PKR 425,490.00
PKR 655,549.74
PKR 383,098.10
PKR 558,012.29
PKR 708,638.52
PKR 539,748.00
PKR 3,917,414.64 GBP 21,763.41
PKR 1,200,000.00 GBP 6,666.67

PKR 2,717,414.64 GBP 15,096.75


PKR 18,500,000.00 GBP 102,777.78 6.807941547594

PKR 12,000,000.00 GBP 66,666.67

PKR 6,500,000.00 GBP 36,111.11


K-Electric

K-Electric
Amount
Per
Hours in KWh / K-Electric Amount
KW Month Unit per Month Per hour Per Month 2000
January 1318.32 67.68 20.51 PKR 1,830,046.00 27038.74 1811595.7944 PKR 1,624,320.00
February 1215.82 92.78 20.51 PKR 2,313,590.00 PKR 2,226,720.00
March 1371.66 84.55 20.51 PKR 2,377,601.00 PKR 2,029,200.00
April 1552.73 84.84 20.51 PKR 2,701,741.00 PKR 2,036,160.00
May 1534.94 77.63 20.51 PKR 2,443,870.00 PKR 1,863,120.00
July 1867.12 53.32 20.51 PKR 2,041,869.74 PKR 1,279,680.00
August 1534.07 70.116 20.51 PKR 2,206,114.10 PKR 1,682,784.00
September 1666 68.303 20.51 PKR 2,333,890.29 PKR 1,639,272.00
October 1729.98 74.736 20.51 PKR 2,651,774.52 PKR 1,793,664.00
November 1603.4 78.385 20.51 PKR 2,577,748.26 PKR 1,881,240.00

units 4
3.8
4.94
24.7
321.1
2889.9
57798
PKR 693,576.00
1.656
21.528
193.752
PKR 3,875.04
PKR 697,451.04
GBP 3,874.73
GENSET Saving

Genset Amount
1400 1250 810 635 per Month
PKR 1,624,320.00 PKR 205,726.00
PKR 2,226,720.00 PKR 86,870.00
PKR 2,029,200.00 PKR 348,401.00
PKR 2,036,160.00 PKR 665,581.00
PKR 1,863,120.00 PKR 580,750.00
PKR 1,279,680.00 PKR 762,189.74
PKR 1,682,784.00 PKR 523,330.10
PKR 1,639,272.00 PKR 694,618.29
PKR 1,793,664.00 PKR 858,110.52
PKR 1,881,240.00 PKR 696,508.26
Total PKR 7,865,954.90
Maintenance PKR 1,500,000.00
Saving PKR 6,365,954.90
GBP 35,366.42

You might also like