A second distribution center adds fixed cost but can reduce variable freight cost. Divide incremental fixed cost by the variable saving per unit. The result is a cost break-even volume under the stated assumptions. Service coverage, capacity and disruption risk still require separate evaluation.
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.
Calculate added annual fixed cost divided by old variable cost per unit minus new variable cost per unit.