This report presents an analysis of Northwind Trading Company's sales performance across its global operations. Covering 2,155 orders, this report examines revenue generation, profitability, product category performance, customer behaviour, and logistics efficiency.
Northwind Trading Company operates across 21 countries, distributing eight product categories ranging from Beverages, Dairy Products, Meat & Poultry, Condiments, Produce, Grains & Cereals, Seafood and Confections. The company works with three shipping partners and serves a diverse customer base spanning Europe, the Americas, and beyond.
Key areas of focus include geographic market performance, seasonal revenue trends, top-performing products and customers, and delivery reliability.
Northwind generated total sales revenue of approximately $1.35 million across the reporting period, with net sales of $1.27 million and total profit of $1.06 million, representing a healthy overall profit margin of approximately 83.5% on net sales.
The United States is the single largest market by both revenue and profit, contributing $199,419 in profit against $263,567 in revenue. Germany closely follows as the second most profitable market at $192,114, while Austria ranks third. Together, the top three markets include USA, Germany, and Austria, which accounts for approximately 46% of total profit. At the other end of the scale, markets such as Poland ($3,070 profit), Norway ($4,838), and Argentina ($6,346) contribute minimally and may need a review relative to the cost of servicing them.
April was the strongest single month at approximately $176,832 in net sales, while January also performed strongly at $155,480. There is a pronounced mid-year dip, with June recording the lowest monthly revenue at just $36,363, less than a quarter of April's figure. Revenue recovers from July onwards, peaking again in December at $116,638.
Beverages is the highest-grossing product category, generating $286,527 in sales revenue, followed by Dairy Products at $251,331 and Meat & Poultry at $178,189. Grains & Cereals is the weakest performer at $100,727, though the gap between the bottom two categories is relatively narrow, suggesting broadly balanced demand across the portfolio.
At the individual product level, Cote de Blaye stands out dramatically as the top-selling product with $149,984 in revenue, nearly double the second-ranked product, Thuringer Rostbratwurst ($87,736). Raclette Courdavault and Camembert Pierrot also feature prominently, reflecting the strength of premium European food products in the portfolio.
The top three customers were QUICK, SAVEA, and ERNSH, collectively accounting for $346,394 in sales revenue, representing approximately 25.6% of total revenue. The loss of any one of these accounts would have a negative impact on overall performance.
Out of 2,155 total orders, the vast majority (1,990 — 92.3%) were delivered on time. However, 92 orders (4.3%) arrived late and 73 (3.4%) had not been shipped at the time of data capture. While on-time performance is strong overall, the volume of unshipped orders is a concern.
Among shippers, United Package handles the largest volume (864 orders), followed closely by Speedy Express (646) and Federal Shipping (645). The difference between Speedy Express and Federal Shipping suggests both are used interchangeably, while United Package carries a greater share of the load.