- Supply chain analyst
- Junior
- 30 min
Chargeable freight weight
Calculate Chargeable freight weight in H2:H7 for every record. Use the source columns and the policy in the task brief. Keep each row linked to its own inputs.
Skills and rubricChargeable freight weight
- Equal weights give the same chargeable kilograms whichever is selected, so that row can't distinguish MAX from an actual-weight-only formula. Use another row with dimensional weight above actual weight. The current quote supplies dimensional kilograms directly; confirm the carrier method before recalculating them from package measurements.
- Increase the supplied dimensional-weight input, then take the larger of actual and revised dimensional kilograms. Recalculate variable freight using that chargeable weight and the quoted rate, add the fixed fee once, and compare the full quote on the same service basis. If actual weight still exceeds the revised figure, chargeable kilograms stay unchanged.
- I retain the source material, the saved answer and the decision owner because a plausible answer alone does not show which requirement was checked. I name the unresolved exception and the next review date.