Excel Assignment
sheldeez
SC_EX365_2021_CS1-3b__1.xlsxDocumentation
| Forward Construction | |
| CREATE FORMULAS WITH FUNCTIONS | |
| Author: | Nicole Robinson |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Budget
| Office Plaza Construction | Date: | Hourly rate: | 105 | |||||||||
| Team Consulting Services | ||||||||||||
| Meadowood Office Center | Code | Description | Completed Hours | Completed $ | Estimated $ | Remaining $ | Remaining % | |||||
| BL-119 | Blueprint drafting | 12 | $ 6,300 | |||||||||
| BL-124 | Blueprint review | 10 | 4,250 | |||||||||
| FO-223 | Foundation inspection | 15 | 1,075 | |||||||||
| HV-489 | HVAC review | 10 | 2,000 | |||||||||
| HV-500 | HVAC evaluation | 22 | 9,550 | |||||||||
| IN-102 | Insurance filing | 15 | 1,000 | |||||||||
| PE-101 | Permit review | 15 | 6,875 | |||||||||
| PE-212 | Permit monitoring | 12 | 6,300 | |||||||||
| SI-235 | Site inspection | 20 | 9,000 | |||||||||
| SI-240 | Site monitoring | 20 | 12,500 | |||||||||
| Total | ||||||||||||
| Average years of experience | ||||||||||||
| Adjust the chart to make it easier to read. | ||||||||||||
Hours
Completed Hours Blueprint drafting Blueprint review Foundation inspection HVAC review HVAC evaluation Insurance filing Permit review Permit monitoring Site inspection Site monitoring 12 10 15 10 22 15 15 12 20 20
Project Team
| Project Team | ||||||
| Name | Services | Manager | Years | Position | Rating | |
| M. Alvarez | FO-223 | Antonin | 2.3 | 90 | ||
| A. Guevara | HV-489 | Peterson | 5.0 | 87 | ||
| B. Olstadt | SI-235 | Antonin | 2.5 | 82 | ||
| D. Shanley | PE-212 | Wang | 2.8 | 78 | ||
| E. Spires | HV-500 | Peterson | 3.0 | 90 | ||
| D. Sutinieri | BL-119 | Peterson | 2.6 | 92 | ||
| T. Tinajero | BL-124 | Wang | 5.8 | 88 | ||
| A. Udvari | IN-102 | Antonin | 4.7 | 79 | ||
| B. Wanta | PE-101 | Peterson | 3.2 | 75 | ||
| C. Woodall | SI-240 | Antonin | 5.7 | 86 |
Schedule
| 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/24 | |||||
| Evaluations | 9/6/24 | |||||
| Monitoring | 10/1/24 | |||||
| Start date | ||||||
| Completion date | ||||||
