A check after quoting
The free calculators estimate costs and selling prices before an order. This worksheet uses completed-order costs and refunds to show the surplus before and after an allowance for your own labor. Existing free CSV and customer PDF features remain available.
- Enter actual production costs including reprints, without adding estimated failure costs again.
- Missing inputs stay incomplete; a genuine zero is accepted. Fully refunded jobs have no margin percentage.
- Choose completion-date bounds and review currency-separated totals. There is no currency conversion or mixed-currency total.
Worked hypothetical examples
These USD examples are synthetic, not customer or business results. The labor allowance is active hours multiplied by an hourly allowance.
| Job | Retained sales | Before labor | After labor |
|---|---|---|---|
| Normal batch | $120.00 | $61.00 | $38.50 |
| Reprint, partial refund | $70.00 | −$2.00 | −$32.00 |
| Full refund | $0.00 | −$35.00 | −$42.50 |
How to use it
- Read Guide and save a copy. The synthetic Example jobs are separate from the blank Orders totals.
- In Orders, enter one job per column in the yellow cells. Use an anonymous job ID and enter 0 for true zero amounts.
- Review surplus above the inputs and period totals below. Incomplete jobs are excluded and visibly counted.
Quote variance compares sales less production cost on both sides. It is not a full-profit forecast variance because expected shipping, fees and labor are not provided. Actual surplus separately accounts for the other costs and labor allowance you enter.
Each file holds six jobs; use a new copy for another batch. Supports USD, KRW, EUR, GBP and JPY. Count each cost once and exclude taxes collected for an authority from sales. These operational subtotals are not audited net income, tax filings or cash-flow statements.
Preview status
This free prototype was created by the BatchQuote Lab operator with AI assistance. It has no macros or external connections. Examples, refunds, missing inputs, currency separation and date boundaries were checked in the generation engine. LibreOffice headless recalculation matched the example results; Excel desktop is untested. Keep your original records.
No paid product is offered at present. If optional anonymous measurement is enabled, activating the download link adds only a daily count for this page. It does not prove that the transfer completed, the file was used or anyone intends to buy. Feedback below measures only whether this explanation was helpful or needs correction.