StateofColoradoMarijuanaSalesSummarySalesfromJanuary2017RetailMarijuanaSales2CountyJan-17Adams$4,192,709Arapahoe$8,481,055ArchuletaBentBoulder$5,351,831Chaffee$316,009ClearCreek$584,198Conejos$294,331Costilla$214,330Denver$25,681,498Eagle$1,297,711Garfield$1,373,945Gilpin$157,003Grand$378,163Gunnison$546,542HuerfanoJefferson$4,098,431Lake$188,571LaPlata$1,655,168Larimer$3,695,944LasAnimas$2,162,976MesaMoffatMontezuma$1,146,208MorganOteroOurayPark$267,804Pitkin$1,164,037Pueblo$2,334,107Routt$938,153SaguacheSanJuanSanMiguel$426,586SedgwickSummit$2,678,675Weld$2,382,718SumofNRCounties4$3,683,538Total5$76,018,423

The following task uses the following excel data file in Canvas Module 1:BIFM Spring 2021 Module 1 HW1 DataThe data represents the monthly retail marijuana sales in the state of Colorado. Goal/Task 1:Create a 14-month forecast for retail sales in Denver. The forecast should be for every month in the 14 month period; Nov 2020, Dec 2020, and every month of the year 2021. Goal/Task 2: Assume you work in a company that sells a product that is related to the sales of marijuana. Your company sells complimentary snacks and supplies outside recreational marijuana shops via vending machines. You have found that your revenues track directly to sales in Denver, to the tune of 25% of every dollar in retail sales. For these sales, you pay 3% in credit card feesand7% in costs related to running, maintaining, and restocking the vending machines(of every dollar in retail sales).Task:1.You must useExcel2.14 month forecasts(by month, Nov 2020 Dec 2021); Denver retail sales, your company sales; total and net.3.Graph 1: Graph sales for Denver for all months of historic Denver retail sales.4.Graph 2: Copy Graph 1and add your estimates for the 14 forecasted months.5.Graph 3: Copy Graph 2 and add in the estimated retail sales of your company sales; total and net.6.Create a 2-page written summary(max)of the Denver forecast and your complementary sales forecast and support why it is a good forecast. 11pt font, 1-inch margins all around. 5 point lost for > 2 pages.7.Includes 3 graphs to the 2-page written summary, in 1 Word document. Each element should be designed with clarity in mind and must stand alone in meaning and message.8.Items you must upload to Canvas: a. Upload your Word document and Excel file both (required)b. Excel must show your work for grading.