تحليل تكاليف-مشروع إنشاء محطة خلط خرسانة.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1		https://pmo-eng.blogspot.com/
2												Date:
3
4	Feasibility study for concrete batching plant 120 m3 / hour
5
6	Proposal (Sales inside the projects + 1000 m3 / month outside the project)
7	Prepared by : https://pmo-eng.blogspot.com/
8
9		The study based on:
10
11			Year	Time (Years)									Total
12			Year	Y2016	Y2017	Y2018	Y2019	Y2020	Y2021	Y2022	Y2023	Y2024	Total
13		Concrete amount, Project 1	Quantity		45,543	49,830	52,509	33,220	33,220	0	0	0	214,322
14		Concrete amount, Project 2	Quantity		13,026	143,281	182,357	156,306	156,306	0	0	0	651,276
15		Concrete amount, out side the project	Quantity		12,000	24,000	24,000	24,000	24,000	0	0	0	108,000
16		Total			70,569	217,111	258,866	213,526	213,526	0	0	0	973,598
17
18		The plant built inside the project
19		Purchasing new equipment
20		Sale price for concrete 250 kg / cm2 inside the project	588		EGP / m3
21		Sale price for concrete 250 kg / cm2 outside the project	542		EGP / m3
22		Number of concrete mixer trucks 10 m3	5		Truck	Price	1,804,325	LE
23		Number of pumps 42 m	1		Pump	Price	6,390,825	LE
24
25	No	Items	Annual increase %	Time (Years)									Total
26	No	Items	Annual increase %	Y2016	Y2017	Y2018	Y2019	Y2020	Y2021	Y2022	Y2023	Y2024	Total
27		Costs (Cash Out)
28	1-1	Batching plant 120 m3 / hr		6,158,500
29	1-2	Operational equipment		21,699,570
30	1-3	Total cost of civil and construction works		3,176,842
31	1-4	Lease Payment			5,323,396	7,082,029	7,902,317	7,902,317	7,902,317	7,902,317	7,902,317	7,902,317	59,819,324
32	1-5	Annual salaries	7%		1,464,000	1,566,480	1,676,134	1,793,463	1,919,005	0	0	0	8,419,082
33	1-6	Annual operational expenses for m3	7%		2,469,915	8,130,807	9,694,532	7,996,549	7,996,549	0	0	0	36,288,351
34	1-7	Annual general expenses	7%		213,600	228,552	244,551	261,669	279,986	0	0	0	1,228,358
35	1-8	Annual expenses for headquarters	7%		829,327	2,730,093	3,255,147	2,685,013	2,685,013	0	0	0	12,184,591
36	1-9	Annual taxes ( 1 % from sales price )	7%		414,663	1,365,046	1,627,573	1,342,506	1,342,506	0	0	0	6,092,296
37	1-10	Annual risk value ( 1 % from sales price )	7%		414,663	1,365,046	1,627,573	1,342,506	1,342,506	0	0	0	6,092,296
38	1-11	Total cost of raw materials for m3 Concrete	7%		24,038,624	79,133,659	94,352,722	77,826,981	77,826,981	0	0	0	353,178,969
39		Total Cost (Cash Out)		31,034,912	35,168,189	101,601,712	120,380,548	101,151,004	101,294,863	7,902,317	7,902,317	7,902,317	483,303,267
40		Revenues (Cash In)
41	2-1	Total sales for concrete 250 kg/cm2	7%		40,923,944	135,343,897	161,596,602	133,089,893	133,089,893	0	0	0	604,044,230
42	2-2	Recovered value for batching plant = 50 %							3,079,250				3,079,250
43	2-3	Recovered value for operational equipment = 50 %							10,849,785				10,849,785
44		Total Revenues (Cash In)			40,923,944	135,343,897	161,596,602	133,089,893	147,018,928	0	0	0	617,973,265
45		Margin (Profits)
46	3-1	Annual Margin (Profit)			5,755,755	33,742,185	41,216,054	31,938,889	45,724,065	-7,902,317	-7,902,317	-7,902,317	134,669,998
47	3-2	Cumulative Annual Margin (Profit)			5,755,755	39,497,940	80,713,994	112,652,883	158,376,948	150,474,631	142,572,315	134,669,998
48
49				Cost / m3	498	468	465	474	474				496
50
51		Total Investment Value	31,034,912	LE
52		Pay Bak Period	2.00	Years
53		NPV Cost	322,898,515	LE
54		NPV Revenue	427,459,353	LE
55		NPV Margin (Profit)	96,847,928	LE
56		Profitability Index (PI)	3.12
57		https://pmo-eng.blogspot.com/
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100