Summary of Last Year’s Sales Performance

Sales Overview:

Weekly units sold ranging from 2,408 to 38,648
Monthly units sold ranging from a low of 15,918 in April 2017 to a high 119,693 in July 2017

 

 

Revenue Performance:

Weekly revenue from lowest £ £7,835 to £68,540 £126,166
Monthly revenue from £25,523 in April to £395,112 in July

52 Weeks Chart Price

Comparison of the difference between store and online prices

The average sell price is relatively stable, hovering around £3.28 to £3.34 for most weeks. This consistency helps in maintaining a predictable turnover.

 

 

Summary:

The sales units for Product B varied significantly across the weeks, with a peak in the week of 04/09/2017, when 38,648 units were sold and total turnover reached £126,620. However, while Product B showed strong performance, particularly in-store, web turnover constituted only a small portion of the total. For instance, during the peak week of 04/09/2017, web sales accounted for just 0.35% of total sales. There are noticeable spikes in sales during certain months that correspond to rainy weather. The average sell price is relatively stable, stock availability, all year on high level

Rain fall during peak sale 

Product:

Comparing the peak sales months with the weather chart showing the highest rainfall in these months, and considering the low price of the product as well as the difference between store and online sales, I would say the product may be an umbrella

 

Additional Information:

 

Query to find the price difference over 52 weeks, result percentage
SELECT 
    CASE 
        WHEN MIN(Average_sell_price) = 0 THEN NULL
        ELSE CAST(
            (MAX(Average_sell_price) – MIN(Average_sell_price)) / MIN(Average_sell_price) * 100
            AS DECIMAL(5,2)
        )
    END AS percentage_difference
FROM 
    [dbo].[Product_B];
>
>
 CTE Query to track difference between sale price week by week over 52 weeks, result percentage
WITH WeeklyAverages AS (
SELECT
WeekNum,
AVG(Average_sell_price) AS AvgPrice
FROM [dbo].[Product_b]
GROUP BY WeekNum
),
PriceDifferences AS (
SELECT
WeekNum,
AvgPrice,
LAG(AvgPrice) OVER (ORDER BY WeekNum) AS PrevWeekPrice
FROM WeeklyAverages
)
SELECT
WeekNum,
AvgPrice AS CurrentWeekPrice,
PrevWeekPrice,
CASE
WHEN PrevWeekPrice IS NULL THEN 0
ELSE cast(((AvgPrice – PrevWeekPrice) / PrevWeekPrice) * 100 as decimal(6,2))
END AS PercentageDifference
FROM PriceDifferences;
>
>
Query to find store and web sale difference over 52 weeks, result percentage

SELECT
YEAR(Week_Commencing) AS [Year],
MONTH(Week_Commencing) AS [Month],
Store_sales_units,
Web_sale_Units,
CONVERT( NUMERIC (8,2) ,((Store_sales_units – Web_sale_Units) * 100.0) /   Web_sale_Units )AS Percentage_Difference
FROM [dbo].[Product_B];