0% ont trouvé ce document utile (0 vote)
6 vues23 pages

Analyse des Coûts et Matériaux

Le document présente une liste de matériaux avec leurs codes, quantités, dimensions et surfaces correspondantes. Il inclut également des totaux de prix, des coûts de fabrication et d'installation, ainsi que des informations financières sur les bénéfices et les pertes. Enfin, il fournit des détails sur les coûts de transport et les matériaux utilisés dans le projet.

Transféré par

nhqrdewaco
Copyright
© All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats XLSX, PDF, TXT ou lisez en ligne sur Scribd
0% ont trouvé ce document utile (0 vote)
6 vues23 pages

Analyse des Coûts et Matériaux

Le document présente une liste de matériaux avec leurs codes, quantités, dimensions et surfaces correspondantes. Il inclut également des totaux de prix, des coûts de fabrication et d'installation, ainsi que des informations financières sur les bénéfices et les pertes. Enfin, il fournit des détails sur les coûts de transport et les matériaux utilisés dans le projet.

Transféré par

nhqrdewaco
Copyright
© All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats XLSX, PDF, TXT ou lisez en ligne sur Scribd

S/N Code Qty L W Area

1 L01 16 3390 6750 22.8825


2 L02 16 750 2200 1.65
3 L03 32 750 2600 1.95
4 L04 112 1800 400 0.72
5 L05 56 800 650 0.52
6 L06 16 2170 6850 14.8645
7 L07 16 450 5750 2.5875
8 L08 16 550 5750 3.1625
9 L09 64 900 400 0.36
10 L10 32 750 2800 2.1
11 L11 3 1670 18450 30.8115
12 L12 96 930 2700 2.511
13 L13 192 700 2700 1.89
14 L14 96 1850 2700 4.995
15 L15 32 1230 2700 3.321
16 L16 8 1650 1800 2.97
17 L17 16 1950 2450 4.7775
18 L18 16 550 2450 1.3475
19 L19 8 1850 2400 4.44
20 L20 3 4440 6850 30.414
21 L21 3 650 2600 1.69
22 L22 1 3460 3730 12.9058
23 L23 1 4260 3730 15.8898
24 L24 10 2000 400 0.8
25 L25 3 5980 400 2.392
26 L26 13 3460 2430 8.4078
27 L27 1 4260 2430 10.3518
28 L28 4 1000 2730 2.73
29 L29 3 1000 2730 2.73
30 Strips 450
885 646.1717
1.07
Area Total Price TOTAL PRICE PRICE W/O TAXES DRY COST Column1
366.12 26,381.00 422,096.00 354,702.52 331,497.68 20,718.61
26.4 3,236.00 51,776.00 43,509.24 40,662.84 2,541.43
62.4 3,686.00 117,952.00 99,119.33 92,634.89 2,894.84
80.64 2,330.00 260,960.00 219,294.12 204,947.77 1,829.89
29.12 1,546.00 86,576.00 72,752.94 67,993.40 1,214.17
237.832 19,809.00 316,944.00 266,339.50 248,915.42 15,557.21
41.4 4,905.00 78,480.00 65,949.58 61,635.12 3,852.20
50.6 5,686.00 90,976.00 76,450.42 71,448.99 4,465.56
23.04 1,544.00 98,816.00 83,038.66 77,606.22 1,212.60
67.2 3,896.00 124,672.00 104,766.39 97,912.51 3,059.77
92.4345 40,804.00 122,412.00 102,867.23 96,137.60 32,045.87
241.056 4,585.00 440,160.00 369,882.35 345,684.44 3,600.88
362.88 3,267.00 627,264.00 527,112.61 492,628.60 2,565.77
479.52 9,348.00 897,408.00 754,124.37 704,789.13 7,341.55
106.272 11,239.00 359,648.00 302,225.21 282,453.47 8,826.67
23.76 5,233.00 41,864.00 35,179.83 32,878.35 4,109.79
76.44 8,159.00 130,544.00 109,700.84 102,524.15 6,407.76
21.56 2,701.00 43,216.00 36,315.97 33,940.16 2,121.26
35.52 7,867.00 62,936.00 52,887.39 49,427.47 6,178.43
91.242 22,689.00 68,067.00 57,199.16 53,457.16 17,819.05
5.07 3,344.00 10,032.00 8,430.25 7,878.74 2,626.25
12.9058 22,737.00 22,737.00 19,106.72 17,856.75 17,856.75
15.8898 24,134.00 24,134.00 20,280.67 18,953.90 18,953.90
8 2,567.00 25,670.00 21,571.43 20,160.21 2,016.02
7.176 5,478.00 16,434.00 13,810.08 12,906.62 4,302.21
109.3014 11,163.00 145,119.00 121,948.74 113,970.78 8,766.98
10.3518 11,638.00 11,638.00 9,779.83 9,140.03 9,140.03
10.92 4,072.00 16,288.00 13,687.39 12,791.96 3,197.99
8.19 1,668.00 5,004.00 4,205.04 3,929.95 1,309.98
450 2,050.00 922,500.00 775,210.08 724,495.41 1,609.99
3153.2413 £ 5,642,323.00 4,741,447.90 4,431,259.72

