What this worksheet isolates
A manager can use target profit price to test a stated assumption. Find the selling price per unit required to cover fixed costs, variable cost, and a chosen profit target at an entered sales volume. Naming the selling period prevents later readers from treating it as a permanent fact.
From a target profit price standpoint, state whether the case is historical, budgeted, or quoted. The same formula can be valid in all three settings while meaning something different.
A second reader of target profit price should note that a later review of value based pricing belongs in the Value Based Pricing Calculator; carry over only figures that share this page’s date and definition.
Match the underlying records
Period fixed costs. For target profit price, Costs unchanged within the planned volume. Compare Period fixed costs with Variable cost per unit inside the target profit price boundary and its selected currency.
Variable cost per unit. Before the target profit price calculation, verify this instruction: Incremental cost attached to one unit. Align the date attached to Variable cost per unit with the timing assigned to Planned units sold.
Planned units sold. For the selected selling period in target profit price, Units expected in the same period. Document whether Planned units sold follows a different target profit price allocation or rounding rule from Target operating profit.
Target operating profit. In the target profit price file, Profit required after the entered costs. Trace Target operating profit independently from Period fixed costs before another reviewer receives the target profit price file.
Trace the arithmetic
For this target profit price case, the equation is direct: Required price equals variable cost per unit plus fixed costs and target profit divided by planned units. Rework the same relationship in a spreadsheet when the output will enter a formal report.
With target profit price defined, use the Bundle Pricing Margin Calculator for the downstream bundle pricing margin question and note the figure transferred from this case.
Separate movement from meaning
For this target profit price case, movement in the answer may come from either side of a ratio. Identify the changing numerator or denominator before explaining performance.
With target profit price defined, a second case should change one documented fact. Begin with Target operating profit, compare every result row, and explain the variance.
A target profit price conclusion becomes easier to defend when Period fixed costs and Target operating profit come from compatible records. Resolve mismatched timing before presentation.
A target profit price result can inform negotiation or planning without dictating either. Record the chosen action and its owner outside the worksheet.
The target profit price file adds an important point: do not read the output past this limit. Capacity limits, taxes, channel fees, and demand response are outside this required-price arithmetic.
In the target profit price review, label the output historical, budgeted, or quoted, and identify who approved the underlying assumptions.
Sample calculation record
Figures in the sample run: Period fixed costs = $45,000; Variable cost per unit = $18; Planned units sold = 4000 units; Target operating profit = $30,000.
While examining target profit price, check the displayed intermediate amounts against hand arithmetic. Then replace Target operating profit with a second documented value.
The target profit price file adds an important point: for a separate view of price increase revenue impact, transfer the dated evidence to the Price Increase Revenue Impact Calculator.
Practical questions
Which date governs this case?
Use the date attached to Period fixed costs; reconcile later information in a new version.
How much rounding is appropriate?
The target profit price file adds an important point: calculate with full precision and round only for presentation or the governing document.
Does the answer authorize a transaction?
In the target profit price review, no. Approval, contracting, tax treatment, and compliance occur outside the arithmetic.
What controls if a contract differs?
From a target profit price standpoint, the signed agreement and current records control; the page is only a planning worksheet.
Does the page supply a benchmark?
A second reader of target profit price should note that no. Any target or comparison standard must be selected and documented by the user.