Scribd
Upload
70 views71 pages

Diesel Production Cost Analysis

- The document appears to be production data from multiple dates listing amperage, voltage, fuel consumption, costs and production rates. - On 16/7/2018, 30kg of diesel was used at a cost of Rs. 3390 to produce 3900 units. The diesel cost per kg was Rs. 0.869. - On subsequent dates, production data is listed for varying amperage and voltage levels including units produced, run time, fuel use and associated costs. Production costs per kg are also calculated.

Uploaded by

zafar iqbal
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
70 views71 pages

Diesel Production Cost Analysis

- The document appears to be production data from multiple dates listing amperage, voltage, fuel consumption, costs and production rates. - On 16/7/2018, 30kg of diesel was used at a cost of Rs. 3390 to produce 3900 units. The diesel cost per kg was Rs. 0.869. - On subsequent dates, production data is listed for varying amperage and voltage levels including units produced, run time, fuel use and associated costs. Production costs per kg are also calculated.

Uploaded by

zafar iqbal
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/ 71

Date

Total Diesel Diesel Cost total Total production Diesel Cost/Kg


16/7/2018 30 3390 3900 0.8692307692
Line No. 1
Ampere Units Unit cost Diesel Cost Total Cost Production Cost/Kg Ampere
0 0 0 50
Line No. 2 Line No. 3
Units Hours Unit cost Diesel Cost Total Cost ProductionCost/Kg Ampere Units Unit cost
340 17 5100 3390.86923 8490.869 3901 2.176588 0 0
Line No. 3 Line No. 4
Diesel Cost Production Total Cost Cost/Kg Ampere Units Unit cost Diesel Cost Production
0 0 0 0
o. 4 Line No. 5
Total Cost Cost/Kg Ampere Units Unit cost Diesel Cost Production Total Cost Cost/Kg Ampere
0 0 0
Line No. 6 Line No. 7
Units Unit cost Diesel Cost ProductionTotal Cost Cost/Kg Ampere Units Unit cost Diesel Cost
0 0 0 0 0
Line No. 7 Line No. 8
Production Total Cost Cost/Kg Ampere Units Unit cost Diesel CostProductionTotal Cost Cost/Kg
0 0
Line No. 9 Line No. 1
Ampere Units Unit cost Diesel Cost Production Total Cost Cost/Kg Ampere Units Unit cost
0 0 0
Line No. 10 Line No. 11
Diesel CostProductionTotal Cost Cost/Kg Ampere Units Unit cost Diesel Cost Production Total Cost
0 0 0
Line No. 12
Cost/Kg Ampere Units Unit cost Diesel Cost Production Total Cost Cost/Kg Ampere Units
0 0
Line No. 13 Line No. 14
Unit cost Diesel Cost Production Total Cost Cost/Kg Ampere Units Unit cost Diesel Cost
0 0 0 0
Line No. 14
Production Total Cost Cost/Kg
Amp Volt CAT Ltr Cost Cost/Hr
Date
350 405 65 113 7345 Ampere Volt
400 400 70 113 7910 30/07/18
450 395 75 113 8475 31/07/2018
500 390 80 113 9040
550 385 85 113 9605
Line No. 1
Units Time(Hr) Production Unit cost Diesel Time Diesel Ltr Rate Diesel Diesel Cost Total Cost
0 0 0 0
Line No. 2
Cost/Kg Ampere Volt Units Time(Hr) ProductionUnit cost Diesel TimDiesel Ltr Rate Diesel
#DIV/0! 0 0
Line No. 3
Diesel CostTotal Cost Cost/Kg Ampere Volt Units Time(Hr) ProductionUnit cost Diesel Tim
0 0 #DIV/0! 0 0
Line No. 3 Lin
Diesel Ltr Rate DieselDiesel CostTotal Cost Cost/Kg Ampere Volt Units Time(Hr) Production
0 0 #DIV/0! 0
Line No. 4
Unit cost Diesel TimDiesel Ltr Rate DieselDiesel Cost Total Cost Cost/Kg Ampere Volt Units
0 0 0 0 0 0 #DIV/0! 23 390 215.28
20 390 187.2
0
20 390 140.4
0
0
0
0
0
0
0
0
Line No. 5
Time(Hr) ProductionUnit cost Diesel TimDiesel Ltr Rate DieselDiesel Cost Total Cost Cost/Kg Ampere
24 1869 3229.2 0 0 0 0 3229.2 1.727769 35
24 1746 2808 0 2808 1.608247 35
0 0 #DIV/0!
18 1869 2106 2106 1.126806 35
0 0 0
0 0
0
0
0
0
0
0
0
Line No. 6
Volt Units Time(Hr) ProductionUnit cost Diesel TimDiesel Ltr Rate DieselDiesel CostTotal Cost
390 327.6 24 1955 4914 0 0 0 0 4914
389 326.76 24 1944 4901.4 4901.4
0 0 0
390 327.6 24 1832 4914 4914
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0 0
Line No. 7
Cost/Kg Ampere Volt Units Time(Hr) ProductionUnit cost Diesel TimDiesel Ltr Rate Diesel
2.513555 0 0
2.521296
#DIV/0!
2.682314
#DIV/0!
#DIV/0!
Line No. 8
Diesel CostTotal Cost Cost/Kg Ampere Volt Units Time(Hr) ProductionUnit cost Diesel Tim
0 0 #DIV/0! 0 0
Line No. 8 L
Diesel Ltr Rate DieselDiesel CostTotal Cost Cost/Kg Ampere Volt Units Time(Hr) Production
0 #VALUE! 105 390 805.077 19.66 2692
105 387 975.24 24 2628
0
105 390 982.8 24 2482
0
0
0
0
0
0
0
Line No. 9
Unit cost Diesel TimDiesel Ltr Rate DieselDiesel Cost Total Cost Cost/Kg Ampere Volt Units
12076.16 0 0 0 0 12076.155 4.48594168 30 390 117
14628.6 14628.6 5.56643836
0 0 #DIV/0! 30 390 11.7
14742 14742 5.93956487 0
0 0 #DIV/0! 0
0 0 0
0 0
0 0
0 0
0 0
0
Line No. 10
Time(Hr) ProductionUnit cost Diesel Time Diesel Ltr Rate Diesel Diesel Cost Total Cost Cost/Kg
10 405 1755 0 1755 4.333333
0 0 #DIV/0!
6.5 96 175.5 175.5 1.828125
0 0 #DIV/0!
0 0 #DIV/0!
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
#VALUE!
Line No. 11
Ampere Volt Units Time(Hr) ProductionUnit cost Diesel Time Diesel Ltr Rate Diesel
0 0
Line No. 12
Diesel Cost Total Cost Cost/Kg Ampere Volt Units Time(Hr) ProductionUnit cost Diesel Tim
0 0 #DIV/0! 0 0
Line No. 12
Diesel Ltr Rate Diesel Diesel Cost Total Cost Cost/Kg
0 0
Over all load of line wa
Machine Load
MACHINE Ampere Volt UNIT/Hr UNIT/24HR
line#1 0 0 line#1
line#2 0 0 line#2
line#3 0 0 line#3
line#4 0 0 line#4
line#5 19 390 7.41 69.3576 line#5 19
line#6 35 389 13.615 127.10964 line#6 35
line#7 0 0 line#7
line#8 0 0 line#8
line#9 105 390 40.95 383.292 line#9 105
line#10 29 390 11.31 105.8616 line#10 29
line#11 0 0 line#11
line#12 0 0 line#12
line#13 22 389 8.558 79.897488 line#13 22
line#14 20 390 7.8 73.008 line#14 20
line#15 12 390 4.68 43.8048 line#15 12
line#16 0 0 line#16
line#17 15 390 5.85 54.756 line#17 15
line#18 0 0 line#18
Mixer 1 0 0 Mixer 1
Mixer 2 0 0 Mixer 2
Mixer 3 45 390 17.55 164.268 Mixer 3 45
Chiller P.E 45 390 17.55 164.268 Chiller P.E 45
Chiller Mould 5 389 1.945 18.15852 Chiller Mould 5
Cooling Tower 15 390 5.85 54.756 Cooling Tower
ZJOint 1 40 389 15.56 145.26816 ZJOint 1
Zjoint 2 20 390 7.8 73.008 Zjoint 2 20
Lab 30 390 11.7 109.512 Lab 30
Office 14 390 5.46 51.1056 Office 14
Residence 8 39 0.312 0.292032 Residence 8
BKM 5 390 1.95 18.252 BKM 5
Turbine 13 390 5.07 47.4552 Turbine 13
Submercible 0 0 Submercible
cursh 1 35 389 13.615 127.10964 cursh 1 35
cursh 2 0 0 cursh 2
mixer 4 0 0 mixer 4
comperssure1 25 390 9.75 91.26 comperssure1 25
comperssure2 0 0 comperssure2
comperssure 3 0 0 comperssure 3
fillter 0 0 0 0 fillter
worke shop 6 390 2.34 21.9024 worke shop 6
214.285 2023.70268 Light 12

