Tuesday, 1 April 2014

For various reasons, my manager recently asked me to compare this month's sales to this month last year's sales, for active SKUs alone.

First, I ran a report for each period and formatted the hellish mess out of them (our EPOS generates some pretty cluttered reports!) Then I reinserted products that have been deleted and are no longer recognised. I compiled both reports and removed the duplicates (to get one comprehensive list of all products sold). I sorted by a part of the product code, to separate out the categories. Finally I vlooked-up (or vlookuped?) status and sorted discontinued/newly-launched product to the bottom.

When it was looking a bit better, I pulled in the sales by value and by unit for 2013 and 2014. After this, I calculated the % difference (by value and by unit) for each product, the % difference by category, and the % difference by category taking into account only active products (it was the last one we were really interested in). To finish, I calculated % difference across all products and across all active products.

What I found was really useful and really positive: strong growth, particularly in active SKUs. And my manager has asked me to do this every month going forward - no small task, but I am pretty proud to have devised a report he appreciates.

Last post, I pulled together some 'botanical illustration' floral prints. I'm not branching out too much this week - I've focussed on floral pencil-drawing prints. Hope you like:

Esprit Printed Cotton Trousers £55, Uniqlo Modal Linen Blended T-Shirt £9.90, Alexander Wang Patent-Leather Loafers £565, Miller Harris Fleur du Matin from £65, Diptyque Rich Body Butter £50, Cowshed Knackered Cow Relaxing Body Lotion £18, Sanderson Anise Wallpaper from £46, Cole and Son Frontier Water Lily Wallpaper from £72

No comments:

Post a Comment