310,188.18
‫‪310,188.18‬‬ ‫قيمة الربح‬
‫‪-‬‬ ‫‪168,237.82‬‬ ‫قية الخسارة‬
150 150
Material Price total Material Price Total L.E ALU l.e Fab L.E Install L.E
16,163.77 258,620.35 258,620.35 54,918.00 54,918.00
2,086.20 33,379.23 33,379.23 3,960.00 3,960.00
2,381.65 76,212.77 76,212.77 9,360.00 9,360.00
1,516.99 169,903.02 169,903.02 12,096.00 12,096.00
923.39 51,709.61 51,709.61 4,368.00 4,368.00
12,316.63 197,066.11 197,066.11 35,674.80 35,674.80
3,212.88 51,406.04 51,406.04 6,210.00 6,210.00
3,713.42 59,414.74 59,414.74 7,590.00 7,590.00
918.87 58,807.58 58,807.58 3,456.00 3,456.00
2,529.82 80,954.39 80,954.39 10,080.00 10,080.00
25,951.48 77,854.45 77,854.45 13,865.18 13,865.18
2,875.87 276,083.37 276,083.37 36,158.40 36,158.40
1,832.32 351,804.63 351,804.63 54,432.00 54,432.00
5,601.75 537,768.42 537,768.42 71,928.00 71,928.00
6,711.26 214,760.42 214,760.42 15,940.80 15,940.80
3,328.53 26,628.21 26,628.21 3,564.00 3,564.00
5,275.59 84,409.40 84,409.40 11,466.00 11,466.00
1,752.81 28,044.91 28,044.91 3,234.00 3,234.00
5,139.16 41,113.26 41,113.26 5,328.00 5,328.00
12,044.96 36,134.88 36,134.88 13,686.30 13,686.30
2,174.93 6,524.80 6,524.80 760.50 760.50
14,146.21 14,146.21 14,146.21 1,935.87 1,935.87
14,272.72 14,272.72 14,272.72 2,383.47 2,383.47
1,636.51 16,365.11 16,365.11 1,200.00 1,200.00
3,693.38 11,080.14 11,080.14 1,076.40 1,076.40
6,554.33 85,206.33 85,206.33 16,395.21 16,395.21
6,371.07 6,371.07 6,371.07 1,552.77 1,552.77
2,320.48 9,281.91 9,281.91 1,638.00 1,638.00
714.78 2,144.35 2,144.35 1,228.50 1,228.50
1,936.00 871,200.00 871,200.00 67,500.00 67,500.00
3,748,668.43 3,748,668.43 472,986.20 472,986.20

