Builder-BOS Raise & Profit Calculator V1.12

Raise & Profit Calculator

Builder-BOS Calculator

12-Month Planning Assumptions

Company / Scenario Name Effective Date

Anticipated 12-Month Revenue

Direct Job Costs / COGS

Gross Profit

Fixed / Overhead Costs

Projected Profit Before Raise

Projected Profit % Before Raise

Proposed Raise & Profit Goal

Annual Raise / Payroll Increase

Target Annual Profit

Projected Profit After Raise

Projected Profit % After Raise

Projected Profit vs. Profit Target

Revenue Requirement

Additional Revenue Needed

—

Enter company figures above.

Revenue Required

—

Revenue needed for the proposal to reach GO status.

Target Profit Margin

—

Target profit ÷ required revenue.

Enter anticipated revenue, target cost percentages, the proposed raise, and target profit.

Notes

Saved Scenarios 0 records

User Guide

Use this calculator as a forward 12-month planning tool. Start with anticipated revenue and target cost percentages rather than relying on historical dollars.

🟢Anticipated 12-Month Revenue

Enter the revenue you reasonably expect to produce during the next 12 months.
This is the starting point for the projection.

🏗️Direct Job Costs / COGS

Enter the target Direct Job Cost percentage of revenue.
The projected dollar amount is calculated automatically beside the percentage.

📊Gross Profit

Gross Profit is calculated automatically as Anticipated Revenue minus Direct Job Costs / COGS.
Negative projected values are displayed when the assumptions produce a loss, including Projected Profit Before Raise.

🏢Fixed / Overhead Costs

Enter the anticipated annual overhead dollars directly.
This amount can be based on historical overhead, adjusted for known changes during the next 12 months.
Overhead is treated as a fixed annual dollar requirement rather than a percentage of revenue.

💵Raise & Profit Goal

Enter the annual payroll increase being considered.
Enter the annual profit dollars you want remaining after the raise.

🎯Projected Profit vs. Profit Target

Above Target shows how much projected profit after the raise exceeds the Target Annual Profit.
Below Target shows the dollar shortfall and is displayed in red.
Meets Target means projected profit after the raise equals the target.

🚦GO / NO GO

GO means anticipated revenue support the target Direct Job Cost %, target Overhead %, proposed raise, and target profit.
NO GO means anticipated revenue are not yet sufficient.
For a NO GO result, the calculator shows the additional revenue needed and the total revenue level required to reach GO.

🧮Planning Formula

Projected Direct Job Costs = Anticipated Revenue × Direct Job Cost %

Gross Profit = Anticipated Revenue − Projected Direct Job Costs

Projected Overhead = Entered Annual Overhead Dollars

Required Revenue = (Overhead + Raise + Target Profit) ÷ (1 − Direct Job Cost %)

⚠️Important Assumption

If Direct Job Cost / COGS reaches 100% or more of revenue, the calculator will still show the projected loss, but a GO revenue threshold is not meaningful until a positive gross margin is restored.
Direct Job Costs / COGS are modeled as a percentage of revenue. Overhead is modeled as a fixed annual dollar amount.
Adjust the overhead dollar input for known staffing, occupancy, insurance, administrative, or other anticipated changes during the forecast period.

💾Save / Saved

Save stores the scenario in this browser.
Saved opens prior scenarios; select a row to reopen it.