Make an economical analysis for this project as per the followings :

1- Use any one of the analysis methods ( PW or AW ) using excel sheet

2- use 5.5% per year MARR compounded monthly .

3- Assume that the payments from the government to the company be based on every three months a payment and a last payment be after 6 months after the period of one year , ( for maintenance assurances  )

4- draw the cash flow diagram

 

Transcribed Image Text:

Division/Description A A.1 A.2 B B.1 с C1 C.1.1 C.1.2 C.2 C.2.1 C.3 C.3.1 C.3.2 C.3.3 C.3.4 C.3.5 C.4 C.4.1 C.4.2 C.4.3 GENERAL TOTAL Mobilization and Demobilization Mobilization: Mobilization of machinery, personnel and all any other material and equipment required to perform the work. Setting up the site camp including offices and accommodations cabins together with any other essential facilities. Demobilization: Demobilization of machinery, personnel and all any other material and equipment from the Worksite. Removal of the site camp including offices and accommodations cabins together with any other essential facilities from the Worksites. The Contractor shall leave the Worksite and close surrounding clean as directed by the Site Engineer. Project Supervision, Survey and Engineering Services Project Management: Supervision of all the engineering and field works. Quality Control and Ensuring all the construction works are in the conformity with the approved plans, specifications and architectural/ structural drawings. Road Construction Works Construction the road with a width of 12 m as shown in the drawings and Typical cross-section, construction the side ditches, side slope crown, cross slope, supper. elevation according to the section R5 of (IGSRB) and including cutting in all type soil (i.e. soil, rocky, semi rocky, concrete, asphalt and other layers) Earth Cutting Works: Supply materials and equipment to use in excavation of the cutting sections. Includes removal of the cutting material. Earth Filling Works: Supply materials and equipment for the filling sections. Sub-base & base layer works: Provide all requirements (including Batch plant) to lay a layer of crushed limestone base course with 40cm thick in three layers, 9 m width and well compacted to %98 of M.D.D according to the section "R7" and table ""Batch plant ksites. The Contractor shall leave the Worksite and close surrounding clean as directed by the Site Engineer.R7/1" in the "IGSRB" and the instructions of the site engineer. Culverts: Provide materials and construct complete concrete pipe & box culverts using fair face wood shuttering all exposed edge shall be chamfered. Double Box culvert 2x2 m Double Box culvert 1.5x1.5 m. Single Box culvert (1.5x1.5)m. 01 m double (Reinforced concrete) Ø1 m single (Reinforced concrete) Construction of New Pavement Prime coat to the requirements of section R&A of the IGSRB and the instructions of the Bituminous stabilizer course with the width of 7.85 meter according to the section R9 and the table R9/3 of SORB revised edition 2003 with the thickness of 10 cm. after compaction according to the site engineer and compaction of %97 density of Marshal laboratory. Notice: the rate of mixing bituminous for the stabilizer and using bulk density 40 to 50 grade and if there was any change in the mixture rate of the bituminous will be deducted according to the IGSRB of 1992 Tack coat to the requirements of section R&B of the IGSRB and the instructions of the site engineer. C.4.4 Bituminous binder course 7.5 meter wide, according to the section R9 and the table R9 Total Costs ($) 1,537,400.00 20,000.00 10,000.00 10,000.00 10,000.00 10,000.00 858,000.00 768,000.00 90,000.00 78,000.00 78,000.00 267,150.00 112,500.00 72,000.00 21,600.00 40,800.00 20,250.00 304,250.00 5,750.00 161,000.00 5,500.00 132,000.00 Total % Complete 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% Work Completed Total Completed to Previous Application date ($) 1,537,400.00 20,000.00 10,000.00 10,000.00 10,000.00 10,000.00 858,000.00 768,000.00 90,000.00 78,000.00 78,000.00 267,150.00 112,500.00 72,000.00 21,600.00 40,800.00 20,250.00 304,250.00 5,750.00 161,000.00 5,500.00 132,000.00 1,537,400.00 20,000.00 10,000.00 10,000.00 10,000.00 10,000.00 858,000.00 768,000.00 90,000.00 78,000.00 78,000.00 267,150.00 112,500.00 72,000.00 21,600.00 40,800.00 20,250.00 304,250.00 5,750.00 161,000.00 5,500.00 132,000.00 This Period ($) Division/Description A A.1 A.2 B B.1 с C1 C.1.1 C.1.2 C.2 C.2.1 C.3 C.3.1 C.3.2 C.3.3 C.3.4 C.3.5 C.4 C.4.1 C.4.2 C.4.3 GENERAL TOTAL Mobilization and Demobilization Mobilization: Mobilization of machinery, personnel and all any other material and equipment required to perform the work. Setting up the site camp including offices and accommodations cabins together with any other essential facilities. Demobilization: Demobilization of machinery, personnel and all any other material and equipment from the Worksite. Removal of the site camp including offices and accommodations cabins together with any other essential facilities from the Worksites. The Contractor shall leave the Worksite and close surrounding clean as directed by the Site Engineer. Project Supervision, Survey and Engineering Services Project Management: Supervision of all the engineering and field works. Quality Control and Ensuring all the construction works are in the conformity with the approved plans, specifications and architectural/ structural drawings. Road Construction Works Construction the road with a width of 12 m as shown in the drawings and Typical cross-section, construction the side ditches, side slope crown, cross slope, supper. elevation according to the section R5 of (IGSRB) and including cutting in all type soil (i.e. soil, rocky, semi rocky, concrete, asphalt and other layers) Earth Cutting Works: Supply materials and equipment to use in excavation of the cutting sections. Includes removal of the cutting material. Earth Filling Works: Supply materials and equipment for the filling sections. Sub-base & base layer works: Provide all requirements (including Batch plant) to lay a layer of crushed limestone base course with 40cm thick in three layers, 9 m width and well compacted to %98 of M.D.D according to the section "R7" and table ""Batch plant ksites. The Contractor shall leave the Worksite and close surrounding clean as directed by the Site Engineer.R7/1" in the "IGSRB" and the instructions of the site engineer. Culverts: Provide materials and construct complete concrete pipe & box culverts using fair face wood shuttering all exposed edge shall be chamfered. Double Box culvert 2x2 m Double Box culvert 1.5x1.5 m. Single Box culvert (1.5x1.5)m. 01 m double (Reinforced concrete) Ø1 m single (Reinforced concrete) Construction of New Pavement Prime coat to the requirements of section R&A of the IGSRB and the instructions of the Bituminous stabilizer course with the width of 7.85 meter according to the section R9 and the table R9/3 of SORB revised edition 2003 with the thickness of 10 cm. after compaction according to the site engineer and compaction of %97 density of Marshal laboratory. Notice: the rate of mixing bituminous for the stabilizer and using bulk density 40 to 50 grade and if there was any change in the mixture rate of the bituminous will be deducted according to the IGSRB of 1992 Tack coat to the requirements of section R&B of the IGSRB and the instructions of the site engineer. C.4.4 Bituminous binder course 7.5 meter wide, according to the section R9 and the table R9 Total Costs ($) 1,537,400.00 20,000.00 10,000.00 10,000.00 10,000.00 10,000.00 858,000.00 768,000.00 90,000.00 78,000.00 78,000.00 267,150.00 112,500.00 72,000.00 21,600.00 40,800.00 20,250.00 304,250.00 5,750.00 161,000.00 5,500.00 132,000.00 Total % Complete 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% Work Completed Total Completed to Previous Application date ($) 1,537,400.00 20,000.00 10,000.00 10,000.00 10,000.00 10,000.00 858,000.00 768,000.00 90,000.00 78,000.00 78,000.00 267,150.00 112,500.00 72,000.00 21,600.00 40,800.00 20,250.00 304,250.00 5,750.00 161,000.00 5,500.00 132,000.00 1,537,400.00 20,000.00 10,000.00 10,000.00 10,000.00 10,000.00 858,000.00 768,000.00 90,000.00 78,000.00 78,000.00 267,150.00 112,500.00 72,000.00 21,600.00 40,800.00 20,250.00 304,250.00 5,750.00 161,000.00 5,500.00 132,000.00 This Period ($)

Answer rating: 100% (QA)

Excel Bank Reconciliation and Charts A Bank Statement Reconciliation Form Application Excel Complete Production Challenge 15C on page 325 of the textbook then create the bank reconciliation statement ... View the full answer