Kenneth

My Candy Store Power BI Desktop Year, Quarter, Month, Day Overview Total Revenue Items Sold € 212.70M 12.8%▲ Max € 254.37K 4210 Brands Count Avg € 1.22K 922 Category Count Q1 Q2 Q3 Q4 Q1 Q2 2022 Q3 Q4 2023 Total Volume 15.3%▲ 4 27.2M Product Types Avg 155.70 Qtr 4 Qtr 1 Qtr 2 Qtr 3 2023   Qtr 1   Qtr 2 We have on record a total of 877 distinct items, 922 brands and 6 manufacturers, 4210 items in have been sold through 2 distribution channels within the space of 2 years.   Qtr 3   Qtr 4   2023   Qtr 1   Qtr 2   Qtr 3 Distribution Channels Volume SMALL AND SPECIALTY STO… SUPERMARKE… 2.9M (23.73%) 9.4M (76.27%) 2 9 Manufacturers 6 Qtr 2 Qtr 3 2022 Volume Channels Count Max 55,200 Qtr 1 Revenue   2022 Revenue by Category € 97M CHIPS AND SNACKS € 82M BAKERY PRODUCTS CANDY Qtr 4 CHOCOLATE BARS € 11M € 22M  My Candy Store Power BI Desktop Year, Quarter, Month, Day Overview Manufacturer Product MANUFACTURER Revenue   2022 Volume   Qtr 1   Qtr 2   Qtr 3 Brand   Qtr 4   2023 Rank CurrentRevenue RevenueChange PrevQtrRank RankMovement QoqRev   Qtr 1   Qtr 2 ELITE SWEETS 6 € 4,168,140 € 652,000 6 0⇡ 15.6%▲ OTHERS 1 € 88,554,640 € 13,769,460 1 0⇡ 15.5%▲ PRIVATE LABEL 5 € 14,232,590 € 2,562,150 5 0⇡ 18.0%▲ ROYAL BLENDS GROUP 2 € 69,732,790 € 10,283,440 2 0⇡ 14.7%▲ STERLING FOODS 3 € 20,553,410 € 2,770,280 3 0⇡ 13.5%▲ UNITY DELIGHT INTERNATIONAL 4 € 15,459,000 € 2,432,230 4 0⇡ 15.7%▲ Top 10 items by Revenue How Volume Impacts Revenue € 0.3M € 7.3M € 4.9M € 3.8M € 3.2M € 3.2M € 3.1M € 3.1M € 3.0M € 2.9M € 2.8M SALES VOLUME in EUR CRUSTY CHEDD… FINE SLICES SO… CHIPS BLUE CH… CRUSTY CHILI VANILLA WAFERS WAVED CHEESE CHIP & DIP LES… CHIPS TZATZIKI CHIP & DIP SO… CLASSIC CHEESE   Qtr 3 € 0.2M € 0.1M € 0.0M 0K 10K 20K 30K 40K SALES VOLUME IN KG 50K 60K  My Candy Store Power BI Desktop Year, Quarter, Month, Day Overview Revenue Items Breakdown ITEM ID      CHIPS AND SNACKS CHOCOLATE BARS 1 100   Qtr 1   Qtr 2   Qtr 3 MANUFACTURER × 480.0 44,614.0 TotalVolume 27,179,652.0 48.0 7,313.0 1002 24.0 1003 Total 12,389,249.0 4,128,268.0 48 0 9,650,023.0 How Package Type Impacted Volume 2.4M 1.8M 1.0M 0.4M 0.1M 0.0M 0.0M 0.0M 0.0M 4.2M 6.0M PRIVATE LABEL 2,784,070.0 STERLING FOODS 2,112,630.0 1,012,112.0 CRUSTY CHED… VANILLA WAFE… CHOCOLATE W… FINE SLICES SO… CRUSTY CHILI CHIP & DIP SO… CHIP & DIP VE… CHIP & DIP LES… WAVED CHEESE CHIPS BLUE CH…   Qtr 3 ROYAL BLENDS … 8,962,600.0  Package Type; Top10 Items by Volume 11.2M   2023   Qtr 2 OTHERS 11,352,222.0 480.0 1001   Qtr 4   Qtr 1 480.0 1000 BAG UNPACKED FLOW WRAP PAPER BOX TUBE WEIGHTED BARS PLASTIC BOX PLASTIC TRAY JAR BUCKET OTHER PLASTIC BASKET Volume Volume by Manufactures BAKERY PRODUCTS CANDY  CHIPS  10   2022 0.80M 0.73M 0.54M 0.45M 0.35M 0.33M 0.31M 0.31M 0.31M 0.30M Unpacked Items being the second highest in volume has caught my attention as this form of packaging reduces package costs and has still managed to remain relevant over time. Stakeholders should encourage usage. 