Cost Sheet Format In Excel 33405 | Cost Estimates Simple

Partial file snippet.

Sheet 1: Assumptions

	
	
	
	
	
	
	
	
	
		

		Outputs Listing
		

		

		

		

		

		

	
	
		

		Output No.
		Description
		

		

		

		

		

	
	
		

		1
		High Voltage Substations
		

		

		

		

		

	
	
		

		2
		High Voltage Transmission Lines
		

		

		

		

		

	
	
		

		3
		Medium and Low Voltage Systems
		

		

		

		

		

	
	
		

		4
		Grid Stabilization
		

		

		

		

		

	
	
		

		5
		Project Management
		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Exchange Rate
		56.25
		Per USD
		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Base Cost Estimation Date
		9/30/2013
		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Inflation Rates
		2013
		2014
		2015
		2016
		2017
		2018
		2019
	
	
		International
		1.80%
		2.00%
		1.20%
		1.30%
		1.50%
		1.50%
		1.50%
	
	
		Domestic
		7.20%
		6.80%
		6.50%
		6.00%
		6.00%
		5.00%
		5.00%
	
	
		Source: ERD Website
		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Annual Exchange rate on PPP
		56.25
		58.9
		61.98
		64.86
		67.74
		70.08
		72.5
	
	
		

		

		

		

		

		

		

		

	
	
		Annual Price Contingency Factors
		

		

		

		

		

		

		

	
	
		

		2013
		2014
		2015
		2016
		2017
		2018
		2019
	
	
		Price Contingency  - FX Expenditure
		0.45%
		1.45%
		3.07%
		4.36%
		5.82%
		7.41%
		9.02%
	
	
		Price Contingency  - LC Expenditure
		1.80%
		5.26%
		12.26%
		19.26%
		26.42%
		33.35%
		40.02%
	
	
		

		

		

		

		

		

		

		

	
	
		Annual exchange rate adjustment factor
		0.0000%
		-0.0800%
		-0.1644%
		-0.2360%
		-0.3015%
		-0.3508%
		-0.3985%
	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Physical Contingency Matrix
		Rate
		

		

		

		

		

		

	
	
		001
		Land Acquisition
		5.00%
		

		

		

	
	
		002
		Environmental and Resettlement
		5.00%
		

		

		

	
	
		003
		HV Transmission Equipment
		10.00%
		

		

		

	
	
		004
		HV Transmission Erection
		10.00%
		

		

		

	
	
		005
		HV Substation Erection
		5.00%
		

		

		

	
	
		006
		HV Substation Equipment
		5.00%
		

		

		

	
	
		007
		ML Substation Equipment
		5.00%
		

		

		

	
	
		008
		ML Substation Erection
		

		

		5.00%
		

		

		

	
	
		009
		Grid Stabilization Equipment
		10.00%
		

		

		

	
	
		010
		Grid Stabilization Erection
		10.00%
		

		

		

	
	
		011
		Project Management
		5.00%
		

		

		

	
	
		012
		Consulting Services
		5.00%
		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Taxes on base cost of Works and Goods
		

		

		

		

		

		

		

	
	
		Excise Duty
		10.30%
		

		

		

		

		

		

	
	
		Central Sales Tax (Base+Excise)
		2.00%
		

		

		

		

		

		

	
	
		Total Taxes
		12.51%
		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Taxes on base cost of consulting services
		

		

		

		

		

		

		

	
	
		Service Tax
		10.20%
		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Associated Civil Works
		10.00%
		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Freight & Insurance (Base + Civil)
		5.00%
		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		The FX component in each package is to be updated in Column H of the Consolidated Investment Plan page
		

		

		

		

		

		

		

	



