Engineering Economics Question

Project started in 1.June 2016

I will be happy if you reply as soon as possible.

Case Description and Questions A mutual agreement is signed between a customer and a construction company. The construction company has divided the project flow into 10 meaningful parts to complete this 4- year project. The construction company has prepared a departmental cost estimate for the project (see Excel file for details). Use Excel functions* to answer the following question: 7. How much money should the company invest on June 1, 2018 to cover the cost of concrete? Note: Unless otherwise stated, you may receive 1% monthly interest. Item Precast Concrete Reinforcing Steel Concrete Placement Division 3 Concrete Quantity Unit Cost Start Date End Date Payment Method Duration/Span 1.200 $900 1.June 2017 1.June 2019 Pay in 4 equal installments Cost for overall period 1.100 $670 1. June 2017 1. June 2019 Pay in 4 equal installments Cost for overall period 900 $460 1.June 2017 1. June 2019 Pay in 4 equal installments Cost for overall period Case Description and Questions A mutual agreement is signed between a customer and a construction company. The construction company has divided the project flow into 10 meaningful parts to complete this 4- year project. The construction company has prepared a departmental cost estimate for the project (see Excel file for details). Use Excel functions* to answer the following question: 7. How much money should the company invest on June 1, 2018 to cover the cost of concrete? Note: Unless otherwise stated, you may receive 1% monthly interest. Item Precast Concrete Reinforcing Steel Concrete Placement Division 3 Concrete Quantity Unit Cost Start Date End Date Payment Method Duration/Span 1.200 $900 1.June 2017 1.June 2019 Pay in 4 equal installments Cost for overall period 1.100 $670 1. June 2017 1. June 2019 Pay in 4 equal installments Cost for overall period 900 $460 1.June 2017 1. June 2019 Pay in 4 equal installments Cost for overall period