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.

AI Chatbot Avatar
⚠️ Welcome to our chatbot! Please note that this chatbot is designed to provide general information about our Excel and Power BI courses, and should not be relied upon as legal or financial advice. Any personal information collected by the chatbot will be handled in accordance with our privacy policy. By interacting with the chatbot, you agree to our terms and conditions.