Loading...
HomeMy WebLinkAboutAcademy Phase I Expansion worksheetRevenues Master Plan per BB&P Bids - July 2013 Value Engineered Budget Project Actuals Variance 1 Bond Proceeds 8,500,000$ 8,500,000$ 8,500,000$ 8,579,231$ 79,231$ 2 BB&P Master Plan Correction - 225,000 225,000 225,000 - 3 BB&P Note Payable - 366,774 366,774 366,774 - 4 Donations - 1,000,000 1,000,000 1,087,758 87,758 IT Smart boards 130,000 West Parking Area 200,000 5 Interest Earned - - 10,000 13,738 3,738 6 Transfer In - - 500,000 536,398 36,398 7 Total Revenues 8,500,000$ 10,091,774$ 10,601,774$ 11,138,899$ 170,727$ 8 Expenditures9Hard Cost 10 Multi-Purpose -9,536 (includes Gen. Conditions & Contingency)1,441,881$ 2,255,250$ 2,060,767$ 1,844,158$ (216,609)$ 11 Field House -8,675 (includes Gen. Conditions & Contingency)1,224,583 2,376,020 1,811,538 1,200,168 (611,370) 12 Secondary -19,452 (includes Gen Conditions & Contingency)3,251,279 3,506,644 3,013,441 2,881,792 (131,649) 13 Additional Requirements - - 14 General Requirements - - 374,493 322,847 (51,646) 15 General Conditions - - 319,190 283,872 (35,318) 16 CM Fee - - 17 Miscellaneous 513,454 495,419 (18,035) 20 Labor Burden - - - 21 Insurance - Bonding - - - 22 Contingency 591,774 - - 23 Town - Site work/civil 813,690 - - West Parking Area 200,000 200,000 24 Utilities 70,000 70,000 59,952 (10,048) 25 Fence Relocation 15,000 15,000 4,286 (10,714) 26 Dirtwork 20,000 20,000 (20,000) 27 Irrigation/Power 40,000 40,000 25,030 (14,970) 28 Contingency 40,000 40,000 (40,000) 29 SF - Site work/civil - 484,051 450,047 428,954 (21,093) 30 Value Engineering Savings - - - 31 Credit Savings - Food Service, Controls, Piers (111,491) 111,491 32 Hard Cost Sub-total 7,323,207$ 8,806,965$ 8,816,439$ 7,746,479$ (1,069,961)$ 34 Soft Cost 35 Design/Engineering Fee 650,952$ -$ -$ -$ -$ 36 Architect - 450,000 450,000 386,302 (63,698) 37 Engineering - 100,000 100,000 78,235 (21,765) 38 Geo testing - - - - - 39 HVAC Controller 175,000 - - - 40 Design/Engineering Sub-total 650,952 725,000 550,000 464,537 (85,463) 41 42 IT/Security 325,476 300,476 - - - 43 Door Hardware - 25,000 - - - 44 Convergent Tech - - 115,238 121,754 6,516 45 AVI - - 115,238 144,150 28,912 Smart Boards 130,000 90,000 (40,000) 46 Synetra - - 100,000 188,300 88,300 47 Betterment Transfer 111,491 - (111,491) 48 IT/Security Sub-total 325,476 325,476 571,967 544,204 (27,763) 49 50 FF & E 650,952 - - - - 51 Kitchen - 202,000 - - - 52 Move in cost - 10,000 10,000 - (10,000) 53 Furniture (classroom/office)374,209 374,209 310,400 (63,809) 54 Audio Video 30,000 - - - 55 Athletic Equip 60,000 124,780 124,780 - 56 FF&E Sub-total 650,952$ 676,209$ 508,989$ 435,180$ (73,809)$ 57 58 Bond Fees - - - - 59 60 Total Soft-Cost 1,627,380$ 1,726,685$ 1,630,956$ 1,443,921$ (187,035)$ 61 Total Construction 8,950,587$ 10,533,650$ 10,447,395$ 9,190,400$ (1,256,996)$ 62 63 Portable Buildings 64 Purchase Current -$ 60,000$ 60,000$ 60,000$ - 65 New Portables - 179,896 179,896 179,896 - 66 Set up & deliver - 22,245 22,245 22,236 (9) 67 deck & ramps - 26,000 26,000 28,692 2,692 68 cover - 10,000 10,000 12,500 2,500 69 Temp controls - 7,000 7,000 4,595 (2,405) 70 Fire Alarm system - 8,000 8,000 7,469 (531) 71 Power - 22,000 22,000 22,099 99 72 IT/Data - 8,000 8,000 14,584 6,584 73 Fence - 1,000 1,000 957 (43) 74 Utilities 6,000 6,000 - (6,000) 75 FF&E 25,000 6,053 12,331 6,278 76 Portables Sub-total -$ 375,141$ 356,194$ 365,359$ 9,165$ 77 78 Total Cost 8,950,587$ 10,908,791$ 10,803,589$ 9,555,759$ (1,247,831)$ 79 80 Excess of Revenues over (under) Expenditures (450,587)$ (817,017)$ (201,815)$ 1,583,140$ 1,418,558$ Westlake Academy Phase I Expansion