{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Read Me","1. Staff_Headcount","2. Salaries_&_Wages","3. Payroll_Taxes_&_Benefits","4. Corporate_&_Misc_Costs","5. Insurance & Bond","6. Variable_Costs","7. Fixed_Costs","8. Transition & Startup","9. Summary"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":14,"n_cols":1,"rows_kept":14}
["This pricing form is provided as an example and template for PROPOSERS to use when generating price PROPOSALS in response to Transit Operations and Maintenance Services. The workbook includes numerous formulas and links, and is not password protected. PROPOSERS should take care to ensure that all formulas and links are correct when PROPOSALS are submitted. Price PROPOSALS must be submitted in un-protected executable Excel format with all appropriate formulas and links, to enable complete cost analysis. Password protected price PROPOSALS may be considered non-responsive, unless approved by RABA prior to submittal."]
[]
["For questions regarding the pricing form, please contact Link Transit Manager @ jandoh@burlingtonnc.gov"]
[]
["Pricing Form Instructions:"]
["1. Complete the Staff Headcount worksheet for all base and option years. Indicate the actual number of staff planned for each position for each year. Add, remove or modify positions as needed."]
["2. Complete the Salaries & Wages worksheet.The list of positions should update automatically based on changes to the positions listed on the Headcount worksheet. Update links and formulas as needed."]
["3. Complete the Payroll Taxes & Benefits worksheet.The list of positions should update automatically based on changes to the positions listed on the Headcount worksheet. Update links and formulas as needed."]
["4. Complete the Corporate & Misc. Costs worksheet. In Column B, indicate whether each cost is variable or fixed. Add, remove or modify cost items as needed. Update links and formulas as needed."]
["5. Complete the Variable Costs Worksheet. Include all variable cost subtotals for each contract year. Update links and formulas as needed."]
["6. Complete the Insurance & Bond worksheet. Update fields as needed."]
["7. Complete the Fixed Costs Worksheet. Include all variable cost subtotals for each contract year. Update links and formulas as needed."]
["8. Complete the Transition & Startup worksheet. Include all transition and project startup related costs."]
["9. Update links and formulas as appropriate, and complete the Summary worksheet. Add lines as needed for fixed and variable prices offered."]

