This project focuses on analyzing Sales and Freight Cost Impact for a retail company using transactional data from 2013 to 2015, with 2014 selected as the year of focus.
The analysis aims to:
Sales figures alone do not fully capture the health of a business, as revenue can be significantly eroded by the cost of getting products to customers. In this case, freight charges represent a critical but often overlooked factor that influences profitability. Although the company works with multiple shippers, there is little clarity on how freight costs relate to order value and size, or which shipping partner consistently provides the most cost-efficient deliveries. It becomes difficult to evaluate the true impact of logistics on overall sales performance. This analysis therefore seeks to find out the relationship between freight and sales, pointing out patterns in shipper performance and examining whether freight costs serve as a barrier or enabler of revenue growth.