PROJECT MANAGEMENT

Schedule of Values 1

10 Points

You discover that your assistant gave you the wrong percentages for the pay request you prepared previously. Prepare the pay request continuation sheet for the following work completed this month, ignoring your previous work (recommended: start over with the blank spreadsheet available in this module):

• 21% of General Conditions (line item 1.0)
• Balance of Paving (line item 2.2)
• 63% of Finish Carpentry (line item 6.2)
• 70% of Doors & Frames (line item 8.1)
• 48% of Acoustical Ceilings (line item 9.3)
• Remainder of HVAC trim (line item 15.32)
• Appropriate amount of Fee (line item 90.0)

You had three change orders this month:

• Change Order #3 was finalized as an add of $14,480 and 65% of the work was completed this month.
• Change Order #4 was finalized as a deduct of ($4,600) and should be billed out 100%.
• Change Order #5 has not been finalized yet, but it will be for an add of $6,400 and 100% of the work has been completed.

Based on your work above, prepare the G703 pay continuation sheet and the amounts for the AIA G702 Application and Certificate for Payment using the Excel sheet provided as with the first assignment. Print out both parts, staple together (if not printed on both sides), and bring to the next class.

A B C D E G G. 1 H (D+E) (G/C) (C-G) Contract Previous Complete Complete % Line Item Description Value Complete This Mo. To Date Complete To Go 1.0 General Conditions 205,000 120,000 120,000 59% 85,000 2.1 Earthwork & Utilities 124,000 124,000 124,000 100% 2.2 Paving 24,000 12,000 12,000 50% 12,000 2.3 Misc. Site 48,000 0 0 0% 48,000 3.1 Reinforcement 13,000 13,000 13,000 100% 3.2 Foundations 42,000 42,000 42,000 100% 0 3.3 Walls & Slabs 82,000 82,000 82,000 100% 5.0 Steel 6,000 6,000 6,000 100% 6.1 Rough Carpentry & Siding 344,000 344,000 344,000 100% 6.11 Siding 40,000 40,000 40,000 100% 6.2 Finish Carpentry 85,000 0 0 0% 85,000 7.1 Insulation 19,000 19,000 19,000 100% 7.2 Roofing 59,000 59,000 59,000 100% 7.3 Gutters 3,000 3,000 3,000 100% 8.1 Doors & Frames 29,000 0 0 0% 29,000 8.2 Glazing 19,000 19,000 19,000 100% 0 8.3 Door Hardware 15,000 0 0 0% 15,000 9.1 Drywall 25,000 10,000 10,000 40% 15,000 9.2 Painting 28,000 14,000 14,000 50% 14,000 9.3 Acoustical Ceilings 8,000 0 0% 8,000 9.4 Carpet 23,000 0 0% 23,000 9.5 Balance of floorcovering 17,000 ooo o O 0 0% 17,000 10.0 Specialties 11,000 0 0% 11,000 14.0 Elevator 30,000 O 0% 30,000 15.1 Plumbing: underslab 9,000 9.000 9,000 100% 15.11 Plumbing: rough-in 20,000 20,000 20,000 100% 0 15.12 Plumbing: fixtures & trim 20,000 0 0 0% 20,00015.1 Plumbing: underslab 9,000 9.000 9,000 100% O 15.11 Plumbing: rough-in 20,000 20,000 20,000 100% 0 15.12 Plumbing: fixtures & trim 20,000 0 0 0% 20,000 15.2 Fire Protection: rough-in 19,000 19,000 19,000 100% 0 15.21 Fire Protection: trim 10,000 0 0 0% 10,000 15.3 HVAC: rough-in 50,000 50,000 50,000 100% 0 15.31 HVAC: equipment 50,000 47,000 47,000 94% 3,000 15.32 HVAC: trim 45,000 3,000 3,000 7% 42,000 15.4 Controls 35,000 0 0 0% 35,000 16.0 Electrical: rough-in 60,000 60,000 60,000 100% 0 16.1 Electrical: trim 60,000 0 0 0% 60,000 90.0 Fee 83,000 50,000 50,000 60% 33,000 Original Total 1,760,000 1,165,000 1, 165,000 66% 595,000 99.1 Change Order #1 4,623 4,623 4,623 100% 0 99.2 Change Order #2 0 0 100% #DIV/O! 0 #DIV/O! Current Total 1,764,623 1,169,623 0 1,169,623 66% 595,000