John Gabriel Mmbando Back to portfolio
Financial analysis · independent work sample

A 10% variance is a question, not a conclusion.

This synthetic year-to-date budget review compares plan with recorded expenditure, traces category variances, and identifies what to verify before explaining them.

Management brief · 60-second read

What should be checked before the forecast changes?

Through June, the synthetic sample records TZS 54.0M against TZS 60.0M planned: TZS 6.0M below plan, with all six months below plan.

Interpretation

A persistent gap is a review signal. It does not establish the cause, a saving, or non-compliance.

Follow-up

Check supplies and outreach timing, commitments and delivery evidence. Follow up the 15 incomplete synthetic packs with an owner and due date.

Decision boundary

Update the forecast only against validated activities, the approved plan and applicable terms. Sample phasing and figures are illustrative.

Approved annual budgetTZS 120.0MFictional sample budget
Planned through JuneTZS 60.0M50% of annual budget
Recorded through JuneTZS 54.0M45% of annual budget
Actual versus plan−TZS 6.0M10% below year-to-date plan

Spending position through June

Actual spend is shown against the approved annual budget.

PlanRecorded expenditureReview period: January–June · illustrative

Category variance drivers

Negative variance means recorded spending is below plan; positive means it is above plan.

Synthetic budget share, January-June plan and recorded expenditure in Tanzanian shillings.
CategoryAnnual budgetBudget shareYTD planYTD actualVarianceVariance %Annual budget used
Personnel48.0M40.0%24.0M24.6M+0.6M+2.5%51.3%
Community outreach36.0M30.0%18.0M15.3M−2.7M−15.0%42.5%
Medical supplies24.0M20.0%12.0M9.0M−3.0M−25.0%37.5%
Travel & supervision12.0M10.0%6.0M5.1M−0.9M−15.0%42.5%
Total120.0M100.0%60.0M54.0M−6.0M−10.0%45.0%
Concentration: Medical supplies and community outreach account for TZS 5.7M, or 95%, of the net TZS 6.0M variance. Personnel is TZS 0.6M above plan and offsets part of the category underspend. Confirm timing, commitments, delivery evidence, and coding before explaining the causes.

Monthly trend and quarterly movement

Monthly plan is evenly phased at TZS 10.0M in this illustration. Cumulative variance shows the running gap from January.

Monthly and cumulative plan-to-actual comparison, January-June, synthetic data.
PeriodPlanActualVarianceVariance %Cumulative variance
January10.0M8.9M−1.1M−11.0%−1.1M
February10.0M8.7M−1.3M−13.0%−2.4M
March10.0M9.0M−1.0M−10.0%−3.4M
April10.0M9.0M−1.0M−10.0%−4.4M
May10.0M9.2M−0.8M−8.0%−5.2M
June10.0M9.2M−0.8M−8.0%−6.0M
Q1 total30.0M26.6M−3.4M−11.3%−3.4M
Q2 total30.0M27.4M−2.6M−8.7%−6.0M
REPEATED SIGNAL

Below plan in 6 of 6 months

The monthly gap narrowed from TZS 1.3M in February to TZS 0.8M in June, but the pattern remains persistent and needs a timing and delivery explanation.

QUARTER-TO-QUARTER

Q2 gap narrowed by TZS 0.8M

Q2 variance was TZS 2.6M below plan versus TZS 3.4M in Q1, a 23.5% smaller quarterly gap. This indicates improvement, not resolution.

BUDGET UTILIZATION

45% used against 50% planned

Actual utilization trails the simple phased budget by 5 percentage points at June. Real spending plans may be seasonal rather than even.

Year-end forecast and sensitivity

The base case combines actuals through June with fictional July-December schedule estimates.

Base synthetic forecast in Tanzanian shillings.
CategoryAnnual budgetYTD actualJul-Dec estimateFY forecastForecast vs budget
Personnel48.0M24.6M23.4M48.0M0.0M
Community outreach36.0M15.3M17.1M32.4M−3.6M
Medical supplies24.0M9.0M12.6M21.6M−2.4M
Travel & supervision12.0M5.1M5.4M10.5M−1.5M
Total120.0M54.0M58.5M112.5M−7.5M
90% of original H2 planTZS 108.0M

Year-end total; TZS 12.0M below annual budget.

Base revised scheduleTZS 112.5M

Year-end total; TZS 7.5M below annual budget.

100% of original H2 planTZS 114.0M

Year-end total; TZS 6.0M below annual budget.

Interpretation: The base scenario forecasts 93.8% utilization of the annual budget. Reaching the full annual budget would require TZS 66.0M of July-December spending, or 110% of the original TZS 60.0M second-half plan. That is arithmetic, not a target: valid activity needs and approvals should guide spending.

Forecast assumptions are synthetic planning estimates, not a statistical projection or a real programme forecast.

Supporting-record review

Fictional document-pack completeness indicators show where a reviewer would follow up.

Synthetic supporting-document packs reviewed for January-June.
CategoryPacks reviewedCompletePendingComplete %Value linked to pending records
Personnel5856296.6%0.6M
Community outreach3227584.4%1.5M
Medical supplies4034685.0%2.4M
Travel & supervision1816288.9%0.5M
Total1481331589.9%5.0M
Follow-up signal: 15 of 148 synthetic packs are incomplete, linked to TZS 5.0M. This is a request-and-review population only; incomplete records do not automatically mean expenditure is ineligible. Request the specific missing support, record an owner and due date, and assess evidence against the actual award terms.

What the figures suggest

These are review prompts based on the sample, not final explanations.

01 / OVERALL POSITION

Spend is below plan

Recorded expenditure is TZS 6.0M, or 10%, below the year-to-date plan. The figures show timing against plan; they do not establish a saving or a compliance issue.

02 / MAIN VARIANCES

Check outreach and supplies

These categories are TZS 5.7M below plan in total. Confirm activity timing, purchase commitments, delivery records, and whether the forecast needs updating.

03 / ABOVE PLAN

Review personnel spend

Personnel expenditure is TZS 0.6M above plan. Check the underlying period and classification, then record the explanation and any follow-up.

Download the full analysis

The report includes the interpretation, assumptions, sensitivity scenarios, and evidence-led follow-up sequence.

The full pack includes the PDF, category summary, 24 monthly category records, supporting-record review, forecast scenarios, and a data guide. Synthetic figures only.

Method

Variance = actual expenditure minus planned expenditure. A negative value means spend is below plan.

Variance percentage = variance divided by plan. Year-to-date burn rate = recorded expenditure divided by the approved annual budget.

Sample calculations
Overall variance: TZS 54.0M − TZS 60.0M = −TZS 6.0M
Variance percentage: −TZS 6.0M ÷ TZS 60.0M = −10%
Actual burn rate: TZS 54.0M ÷ TZS 120.0M = 45%