SC_EX365_2021_CS1-3b_SarahBuchanan_2

Author: No Shelly C

Forward Construction CREATE FORMULAS WITH FUNCTIONS sarah buchanan ote: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from Cashman Excel 365/2021 | Modules 1- 3: SAM Capstone Project 1b

Office Plaza Construction Team Consulting Services Meadowood Ofce Center Code code description Completed Hours Completed $ Estimated $ BL-119 Blueprint drafting 12 $ 1,260 $ 6,300 BL-124 Blueprint review 10 $ 1,050 4,250 FO-223 Foundation inspection 15 $ 1,575 1,075 HV-489 HVAC review 10 $ 1,050 2,000 HV-500 HVAC evaluation 22 $ 2,310 9,550 IN-102 Insurance filing 15 $ 1,575 1,000 PE-101 Permit review 15 $ 1,575 6,875 PE-212 Permit monitoring 12 $ 1,260 6,300 SI-235 Site inspection 20 $ 2,100 9,000 SI-240 Site monitoring 20 $ 2,100 12,500 Total 151 $15,855 $58,850 Average years of experience 3.8 Blue print draft ing Blue print review Fou ndation in spe ction HVAC review HVAC eval uation Insurance fili ng Permi t review Permi t monitori ng Sit 0 5 10 15 20 25 12 10 15 10 22 15 15 12 task progress h o u r s

Date: 11/29/23 1:30 Hourly rate: $105.00 Project Team Remaining $ Remaining % Name Services Manager Years Position $ 5,040 80% M. Alvarez FO-223 Antonin 2.3 support $ 3,200 75% A. Guevara HV-489 Peterson 5.0 senior $ (500) -47% B. Olstadt SI-235 Antonin 2.5 support $ 950 48% D. Shanley PE-212 Wang 2.8 support $ 7,240 76% E. Spires HV-500 Peterson 3.0 support $ (575) -58% D. Sutinieri BL-119 Peterson 2.6 support $ 5,300 77% T. Tinajero BL-124 Wang 5.8 senior $ 5,040 80% A. Udvari IN-102 Antonin 4.7 support $ 6,900 77% B. Wanta PE-101 Peterson 3.2 support $ 10,400 83% C. Woodall SI-240 Antonin 5.7 senior 42,995 73% Site inspectio n Sit e mo nitoring 20 20

Project Team Name Services Manager Years Position Rating M. Alvarez FO-223 Antonin 2.3 support 90 A. Guevara HV-489 Peterson 5.0 senior 87 B. Olstadt SI-235 Antonin 2.5 support 82 D. Shanley PE-212 Wang 2.8 support 78 E. Spires HV-500 Peterson 3.0 support 90 D. Sutinieri BL-119 Peterson 2.6 support 92 T. Tinajero BL-124 Wang 5.8 senior 88 A. Udvari IN-102 Antonin 4.7 support 79 B. Wanta PE-101 Peterson 3.2 support 75 C. Woodall SI-240 Antonin 5.7 senior 86

Office Plaza Construction Project Schedule for Remaining Work SI-240 FO-223 PE-212 SI-235 HV-500 Workdays 1 2 3 3 Inspections 9/12/2024 9/13/2024 9/14/2024 9/15/2024 9/15/2024 Evaluations 9/6/2024 9/7/2024 9/8/2024 9/9/2024 9/9/2024 Monitoring 10/1/2024 10/2/2024 10/3/2024 10/4/2024 10/4/2024 Start date 9/6/2024 Completion date 10/4/2024