Sales/Revenue Projections
Budget: $750 – $1,500 USD
I'd like to model sales and revenue projections for a series of IT and information security consulting and advisory services to be offered in the United States. This is part of a larger business plan covering additional complementary services not currently offered by my company. In addition to information about the specific services and target market demographics, I can share benchmarking and orientation information about IT capex and opex broken out by industry and org size.
We have 13 services, 5 target industry sectors, and 5 size categories. The service offerings build up over time, so we consider 6 service offerings in year one, 4 additional service offerings in year two (total of 10), and 3 additional service offerings in year three (total of 13).
Data points I have to inform the projections:
- Costs to deliver the services (per service variable costs and service suite fixed and variable costs)
- For each industry sector, aggregate revenue, IT spend as a percentage of revenue, breakdown of IT spend dollars (e.g., percent of IT spend going to capex, opex, outsourced services) projected over 2022-2024
- For each industry sector (NAICS industry + relative company size), factors informing industry performance and IT spend (e.g., regulatory burden, technology change, etc.)
- Estimated cost per attempt (cost to pursue selected leads, regardless of outcome)
Key data points we want to model:
- Estimated cost per lead
- Estimated/target conversion rates for similar/like/adjacent services within the target markets
- Estimated cost per win
- annual sales/revenue projects for the next 3 years
- annual profit in 2021 dollars and % margin for the next 3 years
The desired deliverable is an Excel workbook. The first sheet should have all of the key data points we want to model aggregated across all services and the key data points we want to model for each individual service listed underneath. These sources should be linked to the data and calculations in the other sheets to allow us to adjust any of the inputs as required.
I'd prefer to move quickly but need defensible data and modeling, so please balance accuracy and timeline when considering your bid.
We have 13 services, 5 target industry sectors, and 5 size categories. The service offerings build up over time, so we consider 6 service offerings in year one, 4 additional service offerings in year two (total of 10), and 3 additional service offerings in year three (total of 13).
Data points I have to inform the projections:
- Costs to deliver the services (per service variable costs and service suite fixed and variable costs)
- For each industry sector, aggregate revenue, IT spend as a percentage of revenue, breakdown of IT spend dollars (e.g., percent of IT spend going to capex, opex, outsourced services) projected over 2022-2024
- For each industry sector (NAICS industry + relative company size), factors informing industry performance and IT spend (e.g., regulatory burden, technology change, etc.)
- Estimated cost per attempt (cost to pursue selected leads, regardless of outcome)
Key data points we want to model:
- Estimated cost per lead
- Estimated/target conversion rates for similar/like/adjacent services within the target markets
- Estimated cost per win
- annual sales/revenue projects for the next 3 years
- annual profit in 2021 dollars and % margin for the next 3 years
The desired deliverable is an Excel workbook. The first sheet should have all of the key data points we want to model aggregated across all services and the key data points we want to model for each individual service listed underneath. These sources should be linked to the data and calculations in the other sheets to allow us to adjust any of the inputs as required.
I'd prefer to move quickly but need defensible data and modeling, so please balance accuracy and timeline when considering your bid.