Hybrid Fiber-Wireless Budget Calculator

Example data table

Formula used

• Fiber CAPEX = (Trench m × Trench unit) + (Route m × Duct unit) + (Route m × Cable unit) + (Splice qty × Splice unit) + (Enclosure qty × Enclosure unit) + (ODF qty × ODF unit) + Allowances.
• Fiber labor = Fiber labor hours × Labor rate.
• Wireless CAPEX = (Links qty × Radio unit) + (Mast qty × Mast unit) + (Antenna qty × Antenna unit) + (Power qty × Power unit) + Allowances.
• Wireless labor = Wireless labor hours × Labor rate.
• CAPEX subtotal = Fiber CAPEX + Fiber labor + Wireless CAPEX + Wireless labor.
• OPEX total = (ISP monthly + Data monthly + Maintenance monthly) × Months.
• Contingency = CAPEX subtotal × (Contingency % ÷ 100).
• Overhead + profit = (CAPEX subtotal + Contingency) × (OHP % ÷ 100).
• Tax = Tax base × (Tax % ÷ 100), where tax base includes OPEX if selected.
• Grand total = CAPEX subtotal + Contingency + OHP + OPEX total + Tax.

How to use this calculator

1. Enter your project name, currency, and expected duration in months.
2. Choose which scopes apply: fiber build, wireless build, and tax on OPEX.
3. Fill unit rates from your latest vendor quotes or schedule of rates.
4. Adjust contingency and overhead to match your estimating policy.
5. Click Calculate budget to view totals and line items above the form.
6. Use the export buttons to save a CSV or PDF for submittals.

Scope and cost drivers

Hybrid budgets are controlled by route length, civil constraints, and the number of active endpoints. The calculator separates build costs (CAPEX) from service costs (OPEX) so planners can compare short projects against long deployments. Enter realistic unit rates for trenching, conduit, cable, and labor, then confirm whether tax applies to recurring charges. Include mobilization, site safety controls, and restoration standards, because they often shift civils pricing more than material costs.

Fiber build budgeting

Fiber costs scale with two measurements: trench length for excavation and route length for materials. If trench meters exceed route meters, you may be crossing roads or detouring around utilities. Include splicing, enclosures, and patch hardware as discrete line items so the estimate reflects termination density. Higher splice counts usually indicate multiple handholes or building entries; reflect that with extra labor hours. Adjust permit and miscellaneous allowances to cover traffic control, reinstatement, and testing consumables.

Wireless system budgeting

Wireless budgets depend on link count, mounting complexity, and power availability. Radios, antennas, and masts capture the core equipment spend, while installation hours capture alignment and commissioning. For remote sites, increase the power system allowance for UPS or solar. Add grounding and lightning protection where required. OPEX is calculated from monthly backhaul, data plans, and maintenance, multiplied by project duration.

Risk, contingency, and overhead

Contingency addresses uncertainties such as unknown duct paths, rock, dewatering, or access restrictions. Apply contingency to the CAPEX subtotal first, then apply overhead and profit to the subtotal plus contingency to mirror common estimating practice. If you use a different basis, change the percentages and document the rationale in the exported report.

Interpreting totals for decisions

Use the grand total to validate funding, and the monthly equivalent to compare alternatives on an equal time basis. Cost per endpoint helps scale small pilots into full rollouts, especially for trailers, CCTV clusters, and crew zones. Toggle fiber or wireless to evaluate phased delivery, and export CSV to reconcile line items with vendor quotes.

FAQs

1) What values should I use for trenching unit cost?

Use your latest civil rate per meter, including excavation, bedding, backfill, and surface reinstatement. If rock, dewatering, night work, or traffic management is expected, increase the unit rate or add allowance line items.

2) When should I disable fiber or wireless in the scope?

Disable a scope when it is not part of the current phase. For example, model temporary wireless-only service during early works, then re-enable fiber when permanent duct and cable installation is planned.

3) Does OPEX include equipment warranties or replacements?

OPEX here covers recurring service and routine maintenance. If your contract includes extended warranties, spares, or replacement units, add those as monthly maintenance cost or a separate lump-sum allowance in CAPEX.

4) How is tax applied in the calculation?

Tax is calculated as a percentage of the selected tax base. If “Apply tax to OPEX” is checked, tax includes recurring charges; otherwise it applies to build costs plus markups only.

5) What does “cost per endpoint” represent?

It divides the grand total by the number of endpoints you enter. Use endpoints as a scaling unit, such as trailers, camera clusters, work fronts, or Wi‑Fi zones, to compare different site layouts.

6) Why might my totals differ from vendor quotations?

Quotes may include site surveys, mobilization, warranty terms, exchange-rate buffers, or minimum order quantities. Align the unit costs with the quote basis, and add allowances for items that vendors bundle outside your line items.