4,759,071.47
4,759,071.47
15,782.03
- 17,623.57 4,759,071.47
405,486.20
- 407,327.74
15 3
Trans L.E Screw L.E Phase 1 Area Total Pahse 1 Dry Cost Phase 1 Acutal Trans
5,491.80 776.32
396.00 174.93
936.00 183.47
1,209.60 147.73
436.80 126.13
3,567.48 782.29
621.00 210.67
759.00 224.00
345.60 128.53
1,008.00 183.47
1,386.52 1,012.27
3,615.84 312.64
5,443.20 419.73
7,192.80 914.67
1,594.08 1,570.88
356.40 286.40
1,146.60 340.27
323.40 153.60
532.80 313.17
1,368.63 756.05
76.05 172.27
193.59 1,581.39
238.35 2,059.52
120.00 214.51
107.64 214.51
1,639.52 825.65
155.28 1,061.12
163.80 426.77
122.85 209.07
6,750.00 1,350.00
47,298.62 17,132.03 - - -
Phase 1 Trans Study Phase 1 Actual Material KG Phase 1 Total L.E glass Phase 1 total L.e

- - -
S/N Code Qty Area TOTAL Area2
1 C1 6 85 510
2 C2 8 122 976
0
0
0
0
14 207 1486

148600 126,185.00

299 22,415.00
1187

416,080.00
891,600.00
475,520.00
1.25
Price TOTAL PRICE PRICE W/O TAXES DRY COST DRY CosT For Unit
288,209.77 1,729,258.59 1,453,158.48 1,162,526.79 193,754.46
413,665.78 3,309,326.25 2,780,946.43 2,224,757.14 278,094.64
- - #DIV/0!
- - #DIV/0!
- - #DIV/0!
- - #DIV/0!
£ 5,038,584.84 4,234,104.91 3,387,283.93
2,538.07

630.00 928.07
Material Price total Material Price Total L.E Alu Cost L.E Cladding Cost L.E
215,735.96 1,294,415.79 321,300.00 473,315.79
309,644.56 2,477,156.49 614,880.00 905,796.49
- - - -
- - - -
- - - -
- - - -
3,771,572.28 936,180.00 1,379,112.28
350 100 500 30
ACC Cost L.E Fabrecation L.E Installation L.E Trans total L.E phase 1 Alu Weig
178,500.00 51,000.00 255,000.00 15,300.00 7.43
341,600.00 97,600.00 488,000.00 29,280.00 2.18
- - - - 0.14
- - - - 0.45
- - - - 0.35
- - - - 1.34
520,100.00 148,600.00 743,000.00 44,580.00 11.89
DESCription Price For Each Weight Phase 1 Alu L.E Phase 1 Trans Study
4*4*2 41,000.00 304,794.00
4*2*2 41,000.00 89,544.00
5*5*4.6 44,000.00 6,072.00
4*4*1.5 41,000.00 18,368.00
4*4*1.5 41,000.00 14,186.00
IPE 200 49,000.00 65,856.00
- 257,000.00 498,820.00 -
Phase 1 Actual Material KG Phase 1 Total L.E