Sheet 2: Procurement Data

	
	
	
	
	
	
	
	
		Cat Code
		Package No.
		Package
		Ex-works Cost
		Associated Civil Works
		Excise Duty
		Sales Tax
		Service Tax
		Freight and Insurance
		Total Cost
	
	
		004
		HVTR1
		Towers Material 400 kV D/C Twin Moose Conductors
		 551.07 
		

		56.76
		12.16
		

		27.55
		 647.54 
	
	
		004
		HVTR2
		Towers Erection 400 kV D/C Twin Moose Conductors
		 180.19 
		

		

		

		

		

		 180.19 
	
	
		004
		HVTR3
		Towers Material 400 kV LILO Jaisalmer - Jodhpur-Merta
		 527.24 
		

		54.31
		11.63
		

		26.36
		 619.54 
	
	
		012
		C01
		Grid Stabilization Design and Implementation consultant
		 35.72 
		

		

		

		3.64
		

		 39.36 
	
	
		012
		C02
		Project Management Consultant
		 126.56 
		

		

		

		12.91
		

		 139.47 
	
	
		004
		HVTR4
		Towers Erection 400 kV LILO Jaisalmer - Jodhpur-Merta
		 199.24 
		

		

		

		

		

		 199.24 
	
	
		004
		HVTR5
		Towers Material 400 kV Twin D/C Ramgarh - Akal
		 320.09 
		

		32.97
		7.06
		

		16
		 376.12 
	
	
		004
		HVTR6
		Towers Erection 400 kV Twin D/C Ramgarh - Akal
		 151.84 
		

		

		

		

		

		 151.84 
	
	
		003
		HVTR7
		Conductor Package
		 1,742.40 
		

		

		

		

		

		 1,742.40 
	
	
		009
		GS1
		Static VAR Compensators
		 375.00 
		

		38.63
		8.27
		

		18.75
		 440.65 
	
	
		009
		GS2
		Communications Equipment
		 400.00 
		

		41.2
		8.82
		

		20
		 470.02 
	
	
		009
		GS3
		Software
		 500.00 
		

		51.5
		11.03
		

		25
		 587.53 
	
	
		009
		GS4
		Computers and Hardware
		 70.00 
		

		7.21
		1.54
		

		3.5
		 82.25 
	
	
		010
		GS5
		Civil works 
		 50.00 
		

		5.15
		1.1
		

		2.5
		 58.75 
	
	
		005
		HVSS1
		Akal Substation 400 kV
		 265.65 
		 26.57 
		27.36
		5.86
		

		14.61
		 340.05 
	
	
		005
		HVSS2
		Bhadla 400x220 2x315 MVA Substation
		 570.57 
		 57.06 
		58.77
		12.59
		

		31.38
		 730.37 
	
	
		005
		HVSS3
		Bikaner 400 kV Substation Augmentation
		 138.13 
		 13.81 
		14.23
		3.05
		

		7.6
		 176.82 
	
	
		006
		HVSS4
		Transformers
		 480.12 
		

		49.45
		10.59
		

		24.01
		 564.17 
	
	
		006
		HVSS5
		Shunt Reactors
		 404.52 
		

		41.67
		8.92
		

		20.23
		 475.34 
	
	
		007
		MLSS1
		Ramgarh 220/132 kV Substation
		 624.63 
		 62.46 
		

		

		

		34.35
		 721.44 
	
	
		007
		MLSS2
		Bhadla 220/132 kV Substation
		 740.03 
		 74.00 
		

		

		

		40.7
		 854.73 
	
	
		008
		MLSS3
		Ramgarh 220/132 kV, 132/33 kV Substation Equipment
		 306.62 
		 30.66 
		

		

		

		16.86
		 354.14 
	
	
		008
		MLSS4
		Kanasar 220/132 kV, 132/33 kV Substation Equipment
		 305.72 
		 30.57 
		

		

		

		16.81
		 353.10 
	
	
		007
		MLSS5
		Kanasar Extension of 1 220 kV feeder bay
		 5.90 
		 0.59 
		

		

		

		0.32
		 6.81 
	
	
		

		

		Total Procurements
		 9,071.24 
		 295.72 
		 479.21 
		 102.62 
		 16.55 
		 346.53 
		 10,311.87 
	



