Summary of Last Year’s Sales Performance

 

Sales Overview:

Weekly  units sold ranging from a low of 543 to a high of 1,852.

Monthly units sold ranging from a low of 2516 in June 2017 to a high 6413 in December 2017

 

 

 

 

Revenue Performance:

Weekly revenue from lowest £ 18,619 to £68,540

Monthly revenue from £77,823 in June 2017 to £237,992 in December 2017

 

 

 

 

52 Weeks Chart Price

 

 

 

Chart the relationship between weather and sales.

Summary:

There are periods of sharp increases, mid-August to October, with a peak in December at 6,413 units and £238,028 in revenue, where the weather starts dropping from 14.5ºC to 5.8ºC. There were periods of lower performance in June and July, where in some weeks, sales dipped below 600 units. This pattern suggests seasonal demand or other external factors, such as Christmas sales. Given the upward trend in sales observed in the second half of the year, it’s expected that this trend will continue into the next year. Based on the observed growth in the latter half of the year, I expect an average growth rate of around 10.11% in sales units for the coming year. If the price increase remains above 10%, then the lowest monthly total revenue will be around June 2018, with £77,823 + 10.11% = £85,690 in revenue, and the highest total revenue will be around December, with £237,992 + 10.11% = £262,052 in revenue.

Product:

Taking into account the temperature changes, pricing, season, and Christmas period, I would say that the product is winter clothing, such as jackets or shoes or Christmas gift 

 

 

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];