{"sheet":"1. Staff_Headcount","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"merged":[[0,0,1,0]]}
["Position Headcount","Base Year 1","Base Year 2","Base Year 3","Option Year 4","Option Year 5","Base Term Increase","Option Years Increase","5-Year Increase"]
[null,"7/1/2025-6/30/2026","7/1/2026-6/30/2027","7/1/2027-6/30/2028","7/1/2028-6/30/2029","7/1/2029-6/30/2030","7/1/2025-6/30/2028","7/1/2028-6/30/2030","7/1/2025-6/30/2030"]
["Position","Headcount","Headcount","Headcount","Headcount","Headcount","Net Increase","Net Increase","Net Increase"]
["Management:"]
["General Manager",{"v":1,"d":"1.0"},{"$nulls":4},{"$f":"MAX(B5:D5)-MIN(B5:D5)","v":0},{"$f":"MAX(E5:F5)-MIN(E5:F5)","v":0},{"$f":"MAX(B5:F5)-MIN(B5:F5)","v":0}]
["Maintenance Manager",{"v":1,"d":"1.0"},{"$nulls":4},{"$f":"MAX(B6:D6)-MIN(B6:D6)","v":0},{"$f":"MAX(E6:F6)-MIN(E6:F6)","v":0},{"$f":"MAX(B6:F6)-MIN(B6:F6)","v":0}]
["Operations & Safety Manager",{"v":1,"d":"1.0"},{"$nulls":4},{"$f":"MAX(B7:D7)-MIN(B7:D7)","v":0},{"$f":"MAX(E7:F7)-MIN(E7:F7)","v":0},{"$f":"MAX(B7:F7)-MIN(B7:F7)","v":0}]
[]
[]
[]
[]
["Non-Management:"]
["Fixed-Route Driver (Full Time)",{"$nulls":5},{"$f":"MAX(B13:D13)-MIN(B13:D13)","v":0},{"$f":"MAX(E13:F13)-MIN(E13:F13)","v":0},{"$f":"MAX(B13:F13)-MIN(B13:F13)","v":0}]
["Fixed-Route Driver (Part Time)",{"$nulls":5},{"$f":"MAX(B14:D14)-MIN(B14:D14)","v":0},{"$f":"MAX(E14:F14)-MIN(E14:F14)","v":0},{"$f":"MAX(B14:F14)-MIN(B14:F14)","v":0}]
["Paratransit Driver (Full Time)",{"$nulls":5},{"$f":"MAX(B15:D15)-MIN(B15:D15)","v":0},{"$f":"MAX(E15:F15)-MIN(E15:F15)","v":0},{"$f":"MAX(B15:F15)-MIN(B15:F15)","v":0}]
["Paratransit Driver (Part Time)",{"$nulls":5},{"$f":"MAX(B16:D16)-MIN(B16:D16)","v":0},{"$f":"MAX(E16:F16)-MIN(E16:F16)","v":0},{"$f":"MAX(B16:F16)-MIN(B16:F16)","v":0}]
["Dispatcher",{"$nulls":5},{"$f":"MAX(B17:D17)-MIN(B17:D17)","v":0},{"$f":"MAX(E17:F17)-MIN(E17:F17)","v":0},{"$f":"MAX(B17:F17)-MIN(B17:F17)","v":0}]
["Road Supervisor",{"$nulls":5},{"$f":"MAX(B18:D18)-MIN(B18:D18)","v":0},{"$f":"MAX(E18:F18)-MIN(E18:F18)","v":0},{"$f":"MAX(B18:F18)-MIN(B18:F18)","v":0}]
["Customer Service Rep.",{"$nulls":5},{"$f":"MAX(B19:D19)-MIN(B19:D19)","v":0},{"$f":"MAX(E19:F19)-MIN(E19:F19)","v":0},{"$f":"MAX(B19:F19)-MIN(B19:F19)","v":0}]
["Adv. Level Mech./Tech-A",{"$nulls":5},{"$f":"MAX(B20:D20)-MIN(B20:D20)","v":0},{"$f":"MAX(E20:F20)-MIN(E20:F20)","v":0},{"$f":"MAX(B20:F20)-MIN(B20:F20)","v":0}]
["Journeyl Level Mech./Tech-B",{"$nulls":5},{"$f":"MAX(B21:D21)-MIN(B21:D21)","v":0},{"$f":"MAX(E21:F21)-MIN(E21:F21)","v":0},{"$f":"MAX(B21:F21)-MIN(B21:F21)","v":0}]
["Entry Level Mech./Tech-C",{"$nulls":5},{"$f":"MAX(B22:D22)-MIN(B22:D22)","v":0},{"$f":"MAX(E22:F22)-MIN(E22:F22)","v":0},{"$f":"MAX(B22:F22)-MIN(B22:F22)","v":0}]
["Maintenance Utility Worker",{"$nulls":5},{"$f":"MAX(B23:D23)-MIN(B23:D23)","v":0},{"$f":"MAX(E23:F23)-MIN(E23:F23)","v":0},{"$f":"MAX(B23:F23)-MIN(B23:F23)","v":0}]
["Administrative Assistant",{"$nulls":5},{"$f":"MAX(B24:D24)-MIN(B24:D24)","v":0},{"$f":"MAX(E24:F24)-MIN(E24:F24)","v":0},{"$f":"MAX(B24:F24)-MIN(B24:F24)","v":0}]
["Safety Trainer",{"$nulls":5},{"$f":"MAX(B25:D25)-MIN(B25:D25)","v":0},{"$f":"MAX(E25:F25)-MIN(E25:F25)","v":0},{"$f":"MAX(B25:F25)-MIN(B25:F25)","v":0}]
[{"$nulls":6},{"$f":"MAX(B26:D26)-MIN(B26:D26)","v":0},{"$f":"MAX(E26:F26)-MIN(E26:F26)","v":0},{"$f":"MAX(B26:F26)-MIN(B26:F26)","v":0}]
[{"$nulls":6},{"$f":"MAX(B27:D27)-MIN(B27:D27)","v":0},{"$f":"MAX(E27:F27)-MIN(E27:F27)","v":0},{"$f":"MAX(B27:F27)-MIN(B27:F27)","v":0}]
[{"$nulls":6},{"$f":"MAX(B28:D28)-MIN(B28:D28)","v":0},{"$f":"MAX(E28:F28)-MIN(E28:F28)","v":0},{"$f":"MAX(B28:F28)-MIN(B28:F28)","v":0}]
[{"$nulls":6},{"$f":"MAX(B29:D29)-MIN(B29:D29)","v":0},{"$f":"MAX(E29:F29)-MIN(E29:F29)","v":0},{"$f":"MAX(B29:F29)-MIN(B29:F29)","v":0}]
[{"$nulls":6},{"$f":"MAX(B30:D30)-MIN(B30:D30)","v":0},{"$f":"MAX(E30:F30)-MIN(E30:F30)","v":0},{"$f":"MAX(B30:F30)-MIN(B30:F30)","v":0}]
[{"$nulls":6},{"$f":"MAX(B31:D31)-MIN(B31:D31)","v":0},{"$f":"MAX(E31:F31)-MIN(E31:F31)","v":0},{"$f":"MAX(B31:F31)-MIN(B31:F31)","v":0}]
[{"$nulls":6},{"$f":"SUM(G5:G31)","v":0},{"$f":"MAX(E32:F32)-MIN(E32:F32)","v":0},{"$f":"SUM(I5:I31)","v":0}]

{"sheet":"2. Salaries_&_Wages","index":2,"n_rows":42,"n_cols":41,"rows_kept":42,"merged":[[0,0,1,0],[0,1,0,5],[0,6,0,10],[0,11,0,15],[0,16,0,20],[0,21,0,25],[0,26,0,30],[0,31,0,35],[0,36,0,40],[1,1,1,5],[1,6,1,10],[1,11,1,15],[1,16,1,20],[1,21,1,25],[1,26,1,30],[1,31,1,35],[1,36,1,40],[37,1,37,2],[37,6,37,7],[37,11,37,12],[37,16,37,17],[37,21,37,22]]}
["Salaries & Wages","Base Year 1",{"$nulls":4},"Base Year 2",{"$nulls":4},"Base Year 3",{"$nulls":4},"Option Year 4",{"$nulls":4},"Option Year 5",{"$nulls":4},"Base Term Totals",{"$nulls":4},"Option Year Totals",{"$nulls":4},"5-Year Totals"]
[null,"7/1/2025-6/30/2026",{"$nulls":4},"7/1/2026-6/30/2027",{"$nulls":4},"7/1/2027-6/30/2028",{"$nulls":4},"7/1/2028-6/30/2029",{"$nulls":4},"7/1/2029-6/30/2030",{"$nulls":4},"7/1/2025-6/30/2028",{"$nulls":4},"7/1/2028-6/30/2030",{"$nulls":4},"7/1/2025-6/30/2030"]
["Position","Salary/Wage","Hours*","Fixed Cost†","Hours-Based†","Total","Salary/Wage","Hours","Fixed Cost","Hours-Based","Total","Salary/Wage","Hours","Fixed Cost","Hours-Based","Total","Salary/Wage","Hours","Fixed Cost","Hours-Based","Total","Salary/Wage","Hours","Fixed Cost","Hours-Based","Total","Salary/Wage Δ","Hours","Fixed Cost","Hours-Based","Total","Salary/Wage Δ","Hours","Fixed Cost","Hours-Based","Total","Salary/Wage Δ","Hours","Fixed Cost","Hours-Based","Total"]
["Management:"]
["General Manager",0,{"$f":"2080*'1. Staff_Headcount'!B5","v":{"v":2080,"d":"2,080.0"}},{"$f":"B5","v":0},null,{"$f":"D5+E5","v":0},{"$nulls":4},{"$f":"SUM(I5:J5)","v":0},{"$nulls":4},{"$f":"SUM(N5:O5)","v":0},{"$nulls":4},{"$f":"SUM(S5:T5)","v":0},{"$nulls":4},{"$f":"SUM(X5:Y5)","v":0},{"$f":"MAX(B5,G5,L5)- MIN(B5,G5,L5)","v":0},{"$f":" SUM(C5,H5,M5)","v":{"v":2080,"d":"2,080.0"}},null,null,{"$f":"SUM(AC5:AD5)","v":0},{"$f":"MAX(Q5,V5)-MIN(,Q5,V5)","v":0},{"$f":"SUM(R5,W5)","v":0},null,null,{"$f":"SUM(AH5:AI5)","v":0},{"$f":"MAX(B5,G5,L5,Q5,V5)-MIN(B5,G5,L5,Q5,V5)","v":0},{"$f":"AB5+AG5","v":{"v":2080,"d":"2,080.0"}},null,null,{"$f":"SUM(AM5:AN5)","v":0}]
["Maintenance Manager",0,{"$f":"2080*'1. Staff_Headcount'!B6","v":{"v":2080,"d":"2,080.0"}},{"$f":"B6","v":0},null,{"$f":"D6+E6","v":0},{"$nulls":4},{"$f":"SUM(I6:J6)","v":0},{"$nulls":4},{"$f":"SUM(N6:O6)","v":0},{"$nulls":4},{"$f":"SUM(S6:T6)","v":0},{"$nulls":4},{"$f":"SUM(X6:Y6)","v":0},{"$f":"MAX(B6,G6,L6)- MIN(B6,G6,L6)","v":0},{"$f":" SUM(C6,H6,M6)","v":{"v":2080,"d":"2,080.0"}},null,null,{"$f":"SUM(AC6:AD6)","v":0},{"$f":"MAX(Q6,V6)-MIN(,Q6,V6)","v":0},{"$f":"SUM(R6,W6)","v":0},null,null,{"$f":"SUM(AH6:AI6)","v":0},{"$f":"MAX(B6,G6,L6,Q6,V6)-MIN(B6,G6,L6,Q6,V6)","v":0},{"$f":"AB6+AG6","v":{"v":2080,"d":"2,080.0"}},null,null,{"$f":"SUM(AM6:AN6)","v":0}]
[{"$f":"'1. Staff_Headcount'!A7","v":"Operations & Safety Manager"},0,{"$f":"2080*'1. Staff_Headcount'!B7","v":{"v":2080,"d":"2,080.0"}},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,{"v":2080,"d":"2,080.0"},null,null,0,0,0,null,null,0,0,{"v":2080,"d":"2,080.0"},null,null,0]
[{"$f":"'1. Staff_Headcount'!A8","v":0},0,{"$f":"2080*'1. Staff_Headcount'!B8","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A9","v":0},0,{"$f":"2080*'1. Staff_Headcount'!B9","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A10","v":0},0,{"$f":"2080*'1. Staff_Headcount'!B10","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A11","v":0},0,{"$f":"2080*'1. Staff_Headcount'!B11","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
["Non-Management:"]
[{"$f":"'1. Staff_Headcount'!A13","v":"Fixed-Route Driver (Full Time)"},0,{"$f":"2080*'1. Staff_Headcount'!B13","v":0},{"$f":"B13","v":0},null,{"$f":"D13+E13","v":0},{"$nulls":4},{"$f":"SUM(I13:J13)","v":0},{"$nulls":4},{"$f":"SUM(N13:O13)","v":0},{"$nulls":4},{"$f":"SUM(S13:T13)","v":0},{"$nulls":4},{"$f":"SUM(X13:Y13)","v":0},{"$f":"MAX(B13,G13,L13)- MIN(B13,G13,L13)","v":0},{"$f":" SUM(C13,H13,M13)","v":0},null,null,{"$f":"SUM(AC13:AD13)","v":0},{"$f":"MAX(Q13,V13)-MIN(,Q13,V13)","v":0},{"$f":"SUM(R13,W13)","v":0},null,null,{"$f":"SUM(AH13:AI13)","v":0},{"$f":"MAX(B13,G13,L13,Q13,V13)-MIN(B13,G13,L13,Q13,V13)","v":0},{"$f":"AB13+AG13","v":0},null,null,{"$f":"SUM(AM13:AN13)","v":0}]
[{"$f":"'1. Staff_Headcount'!A14","v":"Fixed-Route Driver (Part Time)"},0,{"$f":"2080*'1. Staff_Headcount'!B14","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A15","v":"Paratransit Driver (Full Time)"},0,{"$f":"2080*'1. Staff_Headcount'!B15","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A16","v":"Paratransit Driver (Part Time)"},0,{"$f":"2080*'1. Staff_Headcount'!B16","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A17","v":"Dispatcher"},0,{"$f":"2080*'1. Staff_Headcount'!B17","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A18","v":"Road Supervisor"},0,{"$f":"2080*'1. Staff_Headcount'!B18","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A19","v":"Customer Service Rep."},0,{"$f":"2080*'1. Staff_Headcount'!B19","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A20","v":"Adv. Level Mech./Tech-A"},0,{"$f":"2080*'1. Staff_Headcount'!B20","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A21","v":"Journeyl Level Mech./Tech-B"},0,{"$f":"2080*'1. Staff_Headcount'!B21","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A22","v":"Entry Level Mech./Tech-C"},0,{"$f":"2080*'1. Staff_Headcount'!B22","v":0},{"$f":"B22","v":0},null,{"$f":"D22+E22","v":0},{"$nulls":4},{"$f":"SUM(I22:J22)","v":0},{"$nulls":4},{"$f":"SUM(N22:O22)","v":0},{"$nulls":4},{"$f":"SUM(S22:T22)","v":0},{"$nulls":4},{"$f":"SUM(X22:Y22)","v":0},{"$f":"MAX(B22,G22,L22)- MIN(B22,G22,L22)","v":0},{"$f":" SUM(C22,H22,M22)","v":0},null,null,{"$f":"SUM(AC22:AD22)","v":0},{"$f":"MAX(Q22,V22)-MIN(,Q22,V22)","v":0},{"$f":"SUM(R22,W22)","v":0},null,null,{"$f":"SUM(AH22:AI22)","v":0},{"$f":"MAX(B22,G22,L22,Q22,V22)-MIN(B22,G22,L22,Q22,V22)","v":0},{"$f":"AB22+AG22","v":0},null,null,{"$f":"SUM(AM22:AN22)","v":0}]
[{"$f":"'1. Staff_Headcount'!A23","v":"Maintenance Utility Worker"},0,{"$f":"2080*'1. Staff_Headcount'!B23","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A24","v":"Administrative Assistant"},0,{"$f":"2080*'1. Staff_Headcount'!B24","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A25","v":"Safety Trainer"},0,{"$f":"2080*'1. Staff_Headcount'!B25","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A26","v":0},0,{"$f":"2080*'1. Staff_Headcount'!B26","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A27","v":0},0,{"$f":"2080*'1. Staff_Headcount'!B27","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A28","v":0},0,{"$f":"2080*'1. Staff_Headcount'!B28","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A29","v":0},0,{"$f":"2080*'1. Staff_Headcount'!B29","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A30","v":0},0,{"$f":"2080*'1. Staff_Headcount'!B30","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A31","v":0},0,{"$f":"2080*'1. Staff_Headcount'!B31","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[{"$f":"'1. Staff_Headcount'!A32","v":0},0,{"$f":"2080*'1. Staff_Headcount'!B32","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
["Employee Bonuses/Incentives:"]
["General Manager",0,{"$f":"2080*'1. Staff_Headcount'!B34","v":0},{"$f":"B34","v":0},null,{"$f":"D34+E34","v":0},{"$nulls":4},{"$f":"SUM(I34:J34)","v":0},{"$nulls":4},{"$f":"SUM(N34:O34)","v":0},{"$nulls":4},{"$f":"SUM(S34:T34)","v":0},{"$nulls":4},{"$f":"SUM(X34:Y34)","v":0},{"$f":"MAX(B34,G34,L34)- MIN(B34,G34,L34)","v":0},{"$f":" SUM(C34,H34,M34)","v":0},null,null,{"$f":"SUM(AC34:AD34)","v":0},{"$f":"MAX(Q34,V34)-MIN(,Q34,V34)","v":0},{"$f":"SUM(R34,W34)","v":0},null,null,{"$f":"SUM(AH34:AI34)","v":0},{"$f":"MAX(B34,G34,L34,Q34,V34)-MIN(B34,G34,L34,Q34,V34)","v":0},{"$f":"AB34+AG34","v":0},null,null,{"$f":"SUM(AM34:AN34)","v":0}]
[null,0,{"$f":"2080*'1. Staff_Headcount'!B35","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[null,0,{"$f":"2080*'1. Staff_Headcount'!B36","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
[null,0,{"$f":"2080*'1. Staff_Headcount'!B37","v":0},0,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0]
["Totals",null,null,{"$f":"SUM(D5:D37)","v":0},{"$f":"SUM(E5:E37)","v":0},{"$f":"D38+E38","v":0},null,null,{"$f":"SUM(I5:I37)","v":0},{"$f":"SUM(J5:J37)","v":0},{"$f":"SUM(K5:K37)","v":0},null,null,{"$f":"SUM(N5:N37)","v":0},{"$f":"SUM(O5:O37)","v":0},{"$f":"SUM(P5:P37)","v":0},null,null,{"$f":"SUM(S5:S37)","v":0},{"$f":"SUM(T5:T37)","v":0},{"$f":"SUM(U5:U37)","v":0},null,null,{"$f":"SUM(X5:X37)","v":0},{"$f":"SUM(Y5:Y37)","v":0},{"$f":"SUM(Z5:Z37)","v":0},null,{"$f":" SUM(C38,H38,M38)","v":0},{"$f":"SUM(AC5:AC37)","v":0},{"$f":"SUM(AD5:AD37)","v":0},{"$f":"SUM(AE5:AE37)","v":0},null,{"$f":"SUM(R38,W38)","v":0},{"$f":"SUM(AH5:AH37)","v":0},{"$f":"SUM(AI5:AI37)","v":0},{"$f":"SUM(AJ5:AJ37)","v":0},null,{"$f":"AB38+AG38","v":0},{"$f":"SUM(AM5:AM37)","v":0},{"$f":"SUM(AN5:AN37)","v":0},{"$f":"SUM(AO5:AO37)","v":0}]
[]
[]
["*Enter combined hours per year for all FTEs"]
["†Enter Salary x 1 for salaried positions; \nwage x hours for hourly positions"]

{"sheet":"3. Payroll_Taxes_&_Benefits","index":3,"n_rows":34,"n_cols":25,"rows_kept":34,"merged":[[0,0,1,0],[0,1,0,3],[0,4,0,6],[0,7,0,9],[0,10,0,12],[0,13,0,15],[0,16,0,18],[0,19,0,21],[0,22,0,24],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,10,1,12],[1,13,1,15],[1,16,1,18],[1,19,1,21],[1,22,1,24],[31,1,31,2],[31,4,31,5],[31,7,31,8],[31,10,31,11],[31,13,31,14]]}
["Payroll Taxes & \nEmployer-Paid Benefits","Base Year 1",null,null,"Base Year 2",null,null,"Base Year 3",null,null,"Option Year 4",null,null,"Option Year 5",null,null,"Base Term Totals",null,null,"Option Years Totals",null,null,"5-Year Totals"]
[null,"7/1/2025-6/30/2026",null,null,"7/1/2026-6/30/2027",null,null,"7/1/2027-6/30/2028",null,null,"7/1/2028-6/30/2029",null,null,"7/1/2029-6/30/2030",null,null,"7/1/2025-6/30/2028",null,null,"7/1/2028-6/30/2030",null,null,"7/1/2025-6/30/2030"]
["Position","Taxes*","Benefits*","Total","Taxes","Benefits","Total","Taxes","Benefits","Total","Taxes","Benefits","Total","Taxes","Benefits","Total","Taxes","Benefits","Total","Taxes","Benefits","Total","Taxes","Benefits","Total"]
["Management:"]
[{"$f":"'2. Salaries_&_Wages'!A5","v":"General Manager"},null,null,{"$f":"SUM(B5,C5)","v":0},null,null,{"$f":"SUM(E5,F5)","v":0},null,null,{"$f":"SUM(H5,I5)","v":0},null,null,{"$f":"SUM(K5,L5)","v":0},null,null,{"$f":"SUM(N5,O5)","v":0},{"$f":" SUM(B5,E5,H5)","v":0},{"$f":" SUM(C5,F5,I5)","v":0},{"$f":"Q5+R5","v":0},{"$f":"SUM(K5,N5)","v":0},{"$f":"SUM(L5,O5)","v":0},{"$f":"T5+U5","v":0},{"$f":"Q5+T5","v":0},{"$f":"R5+U5","v":0},{"$f":"W5+X5","v":0}]
[{"$f":"'2. Salaries_&_Wages'!A6","v":"Maintenance Manager"},null,null,{"$f":"SUM(B6,C6)","v":0},null,null,{"$f":"SUM(E6,F6)","v":0},null,null,{"$f":"SUM(H6,I6)","v":0},null,null,{"$f":"SUM(K6,L6)","v":0},null,null,{"$f":"SUM(N6,O6)","v":0},{"$f":" SUM(B6,E6,H6)","v":0},{"$f":" SUM(C6,F6,I6)","v":0},{"$f":"Q6+R6","v":0},{"$f":"SUM(K6,N6)","v":0},{"$f":"SUM(L6,O6)","v":0},{"$f":"T6+U6","v":0},{"$f":"Q6+T6","v":0},{"$f":"R6+U6","v":0},{"$f":"W6+X6","v":0}]
[{"$f":"'2. Salaries_&_Wages'!A7","v":"Operations & Safety Manager"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A8","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A9","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A10","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A11","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A12","v":"Non-Management:"}]
[{"$f":"'2. Salaries_&_Wages'!A13","v":"Fixed-Route Driver (Full Time)"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":" SUM(B13,E13,H13)","v":0},{"$f":" SUM(C13,F13,I13)","v":0},{"$f":"Q13+R13","v":0},{"$f":"SUM(K13,N13)","v":0},{"$f":"SUM(L13,O13)","v":0},{"$f":"T13+U13","v":0},{"$f":"Q13+T13","v":0},{"$f":"R13+U13","v":0},{"$f":"W13+X13","v":0}]
[{"$f":"'2. Salaries_&_Wages'!A14","v":"Fixed-Route Driver (Part Time)"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A15","v":"Paratransit Driver (Full Time)"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A16","v":"Paratransit Driver (Part Time)"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A17","v":"Dispatcher"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A18","v":"Road Supervisor"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A19","v":"Customer Service Rep."},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A20","v":"Adv. Level Mech./Tech-A"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A21","v":"Journeyl Level Mech./Tech-B"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A22","v":"Entry Level Mech./Tech-C"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A23","v":"Maintenance Utility Worker"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A24","v":"Administrative Assistant"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A25","v":"Safety Trainer"},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A26","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A27","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A28","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A29","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A30","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'2. Salaries_&_Wages'!A31","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},{"$f":"SUM(D5:D31)","v":0},null,null,{"$f":"SUM(G5:G31)","v":0},null,null,{"$f":"SUM(J5:J31)","v":0},null,null,{"$f":"SUM(M5:M31)","v":0},null,null,{"$f":"SUM(P5:P31)","v":0},0,0,0,0,0,0,0,0,0]
[]
["*Enter cumulative payroll taxes and \nbenefits for all FTEs in each position"]

{"sheet":"4. Corporate_&_Misc_Costs","index":4,"n_rows":33,"n_cols":10,"rows_kept":33,"merged":[[0,0,1,1]]}
["Corporate & Miscellaneous Costs",null,"Base Year 1","Base Year 2","Base Year 3","Option Year 4","Option Year 5","Base Term Increase","Option Years Increase","5-Year Increase"]
[null,null,"7/1/2025-6/30/2026","7/1/2026-6/30/2027","7/1/2027-6/30/2028","7/1/2028-6/30/2029","7/1/2029-6/30/2030","7/1/2025-6/30/2028","7/1/2028-6/30/2030","7/1/2025-6/30/2030"]
["Item","Fixed/Var.","Cost","Cost","Cost","Cost","Cost","Cost","Cost","Cost"]
["Corporate Taxes",{"$nulls":6},{"$f":"SUM(C4:E4)","v":0},{"$f":"SUM(F4:G4)","v":0},{"$f":"SUM(H4:I4)","v":0}]
["Licenses",{"$nulls":6},{"$f":"SUM(C5:E5)","v":0},{"$f":"SUM(F5:G5)","v":0},{"$f":"SUM(H5:I5)","v":0}]
["Permits",{"$nulls":6},{"$f":"SUM(C6:E6)","v":0},{"$f":"SUM(F6:G6)","v":0},0]
["Office Equipment",{"$nulls":6},{"$f":"SUM(C7:E7)","v":0},{"$f":"SUM(F7:G7)","v":0},0]
["Office Furniture & Fixture",{"$nulls":6},{"$f":"SUM(C8:E8)","v":0},{"$f":"SUM(F8:G8)","v":0},0]
["Computer Equipment",{"$nulls":6},{"$f":"SUM(C9:E9)","v":0},{"$f":"SUM(F9:G9)","v":0},0]
["Computer Software",{"$nulls":6},{"$f":"SUM(C10:E10)","v":0},{"$f":"SUM(F10:G10)","v":0},0]
["Field Communications/Radio",{"$nulls":6},{"$f":"SUM(C11:E11)","v":0},{"$f":"SUM(F11:G11)","v":0},0]
["Cell Phones",{"$nulls":6},{"$f":"SUM(C12:E12)","v":0},{"$f":"SUM(F12:G12)","v":0},0]
["Membership Dues & Subscriptions",{"$nulls":6},{"$f":"SUM(C13:E13)","v":0},{"$f":"SUM(F13:G13)","v":0},0]
["Relocation",{"$nulls":6},{"$f":"SUM(C14:E14)","v":0},{"$f":"SUM(F14:G14)","v":0},0]
["Travel",{"$nulls":6},{"$f":"SUM(C15:E15)","v":0},{"$f":"SUM(F15:G15)","v":0},0]
["Employee Uniforms",{"$nulls":6},{"$f":"SUM(C16:E16)","v":0},{"$f":"SUM(F16:G16)","v":0},0]
["Employee Recruitment & Screening",{"$nulls":6},{"$f":"SUM(C17:E17)","v":0},{"$f":"SUM(F17:G17)","v":0},0]
["Consulting & Professional Services",{"$nulls":6},{"$f":"SUM(C18:E18)","v":0},{"$f":"SUM(F18:G18)","v":0},0]
["Accounting & Payroll Processing",{"$nulls":6},{"$f":"SUM(C19:E19)","v":0},{"$f":"SUM(F19:G19)","v":0},0]
["Legal Services",{"$nulls":6},{"$f":"SUM(C20:E20)","v":0},{"$f":"SUM(F20:G20)","v":0},0]
["IT Support",{"$nulls":6},{"$f":"SUM(C21:E21)","v":0},{"$f":"SUM(F21:G21)","v":0},0]
[{"$nulls":7},{"$f":"SUM(C22:E22)","v":0},{"$f":"SUM(F22:G22)","v":0},0]
[{"$nulls":7},{"$f":"SUM(C23:E23)","v":0},{"$f":"SUM(F23:G23)","v":0},0]
[{"$nulls":7},{"$f":"SUM(C24:E24)","v":0},{"$f":"SUM(F24:G24)","v":0},0]
[{"$nulls":7},{"$f":"SUM(C25:E25)","v":0},{"$f":"SUM(F25:G25)","v":0},0]
[{"$nulls":7},{"$f":"SUM(C26:E26)","v":0},{"$f":"SUM(F26:G26)","v":0},0]
[{"$nulls":7},{"$f":"SUM(C27:E27)","v":0},{"$f":"SUM(F27:G27)","v":0},0]
[{"$nulls":7},{"$f":"SUM(C28:E28)","v":0},{"$f":"SUM(F28:G28)","v":0},0]
["General & Administrative Costs",{"$nulls":6},{"$f":"SUM(C29:E29)","v":0},{"$f":"SUM(F29:G29)","v":0},0]
["Corporate Overhead and Allocations",{"$nulls":6},{"$f":"SUM(C30:E30)","v":0},{"$f":"SUM(F30:G30)","v":0},0]
["Profit",{"$nulls":6},{"$f":"SUM(C31:E31)","v":0},{"$f":"SUM(F31:G31)","v":0},0]
[{"$nulls":7},{"$f":"SUM(C32:E32)","v":0},{"$f":"SUM(F32:G32)","v":0},0]
[null,null,{"$f":"SUM(C4:C32)","v":0},0,0,0,0,0,0,0]

{"sheet":"5. Insurance & Bond","index":5,"n_rows":33,"n_cols":14,"rows_kept":33,"merged":[[0,0,1,0],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10]]}
[null,"Base Year 1",null,"Base Year 2",null,"Base Year 3",null,"Option Year 4",null,"Option Year 5",null,"Base Term Total","Option Years Total","5 Years Total"]
[null,"7/1/2025-6/30/2026",null,"7/1/2026-6/30/2027",null,"7/1/2027-6/30/2028",null,"7/1/2028-6/30/2029",null,"7/1/2029-6/30/2030",null,"7/1/2025-6/30/2028","7/1/2028-6/30/2030","7/1/2025-6/30/2030"]
["Item","Coverage Limit","Premium/Cost","Coverage Limit","Premium/Cost","Coverage Limit","Premium/Cost","Coverage Limit","Premium/Cost","Coverage Limit","Premium/Cost","Premium/Cost","Premium/Cost","Premium/Cost"]
["Performance Bond",{"$nulls":10},{"$f":" SUM(C4,E4,G4)","v":0},{"$f":"SUM(I4,K4)","v":0},{"$f":"SUM(L4:M4)","v":0}]
[{"$nulls":11},{"$f":" SUM(C5,E5,G5)","v":0},{"$f":"SUM(I5,K5)","v":0},{"$f":"SUM(L5:M5)","v":0}]
["General Liability",{"$nulls":10},0,0,0]
["Automobile Liability",{"$nulls":10},0,0,0]
["Worker's Compensation",{"$nulls":10},0,0,0]
["Employee Theft/Crime Insurance",{"$nulls":10},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
[null,null,{"$f":"SUM(C4:C32)","v":0},null,{"$f":"SUM(E4:E32)","v":0},null,{"$f":"SUM(G4:G32)","v":0},null,{"$f":"SUM(I4:I32)","v":0},null,{"$f":"SUM(K4:K32)","v":0},{"$f":"SUM(L4:L32)","v":0},{"$f":"SUM(M4:M32)","v":0},{"$f":"SUM(N4:N32)","v":0}]

{"sheet":"6. Variable_Costs","index":6,"n_rows":33,"n_cols":25,"rows_kept":33,"merged":[[0,0,1,0],[0,1,0,3],[0,4,0,6],[0,7,0,9],[0,10,0,12],[0,13,0,15],[0,16,0,18],[0,19,0,21],[0,22,0,24],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,10,1,12],[1,13,1,15],[1,16,1,18],[1,19,1,21],[1,22,1,24],[32,1,32,2],[32,4,32,5],[32,7,32,8],[32,10,32,11],[32,13,32,14],[32,16,32,17],[32,19,32,20],[32,22,32,23]]}
["Variable Costs","Base Year 1",null,null,"Base Year 2",null,null,"Base Year 3",null,null,"Option Year 4",null,null,"Option Year 5",null,null,"Base Term Total",null,null,"Option Years Total",null,null,"5-Year Totals"]
[null,"7/1/2025-6/30/2026",null,null,"7/1/2026-6/30/2027",null,null,"7/1/2027-6/30/2028",null,null,"7/1/2028-6/30/2029",null,null,"7/1/2029-6/30/2030",null,null,"7/1/2025-6/30/2028",null,null,"7/1/2028-6/30/2030",null,null,"7/1/2025-6/30/2030"]
["Item","Units","$ Each","Total","Units","$ Each","Total","Units","$ Each","Total","Units","$ Each","Total","Units","$ Each","Total","Units","$ Each","Total","Units","$ Each","Total","Units","$ Each","Total"]
["Hourly Staff Wages",null,null,{"$f":"'2. Salaries_&_Wages'!E38","v":0},null,null,{"$f":"E4*F4","v":0},null,null,{"$f":"H4*I4","v":0},null,null,{"$f":"K4*L4","v":0},null,null,{"$f":"N4*O4","v":0},{"$f":"IFERROR( AVERAGE(B4,E4,H4),0)","v":0},{"$f":"IFERROR( AVERAGE(C4,F4,I4),0)","v":0},{"$f":" SUM(D4,G4,J4)","v":0},{"$f":"IFERROR(AVERAGE(K4,N4),0)","v":0},{"$f":"IFERROR(AVERAGE(,L4,O4),0)","v":0},{"$f":"SUM(M4,P4)","v":0},{"$f":"IFERROR(AVERAGE(B4,E4,H4,#REF!,#REF!,#REF!,#REF!,K4,N4,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C4,F4,I4,#REF!,#REF!,#REF!,#REF!,L4,O4,#REF!),0)","v":0},{"$f":"S4+V4","v":0}]
[{"$nulls":3},{"$f":"B5*C5","v":0},null,null,{"$f":"E5*F5","v":0},null,null,{"$f":"H5*I5","v":0},null,null,{"$f":"K5*L5","v":0},null,null,{"$f":"N5*O5","v":0},{"$f":"IFERROR( AVERAGE(B5,E5,H5,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C5,F5,I5,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":" SUM(D5,G5,J5)","v":0},{"$f":"IFERROR(AVERAGE(K5,N5,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L5,O5,#REF!),0)","v":0},{"$f":"SUM(M5,P5)","v":0},{"$f":"IFERROR(AVERAGE(B5,E5,H5,#REF!,#REF!,#REF!,#REF!,K5,N5,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C5,F5,I5,#REF!,#REF!,#REF!,#REF!,L5,O5,#REF!),0)","v":0},{"$f":"S5+V5","v":0}]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B6,E6,H6,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C6,F6,I6,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K6,N6,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L6,O6,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B6,E6,H6,#REF!,#REF!,#REF!,#REF!,K6,N6,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C6,F6,I6,#REF!,#REF!,#REF!,#REF!,L6,O6,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B7,E7,H7,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C7,F7,I7,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K7,N7,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L7,O7,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B7,E7,H7,#REF!,#REF!,#REF!,#REF!,K7,N7,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C7,F7,I7,#REF!,#REF!,#REF!,#REF!,L7,O7,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B8,E8,H8,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C8,F8,I8,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K8,N8,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L8,O8,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B8,E8,H8,#REF!,#REF!,#REF!,#REF!,K8,N8,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C8,F8,I8,#REF!,#REF!,#REF!,#REF!,L8,O8,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B9,E9,H9,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C9,F9,I9,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K9,N9,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L9,O9,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B9,E9,H9,#REF!,#REF!,#REF!,#REF!,K9,N9,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C9,F9,I9,#REF!,#REF!,#REF!,#REF!,L9,O9,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B10,E10,H10,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C10,F10,I10,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K10,N10,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L10,O10,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B10,E10,H10,#REF!,#REF!,#REF!,#REF!,K10,N10,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C10,F10,I10,#REF!,#REF!,#REF!,#REF!,L10,O10,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B11,E11,H11,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C11,F11,I11,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K11,N11,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L11,O11,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B11,E11,H11,#REF!,#REF!,#REF!,#REF!,K11,N11,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C11,F11,I11,#REF!,#REF!,#REF!,#REF!,L11,O11,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B12,E12,H12,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C12,F12,I12,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K12,N12,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L12,O12,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B12,E12,H12,#REF!,#REF!,#REF!,#REF!,K12,N12,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C12,F12,I12,#REF!,#REF!,#REF!,#REF!,L12,O12,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B13,E13,H13,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C13,F13,I13,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K13,N13,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L13,O13,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B13,E13,H13,#REF!,#REF!,#REF!,#REF!,K13,N13,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C13,F13,I13,#REF!,#REF!,#REF!,#REF!,L13,O13,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B14,E14,H14,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C14,F14,I14,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K14,N14,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L14,O14,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B14,E14,H14,#REF!,#REF!,#REF!,#REF!,K14,N14,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C14,F14,I14,#REF!,#REF!,#REF!,#REF!,L14,O14,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B15,E15,H15,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C15,F15,I15,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K15,N15,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L15,O15,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B15,E15,H15,#REF!,#REF!,#REF!,#REF!,K15,N15,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C15,F15,I15,#REF!,#REF!,#REF!,#REF!,L15,O15,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B16,E16,H16,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C16,F16,I16,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K16,N16,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L16,O16,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B16,E16,H16,#REF!,#REF!,#REF!,#REF!,K16,N16,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C16,F16,I16,#REF!,#REF!,#REF!,#REF!,L16,O16,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B17,E17,H17,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C17,F17,I17,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K17,N17,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L17,O17,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B17,E17,H17,#REF!,#REF!,#REF!,#REF!,K17,N17,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C17,F17,I17,#REF!,#REF!,#REF!,#REF!,L17,O17,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B18,E18,H18,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C18,F18,I18,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K18,N18,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L18,O18,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B18,E18,H18,#REF!,#REF!,#REF!,#REF!,K18,N18,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C18,F18,I18,#REF!,#REF!,#REF!,#REF!,L18,O18,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B19,E19,H19,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C19,F19,I19,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K19,N19,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L19,O19,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B19,E19,H19,#REF!,#REF!,#REF!,#REF!,K19,N19,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C19,F19,I19,#REF!,#REF!,#REF!,#REF!,L19,O19,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B20,E20,H20,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C20,F20,I20,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K20,N20,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L20,O20,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B20,E20,H20,#REF!,#REF!,#REF!,#REF!,K20,N20,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C20,F20,I20,#REF!,#REF!,#REF!,#REF!,L20,O20,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B21,E21,H21,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C21,F21,I21,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K21,N21,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L21,O21,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B21,E21,H21,#REF!,#REF!,#REF!,#REF!,K21,N21,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C21,F21,I21,#REF!,#REF!,#REF!,#REF!,L21,O21,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B22,E22,H22,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C22,F22,I22,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K22,N22,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L22,O22,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B22,E22,H22,#REF!,#REF!,#REF!,#REF!,K22,N22,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C22,F22,I22,#REF!,#REF!,#REF!,#REF!,L22,O22,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B23,E23,H23,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C23,F23,I23,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K23,N23,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L23,O23,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B23,E23,H23,#REF!,#REF!,#REF!,#REF!,K23,N23,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C23,F23,I23,#REF!,#REF!,#REF!,#REF!,L23,O23,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B24,E24,H24,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C24,F24,I24,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K24,N24,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L24,O24,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B24,E24,H24,#REF!,#REF!,#REF!,#REF!,K24,N24,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C24,F24,I24,#REF!,#REF!,#REF!,#REF!,L24,O24,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B25,E25,H25,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C25,F25,I25,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K25,N25,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L25,O25,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B25,E25,H25,#REF!,#REF!,#REF!,#REF!,K25,N25,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C25,F25,I25,#REF!,#REF!,#REF!,#REF!,L25,O25,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B26,E26,H26,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C26,F26,I26,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K26,N26,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L26,O26,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B26,E26,H26,#REF!,#REF!,#REF!,#REF!,K26,N26,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C26,F26,I26,#REF!,#REF!,#REF!,#REF!,L26,O26,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B27,E27,H27,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C27,F27,I27,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K27,N27,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L27,O27,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B27,E27,H27,#REF!,#REF!,#REF!,#REF!,K27,N27,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C27,F27,I27,#REF!,#REF!,#REF!,#REF!,L27,O27,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B28,E28,H28,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C28,F28,I28,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K28,N28,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L28,O28,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B28,E28,H28,#REF!,#REF!,#REF!,#REF!,K28,N28,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C28,F28,I28,#REF!,#REF!,#REF!,#REF!,L28,O28,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B29,E29,H29,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C29,F29,I29,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K29,N29,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L29,O29,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B29,E29,H29,#REF!,#REF!,#REF!,#REF!,K29,N29,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C29,F29,I29,#REF!,#REF!,#REF!,#REF!,L29,O29,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B30,E30,H30,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C30,F30,I30,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K30,N30,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L30,O30,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B30,E30,H30,#REF!,#REF!,#REF!,#REF!,K30,N30,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C30,F30,I30,#REF!,#REF!,#REF!,#REF!,L30,O30,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B31,E31,H31,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C31,F31,I31,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K31,N31,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L31,O31,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B31,E31,H31,#REF!,#REF!,#REF!,#REF!,K31,N31,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C31,F31,I31,#REF!,#REF!,#REF!,#REF!,L31,O31,#REF!),0)","v":0},0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IFERROR( AVERAGE(B32,E32,H32,#REF!,#REF!,#REF!,#REF!),0)","v":0},{"$f":"IFERROR( AVERAGE(C32,F32,I32,#REF!,#REF!,#REF!,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(K32,N32,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(,L32,O32,#REF!),0)","v":0},0,{"$f":"IFERROR(AVERAGE(B32,E32,H32,#REF!,#REF!,#REF!,#REF!,K32,N32,#REF!),0)","v":0},{"$f":"IFERROR(AVERAGE(C32,F32,I32,#REF!,#REF!,#REF!,#REF!,L32,O32,#REF!),0)","v":0},0]
[{"$nulls":3},{"$f":"SUM(D4:D32)","v":0},null,null,{"$f":"SUM(G4:G32)","v":0},null,null,{"$f":"SUM(J4:J32)","v":0},null,null,{"$f":"SUM(M4:M32)","v":0},null,null,{"$f":"SUM(P4:P32)","v":0},null,null,{"$f":"SUM(S4:S32)","v":0},null,null,{"$f":"SUM(V4:V32)","v":0},null,null,{"$f":"SUM(Y4:Y32)","v":0}]

{"sheet":"7. Fixed_Costs","index":7,"n_rows":33,"n_cols":25,"rows_kept":33,"merged":[[0,0,1,0],[0,1,0,3],[0,4,0,6],[0,7,0,9],[0,10,0,12],[0,13,0,15],[0,16,0,18],[0,19,0,21],[0,22,0,24],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,10,1,12],[1,13,1,15],[1,16,1,18],[1,19,1,21],[1,22,1,24],[32,1,32,2],[32,4,32,5],[32,7,32,8],[32,10,32,11],[32,13,32,14],[32,16,32,17],[32,19,32,20],[32,22,32,23]]}
["Fixed Costs","Base Year 1",null,null,"Base Year 2",null,null,"Base Year 3",null,null,"Option Year 4",null,null,"Option Year 5",null,null,"Base Term Total",null,null,"Option Years Total",null,null,"5-Year Totals"]
[null,"7/1/2025-6/30/2026",null,null,"7/1/2026-6/30/2027",null,null,"7/1/2027-6/30/2028",null,null,"7/1/2028-6/30/2029",null,null,"7/1/2029-6/30/2030",null,null,"7/1/2025-6/30/2028",null,null,"7/1/2028-6/30/2030",null,null,"7/1/2025-6/30/2030"]
["Item","Units","$ Each","Total","Units","$ Each","Total","Units","$ Each","Total","Units","$ Each","Total","Units","$ Each","Total","Units","$ Each","Total","Units","$ Each","Total","Units","$ Each","Total"]
["Salaried Staff Pay & Bonuses",null,null,{"$f":"'2. Salaries_&_Wages'!D38","v":0},null,null,{"$f":"E4*F4","v":0},null,null,{"$f":"H4*I4","v":0},null,null,{"$f":"K4*L4","v":0},null,null,{"$f":"N4*O4","v":0},{"$f":"IFERROR( AVERAGE(B4,E4,H4),0)","v":0},{"$f":"IFERROR( AVERAGE(C4,F4,I4),0)","v":0},{"$f":" SUM(D4,G4,J4)","v":0},{"$f":"IFERROR(AVERAGE(K4,N4),0)","v":0},{"$f":"IFERROR(AVERAGE(L4,O4),0)","v":0},{"$f":"SUM(M4,P4)","v":0},{"$f":"IFERROR(AVERAGE(B4,E4,H4,K4,N4),0)","v":0},{"$f":"IFERROR(AVERAGE(C4,F4,I4,L4,O4),0)","v":0},{"$f":"S4+V4","v":0}]
[{"$nulls":3},{"$f":"B5*C5","v":0},null,null,{"$f":"E5*F5","v":0},null,null,{"$f":"H5*I5","v":0},null,null,{"$f":"K5*L5","v":0},null,null,{"$f":"N5*O5","v":0},{"$f":"IFERROR( AVERAGE(B5,E5,H5),0)","v":0},{"$f":"IFERROR( AVERAGE(C5,F5,I5),0)","v":0},{"$f":" SUM(D5,G5,J5)","v":0},{"$f":"IFERROR(AVERAGE(K5,N5),0)","v":0},{"$f":"IFERROR(AVERAGE(L5,O5),0)","v":0},{"$f":"SUM(M5,P5)","v":0},{"$f":"IFERROR(AVERAGE(B5,E5,H5,K5,N5),0)","v":0},{"$f":"IFERROR(AVERAGE(C5,F5,I5,L5,O5),0)","v":0},{"$f":"S5+V5","v":0}]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},{"$f":"SUM(D4:D32)","v":0},null,null,{"$f":"SUM(G4:G32)","v":0},null,null,{"$f":"SUM(J4:J32)","v":0},null,null,{"$f":"SUM(M4:M32)","v":0},null,null,{"$f":"SUM(P4:P32)","v":0},{"$f":"IFERROR( AVERAGE(B33,E33,H33,#REF!,#REF! #REF!,#REF!),0)","v":0},null,{"$f":"SUM(D33,G33,J33)","v":0},{"$f":"IFERROR(AVERAGE(K33,N33,#REF!),0)","v":0},null,{"$f":"SUM(M33,P33)","v":0},{"$f":"IFERROR(AVERAGE(B33,E33,H33,#REF!,#REF!,#REF!,#REF!,K33,N33,#REF!),0)","v":0},null,{"$f":"S33+V33","v":0}]

{"sheet":"8. Transition & Startup","index":8,"n_rows":33,"n_cols":4,"rows_kept":33,"merged":[[0,0,1,0],[0,1,0,3],[1,1,1,3],[32,1,32,2]]}
["Transition & Startup","Startup Period"]
[null,"3/1/2024-6/30/2025"]
["Item","Units","$ Each","Total"]
[{"$nulls":3},{"$f":"B4*C4","v":0}]
[{"$nulls":3},{"$f":"B5*C5","v":0}]
[{"$nulls":3},{"$f":"B6*C6","v":0}]
[{"$nulls":3},{"$f":"B7*C7","v":0}]
[{"$nulls":3},{"$f":"B8*C8","v":0}]
[{"$nulls":3},{"$f":"B9*C9","v":0}]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},0]
[{"$nulls":3},{"$f":"SUM(D4:D32)","v":0}]

{"sheet":"9. Summary","index":9,"n_rows":31,"n_cols":10,"rows_kept":31,"merged":[[0,0,1,1],[2,0,2,1],[11,0,11,1],[20,0,20,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[24,3,24,6],[25,0,25,1],[26,0,26,1],[28,0,28,1],[30,0,30,1]]}
["5-Year Cost Summary",null,"Base Year 1","Base Year 2","Base Year 3","Option Year 4","Option Year 5","Base Term","Option Years","5-Year"]
[null,null,"7/1/2025-6/30/2026","7/1/2026-6/30/2027","7/1/2027-6/30/2028","7/1/2028-6/30/2029","7/1/2029-6/30/2030","7/1/2025-6/30/2028","7/1/2028-6/30/2030","7/1/2025-6/30/2030"]
["Salaries/Wages/Bonuses",null,{"$f":"SUM(C4:C5)","v":0},{"$f":"SUM(D4:D5)","v":0},0,0,0,{"$f":"SUM(H4:H5)","v":0},{"$f":"SUM(I4:I5)","v":0},0]
[null,"Management",{"$f":"SUM('2. Salaries_&_Wages'!U5:U11)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!K5:K11)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!P5:P11)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!U5:U11)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!Z5:Z11)","v":0},{"$f":"SUM(C4:E4)","v":0},{"$f":"SUM(F4:G4)","v":0},{"$f":"SUM(H4:I4)","v":0}]
[null,"Non-Management",{"$f":"SUM(C6:C10)","v":0},{"$f":"SUM(D6:D10)","v":0},0,0,0,{"$f":"SUM(C5:E5)","v":0},{"$f":"SUM(F5:G5)","v":0},{"$f":"SUM(H5:I5)","v":0}]
[null,"Fixed Route Drivers",{"$f":"SUM('2. Salaries_&_Wages'!F13:F14)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!K13:K14)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!P13:P14)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!U13:U14)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!Z13:Z14)","v":0},{"$f":"SUM(C6:E6)","v":0},{"$f":"SUM(F6:G6)","v":0},0]
[null,"Paratransit Drivers",{"$f":"SUM('2. Salaries_&_Wages'!F15:F16)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!K15:K16)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!P15:P16)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!U15:U16)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!Z15:Z16)","v":0},{"$f":"SUM(C7:E7)","v":0},{"$f":"SUM(F7:G7)","v":0},0]
[null,"Dispatch & Road Supervisors",{"$f":"SUM('2. Salaries_&_Wages'!F17:F18)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!K17:K18)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!P17:P18)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!U17:U18)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!Z17:Z18)","v":0},{"$f":"SUM(C8:E8)","v":0},{"$f":"SUM(F8:G8)","v":0},0]
[null,"Customer Service",{"$f":"'2. Salaries_&_Wages'!F19","v":0},{"$f":"'2. Salaries_&_Wages'!K19","v":0},{"$f":"'2. Salaries_&_Wages'!P19","v":0},{"$f":"'2. Salaries_&_Wages'!U19","v":0},{"$f":"'2. Salaries_&_Wages'!Z19","v":0},{"$f":"SUM(C9:E9)","v":0},{"$f":"SUM(F9:G9)","v":0},0]
[null,"Maintenance",{"$f":"SUM('2. Salaries_&_Wages'!F20:F23)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!K20:K23)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!P20:P23)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!U20:U23)","v":0},{"$f":"SUM('2. Salaries_&_Wages'!Z20:Z23)","v":0},{"$f":"SUM(C10:E10)","v":0},{"$f":"SUM(F10:G10)","v":0},0]
[]
["Benefits & Payroll Taxes",null,{"$f":"SUM(C13:C14)","v":0},{"$f":"SUM(D13:D14)","v":0},0,0,0,{"$f":"SUM(H13:H14)","v":0},0,0]
[null,"Management",{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!D5:D11)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!G5:G11)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!J5:J11)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!M5:M11)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!P5:P11)","v":0},{"$f":"SUM(C13:E13)","v":0},{"$f":"SUM(F13:G13)","v":0},0]
[null,"Non-Management",{"$f":"SUM(C15:C19)","v":0},{"$f":"SUM(D15:D19)","v":0},0,0,0,{"$f":"SUM(C14:E14)","v":0},{"$f":"SUM(F14:G14)","v":0},0]
[null,"Fixed Route Drivers",{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!D13:D14)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!G13:G14)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!J13:J14)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!M13:M14)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!P13:P14)","v":0},{"$f":"SUM(C15:E15)","v":0},{"$f":"SUM(F15:G15)","v":0},0]
[null,"Paratransit Drivers",{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!D15:D16)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!G15:G16)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!J15:J16)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!M15:M16)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!P15:P16)","v":0},{"$f":"SUM(C16:E16)","v":0},{"$f":"SUM(F16:G16)","v":0},0]
[null,"Dispatch & Road Supervisors",{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!D17:D18)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!G17:G18)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!J17:J18)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!M17:M18)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!P17:P18)","v":0},{"$f":"SUM(C17:E17)","v":0},{"$f":"SUM(F17:G17)","v":0},0]
[null,"Customer Service",{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!D19)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!G19)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!J19)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!M19)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!P19)","v":0},{"$f":"SUM(C18:E18)","v":0},{"$f":"SUM(F18:G18)","v":0},0]
[null,"Maintenance",{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!D20:D23)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!G20:G23)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!J20:J23)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!M20:M23)","v":0},{"$f":"SUM('3. Payroll_Taxes_&_Benefits'!P20:P23)","v":0},{"$f":"SUM(C19:E19)","v":0},{"$f":"SUM(F19:G19)","v":0},0]
[]
["Corporate & Misc. Costs",null,{"$f":"'4. Corporate_&_Misc_Costs'!C33","v":0},{"$f":"'4. Corporate_&_Misc_Costs'!D33","v":0},{"$f":"'4. Corporate_&_Misc_Costs'!E33","v":0},{"$f":"'4. Corporate_&_Misc_Costs'!F33","v":0},{"$f":"'4. Corporate_&_Misc_Costs'!G33","v":0},{"$f":"SUM(C21:E21)","v":0},{"$f":"SUM(F21:G21)","v":0},{"$f":"SUM(H21:I21)","v":0}]
[null,"Profit",{"$f":"'4. Corporate_&_Misc_Costs'!C31","v":0},{"$f":"'4. Corporate_&_Misc_Costs'!D31","v":0},{"$f":"'4. Corporate_&_Misc_Costs'!E31","v":0},{"$f":"'4. Corporate_&_Misc_Costs'!F31","v":0},{"$f":"'4. Corporate_&_Misc_Costs'!G31","v":0},{"$f":"SUM(C22:E22)","v":0},{"$f":"SUM(F22:G22)","v":0},0]
["Insurance",null,{"$f":"SUM('5. Insurance & Bond'!C6:C14)","v":0},{"$f":"SUM('5. Insurance & Bond'!E6:E14)","v":0},{"$f":"SUM('5. Insurance & Bond'!G6:G14)","v":0},{"$f":"SUM('5. Insurance & Bond'!I6:I14)","v":0},{"$f":"SUM('5. Insurance & Bond'!K6:K14)","v":0},{"$f":"SUM(C23:E23)","v":0},{"$f":"SUM(F23:G23)","v":0},0]
["Performance Bond",null,{"$f":"'5. Insurance & Bond'!C4","v":0},{"$f":"'5. Insurance & Bond'!E4","v":0},{"$f":"'5. Insurance & Bond'!G4","v":0},{"$f":"'5. Insurance & Bond'!I4","v":0},{"$f":"'5. Insurance & Bond'!K4","v":0},{"$f":"SUM(C24:E24)","v":0},{"$f":"SUM(F24:G24)","v":0},0]
["Transition & Startup Costs",null,{"$f":"'8. Transition & Startup'!D33","v":0},{"$nulls":4},{"$f":"SUM(C25:E25)","v":0},null,0]
["Variable Costs",null,{"$f":"'6. Variable_Costs'!D33","v":0},{"$f":"'6. Variable_Costs'!G33","v":0},{"$f":"'6. Variable_Costs'!J33","v":0},{"$f":"'6. Variable_Costs'!M33","v":0},{"$f":"'6. Variable_Costs'!P33","v":0},{"$f":"SUM(C26:E26)","v":0},{"$f":"SUM(F26:G26)","v":0},0]
["Fixed Costs",null,{"$f":"'7. Fixed_Costs'!D33","v":0},{"$f":"'7. Fixed_Costs'!G33","v":0},{"$f":"'7. Fixed_Costs'!J33","v":0},{"$f":"'7. Fixed_Costs'!M33","v":0},{"$f":"'7. Fixed_Costs'!P33","v":0},{"$f":"SUM(C27:E27)","v":0},{"$f":"SUM(F27:G27)","v":0},0]
[]
["Total Est. Cost",null,{"$f":"SUM(C26:C27)","v":0},{"$f":"SUM(D3,D12,D26:D27)","v":0},0,0,0,{"$f":"SUM(H3,H12,H26:H27)","v":0},0,0]
[]
["Est. VRH",null,{"v":30500,"d":"30,500.00"},{"v":30500,"d":"30,500.00"},{"v":30500,"d":"30,500.00"},{"v":30500,"d":"30,500.00"},{"v":30500,"d":"30,500.00"},{"$f":"SUM(C31:E31)","v":{"v":91500,"d":"91,500.00"}},{"$f":"SUM(F31:G31)","v":{"v":61000,"d":"61,000.00"}},{"$f":"SUM(H31:I31)","v":{"v":152500,"d":"152,500.00"}}]