520
wapda load
Shift A generat Shift B generato total Total Unit Unit
Volt Hours or Hours r wapda generator Shift A Shift A Total Unit

0 0
0 0
0 0
0 0
390 9 3 11 1 20 4 66.69 81.51 148.2
390 5 3 11 1 16 4 68.25 150.15 218.4
0 0 0 0 0
0 0 0 0 0
390 2 2 0 2 2 81.9 0 81.9
390 2 1 0 2 1 22.62 0 22.62
0 0 0 0 0
0 0 0 0 0
389 8 3 0 8 3 68.464 0 68.464
390 8 3 0 8 3 62.4 0 62.4
390 8 3 0 8 3 37.44 0 37.44
0 0 0 0 0 0
390 8 3 0 8 3 46.8 0 46.8
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
390 5 7 12 0 87.75 122.85 210.6
390 3 0 3 0 52.65 0 52.65
390 7 0 7 0 13.65 0 13.65
0 0 0 0 0
0 0 0 0 0
390 5 0 5 0 39 0 39
390 5 5 10 0 58.5 58.5 117
390 5 0 5 0 27.3 0 27.3
390 9 11 20 0 28.08 34.32 62.4
390 9 0 9 0 17.55 0 17.55
390 4 4 8 0 20.28 20.28 40.56
0 0 0 0 0
389 5 0 5 0 68.075 0 68.075
0 0 0 0 0
0 0 0 0 0
390 9 11 20 0 87.75 107.25 195
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
390 6 0 6 0 14.04 0 14.04
390 0 9 1 9 1 0 42.12 42.12

