Request: The logistics analyst compares two distribution arrangements. Reconcile sellable landed unit cost, volume-weighted distance and a second-center break-even. Deliver the six calculations and distinguish the cost threshold from the separate capacity and service decision. No route optimizer is assumed.
Data: six linked worksheets contain original fictional quantities and cost assumptions. Each completed sheet stays in your workbook as you move to the next task.
Done: all six results pass, with the final numerical finding checked.
The logistics analyst compares two distribution arrangements. Reconcile sellable landed unit cost, volume-weighted distance and a second-center break-even. Deliver the six calculations and distinguish the cost threshold from the separate capacity and service decision. No route optimizer is assumed.
You work on Pine Harbor Distribution's fictional planning file. Before calculating, check the time period, the unit and which business event each input records. Keep those definitions in the workbook so another analyst can reproduce the result. The first task gives you the steps. Later tasks use new quantities, a boundary case and a handoff to another planner. Your answer is recalculated on a second copy of the inputs, so enter a formula rather than a number copied from the example.
Landed cost adds the purchase, freight and nonrecoverable import costs, then divides by sellable units received. Damaged units do not belong in the denominator. This case states that tax is recoverable, so tax is excluded. Real tax treatment depends on the actual shipment and jurisdiction. The formula stays linked to the inputs when quantities change.