Okaloosa County BOCC — December 1, 2015 — General Ledger Audit Trail - Lord & Son Construction, Inc.

Lord & Son Construction, Inc. Project Title: Shalimar Administrative Building (New Phase 2) Purchasing Contract# C12-1995-FM Expires: TBD Retainage begins w/ construction 10% 3160 3160 301 562132 562131 Total Const Cost Not Const Cost 2051100 Amount to be Inv# Const Cost Pre-Const Cost Costto date Subjto Retain Sub to Retain Withheld Paid 1 26,361.70 26,361.70 26,361.70 - 26,361.70 2 21,961.70 21,961.70 21,961.70 - 21,961.70 3 34,098.25 34,098.25 34,098.25 - 34,098.25 4 61,835.80 61,835.80 61,835.80 - 61,835.80 5 20,339.55 20,339.55 20,339.55 - 20,339.55 6 % 10,280.85 10,280.85 10,280.85 - 10,280.85 7 14,561.70 14,561.70 14,561.70 - 14,561.70 8 15,474.04 15,474.04 15,474.04 - 15,474.04 9 12,061.70 12,061.70 12,061.70 - 12,061.70 10 20,754.89 20,754.89 20,754.89 - 20,754.89 1 81,920.86 81,920.86 81,920.86 - 81,920.86 12 71,675.43 71,675.43 71,675.43 - 71,675.43 13 289,187.06 289,187.06 289,187.06 - 289,187.06 14 218,375.99 218,375.99 218,375.99 - 218,375.99 15 131,311.27 131,311.27 131,311.27 - 131,311.27 Subtotal 865,603.79 164,597.00 1,030,200.79 1,030,200.79 - 1,030,200.79 16 ¥ 140,212.33 140,212.33 100,417.33 39,795.00 3,979.50 136,232.83 17 294,611.05 294,611.05 41,730.65 252,880.40 25,288.04 269,323.01 18 613,613.60 613,613.60 553,181.96 60,431.64 60,431.64 553,181.96 Reconcile const cost (240,834.69) 240,834.69 19 540,946.07 540,946.07 540,946.07 54,094.61 486,851.46 20 744,263.60 744,263.60 1,835.00 742,428.60 74,242.86 670,020.74 21 763,552.67 763,552.67 - 763,552.67 76,355.27 687,197.40 22 440,184.82 440,184.82 - 440,184.82 44,018.48 418,709.04 Retainage paid out to subcontractor Inv #22 (22,542.70) 23 780,884.60 780,884.60 - 780,884.60 78,088.46 702,796.14 24 713,618.60 713,618.60 2,340.00 711,278.60 71,127.86 642,490.74 25 494,263.12 494,263.12 - 494,263.12 49,426.31 444 836.81 26 708,585.82 708,585.82 708,585.82 70,858.58 637,727.24 27 614,974.80 614,974.80 614,974.80 61,497.48 553,477.32 28 744,273.39 744,273.39 744,273.39 37,213.67 707,059.72 % of Retainage paid out to Contractor Inv #28 for Substantial Completion (252,870.80) 252,870.80 29 241,196.04 241,196.04 1,260.00 239,936.04 11,996.80 229,199.24 30 36,871.50 443,206.07 480,077.57 Totals 8,700,784.30 164,597.00 8,865,381.30 1,527,002.54 7,375,250.26 886,412.14 8,902,252.79 * Invoice 6 (for $10,280.85) revised to Invoice 5; Invoice 5 (for $20,339.55) remained ** Construction begins with this invoice *** Retainage reduced to 5% Contract Total All Phases $ 904,667.00 Change Order 1 170,854.54 Change Order 2 558,880.00 Change Order 3 178,784.69 Change Order 4 4,024,754.21 Change Order 5 6,237,084.60 Change Order 6 (2,118,627.44) Change Order 7 (741,693.02) Change Order 8 287,192.13 Change Order 9 (516,872.26) Change Order 10 (79,434.90) Change Order 11 30,261.54 Change Order 12 (33,598.30) Revised Contract Total S 8,902,252.79 Bal to finish plus retainage: $ 0.00 Date Paid 01/09/14 02/28/13 06/13/13 03/28/13 08/29/13 12/26/13 01/09/14 02/13/14 02/27/14 03/13/14 05/15/14 06/05/14 06/18/14 07/17/14 08/14/14 09/18/14 10/30/14 11/14/14 12/12/14 01/08/15 02/12/15 03/13/15 04/16/15 05/14/15 06/12/15 07/16/15 08/06/15 09/17/15 09/17/15 Check Number V1302590 V1303747 V1306299 V1304381 V1308319 V1401877 V1402098 V1403104 V1403411 V1403862 V1405666 V1406102 V1406435 V1407144 V1408220 V1409070 V1500851 V1501352 V1502092 V1502702 V1503465 V1504214 V1505043 V1505768 V1506628 V1507451 V1507937 V1509222 V1509222 SUNGARD PENTAMATION, INC. DATE: 11/20/2015 TIME: 09:09:49 ACCOUNTING PERIODS: SELECTION CRITERIA: TOTALED ON: FUND, ACCOUNT, PERIOD FUND - 301 - CAPITAL PROJECTS FUND ACCOUNT DATE TIE REFERENCE 2051100 CONTRACTS PAY-RETAINED% 09/30/13 19-1 NEW YEAR TOTAL PERIOD 1 02/06/14 21-5 V1402709 TOTAL PERIOD 5 04/03/14 21-7 1404435 TOTAL PERIOD 7 05/01/14 21-8 1405089 TOTAL PERIOD 8 07/10/14 21-10 1406967 TOTAL PERIOD 10 09/11/14 21-12 1408872 09/18/14 21-12 V1409070 TOTAL PERIOD 12 TOTAL CONTRACTS PAY-RETAINEDS TOTAL CAPITAL PROJECTS FUND TOTAL R