122 69 24 969.189 616.98 1586.169

Shift A Shift B
Generator Hours 6
Generator
wapda load
DATE machine load Volt time/ON time/OFF
line#1
line#2
line#3
line#4
line#5 22
line#6
line#7
line#8
line#9
line#10
line#11
line#12
line#13
line#14
line#15
line#16
line#17
line#18
Mixer 1
Mixer 2
Mixer 3
Chiller P.E
Chiller Mould
Cooling Tower
ZJOint 1
Zjoint 2
Lab
Office
Residence
BKM
Turbine
Submercible
cursh 1
cursh 2
mixer 4
comperssure1
comperssure2
comperssure 3
fillter
Total/hr Production

1800
wapda load
DATE machine load Volt time/ON time/OFF
line#1
line#2
line#3
line#4
line#5 22
line#6
line#7
line#8
line#9
line#10
line#11
line#12
line#13
line#14
line#15
line#16
line#17
line#18
Mixer 1
Mixer 2
Mixer 3
Chiller P.E
Chiller Mould
Cooling Tower
ZJOint 1
Zjoint 2
Lab
Office
Residence
BKM
Turbine
Submercible
cursh 1
cursh 2
mixer 4
comperssure1
comperssure2
comperssure 3
fillter
Total/hr Production

1800

You might also like