The answer at a glance
Use a defined period, sourced actuals, consistent targets, clear variance calculations, and owned follow-up actions. Missing data is unavailable, not zero.
Use a checkable method
Choose the decisions the review supports. Identify period, audience, metric definition, source, and owner for each number.[1]
Show actuals and targets separately. Calculate variance using a stated denominator, and distinguish an observed change from a proposed explanation.
List risks, decisions, and data gaps. Do not infer contribution or profitability when cost data is missing.
Review prior commitments, propose next owners, and choose review dates. Reuse the structure with fresh evidence. Scheduling and connected retrieval require existing configuration and permissions.
Worked fictional example
Prepared September example: 40 booked jobs against a target of 45; revenue USD 4,000; cost data unavailable.
Booking variance is −5 jobs. The report can state supplied revenue, but contribution and profit remain unavailable.
Investigate booking loss reasons and verify capacity before increasing outreach. This is a fictional review, not a customer result.
Limits to keep visible
A recurring structure is not a live dashboard or automatically scheduled task. Source access, metric definitions, collection delays, and missing data limit interpretation.
Kona Workspace supports saved business work and supported exports, subject to authentication, usage limits, configuration, and user review. Source links do not automatically certify every conclusion.[2]
Continue with your own evidence
Use the management-report starter with current actuals and source notes. Attach authorized files or connect supported read-only sources after signing in.
- Formula caches match independently calculated values.
- Inputs are editable and referenced by formulas.
- Opening/closing cash reconciles across months.
- Excluded cash items are visible.
Yours to use
Forecast and scenarios sample pack — method notes
Prepared fictional notes to inspect and revise. Editable Office files are available from the related sample pack.
Markdown · Opens in any text editor · No signup required
# Cedar Cycle — scenario model
Prepared fictional Kona example. Not a live AI run, customer story, verified demand, or approved financial/legal advice.
## Prepared inputs
Cedar Cycle is a fictional mobile bicycle-service concept. Unit price USD 100; variable cost USD 40/visit; monthly fixed cost USD 2,000; opening cash USD 10,000. Downside/base/upside volume: 30/40/50 visits per month. All figures are prepared assumptions. The simplified model excludes tax, debt, capex, payment timing, and changing capacity costs.
## Formulas
Revenue = monthly visits × price. Variable cost = monthly visits × variable cost per visit. Gross contribution = revenue − variable cost. Simplified operating cash = gross contribution − monthly fixed cost. Ending cash = prior cash + operating cash.
## Expected results
Downside monthly result: USD −200; month-12 cash: USD 7,600. Base monthly result: USD 400; month-12 cash: USD 14,800. Upside monthly result: USD 1,000; month-12 cash: USD 22,000.
## Review
These are constant-month scenarios. They are not tax, debt, capex, payment-timing, or probability-weighted forecasts. Do not read opening cash as an observed real account balance.
## How to revise
Edit the Inputs sheet, open the XLSX in compatible spreadsheet software, and inspect formula recalculation. Add supported lines explicitly if your business needs them.
## Review checklist
- Formula caches match independently calculated values.
- Inputs are editable and referenced by formulas.
- Opening/closing cash reconciles across months.
- Excluded cash items are visible.Sources
Sources and further reading
[1]
Plan your businessU.S. Small Business Administration
[2]
Kona capabilities and current limitsKona Business
Editorial method
This guide combines the linked sources with a worked example and a reusable template. Replace example inputs with your own evidence and check the result before making a business decision.
About Kona’s editorial standardsPut it into practice
Adapt this to your business in Workspace
Copy the brief below, open Workspace, and paste it with the inputs you want to use. Review the assumptions and calculations before relying on the output.
Use the management-report starter with current actuals and source notes. Attach authorized files or connect supported read-only sources after signing in.
Keep working on the decision
Validate a business idea with evidence, not a polished plan
Turn a customer hypothesis into a bounded test. Use a worked service-business example, an evidence table, and decision gates before committing resources.
Build a competitor matrix that helps a real decision
Compare the same customer job, record official sources and unknowns, and turn differences into testable positioning. Includes a prepared downloadable matrix.