This integrated project includes Word, Excel, and PowerPoint skills you have learned in this course. Congratulations on earning a summer internship with Hav-A-Java, a company operating two retail stores that sell coffee and related products. One retail store is located in Charleston, South Carolina, while the other is in Myrtle Beach, South Carolina. The company is three years old and has seen approximately 15- to 20-percent growth in profits each year. During your internship, you will report to the vice president of Hav-A Java, Alaina Danielson. The vice president has asked you to research a new product line for the stores - plant-based smoothies. Based on your research, you find the following: . Research has shown an 8 percent growth in the plant-based smoothie market. . The target population for plant-based smoothies is people ages 15 to 35. . Market analysis indicates that only two local retail companies sell plant-based smoothies in the Charleston and Myrtle Beach areas. After meeting with Ms. Danielson to discuss your research, she decides to move forward with a recommendation at the annual meeting that Hav-A-Java develop three plant-based smoothies for market consumption by early next year. She needs your assistance to prepare for the annual meeting and has assigned the following tasks to you (each worth 10 points): Project Project Description Project Name 1 Determine sales quota increases (Excel) SalesQuota_LastnameFirstname.xIsx 2 Build sales worksheet, create charts (Excel) ProductSales_LastnameFirstname.xIsx Write an executive summary - projected sales ExecSummary_LastnameFirstname.docx (Word) 4 Design and create her slide presentation MktgPres_LastnameFirstname.pptx (PowerPoint)Proiect l Hav-A-Java employs six [6] full-time employees as well as several part-time. The full-timers are given a quota for annual sales that they are to meet based on the number of years they have been employed. The 1rice president has determined that the quotas need to he raised for the upcoming year but is not sure whether the quotas should be increased 5- peroent or 3 percent. She has asked you to prepare a mrksheet with the following information {ripofmsjz Sale: I not.\" mm $250 000 5190.000 51151000 You determine Ihe projected quotas at both 15 percent more than the current quota and 3 percent more than the current quota. Your Formulas should also include die current quotas {2 points). You decide that a line chart with markeis will 1.risually enhance the interpretation of the data, and you will add the chart to a new sheet Spoil-Its). You will also add the chart title 211?! Projected Quotas. {Spoiler} After you have formatted the worksheet and named the worksheet and chart tabs, you will save it as SalesQuut-_Lsstu.lmeli'irstusme.xls1. {Ljpoi'nty Proiect 1 In preparation for the vice president's presentation at the annual company meeting, you will build a product sales worksheet with the Following information (3 points): 2020 Percent of Sales Ty - of Coffee ' - - 35% - -E [eece E.resso E. resso Decaf Flavon Flavon Decaf 21% [2% [0% [5% 7% To visually display the data, you have decided to create a 3-D pie chart as a new worksheet. You give the pie chart the title MM Percentage ofles'. {Epomj After you review the chart and worksheet, you decide to add another column that will display the proiected product sales percentages for 202 I . You notice you need to add another row to the worksheet for the new plant-based smoothies. Using the current worksheet, you will add the following information that has gray shading: (2 points) In!\" Percent of Sales 35% 2W:- I294:- I% I594:- HB- Type of Coffee 1.11 Pm of 24% 10% 16% - -: larDecaf Esresso Es : resso Decaf Flavored Flavored Decaf Fleet-hm Smoothies 21% 15% To compare and contrast the current {MED} versus projected sales [2112 I], you will create another 3-D pie chart as a new worksheet that shows the products and projected percentage of sales. Add 2921' Protected Percentage ofoies' as the title ofthe pie chart. {2 points) You also notice that you do not have a title for the worksheet1 so you add a descriptive title for the worksheet. {I point) After formatting the worksheet and charts, you will proofread, check the spelling, and save the workbook as ProduetS-lee_LaetuameFiret-ame.xls:.