Sheet 3: Consolidated Investment Plan

	
	
	
	
	
	
	
	
		Cat Code
		Pkg No.
		Package
		Base Cost (incl. CW)
		Taxes
		F&I
		Total
		FX %
		FX Amt
		LC Amt
	
	
		001
		LROW
		Land Acquisition and Right of Way
		 35.45 
		

		

		 35.45 
		

		 -   
		 35.45 
	
	
		002
		RENV
		Resettlement and Environment
		 14.76 
		

		

		 14.76 
		

		 -   
		 14.76 
	
	
		003
		HVTR7
		Conductor Package
		 1,742.40 
		 -   
		 -   
		 1,742.40 
		

		 -   
		 1,742.40 
	
	
		004
		HVTR1
		Towers Material 400 kV D/C Twin Moose Conductors
		 551.07 
		 68.92 
		 27.55 
		 647.54 
		30.00%
		 194.26 
		 453.28 
	
	
		004
		HVTR2
		Towers Erection 400 kV D/C Twin Moose Conductors
		 180.19 
		 -   
		 -   
		 180.19 
		

		 -   
		 180.19 
	
	
		004
		HVTR3
		Towers Material 400 kV LILO Jaisalmer - Jodhpur-Merta
		 527.24 
		 65.94 
		 26.36 
		 619.54 
		30.00%
		 185.86 
		 433.68 
	
	
		004
		HVTR4
		Towers Erection 400 kV LILO Jaisalmer - Jodhpur-Merta
		 199.24 
		 -   
		 -   
		 199.24 
		

		 -   
		 199.24 
	
	
		004
		HVTR5
		Towers Material 400 kV Twin D/C Ramgarh - Akal
		 320.09 
		 40.03 
		 16.00 
		 376.12 
		30.00%
		 112.84 
		 263.28 
	
	
		004
		HVTR6
		Towers Erection 400 kV Twin D/C Ramgarh - Akal
		 151.84 
		 -   
		 -   
		 151.84 
		50.00%
		 75.92 
		 75.92 
	
	
		005
		HVSS1
		Akal Substation 400 kV
		 292.22 
		 33.22 
		 14.61 
		 340.05 
		

		 -   
		 340.05 
	
	
		005
		HVSS2
		Bhadla 400x220 2x315 MVA Substation
		 627.63 
		 71.36 
		 31.38 
		 730.37 
		25.00%
		 182.59 
		 547.78 
	
	
		005
		HVSS3
		Bikaner 400 kV Substation Augmentation
		 151.94 
		 17.28 
		 7.60 
		 176.82 
		25.00%
		 44.21 
		 132.62 
	
	
		006
		HVSS4
		Transformers
		 480.12 
		 60.04 
		 24.01 
		 564.17 
		80.00%
		 451.34 
		 112.83 
	
	
		006
		HVSS5
		Shunt Reactors
		 404.52 
		 50.59 
		 20.23 
		 475.34 
		80.00%
		 380.27 
		 95.07 
	
	
		007
		MLSS1
		Ramgarh 220/132 kV Substation
		 687.09 
		 -   
		 34.35 
		 721.44 
		

		 -   
		 721.44 
	
	
		007
		MLSS2
		Bhadla 220/132 kV Substation
		 814.03 
		 -   
		 40.70 
		 854.73 
		

		 -   
		 854.73 
	
	
		007
		MLSS5
		Kanasar Extension of 1 220 kV feeder bay
		 6.49 
		 -   
		 0.32 
		 6.81 
		

		 -   
		 6.81 
	
	
		008
		MLSS3
		Ramgarh 220/132 kV, 132/33 kV Substation Equipment
		 337.28 
		 -   
		 16.86 
		 354.14 
		

		 -   
		 354.14 
	
	
		008
		MLSS4
		Kanasar 220/132 kV, 132/33 kV Substation Equipment
		 336.29 
		 -   
		 16.81 
		 353.10 
		

		 -   
		 353.10 
	
	
		009
		GS1
		Static VAR Compensators
		 375.00 
		 46.90 
		 18.75 
		 440.65 
		100.00%
		 440.65 
		 -   
	
	
		009
		GS2
		Communications Equipment
		 400.00 
		 50.02 
		 20.00 
		 470.02 
		100.00%
		 470.02 
		 -   
	
	
		009
		GS3
		Software
		 500.00 
		 62.53 
		 25.00 
		 587.53 
		

		 587.53 
		 -   
	
	
		009
		GS4
		Computers and Hardware
		 70.00 
		 8.75 
		 3.50 
		 82.25 
		100.00%
		 82.25 
		 -   
	
	
		010
		GS5
		Civil works 
		 50.00 
		 6.25 
		 2.50 
		 58.75 
		100.00%
		 58.75 
		 -   
	
	
		011
		PM
		Project Management
		 687.53 
		

		

		 687.53 
		100.00%
		 687.53 
		 -   
	
	
		012
		C01
		Grid Stabilization Design and Implementation consultant
		 35.72 
		 3.64 
		 -   
		 39.36 
		40.00%
		 15.74 
		 23.62 
	
	
		012
		C02
		Project Management Consultant
		 126.56 
		 12.91 
		 -   
		 139.47 
		30.00%
		 41.84 
		 97.63 
	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		Grand Total
		 10,104.70 
		 598.38 
		 346.53 
		 11,049.61 
		

		 4,011.60 
		 7,038.02

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet assumptions outputs listing output no description high voltage substations transmission lines medium and low systems grid stabilization project management exchange rate per usd base cost estimation date inflation rates international domestic source erd website annual on ppp price contingency factors fx expenditure lc adjustment factor physical matrix land acquisition environmental resettlement hv equipment erection substation ml consulting services taxes of works goods excise duty central sales tax baseexcise total service associated civil freight amp insurance the component in each package is to be updated column h consolidated investment plan page procurement data cat code exworks hvtr towers material kv dc twin moose conductors lilo jaisalmer jodhpurmerta c design implementation consultant ramgarh akal conductor gs static var compensators communications software computers hardware hvss bhadla x mva bikaner augmentation transformers shunt reactors mlss kanasar extension feeder ...

