IS 2200- Business Letter with Data Analysis/Pivot Tables-(50pts) Sprinkles Ice Cream Shoppe want to Expand! Lilly is really impressed with all your work so far! She has just found out that there is a shop in the shopping center where she plans to open where the owner is looking to sell his bakery. BakelT! Has been around for three years and the owner sells Muffins, Donuts and Bagels. Lilly wants you to look at their numbers and help her decide if this is the kind of business that would work well with hers and she might consider taking on BakelT!'s products as part of Sprinkles. After you have completed the analysis, she has asked that you write a formal business letter to her investor, Mr. Smith, with your recommendations and the details of what you found in your analysis. What to do: Analysis/Pivot Tables 1. Use the attached Excel data file to analyze and create the appropriate pivot tables needed to provide the appropriate information for the following: a. Which products are the best selling products in each category (Donuts, Muffins, and Bagels per year? (Hint: this will require a breakdown for both the units sold and the dollar value sold) b. Which products are our best based on total sales per year? c. Which products are our most profitable per year? (Hint: This requires a calculation for each sale) 2. Analyze and create a pivot table for each of the scenarios. 3. Name file yournamebakeitsales.xlsx. Business Letter Recommendation to Investor: Write a formal business letter to Lilly's investor, Mr. Smith, with your recommendations and the details of what you found in your analysis. Refer to your BCOM textbook Appendix documents see Module in D2L for the proper business letter format or use Google or check out your word processor for a business letter template. The letter itself should have a complete and correct standard business letter format. Appropriate language and tone should be used throughout the letter. In addition to the correct structure, your letter should include: 1. 2. Introduction Create your own letterhead. You may use a Word template customized with your consultant information or adding information/graphics etc. to the header and footer.