-
S/N Code Qty W H Area
1 D01 9 2000 2200 4.4
2 D02 8 1800 2200 3.96
3 D10 32 2700 2600 7.02
4 D14 64 1800 2600 4.68
5 D15 288 1800 2200 3.96
6 D12 5 2000 2200 4.4
7 D13 26 2000 2200 4.4
8 D07 16 1000 2200 2.2
9 D17 1 1000 2200 2.2
10 W01 253 1000 900 0.9
11 W02 47 800 1800 1.44
12 W03 64 900 1600 1.44
13 W04 270 700 900 0.63
14 W05 416 600 900 0.54
15 W06 32 2700 2200 5.94
16 W07 16 2700 1200 3.24
17 W08 8 1800 2000 3.6
18 W09 22 1800 2000 3.6
19 W10 22 1800 2000 3.6
20 W11 72 1800 2200 3.96
21 W12 212 900 1200 1.08
22 W13 7 1000 600 0.6
23 W14 108 1800 1600 2.88
24 W15 432 1800 1200 2.16
26 W17 56 1500 450 0.675
2486 73.505
Column1 Column2
(blank)
D07 12
D10 10
D12 2
D13 22
D14 20
D15 179
W01 124
W02
W03 20
W04 138
W05 233
W07 10
W08 3
W09 16
W10 17
W11 19
W12 120
W14 50
W15 264
W16 14
1.07
Area Total Price TOTAL PRICE PRICE W/O TAXES DRY COST Column1
39.6 8481 76,329.00 64,142.02 59,945.81 6,660.65
31.68 7761 62,088.00 52,174.79 48,761.49 6,095.19
224.64 14470 463,040.00 389,109.24 363,653.50 11,364.17
299.52 9766 625,024.00 525,230.25 490,869.39 7,669.83
1140.48 8521 2,454,048.00 2,062,225.21 1,927,313.28 6,692.06
22 10458 52,290.00 43,941.18 41,066.52 8,213.30
114.4 9069 235,794.00 198,146.22 185,183.38 7,122.44
35.2 4411 70,576.00 59,307.56 55,427.63 3,464.23
2.2 4411 4,411.00 3,706.72 3,464.23 3,464.23
227.7 2447 619,091.00 520,244.54 486,209.85 1,921.78
67.68 3463 162,761.00 136,773.95 127,826.12 2,719.70
92.16 3188 204,032.00 171,455.46 160,238.75 2,503.73
170.1 2119 572,130.00 480,781.51 449,328.52 1,664.18
224.64 1974 821,184.00 690,070.59 644,925.78 1,550.30
190.08 14054 449,728.00 377,922.69 353,198.77 11,037.46
51.84 8175 130,800.00 109,915.97 102,725.20 6,420.33
28.8 9616 76,928.00 64,645.38 60,416.24 7,552.03
79.2 7991 175,802.00 147,732.77 138,068.01 6,275.82
79.2 6028 132,616.00 111,442.02 104,151.42 4,734.16
285.12 8938 643,536.00 540,786.55 505,407.99 7,019.56
228.96 2623 556,076.00 467,290.76 436,720.33 2,060.00
4.2 3406 23,842.00 20,035.29 18,724.57 2,674.94
311.04 7098 766,584.00 644,188.24 602,045.08 5,574.49
933.12 5692 2,458,944.00 2,066,339.50 1,931,158.41 4,470.27
37.8 1988 111,328.00 93,552.94 87,432.66 1,561.30
4921.36 £ 11,948,982.00 10,041,161.34 9,384,262.94

894.39938931
169,605.01
112.280701754
Material Price total Material Price Total L.E KG kg total kg/l.e acc/l.e
4,147.11 37,323.95 15.40 138.60 1,781.00 2,366.11
3,985.38 31,883.02 13.86 110.88 1,602.90 2,382.48
7,125.97 228,031.16 24.57 786.24 2,841.50 4,284.47
4,853.65 310,633.54 16.38 1,048.32 1,894.33 2,959.32
4,291.67 1,236,000.00 13.86 3,991.68 1,602.90 2,688.77
5,062.36 25,311.80 15.40 77.00 1,781.00 3,281.36
4,440.75 115,459.39 15.40 400.40 1,781.00 2,659.75
2,194.62 35,113.96 7.70 123.20 890.50 1,304.12
2,194.62 2,194.62 7.70 7.70 890.50 1,304.12
1,468.20 371,455.04 3.15 796.95 364.29 1,103.91
1,791.66 84,207.92 5.04 236.88 582.87 1,208.79
1,647.10 105,414.18 5.04 322.56 582.87 1,064.22
1,207.09 325,913.68 2.21 595.35 255.01 952.08
1,120.35 466,065.96 1.89 786.24 218.58 901.77
7,291.32 233,322.11 20.79 665.28 2,404.35 4,886.97
4,606.99 73,711.86 11.34 181.44 1,311.46 3,295.53
4,982.85 39,862.81 12.60 100.80 1,457.18 3,525.67
4,163.37 91,594.11 12.60 277.20 1,457.18 2,706.19
3,348.40 73,664.88 12.60 277.20 1,457.18 1,891.22
4,709.09 339,054.32 13.86 997.92 1,602.90 3,106.19
1,417.61 300,532.32 3.78 801.36 437.15 980.45
1,845.87 12,921.08 2.10 14.70 242.86 1,603.01
3,914.90 422,809.58 10.08 1,088.64 1,165.74 2,749.16
3,226.43 1,393,817.68 7.56 3,265.92 874.31 2,352.12
667.69 37,390.81 2.36 132.30 273.22 394.47
6,393,689.76 257.27 17,224.76 29,752.76 55,952.27

