pls create pivot tables

IS 2200 - Business Letter with Data Analysis/Pivot Tables-(100pts) Sprinkles tce Cream Shoppe wants to Expandl Olivia is really impressed with all your work so fart 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! Olivia wants you to look at BakeIT numbers and help her decide if this is the kind of business that would work well with hers and she might consider taking on BakelTT'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. Franks, 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 analyce and create the appropriate pivot tables needed to provide the appropriate infomation for the following. Place each pivot table on its own worksheet and label each appropriately for each: Bake-It is a local company in Kennesaw, GA which has a stoee front location in the same shopping center where Sprinkles will be opening. The owner is considering making a move out of town and has approached Sprinkles about possibly buying their existing business. Bake-th sells two ways. They sell direct to customers in the Kennesaw Location, and they also ship to several cities and states throughout the US where independent shops sell Bake-it's goods. Bake-It's owner has provided raw data of the sales from 2019,2020 and 2021. They sell 2 primary categorios of products. First, they sels Soft Baked Cookies. Cookies are large and can easily feed 2 people as a dessert or snack. and second, they sell Trail Bars. Trail Bars are sold in mini bags with multiple bars in the bag. They are chewy, hearty muffin cookie hybrid snacks that are lower in sugar and use local honey to sweeten. All of the Bake-It products are organic which does have higher costs, but they think it's worth it Olvia CEO of Sprinkles needs you to analyze this - should they ask the investor to help them take over the Bake-ft business? Create 6 Pivot Tables to answer the following questions: 1 - What are the top products by category for each year that are sold at Bake it? (Hint look at this in terms of Units soid and Dollars) 2 - What is the top selling product for each of the years? 3 - What is the most profitable product in each category? (Hint, you will need to create a formula to calculate profit) 4 - What are the sales each year, by region, in each city, in each category and product? 5 - Which cily orders the most per year dollar wise? 6 - What are the sales for each product per year in the Kennesaw location in terms of units and dollars? (Hint you will have to pull the report by city and then fiter for Kennesaw) Analyze and 2. Analyze and create a pivot table for each of the questions. 3. Name file yournamebakeitsales.xlsx. Business Letter Recommendation to Investor: Write a formal business letter to Olivia's investor, Mr. Franks, with your recommendations and the details of what you found in your analysis. Refer to Memos and Business Letter links in Effective Messages 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 Olivia Marks, owner of Sprinkles Ice Cream Shoppe. You have completed the analysis on the BakelT! business a id will share the information with Mr. Franks ( possible investor) and make a recomr endation. Mr. Jerry Franks CEO Investors Inc. 1500 Main Street Atlanta, GA 30156 4. Integrate the 6 pivot tables in an informative and useful way to answer the questions regarding the BakelT! Sales and store data. 5. Create a Word table that provides the pros and cons for acquiring and investing in the BakelT! business for Sprinkles Ice Cream Shoppe. 6. Include your recommendation based on the data. 7. Conclusion 8. Name your file: yournamebusletter.docx IS 2200 - Business Letter with Data Analysis/Pivot Tables-(100pts) Sprinkles tce Cream Shoppe wants to Expandl Olivia is really impressed with all your work so fart 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! Olivia wants you to look at BakeIT numbers and help her decide if this is the kind of business that would work well with hers and she might consider taking on BakelTT'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. Franks, 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 analyce and create the appropriate pivot tables needed to provide the appropriate infomation for the following. Place each pivot table on its own worksheet and label each appropriately for each: Bake-It is a local company in Kennesaw, GA which has a stoee front location in the same shopping center where Sprinkles will be opening. The owner is considering making a move out of town and has approached Sprinkles about possibly buying their existing business. Bake-th sells two ways. They sell direct to customers in the Kennesaw Location, and they also ship to several cities and states throughout the US where independent shops sell Bake-it's goods. Bake-It's owner has provided raw data of the sales from 2019,2020 and 2021. They sell 2 primary categorios of products. First, they sels Soft Baked Cookies. Cookies are large and can easily feed 2 people as a dessert or snack. and second, they sell Trail Bars. Trail Bars are sold in mini bags with multiple bars in the bag. They are chewy, hearty muffin cookie hybrid snacks that are lower in sugar and use local honey to sweeten. All of the Bake-It products are organic which does have higher costs, but they think it's worth it Olvia CEO of Sprinkles needs you to analyze this - should they ask the investor to help them take over the Bake-ft business? Create 6 Pivot Tables to answer the following questions: 1 - What are the top products by category for each year that are sold at Bake it? (Hint look at this in terms of Units soid and Dollars) 2 - What is the top selling product for each of the years? 3 - What is the most profitable product in each category? (Hint, you will need to create a formula to calculate profit) 4 - What are the sales each year, by region, in each city, in each category and product? 5 - Which cily orders the most per year dollar wise? 6 - What are the sales for each product per year in the Kennesaw location in terms of units and dollars? (Hint you will have to pull the report by city and then fiter for Kennesaw) Analyze and 2. Analyze and create a pivot table for each of the questions. 3. Name file yournamebakeitsales.xlsx. Business Letter Recommendation to Investor: Write a formal business letter to Olivia's investor, Mr. Franks, with your recommendations and the details of what you found in your analysis. Refer to Memos and Business Letter links in Effective Messages 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 Olivia Marks, owner of Sprinkles Ice Cream Shoppe. You have completed the analysis on the BakelT! business a id will share the information with Mr. Franks ( possible investor) and make a recomr endation. Mr. Jerry Franks CEO Investors Inc. 1500 Main Street Atlanta, GA 30156 4. Integrate the 6 pivot tables in an informative and useful way to answer the questions regarding the BakelT! Sales and store data. 5. Create a Word table that provides the pros and cons for acquiring and investing in the BakelT! business for Sprinkles Ice Cream Shoppe. 6. Include your recommendation based on the data. 7. Conclusion 8. Name your file: yournamebusletter.docx