{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["SUMMARY","Budget Worksheet"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SUMMARY","index":0,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["TITUSVILLE ALF"]
["Titusville, FL"]
["2025-07-18"]
[]
["BUDGET ESTIMATE "]
["4-Story, 137-Bed, Assisted Living Facility using Tunnel-Form Construction"]
[]
["Description","Beds","Area","Total","% of Building","%of Total","Cost per Key","SF Cost"]
["01 - General Conditions/Fee/Bond/Overhead",137,106915,2095850.35,{"$f":"D15/$D$33","v":9.1215922096144805E-2},{"$f":"D15/$D$33","v":9.1215922096144805E-2},{"$f":"D15/B15","v":15298.177737226279}]
["02 - Site Construction ",137,106915,{"$f":"C16*H16","v":0},null,0,{"$f":"D16/B16","v":0},{"$f":"'Budget Worksheet'!F15","v":0}]
["03 - Concrete",137,106915,{"$f":"C17*H17","v":4597345},0.20008635796401247,0.20008635796401247,{"$f":"D17/B17","v":33557.262773722628},{"$f":"'Budget Worksheet'!F18","v":43}]
["04 - Masonry",137,106915,962235,4.1878540038979353E-2,4.1878540038979353E-2,{"$f":"D18/B18","v":7023.6131386861316},{"$f":"'Budget Worksheet'!F21","v":9}]
["05 - Metals",137,106915,588032.5,2.5592441134931827E-2,2.5592441134931827E-2,4292.2080291970806,{"$f":"'Budget Worksheet'!F24","v":5.5}]
["06 - Wood, Plastics, and Composites",137,106915,487499.99999999994,2.1217050168620379E-2,2.1217050168620379E-2,3558.3941605839414,{"$f":"'Budget Worksheet'!F29","v":4.5596969555254168}]
["07 - Thermal and Moisture Protection",137,106915,987644.54999999993,4.2984418392029745E-2,4.2984418392029745E-2,7209.0843065693425,{"$f":"'Budget Worksheet'!F36","v":9.2376612262077344}]
["08 - Openings",137,106915,1799000.0000000002,7.8296355391483233E-2,7.8296355391483233E-2,13131.386861313871,{"$f":"'Budget Worksheet'!F42","v":16.826450918954311}]
["09 - Finishes",137,106915,2688156.9499999997,0.11699438127030881,0.11699438127030881,19621.583576642333,{"$f":"'Budget Worksheet'!F50","v":25.142935509516903}]
["10 - Specialties",137,106915,171000,7.4422883668391494E-3,7.4422883668391494E-3,1248.1751824817518,{"$f":"'Budget Worksheet'!F62","v":1.5994013936304541}]
["11 - Equipment (By Owner)",137,106915,0,0,0,0,{"$f":"'Budget Worksheet'!F70","v":0}]
["12 - FF&E (Install Only)",137,106915,100000,4.3522154192041813E-3,4.3522154192041813E-3,729.92700729927003,{"$f":"'Budget Worksheet'!F73","v":0.93532245241547018}]
["13 - Special Construction (Swimming Pool)",137,106915,0,0,0,0,{"$f":"'Budget Worksheet'!F78","v":0}]
["14 - Conveying Equipment",137,106915,260000,1.1315760089930871E-2,1.1315760089930871E-2,1897.8102189781023,{"$f":"'Budget Worksheet'!F82","v":2.4318383762802225}]
["21 - Fire Suppression",137,106915,962235,4.1878540038979353E-2,4.1878540038979353E-2,7023.6131386861316,{"$f":"'Budget Worksheet'!F84","v":9}]
["22.5 - HVAC & Plumbing",137,106915,4525196,0.19694627806121084,0.19694627806121084,33030.627737226278,{"$f":"'Budget Worksheet'!F85+'Budget Worksheet'!F87+'Budget Worksheet'!F86","v":42.32517420380676}]
["26 - Electrical",137,106915,{"$f":"C31*H31","v":2127608.5},9.2598105197298788E-2,9.2598105197298788E-2,15529.98905109489,{"$f":"'Budget Worksheet'!F96","v":19.899999999999999}]
["30 - Contingency",137,106915,{"$f":"C32*H32","v":625000},2.7201346370026133E-2,2.7201346370026133E-2,4562.0437956204378,{"$f":"'Budget Worksheet'!F99","v":5.8457653275966885}]
["Building Total:",137,106915,{"$f":"SUM(D15:$D$32)","v":22976803.850000001},{"$f":"SUM(E15:E31)","v":0.97279865362997375},1,{"$f":"SUM(G15:G32)","v":167713.89671532848},{"$f":"SUM(H15:H32)","v":195.304246363934}]

{"sheet":"Budget Worksheet","index":1,"n_rows":103,"n_cols":7,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["Titusville ALF Budget Worksheet"]
[]
["Floors",4]
["Beds",137]
["Area",106915]
[]
["Description/Division","Qty","Unit","UP","Total","$/SF","$/Unit"]
["Division 1"]
["General Conditions",1,"LS",1095850,{"$f":"B9*D9","v":1095850},{"$f":"E9/$B$5","v":10.24973109479493},{"$f":"E9/$B$4","v":7998.905109489051}]
["Subtotal",null,null,null,{"$f":"SUM(E9:E9)","v":1095850},{"$f":"SUM(F9:F9)","v":10.24973109479493},{"$f":"SUM(G9:G9)","v":7998.905109489051}]
["Division 2"]
["Site Work - By Others (Misc. Allowance)",0,"LS",null,{"$f":"B12*D12","v":0},{"$f":"E12/$B$5","v":0},{"$f":"E12/$B$4","v":0}]
["Irrigation & Landscaping - By Owner",0,"LS",0,{"$f":"B13*D13","v":0},{"$f":"E13/$B$5","v":0},{"$f":"E13/$B$4","v":0}]
["Bike Racks",0,"EA",0,0,0,0]
["Subtotal",null,null,null,{"$f":"SUM(E12:E14)","v":0},{"$f":"SUM(F12:F14)","v":0},{"$f":"SUM(G12:G14)","v":0}]
["Division 3"]
["Tunnel-Form Construction",{"$f":"$B$5","v":106915},"SF",43,{"$f":"B17*D17","v":4597345},{"$f":"E17/$B$5","v":43},{"$f":"E17/$B$4","v":33557.262773722628}]
["Subtotal",null,null,null,{"$f":"SUM(E17:E17)","v":4597345},{"$f":"SUM(F17:F17)","v":43},{"$f":"SUM(G17:G17)","v":33557.262773722628}]
["Division 4"]
["Masonry",{"$f":"$B$5","v":106915},"SF",9,{"$f":"B20*D20","v":962235},{"$f":"E20/$B$5","v":9},{"$f":"E20/$B$4","v":7023.6131386861316}]
["Subtotal",null,null,null,{"$f":"SUM(E20:E20)","v":962235},{"$f":"SUM(F20:F20)","v":9},{"$f":"SUM(G20:G20)","v":7023.6131386861316}]
["Division 5"]
["Structural Steel",{"$f":"$B$5","v":106915},"SF",5.5,{"$f":"B23*D23","v":588032.5},{"$f":"E23/$B$5","v":5.5},{"$f":"E23/$B$4","v":4292.2080291970806}]
["Subtotal",null,null,null,{"$f":"SUM(E23:E23)","v":588032.5},{"$f":"SUM(F23:F23)","v":5.5},{"$f":"SUM(G23:G23)","v":4292.2080291970806}]
["Division 6"]
["Rough Carpentry",1,"LS",20000,{"$f":"B26*D26","v":20000},{"$f":"E26/$B$5","v":0.18706449048309404},{"$f":"E26/$B$4","v":145.98540145985402}]
["Millwork ",1,"LS",450000,{"$f":"B27*D27","v":450000},{"$f":"E27/$B$5","v":4.2089510358696156},{"$f":"E27/$B$4","v":3284.6715328467153}]
["Guestroom Vanities & Tops",100,"EA",175,17500,0.16368142917270728,127.73722627737226]
["Subtotal",null,null,null,{"$f":"SUM(E26:E28)","v":487500},{"$f":"SUM(F26:F28)","v":4.5596969555254168},{"$f":"SUM(G26:G28)","v":3558.3941605839418}]
["Division 7"]
["Waterproofing",1,"LS",10000,{"$f":"B31*D31","v":10000},{"$f":"E31/$B$5","v":9.3532245241547018E-2},{"$f":"E31/$B$4","v":72.992700729927009}]
["Caulking & Sealants",1,"LS",40000,{"$f":"B32*D32","v":40000},{"$f":"E32/$B$5","v":0.37412898096618807},{"$f":"E32/$B$4","v":291.97080291970804}]
["Fireproofing Steel",0,"LS",0,0,0,0]
["EIFS System (100%)",{"$f":"B5","v":106915},"SF",6.1,{"$f":"B34*D34","v":652181.5},6.1,{"$f":"E34/$B$4","v":4760.4489051094888}]
["TPO Roofing System",{"$f":"B5","v":106915},"SF",2.67,285463.05,2.67,2083.671897810219]
["Subtotal",null,null,null,{"$f":"SUM(E31:E35)","v":987644.55},{"$f":"SUM(F31:F35)","v":9.2376612262077344},{"$f":"SUM(G31:G35)","v":7209.0843065693425}]
["Division 8"]
["Doors, Frames, Hardware",1,"LS",825000,{"$f":"B38*D38","v":825000},{"$f":"E38/$B$5","v":7.7164102324276298},{"$f":"E38/$B$4","v":6021.8978102189785}]
["Automatic Vestibule Door",0,"LS",0,{"$f":"B39*D39","v":0},{"$f":"E39/$B$5","v":0},{"$f":"E39/$B$4","v":0}]
["Storefront & Windows",1,"LS",974000,974000,9.1100406865266805,7109.4890510948908]
["Card Access Systems (NIC)",0,"LS",0,0,0,0]
["Subtotal",null,null,null,{"$f":"SUM(E38:E41)","v":1799000},{"$f":"SUM(F38:F41)","v":16.826450918954311},{"$f":"SUM(G38:G41)","v":13131.386861313869}]
["Division 9"]
["Framing, Insulation, Drywall (Hotel)",{"$f":"$B$5-B45","v":102915},"SF",17,{"$f":"B44*D44","v":1749555},{"$f":"E44/$B$5","v":16.363980732357479},{"$f":"E44/$B$4","v":12770.474452554745}]
["Framing, Insulation, Drywall (Shell Only)",4000,"SF",12,{"$f":"B45*D45","v":48000},{"$f":"E45/$B$5","v":0.44895477715942572},{"$f":"E45/$B$4","v":350.36496350364962}]
["Accoustical Ceilings",{"$f":"$B$5","v":106915},"SF",0.6,{"$f":"B46*D46","v":64149},{"$f":"E46/$B$5","v":0.6},{"$f":"E46/$B$4","v":468.24087591240874}]
["Flooring & Tile",106915,"SF",4,427660,4,3121.6058394160582]
["Carpet (Install Only)",106915,"SF",0.65,{"$f":"B48*D48","v":69494.75},0.65,{"$f":"E48/$B$4","v":507.2609489051095}]
["Paint & Install Wallcoverings",106915,"SF",3.08,329298.2,3.08,2403.6364963503652]
["Subtotal",null,null,null,{"$f":"SUM(E44:E49)","v":2688156.95},{"$f":"SUM(F44:F49)","v":25.142935509516903},{"$f":"SUM(G44:G49)","v":19621.583576642337}]
["Division 10"]
["Lockers",1,"LS",5000,{"$f":"B52*D52","v":5000},{"$f":"E52/$B$5","v":4.6766122620773509E-2},{"$f":"E52/$B$4","v":36.496350364963504}]
["Shower & Tub Surrounds",100,"EA",550,55000,0.5144273488285086,401.45985401459853]
["Fire Extinguishers & Cabinets",1,"LS",7500,7500,7.0149183931160264E-2,54.744525547445257]
["Glass Shower Doors",100,"EA",450,45000,0.42089510358696158,328.46715328467155]
["Bath Accessories",1,"LS",35000,35000,0.32736285834541456,255.47445255474452]
["Storage Shelving BOH (NIC)",null,"LS",0,0,0,0]
["Louvers, Vents, Screens",0,"LS",20000,0,0,0]
["Patio Canopy",1,"LS",23500,{"$f":"B59*D59","v":23500},0.2198007763176355,{"$f":"E59/$B$4","v":171.53284671532847}]
["Exterior Bldg. Signage (NIC)",0,"LS",0,{"$f":"B60*D60","v":0},0,{"$f":"E60/$B$4","v":0}]
["Interior Bldg. Signage (NIC)",0,"LS",0,0,0,0]
["Subtotal",null,null,null,{"$f":"SUM(E52:E61)","v":171000},{"$f":"SUM(F52:F61)","v":1.5994013936304541},{"$f":"SUM(G52:G61)","v":1248.175182481752}]
["Division 11"]
["Kitchen & Bar Equipment (NIC)",0,"LS",0,{"$f":"B64*D64","v":0},{"$f":"E64/$B$5","v":0},{"$f":"E64/$B$4","v":0}]
["Appliances (NIC)",0,"LS",0,{"$f":"B65*D65","v":0},{"$f":"E65/$B$5","v":0},{"$f":"E65/$B$4","v":0}]
["Fitness Equipment (NIC)",0,"LS",0,0,0,0]
["Laundry Equipment (NIC)",0,"LS",0,0,0,0]
["Ice Machines (NIC)",0,"LS",0,0,0,0]
["Guest Laundry (NIC)",0,"LS",0,0,0,0]
["Subtotal",null,null,null,{"$f":"SUM(E64:E69)","v":0},{"$f":"SUM(F64:F69)","v":0},{"$f":"SUM(G64:G69)","v":0}]
["Division 12"]
["FF&E Installation (Warehousing By Others)",1,"LS",100000,{"$f":"B72*D72","v":100000},{"$f":"E72/$B$5","v":0.93532245241547018},{"$f":"E72/$B$4","v":729.92700729927003}]
["Subtotal",null,null,null,{"$f":"SUM(E72:E72)","v":100000},{"$f":"SUM(F72:F72)","v":0.93532245241547018},{"$f":"SUM(G72:G72)","v":729.92700729927003}]
["Division 13"]
["Swimming Pool w/ADA Lift",0,"LS",175000,{"$f":"B75*D75","v":0},{"$f":"E75/$B$5","v":0},{"$f":"E75/$B$4","v":0}]
["Pool Fence & Gates",0,"LS",30000,{"$f":"B76*D76","v":0},{"$f":"E76/$B$5","v":0},{"$f":"E76/$B$4","v":0}]
["Hardscape Brick Pavers",0,"LS",50000,0,0,0]
["Subtotal",null,null,null,{"$f":"SUM(E75:E77)","v":0},{"$f":"SUM(F75:F77)","v":0},{"$f":"SUM(G75:G77)","v":0}]
["Division 14"]
["Elevators",8,"STOPS",32500,{"$f":"B80*D80","v":260000},{"$f":"E80/$B$5","v":2.4318383762802225},{"$f":"E80/$B$4","v":1897.8102189781023}]
["Linen Chute",0,"LS",null,{"$f":"B81*D81","v":0},{"$f":"E81/$B$5","v":0},{"$f":"E81/$B$4","v":0}]
["Subtotal",null,null,null,{"$f":"SUM(E80:E81)","v":260000},{"$f":"SUM(F80:F81)","v":2.4318383762802225},{"$f":"SUM(G80:G81)","v":1897.8102189781023}]
["Division 15"]
["Fire Sprinkler System",{"$f":"$B$5","v":106915},"SF",9,{"$f":"B84*D84","v":962235},{"$f":"E84/$B$5","v":9},{"$f":"E84/$B$4","v":7023.6131386861316}]
["Plumbing (Hotel)",{"$f":"$B$5-B86","v":102915},"SF",17,{"$f":"B85*D85","v":1749555},{"$f":"E85/$B$5","v":16.363980732357479},{"$f":"E85/$B$4","v":12770.474452554745}]
["Plumbing (Shell Only)",4000,"SF",15,{"$f":"B86*D86","v":60000},{"$f":"E86/$B$5","v":0.56119347144928211},{"$f":"E86/$B$4","v":437.95620437956205}]
["HVAC",{"$f":"$B$5","v":106915},"SF",25.4,2715641,25.4,19822.197080291971]
["Subtotal",null,null,null,{"$f":"SUM(E84:E87)","v":5487431},{"$f":"SUM(F84:F87)","v":51.32517420380676},{"$f":"SUM(G84:G87)","v":40054.240875912408}]
["Division 16"]
["Electrical (Hotel)",{"$f":"$B$5-B91","v":102915},"SF",18,{"$f":"B90*D90","v":1852470},{"$f":"E90/$B$5","v":17.32656783426086},{"$f":"E90/$B$4","v":13521.678832116788}]
["Electrical (Shell Only)",4000,"SF",18,{"$f":"B91*D91","v":72000},{"$f":"E91/$B$5","v":0.67343216573913856},{"$f":"E91/$B$4","v":525.54744525547449}]
["Fire Alarm",{"$f":"$B$5","v":106915},"SF",1.25,{"$f":"B92*D92","v":133643.75},{"$f":"E92/$B$5","v":1.25},{"$f":"E92/$B$4","v":975.50182481751824}]
["BDA System",106915,"SF",0.65,69494.75,0.65,507.2609489051095]
["Data Cabling (NIC)",0,"LS",0,0,0,0]
["Data & Comm Equip. (NIC)",0,"LS",0,0,0,0]
["Subtotal",null,null,null,{"$f":"SUM(E90:E95)","v":2127608.5},{"$f":"SUM(F90:F95)","v":19.899999999999999},{"$f":"SUM(G90:G95)","v":15529.98905109489}]
["Division 17"]
["Contingency",1,"LS",625000,{"$f":"B98*D98","v":625000},{"$f":"E98/$B$5","v":5.8457653275966885},{"$f":"E98/$B$4","v":4562.0437956204378}]
["Subtotal",null,null,null,{"$f":"SUM(E98:E98)","v":625000},{"$f":"SUM(F98:F98)","v":5.8457653275966885},{"$f":"SUM(G98:G98)","v":4562.0437956204378}]
[]
[null,null,null,"Subtotal Direct Cost:",{"$f":"E99+E96+E88+E82+E78+E73+E62+E50+E42+E36+E29+E24+E21+E18+E15+E10","v":21976803.5},{"$f":"E101/$B$5","v":205.55397745872889},{"$f":"E101/$B$4","v":160414.62408759125}]
[null,null,null,"Fee:",1000000,{"$f":"E102/$B$5","v":9.3532245241547027},{"$f":"E102/$B$4","v":7299.270072992701}]
[null,null,null,"Grand Total:",{"$f":"SUM(E101:E102)","v":22976803.5},{"$f":"E103/$B$5","v":214.90720198288361},{"$f":"E103/$B$4","v":167713.89416058394}]