The computer server crashed, and all the Sales Data was lost. We have run a database query and got the monthly sales numbers back. But there is no analysis. The person who built the spreadsheet has left the company.

Our New CEO wants to know what the numbers mean. Your job is to tell explain to her how sales are going so far this year. She wants an analysis of where we are in 2020 compare to last year. Are we on track to sell more or less than last year? Where do sales come from? You can also provide Need to Support your statements with numbers from the sales sheet.

The data is up to May 30, 2020

Customer Locationwise Units and Sales Report Sale Locationwise Units and Sales Report Monthwise Units and Sales Report Customer Location Units. Net Sales. sales Location Units. Net Sales. Month Units Total Price Discount HST Shipping Net Sales USA British Columbia Canada International 462 $ 142,982 9 $ 3,641 300 $ 104,928 4 $ 1,781 Amazon Dealer ebay Local Website Phone 77 $ 26,950 355 $ 104,725 33 $ 11,550 10 $ 3,650 275 $ 98,332 25 $ 8,125 January February March April May June 34 $ 11,859 $ 100 $ 200 $ 75 $ 12,309 65 $ 22,235 $ 172 $ 561 $ 151 $ 23,326 179 $ 42,255 $ 449 $ 1,543 $ 268 $ 59,297 193 $ 53,500 $ 817 $ 1,447 $ 685 $ 65,680 304 $ 89,613 $ 775 $ 2,333 $ 774 $ 92,720 $. $- $- $ $- $- $- $- $ $ $ $- $- $- $ $- $- $- $- $- $- $- $- $- S- $- $- $- $ $- $- $ July August September October November December Units Jun Jul Sep Oct Nov Jan 24 34 Feb 59 65 Mar 139 179 Apr 179 193 May 242 304 Aug 134 Dec 41 2019 2020 210 218 115 38 40 - Customer Locationwise Units and Sales Report Sale Locationwise Units and Sales Report Monthwise Units and Sales Report Customer Location Units. Net Sales. sales Location Units. Net Sales. Month Units Total Price Discount HST Shipping Net Sales USA British Columbia Canada International 462 $ 142,982 9 $ 3,641 300 $ 104,928 4 $ 1,781 Amazon Dealer ebay Local Website Phone 77 $ 26,950 355 $ 104,725 33 $ 11,550 10 $ 3,650 275 $ 98,332 25 $ 8,125 January February March April May June 34 $ 11,859 $ 100 $ 200 $ 75 $ 12,309 65 $ 22,235 $ 172 $ 561 $ 151 $ 23,326 179 $ 42,255 $ 449 $ 1,543 $ 268 $ 59,297 193 $ 53,500 $ 817 $ 1,447 $ 685 $ 65,680 304 $ 89,613 $ 775 $ 2,333 $ 774 $ 92,720 $. $- $- $ $- $- $- $- $ $ $ $- $- $- $ $- $- $- $- $- $- $- $- $- S- $- $- $- $ $- $- $ July August September October November December Units Jun Jul Sep Oct Nov Jan 24 34 Feb 59 65 Mar 139 179 Apr 179 193 May 242 304 Aug 134 Dec 41 2019 2020 210 218 115 38 40