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)
Sales last Compare with a Year and Actween Units Dollars and Between years (units) and compare to Overall where did growth/losses come from) Units Product Name Net Sales. Year Units Customer Location Units Net Sales. sales Location Units. Net Sales. Last Year USA British Columbia Canada International Grand Total 483 $ 173,638 35 $ 12,390 517 $ 160,398 29 $ 11,821 1064 $ 358,246 370 26 451 32 879 121 340 92 13 15.04% 16.03% 40.70% 11.37% 1.32* Amazon Dealer eBay Local / Checue LTD Website Realacement Returned Virtual Termina Grand Total 160 $ 60,650 433 $121,369 121 $ 44,551 14 $ 4,203 243 $ 92,508 D$ DS 93 $ 34,956 1064 $358,246 232 22.8% 0.00 81 B79 100,00 2.72 BMW E30 BMW E36 BMW E46 Lexus IS 250 or 350 Lexus 5C 430 MB 107 MB 113 MB 124 MB 129 MGB Miata Must 05+ BOTTOM ONLY Mustang 1984 to 1991 Mustang 1990 to 1993 Mustang 1994 to 2004 Mustang 2005 to 2011 Mustang Light Bar PT Cruiser Saab 900 Saab 9-3 (1994-03) Sebring 1996 to 2000 Sebring 2001 to 2006 Sebring 2007 to 2010 Solara 1999 to 2003 Solara 2005 to 2009 Spyder 2000 to 2005 Thunderbird Ww1 VW3 Grand Total 11 $ 3,969 11 $ 3.886 107 S 39,663 2 $ 770 13 $ 4,548 121 $ 42,716 6 $ 1,980 12 $4,374 22 $ 8,315 2 $ 525 7 $ 1,781 0 $ 15 375 4 $ 1,000 80 $ 25,972 386 $125,689 74 S 23,158 23 $ 5,939 S$ 1,710 7 $ 2,549 7 $ 2443 19 $ 6,378 69 $ 25,578 4 $ 1,470 43 S 15,553 6 $ 1,799 9 $ 2,892 3 $ 886 10 S 2,828 1064 $358,245 9 10 87 0 11 101 5 5 22 1 6 D 1 2 92 304 S7 17 5 7 7 20 45 4 35 5 9 3 476 Month January February March April May June July August September October November December Units Total Price Discount 29 $ 4,915 $ 705 45 $ 12,194 $ 70 S $ 88 $ 32,633 $ 908 $ 145 $ 53,540 $ 649 $ 165 $ 52,315 $ 411 5 185 $ 60,397 $ 949 $ 100 $ 44,158 $ 387 $ 133 S 42,850 $ 663 $ 70 $ 23,613 $ 486 S 41 $ 11,895 $ 172 $ 172 $ 26 $ 8,631 $ 105 37 S 9,660 $ 290 $ HST Shipping Net Sales 85 $ $ 4,930 280 $ 175 ##HA 833 $ 202 ### 1,126 $ 701 ###### 1,387 $ ##### 2.299 $ 544 HAHAHA 1.758 S $ 304 HNHAM 1.250 $ 676 452 $ 55 149 $ 655 ##### - $ 33 $ 8,493 213 $ - $9,583 879 CARG, Compare Month to Morth, MTD to MID Units and Percentage, Compare Units and Percentatge YT 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 Net Sales. Last Year $173,638 370 $12,390 26 $160,398 451 $11,821 32 $358,246 879 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 29 1064 A B D 1 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 VW3 10 $ 2,828 9 32 Grand Total 1064 ###### 879 1 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 Apr 115 62 36 29 May 127 165 20 45 Jul 130 100 143 185 33 Aug 114 133 Sep 46 70 21 26 32 37 879 1064 88 145 41 Stores 3 4 Sales 2018 Sales 2019 1 6500 5500 2 3000 2500 3 5000 4000 4 8000 7000 5 2500 8000 6 9000 Sales last Compare with a Year and Actween Units Dollars and Between years (units) and compare to Overall where did growth/losses come from) Units Product Name Net Sales. Year Units Customer Location Units Net Sales. sales Location Units. Net Sales. Last Year USA British Columbia Canada International Grand Total 483 $ 173,638 35 $ 12,390 517 $ 160,398 29 $ 11,821 1064 $ 358,246 370 26 451 32 879 121 340 92 13 15.04% 16.03% 40.70% 11.37% 1.32* Amazon Dealer eBay Local / Checue LTD Website Realacement Returned Virtual Termina Grand Total 160 $ 60,650 433 $121,369 121 $ 44,551 14 $ 4,203 243 $ 92,508 D$ DS 93 $ 34,956 1064 $358,246 232 22.8% 0.00 81 B79 100,00 2.72 BMW E30 BMW E36 BMW E46 Lexus IS 250 or 350 Lexus 5C 430 MB 107 MB 113 MB 124 MB 129 MGB Miata Must 05+ BOTTOM ONLY Mustang 1984 to 1991 Mustang 1990 to 1993 Mustang 1994 to 2004 Mustang 2005 to 2011 Mustang Light Bar PT Cruiser Saab 900 Saab 9-3 (1994-03) Sebring 1996 to 2000 Sebring 2001 to 2006 Sebring 2007 to 2010 Solara 1999 to 2003 Solara 2005 to 2009 Spyder 2000 to 2005 Thunderbird Ww1 VW3 Grand Total 11 $ 3,969 11 $ 3.886 107 S 39,663 2 $ 770 13 $ 4,548 121 $ 42,716 6 $ 1,980 12 $4,374 22 $ 8,315 2 $ 525 7 $ 1,781 0 $ 15 375 4 $ 1,000 80 $ 25,972 386 $125,689 74 S 23,158 23 $ 5,939 S$ 1,710 7 $ 2,549 7 $ 2443 19 $ 6,378 69 $ 25,578 4 $ 1,470 43 S 15,553 6 $ 1,799 9 $ 2,892 3 $ 886 10 S 2,828 1064 $358,245 9 10 87 0 11 101 5 5 22 1 6 D 1 2 92 304 S7 17 5 7 7 20 45 4 35 5 9 3 476 Month January February March April May June July August September October November December Units Total Price Discount 29 $ 4,915 $ 705 45 $ 12,194 $ 70 S $ 88 $ 32,633 $ 908 $ 145 $ 53,540 $ 649 $ 165 $ 52,315 $ 411 5 185 $ 60,397 $ 949 $ 100 $ 44,158 $ 387 $ 133 S 42,850 $ 663 $ 70 $ 23,613 $ 486 S 41 $ 11,895 $ 172 $ 172 $ 26 $ 8,631 $ 105 37 S 9,660 $ 290 $ HST Shipping Net Sales 85 $ $ 4,930 280 $ 175 ##HA 833 $ 202 ### 1,126 $ 701 ###### 1,387 $ ##### 2.299 $ 544 HAHAHA 1.758 S $ 304 HNHAM 1.250 $ 676 452 $ 55 149 $ 655 ##### - $ 33 $ 8,493 213 $ - $9,583 879 CARG, Compare Month to Morth, MTD to MID Units and Percentage, Compare Units and Percentatge YT 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 Net Sales. Last Year $173,638 370 $12,390 26 $160,398 451 $11,821 32 $358,246 879 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 29 1064 A B D 1 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 VW3 10 $ 2,828 9 32 Grand Total 1064 ###### 879 1 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 Apr 115 62 36 29 May 127 165 20 45 Jul 130 100 143 185 33 Aug 114 133 Sep 46 70 21 26 32 37 879 1064 88 145 41 Stores 3 4 Sales 2018 Sales 2019 1 6500 5500 2 3000 2500 3 5000 4000 4 8000 7000 5 2500 8000 6 9000
