Skip to main content

Goal budget solver and sensitivity analysis

How Workforce Cost Forecast finds, with exact calculations, the largest raise or hiring that stays within a target total cost, saves the solution as a new plan, and shows how the cost changes with the exchange rate, the minimum wage and the general raise.

This article answers two questions: "Our budget is 50 million TL; how big a raise can we afford?" and "What happens if the exchange rate goes up 10%?". The Goal budget solver takes one variable you choose (a raise percentage, the number of people to hire or the start month of new hires) to the largest value that keeps the total cost within the target. On the Sensitivity card you move the exchange rate, minimum wage and general raise sliders and see how the total cost changes; the Sensitivity ranking shows the effect of a 10% change in each factor, largest first.

All results are calculated exactly with the payroll engine and nothing is written to the plan itself. If you want to use a solution, Save as scenario opens a copy of the plan with the solved value. Total cost means the total including expenses.

Before you start

  • You have a budget plan that is ready to calculate: the readiness list shows no errors (Calculation readiness check).

  • You can see the pay of every employee in the plan (the salary viewing permission and branch scope). Otherwise the page reads "These analyses need you to see the amounts of every employee in the plan."

  • The goal solver is for module admins and managers. People the plan is shared with for viewing can use the sensitivity cards.

  • To see estimates while you drag, the plan's report must have been calculated at least once (Creating and recalculating the budget report). Exact calculations do not need it.

Step by step

  1. In the plan's header open the More menu and click Compare. The Comparison page opens with the plan; you can pick another plan in the Plan field at the top.

  2. On the Goal budget solver card click Open the goal solver.

    Goal budget solver
  3. Type the target in Target total cost. You can write "50 million", "49.5m" or "50,000,000"; the line under the field shows how it was read and the current total.

  4. Choose the variable in Change:

    • January raise percentage (all employees): the plan's January raise for everyone. You can pick another month in Raise month. Employees covered by a more specific raise of a group in that month keep that raise.

    • Raise percentage of a group: choose a group such as a department, branch or position and its values.

    • Number of people to hire: choose a row in Planned hire; it calculates how many people with the same details can be hired.

    • Start month of new hires: the start dates of all new hires who join during the plan move together.
      The Kept as they are list shows the inputs that do not change.

  5. Click Solve. The progress "Exact calculation 3 / 8 steps" appears; the solver makes at most 8 exact calculations. You can close the window; the solver keeps running and the card shows its latest state.

  6. The result band reads, for example, "A raise of up to 27.4% stays within the target (total 49.98m TL).". The exact total of the value found never exceeds the target and is usually within 0.5% under it; for whole-number variables such as people and months the next value exceeds the target.

  7. To use the solution, check Name of the new plan and click Save as scenario. A copy of the plan is created with the solved value: a raise goes to the row in the Increases step, people and start months to Employee details. Open the plan opens the new plan; create its report with Create report.

  8. On the Sensitivity card move the Exchange rate (±30%), Minimum wage (±20%) and General raise (points) (±10 points) sliders. The Estimated total and its difference change while you drag.

    Sensitivity and sensitivity ranking
  9. For the exact value click Calculate exactly. When it is done the "Exact total: ..." line shows with the difference. If you move the sliders again, calculate again for the exact value.

  10. On the Sensitivity ranking card click Calculate. The general raise, minimum wage, benefits, SSI ceiling and exchange rate are lowered and raised by 10% and calculated exactly; the chart shows each factor's effect on total cost in million TL, largest first. Factors the plan does not have (for example the exchange rate without pay in a foreign currency) are listed under the chart with the reason.

Result

Solutions and sensitivity results do not change the plan; only Save as scenario creates a new plan. The solver also works on a plan sent for approval or approved; saving always creates a new draft plan and the approved budget stays as it is. The copy belongs to the person who created it; shares are not copied.

In Year-end forecast plans and plans with Keep up to date with actuals on, the closed payroll months are fixed with their actual values. The top of the page says, for example, "January-July 2026 come from closed payroll and do not change. The goal solver and the sensitivity recalculate August-December 2026 only." The solver, the sensitivity and the ranking never change these months but include them in the totals; the remaining months are calculated with the values carried over from the last closed month (cumulative tax base, social security carry-over). A change that only affects closed months has no effect. Start month of new hires moves only the hires who start in a forecast month, at the earliest to the first forecast month.

The General raise slider and General raise ±10% in the ranking are the plan's percentage raise for all employees in January. Benefits ±10% changes the payment and benefit amounts in the timesheet; items entered as days or hours and deductions do not change. Exchange rate changes the exchange rate assumption of the Parameters step. The estimated effect of the exchange rate while you drag comes from the exact effect in the sensitivity ranking; if the ranking has not been calculated, calculate exactly.

Common problems

Symptom: The result band reads "Even without a raise the total is ...; it exceeds the target."
​Cause: Even at the lowest value of the chosen variable the total cost is above the target.
​Fix: Raise the target or choose another variable.

Symptom: Solve or Calculate exactly says "Fix 2 errors first."
​Cause: The plan has errors that block the calculation.
​Fix: Fix them from the Readiness badge in the header.

Symptom: "The plan changed after this solution; solve again before saving." shows and Save as scenario is missing.
​Cause: An input of the plan changed after the solver started.
​Fix: Click Solve again.

Symptom: While dragging it reads "Calculate the sensitivity ranking or calculate exactly to see the exchange rate effect."
​Cause: There is pay in a foreign currency and the effect of the exchange rate has not been calculated exactly yet.
​Fix: Click Calculate on Sensitivity ranking or Calculate exactly.

Symptom: Number of people to hire or Start month of new hires cannot be chosen.
​Cause: The plan has no planned hire and no employee who joins during the plan.
​Fix: Add planned hires in the Data sources step or in Employee details.

Related articles

Did this answer your question?