Solve

You have been assigned as the project engineer for a project that includes the construction of a cast in place concrete foundation wall. You have been given the following budget for the work and are responsible for reporting on the progress of the project in an effort to keep the project within budget Concrete Foundation Walls Budget Activity Quantity Total Budget 03112 - Set Formwork 2,500 LF $53,112.00 03113 - Strip Formwork 2,500 LF $4,554.00 03202 - Install Rebar 2,500 LF $6,558.60 03302 - Place wall 1,000 CY $9,715.20 concrete 03303 - Sack rub walls 40,000 sqft $6,072.00 Total Concrete Foundation Walls Budget $80,011.80 Using the information above, answer the following questions. Be sure to show your work. If creating a table Excel to calculate values, be sure to clearly indicate the answers to the questions being asked. 1. What are the budgeted costs per unit for each activity? 2. After the first week on the project, your crew completed 380 If of the set formwork activity. What is the percent complete for the set formwork activity? 3. Your companies labor cost reports indicate the crew worked 40 hours @ a cost of $221.3/hr. What is the total As-Built cost of the set formwork activity? 4. What is the As-Built cost per unit of the set formwork activity? 5. To date, explain how is this activity is doing compared to your budget? 6. Using the percent complete, how much of the set formwork budget has been earned? 7. What is the difference between your earned budget and your As-Built costs? Are you currently under or over budget? 8. After the second week on the project, your crews completed the following work