Option #1: Project Costs Calculate the weighed unit cost per square foot (sf) for the project data shown and determine the cost of a 30,000 sf project. Project 1 2 3 4 5 16 7 Size, sf $3,036,400.00 26,400 $3,129,700.00 29,800 $2,580,300.00 21,500 $2,287,500.00 18,300 $2,743,200.00 23,450 $3,065,300.00 32,350 $4,503,600.00 41,700 Total Cost Use the time and location indices presented in Chapter 4 of your textbook to estimate the cost of a building that contains 48,000 sf of floor area. The building is to be constructed three (3) years from now in City C. The cost of a similar type of building that contained 32,000 sf was completed two (2) years ago in City B for a cost of $3,680,000. Proposed structure information: Size: 48,000 sf Location: City C Start of construction: three (3) years from now Previous structure information: Size: 32,000 sf Location: City B Completion date: Two (2) years ago Cost: $3,680,000 . Deliverable: Upon completion of this assignment, you will deliver an excel spreadsheet to include: Tables of all information (data) given in the problem Formulas that reference cells, thus creating dynamic formulas that will change if information in the tables change The final answer highlighted in yellow

Calculate the weighed unit cost per square foot (sf) for the project data shown and determine the cost of a 30,000 sf project Use the time and location indices presented in Chapter 4 of your textbook to estimate the cost of a bulding that contains 48,000 st of floor area. The buliding is to be constructed three (3) years from now in City C. The cost of a similar type of building that contained 32,000 sf was completed two (2) years ago in City B for a cost of $3,680,000. Proposed structure information: Scze: 48,000 s! Location: City C Start of construction: three (3) years from now Previous structure information: Size: 32,000 sf Location: City 8 Completion date. Two (2) years ago Cost $3,680,000 Deliverable: Upon completion of this assignment, you will deliver an excel spreadsheet to include: - Tables of all information (data) given in the problem - Formulas that reference colls, thus creating dynamic formulas that will change if information in the tables change - The final answer highlighted in yellow