# The Construction Contracts Manager: companion files

Julian R. Sterling

## What is here

- **GC_Contracts_1_Exposure_by_Clause.xlsx** (Chapters 4, 5, 7 and 8; Workbook 1 of Appendix A): sheets Exposure, Liquidated damages, Escalation, then Checks. The seven priced clauses of the owner's draft against the contract as signed: $1,291,230 of expected exposure on the draft, $680,286 as signed, with the decision rule beside each clause; the liquidated damages rate and cap; the steel escalation clause and the S2 flow-down gap ($155,000 borne by Fenwright).
- **GC_Contracts_2_Change_Order_Pricing.xlsx** (Chapters 11 and 15; Workbook 2): sheets Change orders, CCD6, then Checks. CO1 to CO7 on the case markup rule (CO1 $428,987), the net change of $1,207,627 and the CCD6 directive to its settlement.
- **GC_Contracts_3_Pay_Applications.xlsx** (Chapters 6, 12 and 16; Workbook 3): sheets Pay applications, Closeout, then Checks. The 21 pay applications of P1, retainage held after pay application No. 20 ($3,142,826) and its cost ($229,526), a late payment test, and the closeout to a final payment of $272,500.
- **GC_Contracts_4_Notice_and_Delay.xlsx** (Chapters 10, 13 and 14; Workbook 4): sheets Notice calendar, Delay, then Checks. The notice log N1 to N5 with its deadlines, the delay to 7 days late and $59,500 of liquidated damages, and the Miller Act block of the federal job F1.
- **Construction_Contracts_Manager_Toolkit.docx**: the 8 check-lists of Appendix B, editable (Contract review check-list; Clause pricing check-list; Subcontract flow-down check-list; Notice check-list; Change order check-list; Monthly pay application check-list; Closeout check-list; Federal job additions).

## How to use the workbooks

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. On every sheet the inputs come first, then the calculations, then the outputs. Change one input at a time, note the output, and set the input back before the next test: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK at the base case. The 10 exercises of Appendix A each move one input.

Two inputs to try first:

1. In GC_Contracts_4_Notice_and_Delay.xlsx, on Notice calendar, set the date N4 was sent to 6 October 2025: the notice is in time, the rain days are granted, and the Delay sheet drops to 3 days late.
2. In GC_Contracts_1_Exposure_by_Clause.xlsx, on Escalation, set the steel increase to 17 percent: the owner's share stops at the cap and Fenwright's share grows.

The workbooks are separate files with no link between them: a figure from another workbook is entered as an input, and its label names the workbook it comes from.

## A word of caution

Fenwright Builders, the Varnmoor Institute, the city of Corrandale and every party in the case are fictional. Contract sums, rates, markups, probabilities, retainage and the other contract terms are teaching assumptions, not market terms or the default of any standard form. Notice periods, payment rules and Miller Act dates must be read in the signed contract and the current texts, and confirmed with counsel. Nothing here is legal advice.
