Task
Best practices for businesses is to compare, evaluate, and report on performance; both this year and last year. This shows growth or decline and measures changes in strategies. Your task is to download the file and complete the This Year/Last Year spreadsheets following the directions on the INSTRUCTIONS tab. Post questions to the FAQ. Remember, if you have the question most likely another person does too! In-Class Activity - TY vs LY.xisx NOTE: Instructions are available within the Excel file. With the file open in Excel, dig around and search for the instructions. Where could the Instructions be hiding? HINT: Helpful Functions Assignment introduced VLOOKUP needed for this assignment. See FAQ Discussion for more formula hints.Instock WGSN Product Assortment Report KPI All Date Range September 1st, 2017 - September 30th, 2017 Country US Retailer Shopbop Product Womens Apparel Tops Price All Color All Prints & Graphics All Material All View By Retailers Country Retailers Subcategories Count % of Total US Shopbop T-shirts & tee 1427 US Shopbop Tank top 647 US Shopbop Cold shoulder 530 US Shopbop Fleece sweatshirt 486 US Shopbop Crop top 391 US Shopbop Bodysuit 271 US Shopbop Hoodies & track tops 221 US Shopbop Other 153 US Shopbop Vests 118 US Shopbop Shell top 94 US Shopbop Tunic 62 US Shopbop Tshirts & Tees 44 US Shopbop Swing top 37 US Shopbop Strapless top 36 US Shopbop Maternity 31 US Shopbop Henley shirt 22 US Shopbop Polo shirt 5 US Shopbop Jumpers & sweaters 4 US Shopbop Long sleeved 4 US Shopbop Bandeau top US Shopbop Sleeveless Shirt US Shopbop Ruffled blouse US Shopbop Blouses Top US Shopbop Sweater & jumper dress US Shopbop Tunic dress US Shopbop Cardigans US Shopbop Wrap Shirt US Shopbop Pyjamas US Shopbop Sports US Shopbop Kimono top US Shopbop Cover-ups US Shopbop Short sleeved US Shopbop Striped ShirtInstock WGSN Product Assortment Report KPI All Date Range September 1st, 2016 - September 30th, 2016 Country US Retailer Shopbop Product Womens Apparel Tops Price All Color All Prints & Graphics All Material All View By Retailers Country Retailers Subcategories Count % of Total US Shopbop T-shirts & tee 1093 US Shopbop Tank top 575 US Shopbop Fleece sweatshirt 329 US Shopbop Cold shoulder 273 US Shopbop Crop top 268 US Shopbop Bodysuit 181 US Shopbop Vests 108 US Shopbop Hoodies & track tops 95 US Shopbop Other 82 US Shopbop Tunic 77 US Shopbop Henley shirt 35 US Shopbop Strapless top 23 US Shopbop Maternity 21 US Shopbop Shell top 12 US Shopbop Kimono top 10 US Shopbop Bandeau top 8 US Shopbop Swing top US Shopbop Polo shirtInstock WGSN Price Assortment Report KPI All Date Range September 1st, 2017 - September 30th, 2017 Country US Retailer Shopbop Product Womens Apparel Tops Price All Color All Prints & Graphics All Material All View By Retailers Country Retailers Price Range (USD Average Price (USD Count % of Total US Shopbop 0 - 1.99 US Shopbop 2 - 3.99 O 0 US Shopbop 4 - 5.99 0 0 US Shopbop 6 - 7.99 0 0 US Shopbop 8 - 9.99 0 0 US Shopbop 10 - 11.99 11.1 3 US Shopbop 12 - 14.99 14.05 4 Shopbop 15 - 19.99 18.17 18 Shopbop 20 - 29.99 25.52 75 Shopbop 30 - 39.99 35.04 159 Shopbop 40 - 49.99 45.31 258 Shopbop 50 - 59.99 55.32 275 Shopbop 60 - 69.99 64.67 284 Shopbop 70 - 79.99 75.37 323 Shopbop 80 - 89.99 85.37 281 Shopbop 90 - 99.99 95.31 294 Shopbop 100 - 199.99 144.28 1344 Shopbop 200 - 299.99 253.05 444 Shopbop 300 - 399.99 354 220 Shopbop 400 - 499.99 455.19 101 Shopbop 500 - 999.99 678.46 137 Shopbop 1000 - 2499.99 1494.43 15 Shopbop 2500 - 4999.99 2995 1 Shopbop 5000 - 7499.99 0 Shopbop 7500 - 9999.99 O Shopbop 10000+Instock WGSN Price Assortment Report KPI All Date Range September 1st, 2016 - September 30th, 2016 Country US Retailer Shopbop Product Womens Apparel Tops Price All Color All Prints & Graphics All Material All View By Retailers Country Retailers Price Range (USD Average Price (USD Count % of Total US Shopbop 0 - 1.99 0 US Shopbop 2 - 3.99 0 0 US Shopbop 4 - 5.99 0 0 US Shopbop 6 - 7.99 7.5 1 US Shopbop 8 - 9.99 0 0 US Shopbop 10 - 11.99 0 0 US Shopbop 12 - 14.99 13.05 2 Shopbop 15 - 19.99 18.15 12 Shopbop 20 - 29.99 25.7 70 Shopbop 30 - 39.99 35.24 131 Shopbop 40 - 49.99 45.53 212 Shopbop 50 - 59.99 54.96 235 Shopbop 60 - 69.99 64.74 249 Shopbop 70 - 79.99 74.81 224 Shopbop 80 - 89.99 85.06 190 Shopbop 90 - 99.99 95.28 184 Shopbop 100 - 199.99 142.78 836 Shopbop 200 - 299.99 252.16 240 Shopbop 300 - 399.99 360.92 153 Shopbop 400 - 499.99 461.68 61 Shopbop 500 - 999.99 676.2 75 Shopbop 1000 - 2499.99 1517.5 18 Shopbop 2500 - 4999.99 3300 1 Shopbop 5000 - 7499.99 0 Shopbop 7500 - 9999.99 10000+ O ShopbopInstock WGSN Colour Assortment Report KPI All Date Range September 1st, 2017 - September 30th, 2017 Country US Retailer Shopbop Product Womens Apparel Tops Price All Color All Prints & Graphics All Material All View By Retailers Country Retailers Colours Count % of Total US Shopbop Black 1236 US Shopbop White 852 US Shopbop Multi 707 US Shopbop Grey 454 US Shopbop Blue 443 US Shopbop Neutral 314 US Shopbop Pink 172 US Shopbop Red 122 US Shopbop Green 103 US Shopbop Purple 68 US Shopbop Brown 41 US Shopbop Orange 40 US Shopbop Yellow 40 US Shopbop Metallic 29Instock WGSN Colour Assortment Report KPI All Date Range September 1st, 2016 - September 30th, 2016 Country US Retailer Shopbop Product Womens Apparel Tops Price All Color All Prints & Graphics All Material All View By Retailers Country Retailers Colours Count % of Total US Shopbop Black 978 US Shopbop White 744 US Shopbop Grey 417 US Shopbop Multi 373 US Shopbop Blue 276 US Shopbop Neutral 241 US Shopbop Green 86 US Shopbop Pink 80 US Shopbop Red 76 US Shopbop Purple 38 US Shopbop Brown 27 US Shopbop Orange 26 US Shopbop Metallic 13 US Shopbop Yellow 9In-Class Activity: TY vs LY Calculate % of Total columns using Absolute Cell References. Bring each LY's data onto each TY's tab so you can compare all Classifications, Price Points, and Colors side by side. Do not copy, paste, or sort. Calculate the % change TY vs LY. Add Data Bars to your % change. Create three charts, each comparing TY and LY side by side. What conclusions can you draw from your data
