Make an economical analysis for this project as per the followings : 1- Use any one of
Fantastic news! We've Found the answer you've been seeking!
Question:
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 ($)
Expert Answer:
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
Related Book For
Microeconomics Theory and Applications with Calculus
ISBN: 978-0133019933
3rd edition
Authors: Jeffrey M. Perloff
Posted Date:
Students also viewed these accounting questions
-
Draw a cash flow diagram for the following cashflow: YEAR Receipts (S) Disbursements ($) 0 2 3 4 1,000 0 0 2,000 2,000 1,000 4,750 0 0 0
-
Draw a cash flow diagram for the following cashflow: YEAR Receipts (S) Disbursements ($) 2 3 4 0 5,000 5,000 0 0 5,000 7,500 5,000 0 0
-
Draw the cash flow diagram for the following statements: $70K Purchase price with 20% down ($14K) Monthly expenses (utilities, maintenance, insurance, etc..) = $200 Monthly P&I = $345 (starts in...
-
Draw a simple undirected graph G that has 12 vertices, 18 edges, and 3 connected components.
-
In the theory of finance, a market for any asset or commodity is said to be efficient if items of identical quality and other attributes (such as risk, in the case of stocks) are sold at the same...
-
The accounting records of the Cedar Company include the following information relating to the current year. The company manufactures a single product; during the current year, 60,000 units were...
-
You are appointed to participate on a time efficiency team. The team includes factory workers, Supervisor and a representative from the accounting department. Currently the factory workers record...
-
Refer to Exercise 6-1. Calculate the amount of the noncontrolling interest to be deducted from consolidated income in arriving at 2011 controlling interest in consolidated net income.
-
Market Value Capital Structure Suppose the Schoof Company has this book value balance sheet: Current assets $ 3 0 , 0 0 0 , 0 0 0 Current liabilities $ 2 0 , 0 0 0 , 0 0 0 Notes payable 1 0 , 0 0 0 ,...
-
Martin Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Martin Manufacturing's operations: Current Assets as of December 31...
-
Suppose that a small ultralight is powered by a gasoline engine. The cruising speed for the ultralight is 33 mph. a. Assume that it requires 25 hp of thrust to power the ultralight at 33 mph and...
-
Calculate the displacement y (in metres) for the wave described by the equation y(x,t) = (0.12 m) sin (245x-124t) at time 5.1 seconds and position 2.5 metres. You can assume that all values are in SI...
-
Suppose the 2022 income statement for McDonald's Corporation shows cost of goods sold $4,826.1 million and operating expenses (including depreciation expense of $1,270.0 million) $10,647.1 million....
-
ABC's financial data is shown below: Operating Income $41,000 Total Assets $200,000 Sales $400,000 Current Liabilities $25,000 Target Rate of Return 12% WACC 14% Tax rate 22% Required: Compute: (1)...
-
Suppose an intensity 641 mW/m lands on a detector of area 4.4 cm. Calculate the power generated by the detector in W with a single digit of precision. Hint: be careful with unit conversions!
-
Cabaret Corporation produces a single product. Data concerning the company's operations last year appear below: Units in beginning inventory.. Units produced Units sold Selling price per unit....
-
6. Consider a physical experiment where output can be written as a linear function of the input as: Output Bo+Binput1 + input2 + 3input3 + The estimate of regression coefficient = (0.2 0.8 -0.7 0.6)....
-
r = 0.18 Find the coefficients of determination and non-determination and explain the meaning of each.
-
What are the major differences between expected utility theory and prospect theory?
-
Remy views ice cream and fudge sauce as perfect complements. Is it possible that either of these goods or both of them are Giffen goods?
-
If an individual's labor supply curve slopes forward at low wages and bends backward at high wages, is leisure a Giffen good? If so, is leisure a Giffen good at high or low wage rates?
-
Show that \((4 / 3,10 / 3,0,0)\) is a basic feasible solution of the system: 2x1 + x2 + X3 6 x1 + 2x2 X20 + X4 = 8 for all i
-
Prove that if a feasible solution to a maximum problem in equality form is locally optimal, then it is optimal. (A solution is locally optimal if its objective value exceeds those of all feasible...
-
Let \(\mathscr{G}\) be an RKHS with reproducing kernel \(\kappa\). Show that \(\kappa\) is a positive semidefinite function.
Study smarter with the SolutionInn App