9,871,556.34

0.95063661885
0%
150 150
kg total l.e acc total L.E glass glass total L.E Fab L.E Install L.E
16,028.97 21,294.98 1,376.84 12,391.58 5,940.00 5,940.00
12,823.17 19,059.84 1,212.63 9,701.05 4,752.00 4,752.00
90,927.97 137,103.19 2,454.74 78,551.58 33,696.00 33,696.00
121,237.29 189,396.26 1,587.37 101,591.58 44,928.00 44,928.00
461,634.29 774,365.71 1,347.37 388,042.11 171,072.00 171,072.00
8,904.98 16,406.82 1,785.26 8,926.32 3,300.00 3,300.00
46,305.91 69,153.48 1,515.79 39,410.53 17,160.00 17,160.00
14,247.97 20,865.99 665.26 10,644.21 5,280.00 5,280.00
890.50 1,304.12 665.26 665.26 330.00 330.00
92,166.57 279,288.48 248.68 62,917.11 34,155.00 34,155.00
27,394.96 56,812.96 515.79 24,242.11 10,152.00 10,152.00
37,303.78 68,110.39 471.58 30,181.05 13,824.00 13,824.00
68,851.71 257,061.98 165.79 44,763.16 25,515.00 25,515.00
90,927.97 375,138.00 138.16 57,473.68 33,696.00 33,696.00
76,939.05 156,383.06 1,991.58 63,730.53 28,512.00 28,512.00
20,983.38 52,728.48 1,023.16 16,370.53 7,776.00 7,776.00
11,657.43 28,205.38 1,456.84 11,654.74 4,320.00 4,320.00
32,057.94 59,536.17 1,187.37 26,122.11 11,880.00 11,880.00
32,057.94 41,606.94 766.32 16,858.95 11,880.00 11,880.00
115,408.57 223,645.74 1,301.05 93,675.79 42,768.00 42,768.00
92,676.58 207,855.73 341.05 72,303.16 34,344.00 34,344.00
1,700.04 11,221.04 455.92 3,191.45 630.00 630.00
125,900.26 296,909.32 930.53 100,496.84 46,656.00 46,656.00
377,700.78 1,016,116.90 682.11 294,669.47 139,968.00 139,968.00
15,300.38 22,090.43 597.89 33,482.11 5,670.00 5,670.00
1,992,028.38 4,401,661.38 1,602,056.97 738,204.00 738,204.00

