US Voyage Cost Calculator: Build a Transparent Input Sheet

Define whose cost the calculator measures

A voyage cost calculator should begin with the party's perspective and the decision it supports. An owner's voyage contribution, a charterer's transport budget and a cargo buyer's delivered cost are different calculations. Combining their inputs indiscriminately can double-count expenses or omit obligations. The worksheet should state its perspective before presenting a total.

Veson's voyage-estimate documentation separates itinerary information from revenue and expense inputs. Veson: VMS Voyage Estimate.

That product example illustrates structured inputs, not a requirement to use a particular system. The independent worksheet described here can help a US team understand its own estimate before choosing software. It is an educational model, with fictional figures below, and does not determine technical voyage feasibility or contractual cost allocation.

Create an input register rather than a list of amounts

For each input, record a description, value, unit, currency, source date and status. Status should distinguish an agreed amount, a current quotation, a planning assumption and a missing value. Keep the supporting source or contact reference close enough that another reviewer can find it. A precisely formatted number without a basis is still an assumption.

Use separate rows for costs driven by different variables. A daily vessel charge responds to duration. Fuel expenditure responds to consumption and price. A fixed service charge may remain unchanged across a small quantity variation. If these are combined into one unexplained allowance, the calculator cannot show what changes when the voyage plan changes.

Do not insert zero where a required input is unknown. Use an explicit unresolved status and prevent the result from being labeled complete. Zero means the cost is assumed absent or included elsewhere, which should be explained. Missing means the team has not established its value. Confusing the two can make an incomplete estimate appear unusually attractive.

Keep the equations visible

For a simplified voyage contribution model, calculate freight revenue as the agreed charging quantity multiplied by its applicable rate. Deduct the expenses borne by the modeled party. Where a daily charge applies, multiply the reviewed daily amount by the corresponding modeled days. The actual contract determines the relevant bases; the calculator should not infer them from a generic industry label.

GAO's cost guide emphasizes documenting assumptions and examining their effects on an estimate. GAO: Cost Estimating Guide.

The original worksheet application is to show both the input and the formula that uses it. If an expense is a lump sum, identify it as such. If a percentage is applied to revenue, state which revenue items enter the base. If currency conversion is needed, retain the original amount and the chosen conversion assumption rather than replacing the source number without explanation.

A summary sheet should draw from these inputs instead of repeating manually typed totals. Repeated copies make it easier for one version to change while another remains stale. The reviewer should be able to reproduce the output from the visible inputs and identify which source update caused a difference.

Reproduce a hypothetical Houston voyage

Consider a fictional Houston export voyage modeled from the perspective of a party bearing the listed voyage costs. The charging quantity is 20,000 metric tonnes and the freight rate is USD 45 per tonne, producing USD 900,000 revenue. Assume fuel consumption of 300 tonnes at USD 600 per tonne, giving USD 180,000 fuel cost.

Add USD 120,000 in port and service expenses, USD 30,000 in other voyage expenses and an illustrative daily vessel charge of USD 15,000 for 30 days, totaling USD 450,000. Total modeled expenses are USD 780,000. The resulting contribution after these listed costs is USD 120,000. It is not described as accounting profit because other business costs may be excluded.

The input sheet should show the units behind every multiplication and the scope of each lump sum. It should also explain that the daily vessel charge is part of this fictional perspective. A cargo owner's freight-only budget should not automatically add the carrier's vessel costs on top of a freight price that already compensates the carrier for its service.

Now increase duration to 33 days while holding all other assumptions constant. The daily charge becomes USD 495,000, total expenses USD 825,000 and contribution USD 75,000. This isolated sensitivity reduces contribution by USD 45,000. It does not claim that fuel and port expenses would truly remain unchanged during a real delay; it shows the effect of one chosen input.

If a combined scenario also adds 20 tonnes of fuel at the same price, expenses increase by another USD 12,000 and contribution becomes USD 63,000. Label that as a combined scenario so the reader can distinguish it from the duration-only result. Neither scenario is a forecast or a claim for recoverable delay compensation.

Add checks that expose a wrong basis

Useful checks include confirming that all included amounts use the reporting currency, that revenue quantity matches the intended freight basis and that each cost appears only once. Reconcile the modeled days with the defined period rather than accepting a duration copied from a different voyage. Technical duration and consumption assumptions require the appropriate operational input.

Review exclusions explicitly. A calculator can produce a valid subtotal while leaving out financing, insurance, taxes, overhead or another material item. State the boundary so the decision maker understands what the result represents. Do not add a generic contingency merely to make the estimate look conservative without explaining the risk it addresses.

Preserve the approved input set when updating a forecast. The comparison should identify whether a change came from quantity, rate, duration, price or scope. This makes the worksheet useful after the initial decision as well as before it. It also helps the team distinguish an arithmetic error from a genuine change in commercial conditions.

Zeaclub's proposed voyage-estimate discussions can help US teams define a transparent input structure before relying on a headline result. Bring the decision perspective, cost responsibilities and uncertain inputs to Zeaclub. The practical next step is a reproducible worksheet whose assumptions are visible enough for an authorized reviewer to challenge and improve.

Sources

Related articles