Identify rules usable for any mode from the study table. FAS, FOB, CFR and CIF are the waterway group. The other seven allow any mode. For a container handed to a carrier before vessel loading, examine FCA.
Work in the spreadsheet, keeping the source columns intact. Read each row before filling the output column: the extract includes a boundary case that can expose an attractive but incorrect formula. Start with the guided example, then repeat the calculation on a changed extract and an operational handoff. The workbook uses original fictional records. A result must still work when quantities and charges change, so use cell references rather than a typed total.
Identify rules usable for any mode from the study table. FAS, FOB, CFR and CIF are the waterway group. The other seven allow any mode. For a container handed to a carrier before vessel loading, examine FCA.