197,431.13
9,810,379.14
- 426,116.20
-0.0454075297 -4.54075296909
15 20
Trans L.E permeter Flashing L.E Screen / M2 Screen L.E phase 1
594.00 8.40 1,512.00 -
475.20 8.00 1,280.00 -
3,369.60 10.60 6,784.00 77.96 2,494.80 12.00
4,492.80 8.80 11,264.00 51.98 3,326.40 24.00
17,107.20 8.00 46,080.00 51.98 14,968.80 215.00
330.00 8.40 840.00 57.75 288.75 2.00
1,716.00 8.40 4,368.00 57.75 1,501.50 22.00
528.00 6.40 2,048.00 - - 12.00
33.00 6.40 128.00 - -
3,415.50 3.80 19,228.00 23.63 5,977.13 144.00
1,015.20 5.20 4,888.00 37.80 1,776.60
1,382.40 5.00 6,400.00 - 24.00
2,551.50 3.20 17,280.00 16.54 4,465.13 149.00
3,369.60 3.00 24,960.00 14.18 5,896.80 252.00
2,851.20 9.80 6,272.00 28.35 907.20
777.60 7.80 2,496.00 28.35 453.60 12.00
432.00 7.60 1,216.00 31.50 252.00 3.00
1,188.00 7.60 3,344.00 31.50 693.00 16.00
1,188.00 7.60 3,344.00 31.50 693.00 17.00
4,276.80 8.00 11,520.00 28.35 2,041.20 23.00
3,434.40 4.20 17,808.00 - 144.00
63.00 3.20 448.00 18.90 132.30 -
4,665.60 6.80 14,688.00 28.35 3,061.80 61.00
13,996.80 6.00 51,840.00 28.35 12,247.20 316.00
567.00 3.90 4,368.00 - 16.00
73,820.40 264,404.00 61,177.20 1,464.00

9,871,556.34
12,600.00 142,909.50
9,000.00

4.653294567541
100000
9000
109000
Phase 1 Area Total Pahse 1 Dry Cost Phase 1 Acutal Trans Phase 1 Trans Study
- - -
- - -
84.24 136,370.06 391.72 1,263.60
112.32 184,076.02 522.29 1,684.80
851.40 1,438,792.90 3,959.01 12,771.00
8.80 16,426.61 40.92 132.00
96.80 156,693.63 450.12 1,452.00
26.40 41,570.72 122.76 396.00
- - - -
129.60 276,736.04 602.64 1,944.00
- - - -
34.56 60,089.53 160.70 518.40
93.87 247,962.77 436.50 1,408.05
136.08 390,676.20 632.77 2,041.20
- - - -
38.88 77,043.90 180.79 583.20
10.80 22,656.09 50.22 162.00
57.60 100,413.10 267.84 864.00
61.20 80,480.64 284.58 918.00
91.08 161,449.78 423.52 1,366.20
155.52 296,640.23 723.17 2,332.80
- - - -
175.68 340,043.98 816.91 2,635.20
682.56 1,412,606.61 3,173.90 10,238.40
10.80 24,980.76 50.22 162.00
2,858.19 5,465,709.57 13,290.58 42,872.85

1,059,528.40
3,606,098.00
1,859,611.57

12600
4.4083843271441
Phase 1 Actual Material KG Phase 1 Total L.E glass Phase 1 total L.e
- - -
- - -
673.92 85,511.68 29,456.84
898.56 116,487.58 38,096.84
6,811.20 922,708.33 289,684.21
70.40 10,124.72 3,570.53
774.40 97,696.40 33,347.37
211.20 26,335.47 7,983.16
- - -
1,036.80 211,421.05 35,810.53
- - -
276.48 39,530.32 11,317.89
750.96 179,856.07 24,702.63
1,088.64 282,328.42 34,815.79
- - -
311.04 55,283.89 12,277.89
86.40 14,948.55 4,370.53
460.80 66,613.89 18,997.89
489.60 56,922.86 13,027.37
728.64 108,309.02 29,924.21
1,244.16 204,135.16 49,111.58
- - -
1,405.44 238,809.11 56,762.11
5,460.48 1,019,551.82 215,545.26
86.40 10,683.09 9,566.32
3,747,257.46 918,368.95

4,665,626.40

7995746.73684211

3,330,120.33

Vous aimerez peut-être aussi