Related files

Share

Help

	Outputs Listing
	Output No.	Description
	1	High Voltage Substations
	2	High Voltage Transmission Lines
	3	Medium and Low Voltage Systems
	4	Grid Stabilization
	5	Project Management

Exchange Rate	56.25	Per USD

Base Cost Estimation Date	9/30/2013

Inflation Rates	2013	2014	2015	2016	2017	2018	2019
International	1.80%	2.00%	1.20%	1.30%	1.50%	1.50%	1.50%
Domestic	7.20%	6.80%	6.50%	6.00%	6.00%	5.00%	5.00%
Source: ERD Website

Annual Exchange rate on PPP	56.25	58.9	61.98	64.86	67.74	70.08	72.5

Annual Price Contingency Factors
	2013	2014	2015	2016	2017	2018	2019
Price Contingency - FX Expenditure	0.45%	1.45%	3.07%	4.36%	5.82%	7.41%	9.02%
Price Contingency - LC Expenditure	1.80%	5.26%	12.26%	19.26%	26.42%	33.35%	40.02%

Annual exchange rate adjustment factor	0.0000%	-0.0800%	-0.1644%	-0.2360%	-0.3015%	-0.3508%	-0.3985%


Physical Contingency Matrix	Rate
001	Land Acquisition			5.00%
002	Environmental and Resettlement			5.00%
003	HV Transmission Equipment			10.00%
004	HV Transmission Erection			10.00%
005	HV Substation Erection			5.00%
006	HV Substation Equipment			5.00%
007	ML Substation Equipment			5.00%
008	ML Substation Erection			5.00%
009	Grid Stabilization Equipment			10.00%
010	Grid Stabilization Erection			10.00%
011	Project Management			5.00%
012	Consulting Services			5.00%

Taxes on base cost of Works and Goods
Excise Duty	10.30%
Central Sales Tax (Base+Excise)	2.00%
Total Taxes	12.51%

Taxes on base cost of consulting services
Service Tax	10.20%

Associated Civil Works	10.00%

Freight & Insurance (Base + Civil)	5.00%


The FX component in each package is to be updated in Column H of the Consolidated Investment Plan page

Cat Code	Package No.	Package	Ex-works Cost	Associated Civil Works	Excise Duty	Sales Tax	Service Tax	Freight and Insurance	Total Cost
004	HVTR1	Towers Material 400 kV D/C Twin Moose Conductors	551.07		56.76	12.16		27.55	647.54
004	HVTR2	Towers Erection 400 kV D/C Twin Moose Conductors	180.19						180.19
004	HVTR3	Towers Material 400 kV LILO Jaisalmer - Jodhpur-Merta	527.24		54.31	11.63		26.36	619.54
012	C01	Grid Stabilization Design and Implementation consultant	35.72				3.64		39.36
012	C02	Project Management Consultant	126.56				12.91		139.47
004	HVTR4	Towers Erection 400 kV LILO Jaisalmer - Jodhpur-Merta	199.24						199.24
004	HVTR5	Towers Material 400 kV Twin D/C Ramgarh - Akal	320.09		32.97	7.06		16	376.12
004	HVTR6	Towers Erection 400 kV Twin D/C Ramgarh - Akal	151.84						151.84
003	HVTR7	Conductor Package	1,742.40						1,742.40
009	GS1	Static VAR Compensators	375.00		38.63	8.27		18.75	440.65
009	GS2	Communications Equipment	400.00		41.2	8.82		20	470.02
009	GS3	Software	500.00		51.5	11.03		25	587.53
009	GS4	Computers and Hardware	70.00		7.21	1.54		3.5	82.25
010	GS5	Civil works	50.00		5.15	1.1		2.5	58.75
005	HVSS1	Akal Substation 400 kV	265.65	26.57	27.36	5.86		14.61	340.05
005	HVSS2	Bhadla 400x220 2x315 MVA Substation	570.57	57.06	58.77	12.59		31.38	730.37
005	HVSS3	Bikaner 400 kV Substation Augmentation	138.13	13.81	14.23	3.05		7.6	176.82
006	HVSS4	Transformers	480.12		49.45	10.59		24.01	564.17
006	HVSS5	Shunt Reactors	404.52		41.67	8.92		20.23	475.34
007	MLSS1	Ramgarh 220/132 kV Substation	624.63	62.46				34.35	721.44
007	MLSS2	Bhadla 220/132 kV Substation	740.03	74.00				40.7	854.73
008	MLSS3	Ramgarh 220/132 kV, 132/33 kV Substation Equipment	306.62	30.66				16.86	354.14
008	MLSS4	Kanasar 220/132 kV, 132/33 kV Substation Equipment	305.72	30.57				16.81	353.10
007	MLSS5	Kanasar Extension of 1 220 kV feeder bay	5.90	0.59				0.32	6.81
		Total Procurements	9,071.24	295.72	479.21	102.62	16.55	346.53	10,311.87

