allocate delivery cost problem

Is there a better way in Excel to allocate the Delivery Cost to Business Units

The Problem

BT has a file on delivery costs.

He needs to consolidate the DOs for each delivery truck, calculate the delivery cost, and allocate the calculated delivery cost to the respective business units.

BT did the first round and feels that there is a better way to complete this task than what he has already done.

Could you do better than him by saving time and improving the accuracy of the task?

Watch the video to get learn the problem and solve it.