Using the sales sheet provided on Moodle to answer the questions below
- What is the year over year growth (CAGR) in units and as a percentage?
- Compare the products.
- What are the Top 3 products that had the largest increase in units sold and largest decrease in units sold. What is the percentage increase and percentage decrease?
-
- What percentage of total units and dollars sales do the top 5 best products represent? (think 80/20/115 rule
-
- How many products are outside the top 5 and what percentage of Units and Dollars do they represent?
- Compare Selling Country Sales
- Which country had the highest growth in units and which had the highest growth as a percentage
-
- What percentage of sales revenue goes thru each Country?
- Compare Selling Channels
- Which Channel had the highest growth in units and which had the highest growth as a percentage
-
- What percentage of sales revenue goes thru Channel?
- Sales by Month
- Calculate the growth by month ( ex. How many more units were Jan to Jan) by Unit and as a percentage. You have to do all Months
-
- Which month has highest growth in units and which had the highest percentage growth rate (percentage)?
-
- Calculate the growth Month to Date in sales by Unit and as a percentage. (Jan = Jan, Feb= Jan + Feb, March = Jan + Feb + March, et
Compare Month to Date for this year and last year: This calculation looks at how the overall year is going (Are we on target to meet our sales targets)
Compare with a Year and Between Units Dollars and Between years (units) and compare to Overall (where did growth/losses come from) Customer Location USA British Columbia Canada International Grand Total Units 483 35 517 29 1064 Net Sales $173,638 $12,390 $160,398 $11,821 $358,246 Last Year 370 26 451 32 sales Location Amazon Dealer eBay Local / Cheque LTD Website Virtual Terminal Grand Total Units. 160 433 121 14 243 93 1064 Net Sales. Last Year $60,650 121 $121,369 340 $44,561 92 $4,203 13 $92,508 232 $34,956 81 $358,246 879 879 A B D 1 Sales Reports 2 CARG (year over year) and Compare Growth and Loss in Units and to CARG 3 Product Name Units Net Sales. last Year Units 4 BMW E30 11 $ 3,969 9 5 BMW E36 11 $ 3,886 10 6 BMW E46 107 $39,663 87 7 Lexus IS 250 or 350 2 $ 770 0 8 Lexus SC 430 13 $ 4,548 11 9 MB 107 121 $42,716 101 10 MB 113 6 $ 1,980 5 11 MB 124 12 $ 4,374 5 12 MB 129 22 $ 8,315 22 13 MGB 2 $ 525 1 14 Miata 7 $ 1,781 6 15 Mustang 1984 to 1990 1 $ 375 1 16 Mustang 1990 to 1993 4 $ 1,000 2 17 Mustang 1994 to 2004 80 $25,972 92 18 Mustang 2005 to 2011 386 ###### 304 19 Mustang Light Bar 74 $23,158 57 20 PT Cruiser 23 $ 5,839 17 21 Saab 900 5 $ 1,710 5 22 Saab 9-3 (1994-03) 7 $ 2,649 7 23 Sebring 1996 to 2000 7 $ 2,443 7 24 Sebring 2001 to 2006 19 $ 6,378 20 25 Sebring 2007 to 2010 69 $25,578 45 26 Solara 1999 to 2003 4 $ 1,470 4 27 Solara 2005 to 2009 43 $15,553 35 28 Spyder 2000 to 2005 6 $ 1,799 5 29 Thunderbird 9 $ 2,392 9 30 VW 1 3 $ 886 3 31 VW 3 10 $ 2,828 9 32 Grand Total 1064 ###### 879 CARG, Compare Month to Month, MTD to MTD Units and Percentage, Compare Units and Percentatge YTD Jan Feb Mar Jun Oct Nov Dec Units Last year sales MTD This year Sales 20 62 Apr 115 145 May 127 165 Sep 46 Jul 130 100 Aug 114 133 36 29 33 21 32 143 185 879 45 88 70 41 26 37 1064 A1 X fx B D E F G . 1 J K L M N o Q R S T U V V 0 1 2 92 304 57 17 5 7 Net Sales $ 4,930 ###### ###### ###### 0 $ 1 $ 375 4 $ 1,000 80 $ 25,972 386 $125,689 74 $ 23,158 23 $ 5,839 5 $ 1,710 7 $ 2,649 7 $ 2,443 19 $ 6,378 69 $ 25,578 4 $ 1,470 43 $ 15,553 6 $ 1,799 9 $ 2,392 3 $ 886 10 $ 2,828 1064 $358,246 7 ###### 20 Month January February March April May June July August September October November December Units Total Price Discount 29 $ 4,915 $ 70 $ 45 $ 12,194 $ 70 $ 88 $ 32,633 $ 308 $ 145 $ 53,540 $ 649 $ 165 $ 52,315 $ 411 $ 185 $ 60,397 $ 949 $ 100 $ 44,158 $ 387 $ 133 $ 42,850 $ 663 $ 70 $ 23,613 $ 486 $ 41 $ 11,885 $ 172 $ 26 $ 8,631 $ 105 $ 37 $ 9,660 $ 290 $ HST Shipping 85 $ 280 $ 175 833 $ 202 1,126 $ 701 1,387 $ 476 2,299 $ 544 1,758 $ 1,258 $ 676 452 $ 55 148 $ 655 $ 33 213 $ ###### 45 20 Must 05+ BOTTOM ONLY 21 Mustang 1984 to 1990 22 Mustang 1990 to 1993 23 Mustang 1994 to 2004 24 Mustang 2005 to 2011 25 Mustang Light Bar 26 PT Cruiser 27 Saab 900 28 Saab 9-3 (1994-03) 29 Sebring 1996 to 2000 30 Sebring 2001 to 2006 31 Sebring 2007 to 2010 32 Solara 1999 to 2003 33 Solara 2005 to 2009 34 Spyder 2000 to 2005 35 Thunderbird 36 VW 1 37 VW 3 38 Grand Total 39 40 41 42 43 44 45 46 47 48 49 304 4 ###### 35 5 ###### ###### $ 8,493 $ 9,583 9 3 9 879 CARG, Compare Month to Month, MTD to MTD Units and Percentage, Compare Units and Percentatge YTD last year Sales MTD YTD Sales % Units Last year sales MTD This year Sales Apr Jul Sep 46 Jan 36 29 (7) Feb 20 45 25 Mar 62 88 26 Dec 32 115 145 30 May 127 165 38 Jun 143 185 42 Aug 114 133 130 100 (30) Oct 33 41 Nov 21 26 70 37 Stores Sales 2018 Sales 2019 1 6500 5500 2 3000 2500 3 5000 4000 4 8000 7000 5 2500 8000 6 9000 Compare with a Year and Between Units Dollars and Between years (units) and compare to Overall (where did growth/losses come from) Customer Location USA British Columbia Canada International Grand Total Units 483 35 517 29 1064 Net Sales $173,638 $12,390 $160,398 $11,821 $358,246 Last Year 370 26 451 32 sales Location Amazon Dealer eBay Local / Cheque LTD Website Virtual Terminal Grand Total Units. 160 433 121 14 243 93 1064 Net Sales. Last Year $60,650 121 $121,369 340 $44,561 92 $4,203 13 $92,508 232 $34,956 81 $358,246 879 879 A B D 1 Sales Reports 2 CARG (year over year) and Compare Growth and Loss in Units and to CARG 3 Product Name Units Net Sales. last Year Units 4 BMW E30 11 $ 3,969 9 5 BMW E36 11 $ 3,886 10 6 BMW E46 107 $39,663 87 7 Lexus IS 250 or 350 2 $ 770 0 8 Lexus SC 430 13 $ 4,548 11 9 MB 107 121 $42,716 101 10 MB 113 6 $ 1,980 5 11 MB 124 12 $ 4,374 5 12 MB 129 22 $ 8,315 22 13 MGB 2 $ 525 1 14 Miata 7 $ 1,781 6 15 Mustang 1984 to 1990 1 $ 375 1 16 Mustang 1990 to 1993 4 $ 1,000 2 17 Mustang 1994 to 2004 80 $25,972 92 18 Mustang 2005 to 2011 386 ###### 304 19 Mustang Light Bar 74 $23,158 57 20 PT Cruiser 23 $ 5,839 17 21 Saab 900 5 $ 1,710 5 22 Saab 9-3 (1994-03) 7 $ 2,649 7 23 Sebring 1996 to 2000 7 $ 2,443 7 24 Sebring 2001 to 2006 19 $ 6,378 20 25 Sebring 2007 to 2010 69 $25,578 45 26 Solara 1999 to 2003 4 $ 1,470 4 27 Solara 2005 to 2009 43 $15,553 35 28 Spyder 2000 to 2005 6 $ 1,799 5 29 Thunderbird 9 $ 2,392 9 30 VW 1 3 $ 886 3 31 VW 3 10 $ 2,828 9 32 Grand Total 1064 ###### 879 CARG, Compare Month to Month, MTD to MTD Units and Percentage, Compare Units and Percentatge YTD Jan Feb Mar Jun Oct Nov Dec Units Last year sales MTD This year Sales 20 62 Apr 115 145 May 127 165 Sep 46 Jul 130 100 Aug 114 133 36 29 33 21 32 143 185 879 45 88 70 41 26 37 1064 A1 X fx B D E F G . 1 J K L M N o Q R S T U V V 0 1 2 92 304 57 17 5 7 Net Sales $ 4,930 ###### ###### ###### 0 $ 1 $ 375 4 $ 1,000 80 $ 25,972 386 $125,689 74 $ 23,158 23 $ 5,839 5 $ 1,710 7 $ 2,649 7 $ 2,443 19 $ 6,378 69 $ 25,578 4 $ 1,470 43 $ 15,553 6 $ 1,799 9 $ 2,392 3 $ 886 10 $ 2,828 1064 $358,246 7 ###### 20 Month January February March April May June July August September October November December Units Total Price Discount 29 $ 4,915 $ 70 $ 45 $ 12,194 $ 70 $ 88 $ 32,633 $ 308 $ 145 $ 53,540 $ 649 $ 165 $ 52,315 $ 411 $ 185 $ 60,397 $ 949 $ 100 $ 44,158 $ 387 $ 133 $ 42,850 $ 663 $ 70 $ 23,613 $ 486 $ 41 $ 11,885 $ 172 $ 26 $ 8,631 $ 105 $ 37 $ 9,660 $ 290 $ HST Shipping 85 $ 280 $ 175 833 $ 202 1,126 $ 701 1,387 $ 476 2,299 $ 544 1,758 $ 1,258 $ 676 452 $ 55 148 $ 655 $ 33 213 $ ###### 45 20 Must 05+ BOTTOM ONLY 21 Mustang 1984 to 1990 22 Mustang 1990 to 1993 23 Mustang 1994 to 2004 24 Mustang 2005 to 2011 25 Mustang Light Bar 26 PT Cruiser 27 Saab 900 28 Saab 9-3 (1994-03) 29 Sebring 1996 to 2000 30 Sebring 2001 to 2006 31 Sebring 2007 to 2010 32 Solara 1999 to 2003 33 Solara 2005 to 2009 34 Spyder 2000 to 2005 35 Thunderbird 36 VW 1 37 VW 3 38 Grand Total 39 40 41 42 43 44 45 46 47 48 49 304 4 ###### 35 5 ###### ###### $ 8,493 $ 9,583 9 3 9 879 CARG, Compare Month to Month, MTD to MTD Units and Percentage, Compare Units and Percentatge YTD last year Sales MTD YTD Sales % Units Last year sales MTD This year Sales Apr Jul Sep 46 Jan 36 29 (7) Feb 20 45 25 Mar 62 88 26 Dec 32 115 145 30 May 127 165 38 Jun 143 185 42 Aug 114 133 130 100 (30) Oct 33 41 Nov 21 26 70 37 Stores Sales 2018 Sales 2019 1 6500 5500 2 3000 2500 3 5000 4000 4 8000 7000 5 2500 8000 6 9000
