US Voyage Estimate Audit: Reproduce the Number Before Approving
Require another person to reproduce the result
A voyage estimate audit should establish that the reported number follows from identifiable inputs and a coherent calculation. A total that looks reasonable is not enough. Another reviewer should be able to rebuild the result, explain its scope and identify which assumptions remain uncertain before the estimate is used for approval.
For a Houston-linked voyage proposal, the audit should focus on the decision the estimate supports. Is the team approving a price, comparing employment options or updating expected contribution after a change? The same workbook can contain useful figures for all three purposes, but a result prepared for one question may be misleading when reused for another.
GAO's cost-estimating guide includes documentation and validation of estimates. GAO cost-estimating guide.
The process below is an original maritime review design. It uses that narrow methodological context without presenting a commercial voyage estimate as a government program model.
Define the boundary before checking formulas
State what revenue and costs the estimate includes, the period covered and the currency used. Identify whether the result is a voyage contribution, cash requirement or another measure. An accurate subtraction can still mislead if the label implies that every company cost has been included when the model covers only selected voyage items.
List excluded items and explain whether they are common to the alternatives, outside the decision or still unresolved. Do not hide a missing estimate inside a miscellaneous allowance unless that treatment is explicit and justified. The reviewer should know whether an apparent margin depends on an unpriced service.
Check the quantity and service boundary against the current proposal. A model prepared for a different parcel, terminal or cost allocation may remain mathematically correct while no longer describing the transaction. Confirm the commercial version before spending time verifying a workbook that the team should no longer use.
Follow the input lineage to the output
For each material input, identify the source, date, unit and status. Separate supplier quotations from internal assumptions and calculated values. Preserve the original source amount alongside any conversion or normalization. This makes it possible to distinguish a source change from a formula change.
Excel provides tools for tracing relationships between formulas and their precedent or dependent cells. Microsoft formula relationships.
Such tools can help inspect a spreadsheet, but the reviewer still needs to understand what the cells mean. A valid reference to the wrong quantity is not necessarily a spreadsheet error that software will flag. Check the semantic connection as well as the cell connection.
Look for overwritten formulas, hard-coded subtotals and external links that may not reflect the current inputs. A model can display a new fuel price while the reported contribution still uses an old manually entered cost. The audit should establish that changing a relevant input actually changes the appropriate output.
Reproduce a fictional estimate independently
Assume a hypothetical voyage earns USD 900,000. Its model includes fuel of 300 tonnes at USD 600 per tonne, port costs of USD 120,000, other voyage costs of USD 30,000 and twenty days at a daily cost of USD 20,000. These are fictional planning inputs, not market figures.
Fuel is USD 180,000 and time cost is USD 400,000. Total modeled cost is USD 730,000, leaving USD 170,000 contribution. The independent reviewer should obtain the same result from the stated inputs without relying on the workbook's subtotal cells.
Now increase the assumed duration to twenty-two days. Time cost should rise to USD 440,000, total cost to USD 770,000 and contribution should fall to USD 130,000. If the displayed output remains USD 170,000, the audit has exposed a broken dependency or an intentionally fixed field that needs explanation.
Then increase fuel price by USD 50 per tonne while keeping the twenty-two-day case. Fuel cost increases by USD 15,000 and contribution becomes USD 115,000. This second test checks that an independent cost driver reaches the result correctly. It does not suggest that these are the only uncertainties relevant to a real voyage.
Test boundaries and sign conventions
Use simple cases whose expected behavior is obvious. A zero quantity should not produce quantity-based revenue unless a separate fixed amount is expressly modeled. An additional cost should reduce contribution, while a genuine cost credit should have the opposite sign. A currency conversion should be reversible within the stated rounding policy.
Check thresholds and minimums separately. A stepped charge can be correct at the base case but fail when an input crosses a boundary. Test a value just below and just above the relevant threshold using the actual quoted rule. Do not assume that a formula verified at one quantity works throughout its displayed range.
Review percentages for their denominator. A commission on revenue differs from a percentage added to cost; a margin on sales differs from a markup on cost. The label should identify the intended basis. Reproducing a percentage without understanding that basis can validate the wrong calculation very efficiently.
Distinguish model assurance from commercial approval
The audit conclusion should say what was checked and what remains outside its scope. Arithmetic reproduced, source amounts verified and assumptions approved are different statements. A reviewer may confirm the formulas while a major operational assumption remains unconfirmed. Keep that limitation visible in the approval package.
When an error is corrected, identify which previous decisions used the affected result. A corrected workbook alone may not reach someone who copied the old contribution into a proposal or approval message. Communicate the changed result and its cause to the relevant decision owner, without suggesting that every prior action is automatically invalid.
Retain the approved version, source package and audit notes together. Future actual-cost comparisons should use the correct baseline rather than a workbook that has continued to evolve. This preserves a useful distinction between the original decision, later forecasts and eventual results.
Bring a voyage estimate and its underlying quotations to Zeaclub to discuss a proposed independent-reproduction review. The objective is a number that a US commercial team can explain and test, with visible assumptions and a clear handoff from calculation assurance to the people authorized to approve the business.
Sources
- GAO: Cost Estimating and Assessment Guide, checked October 24, 2026; documentation and validation scope only, within the shared underlying-source allocation.
- Microsoft: Formula Relationships, checked October 24, 2026; formula-tracing capability only.
Related articles
- 0976: US Voyage Cost Calculator: Build a Transparent Input Sheet
- 0713: A US Voyage Analyst Can Keep a Spreadsheet Without Keeping a Shadow System
- 0998: US Freight Scenario Dashboard: Show What Can Reverse a Choice


