Home inte Or Page Layout Tarm Data Rusiew Vww Tel City wat - . -- A- 5 % -5 Free For - FS - -31 H 352 19 NE 1, 1 w 2021 Mb Me More 2. 15201 CM 14.00 MDC $ E www . . L. WE 4111 1991 SES LIGE TRE EN 21 JERSE 103 OLET SLIH 11 HA 1340 NE . . 1 NAS 3.93590 4.2 S 250 1. i 25 14.75 1.82 33 2.706 25 % DES 11.61592133903 LES 1.00 11 CASTRO 5.2010 15605 2103 1 11 LE 14.00 LEN 21.1 TILL 111 BEN HE DEN D . 30341 1048 BE LE 1212 SEGE . . . . 11 DE .NL 09120 LO Bayan DO TE 23 130 13 STRE www. LVL SOLO SOS TEST ** M. 22 VE BE DES WE COM ANTOS 2) RE EE OST . . TE 9 LE SF VE . 11997 RI BORRE 3 1551 5 5 150 A) LE NE SU DELT L. Na 178 25 1 .. . 17 TES 933 tie TE 16 2018 + HE WW 22 DER TESTS 7411 . Disco 1.1 B 3.1 . SER SEIF 2,10 writt . . 5 STONE 1925 325 14 1575003 25 NIH DE DE ht RE 1125 2012 US INTI VE EFT 20 11 SALLE 19 BE M . LOVE BE SI C 2011 13 43 ESE SM1 GO LE RE Det Sant 1 55.00 . WE 1 Gm OF OPIN . 1 11 Inese 2.1 S2021 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 Bakelti'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. Introduction 2. 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 3. You are working for Lilly Waters, owner of Sprinkles Ice Cream Shoppe. You have completed the analysis on the Bakelti business and will share the information with Mr. Thomas and make a recommendation, Mr. Miles Smith Senior Investor @ Large Inc 1500 Main Street Marietta, GA 30156 4. 5 Integrate the 3 pivot tables in an informative and useful way to answer the three questions regarding the Bakelt! data. Create a Word table that provides the pros and cons for acquiring and investing in the Bakelti business for Sprinkles Ice Cream Shoppe. Include your recommendation based on the data. Conclusion Name your file: yournamebusletter.docx 6 7. 8. What to Submit 1. Submit your Pivot Table Analysis (Excel) document to D2L. A link is not acceptable. You must submit the file 2. Submit your Business Letter (Word Doc) document to D2L. A link is not acceptable. You must submit the file. Please refer to the following grade rubric to ensure that you accounted for all components of the assignment Possible points 5 points 10 points 10 points Criteria Spelling and grammar Correct business letter format with your logo Pivot table data integrated into document and explanation of the data questions Table - one you create in Word and recommendation Professional content and writing 3 Pivot tables created in the Excel file accurately and completely answering the analysis questions 10 points 15 points 25 points Home inte Or Page Layout Tarm Data Rusiew Vww Tel City wat - . -- A- 5 % -5 Free For - FS - -31 H 352 19 NE 1, 1 w 2021 Mb Me More 2. 15201 CM 14.00 MDC $ E www . . L. WE 4111 1991 SES LIGE TRE EN 21 JERSE 103 OLET SLIH 11 HA 1340 NE . . 1 NAS 3.93590 4.2 S 250 1. i 25 14.75 1.82 33 2.706 25 % DES 11.61592133903 LES 1.00 11 CASTRO 5.2010 15605 2103 1 11 LE 14.00 LEN 21.1 TILL 111 BEN HE DEN D . 30341 1048 BE LE 1212 SEGE . . . . 11 DE .NL 09120 LO Bayan DO TE 23 130 13 STRE www. LVL SOLO SOS TEST ** M. 22 VE BE DES WE COM ANTOS 2) RE EE OST . . TE 9 LE SF VE . 11997 RI BORRE 3 1551 5 5 150 A) LE NE SU DELT L. Na 178 25 1 .. . 17 TES 933 tie TE 16 2018 + HE WW 22 DER TESTS 7411 . Disco 1.1 B 3.1 . SER SEIF 2,10 writt . . 5 STONE 1925 325 14 1575003 25 NIH DE DE ht RE 1125 2012 US INTI VE EFT 20 11 SALLE 19 BE M . LOVE BE SI C 2011 13 43 ESE SM1 GO LE RE Det Sant 1 55.00 . WE 1 Gm OF OPIN . 1 11 Inese 2.1 S2021 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 Bakelti'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. Introduction 2. 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 3. You are working for Lilly Waters, owner of Sprinkles Ice Cream Shoppe. You have completed the analysis on the Bakelti business and will share the information with Mr. Thomas and make a recommendation, Mr. Miles Smith Senior Investor @ Large Inc 1500 Main Street Marietta, GA 30156 4. 5 Integrate the 3 pivot tables in an informative and useful way to answer the three questions regarding the Bakelt! data. Create a Word table that provides the pros and cons for acquiring and investing in the Bakelti business for Sprinkles Ice Cream Shoppe. Include your recommendation based on the data. Conclusion Name your file: yournamebusletter.docx 6 7. 8. What to Submit 1. Submit your Pivot Table Analysis (Excel) document to D2L. A link is not acceptable. You must submit the file 2. Submit your Business Letter (Word Doc) document to D2L. A link is not acceptable. You must submit the file. Please refer to the following grade rubric to ensure that you accounted for all components of the assignment Possible points 5 points 10 points 10 points Criteria Spelling and grammar Correct business letter format with your logo Pivot table data integrated into document and explanation of the data questions Table - one you create in Word and recommendation Professional content and writing 3 Pivot tables created in the Excel file accurately and completely answering the analysis questions 10 points 15 points 25 points