Cat Code	Pkg No.	Package	Base Cost (incl. CW)	Taxes	F&I	Total	FX %	FX Amt	LC Amt
001	LROW	Land Acquisition and Right of Way	35.45			35.45		-	35.45
002	RENV	Resettlement and Environment	14.76			14.76		-	14.76
003	HVTR7	Conductor Package	1,742.40	-	-	1,742.40		-	1,742.40
004	HVTR1	Towers Material 400 kV D/C Twin Moose Conductors	551.07	68.92	27.55	647.54	30.00%	194.26	453.28
004	HVTR2	Towers Erection 400 kV D/C Twin Moose Conductors	180.19	-	-	180.19		-	180.19
004	HVTR3	Towers Material 400 kV LILO Jaisalmer - Jodhpur-Merta	527.24	65.94	26.36	619.54	30.00%	185.86	433.68
004	HVTR4	Towers Erection 400 kV LILO Jaisalmer - Jodhpur-Merta	199.24	-	-	199.24		-	199.24
004	HVTR5	Towers Material 400 kV Twin D/C Ramgarh - Akal	320.09	40.03	16.00	376.12	30.00%	112.84	263.28
004	HVTR6	Towers Erection 400 kV Twin D/C Ramgarh - Akal	151.84	-	-	151.84	50.00%	75.92	75.92
005	HVSS1	Akal Substation 400 kV	292.22	33.22	14.61	340.05		-	340.05
005	HVSS2	Bhadla 400x220 2x315 MVA Substation	627.63	71.36	31.38	730.37	25.00%	182.59	547.78
005	HVSS3	Bikaner 400 kV Substation Augmentation	151.94	17.28	7.60	176.82	25.00%	44.21	132.62
006	HVSS4	Transformers	480.12	60.04	24.01	564.17	80.00%	451.34	112.83
006	HVSS5	Shunt Reactors	404.52	50.59	20.23	475.34	80.00%	380.27	95.07
007	MLSS1	Ramgarh 220/132 kV Substation	687.09	-	34.35	721.44		-	721.44
007	MLSS2	Bhadla 220/132 kV Substation	814.03	-	40.70	854.73		-	854.73
007	MLSS5	Kanasar Extension of 1 220 kV feeder bay	6.49	-	0.32	6.81		-	6.81
008	MLSS3	Ramgarh 220/132 kV, 132/33 kV Substation Equipment	337.28	-	16.86	354.14		-	354.14
008	MLSS4	Kanasar 220/132 kV, 132/33 kV Substation Equipment	336.29	-	16.81	353.10		-	353.10
009	GS1	Static VAR Compensators	375.00	46.90	18.75	440.65	100.00%	440.65	-
009	GS2	Communications Equipment	400.00	50.02	20.00	470.02	100.00%	470.02	-
009	GS3	Software	500.00	62.53	25.00	587.53		587.53	-
009	GS4	Computers and Hardware	70.00	8.75	3.50	82.25	100.00%	82.25	-
010	GS5	Civil works	50.00	6.25	2.50	58.75	100.00%	58.75	-
011	PM	Project Management	687.53			687.53	100.00%	687.53	-
012	C01	Grid Stabilization Design and Implementation consultant	35.72	3.64	-	39.36	40.00%	15.74	23.62
012	C02	Project Management Consultant	126.56	12.91	-	139.47	30.00%	41.84	97.63


		Grand Total	10,104.70	598.38	346.53	11,049.61		4,011.60	7,038.02

Related files

Share

Share to social media

Help

Login Area