please write a business letter from the given excel worksheets

the attached Excel data file to analyze and create the appropriate pivot tables needed to vide the appropriate information for the following. Place each pivot table on its own worksheet label each appropriately for each question: Bake-lt is a local company in Kennesaw, GA which has a store front location in the same shopping center where Perez POPS will be opening. The owner is considering making a move out of town and has approached Perez POPS about possibly buying their existing business. Bake-lt 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-ti's owner has provided raw data of the sales from 2020, 2021 and 2022. They sell 2 primary categories of products. First, they sell 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. Allof the Bake-lt products are organic which does have higher costs, but they think its worth itt Katie CEO of Perez POPS needs you to analyze thils - should they ask the investor to help them take over the Bake-lt business? Create 4 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 sold and Dollars) 2-What is the top selling product for each of the years? 3- What is the most proftable product in each category? (Hint, you will need to create a formula to calculate profit) 4-Which cily orders the most per year dollar wise each year? (Hint, you will need to plck a clty outside Kennesaw each year as the answer) Business Letter Recommendation to Investor: Write a formal business letter to Katie's investor, Mr. Johnson, with your recommendations and the detail 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 Katle Perez, owner of Perez POPS. You have completed the analysis on the BakelTI business and will share the information with Mr. Johnson (possible investor) and make a recommendation. Mr. Brandon Johnson, CEO Investiture Inc. 4550 Main Street NW Apharetta, GA 30022 4. Integrate the F. ilvot tables in an informative and useful way to answer the questionstegarding the BakeITI Sales and store data. 5. Create a Word table that provides the pros and cons for acquiring and investing in the BakelTI business for Perez POPS. 6. Include your recommendation based on the data. 7. Conclusion 8. Name your flile: youmamebusletter.docx Sum of Total Units Sold Per Year Sum of Total Order Sales per Year B3 xfx Sum of Total Order Cost Per Year \begin{tabular}{|l|l|l|} \hline 2 & & \\ \hline 3 & Row Labels & Sum of Total Order Cost Per Year \\ \hline 4 & 2020 & 132159.64 \\ \hline 5 & Baltimore & 1213.92 \\ \hline 6 & Boston & 4276.62 \\ \hline 7 & Charleston & 4943.04 \\ \hline 8 & Charlotte & 5591.7 \\ \hline \end{tabular} Kennesw 35285.88 LosAngeles 15092.04 Minneapolis 1040.64 Naples 419.04 New York 6715.8 Orlando 1920.6 Raleigh 7056.52 Richmond 1237.08 San Antonio 4890.96 San Diego 19891.56 Santa hosa 787.44 Tampa 21796.8 \begin{tabular}{rr} 2021 & 367858.2 \\ \hline Asheville & 8904.6 \end{tabular} Baltimore 17208.36 Borton 18498.96 Charleston 13599.24 Charlotte 13968 Clearwater 1179.36 Kennesaw 60634.08 Los Angeles 22147.2 Miaml Minnerpotis Noples NewYorkOrlando30992.768904.6 Paleigh 21313.32 Aichmond 1250.46 San Antonio 21258.36 San Diego 43186.44 Santa Rosa 17060,76 Tampa 21290.4 Trenton. 1284.66 2022 Baltimore Boston 12383.16 Ready P Accessibility: Good to go Ready RAccessibility: Good to go the attached Excel data file to analyze and create the appropriate pivot tables needed to vide the appropriate information for the following. Place each pivot table on its own worksheet label each appropriately for each question: Bake-lt is a local company in Kennesaw, GA which has a store front location in the same shopping center where Perez POPS will be opening. The owner is considering making a move out of town and has approached Perez POPS about possibly buying their existing business. Bake-lt 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-ti's owner has provided raw data of the sales from 2020, 2021 and 2022. They sell 2 primary categories of products. First, they sell 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. Allof the Bake-lt products are organic which does have higher costs, but they think its worth itt Katie CEO of Perez POPS needs you to analyze thils - should they ask the investor to help them take over the Bake-lt business? Create 4 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 sold and Dollars) 2-What is the top selling product for each of the years? 3- What is the most proftable product in each category? (Hint, you will need to create a formula to calculate profit) 4-Which cily orders the most per year dollar wise each year? (Hint, you will need to plck a clty outside Kennesaw each year as the answer) Business Letter Recommendation to Investor: Write a formal business letter to Katie's investor, Mr. Johnson, with your recommendations and the detail 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 Katle Perez, owner of Perez POPS. You have completed the analysis on the BakelTI business and will share the information with Mr. Johnson (possible investor) and make a recommendation. Mr. Brandon Johnson, CEO Investiture Inc. 4550 Main Street NW Apharetta, GA 30022 4. Integrate the F. ilvot tables in an informative and useful way to answer the questionstegarding the BakeITI Sales and store data. 5. Create a Word table that provides the pros and cons for acquiring and investing in the BakelTI business for Perez POPS. 6. Include your recommendation based on the data. 7. Conclusion 8. Name your flile: youmamebusletter.docx Sum of Total Units Sold Per Year Sum of Total Order Sales per Year B3 xfx Sum of Total Order Cost Per Year \begin{tabular}{|l|l|l|} \hline 2 & & \\ \hline 3 & Row Labels & Sum of Total Order Cost Per Year \\ \hline 4 & 2020 & 132159.64 \\ \hline 5 & Baltimore & 1213.92 \\ \hline 6 & Boston & 4276.62 \\ \hline 7 & Charleston & 4943.04 \\ \hline 8 & Charlotte & 5591.7 \\ \hline \end{tabular} Kennesw 35285.88 LosAngeles 15092.04 Minneapolis 1040.64 Naples 419.04 New York 6715.8 Orlando 1920.6 Raleigh 7056.52 Richmond 1237.08 San Antonio 4890.96 San Diego 19891.56 Santa hosa 787.44 Tampa 21796.8 \begin{tabular}{rr} 2021 & 367858.2 \\ \hline Asheville & 8904.6 \end{tabular} Baltimore 17208.36 Borton 18498.96 Charleston 13599.24 Charlotte 13968 Clearwater 1179.36 Kennesaw 60634.08 Los Angeles 22147.2 Miaml Minnerpotis Noples NewYorkOrlando30992.768904.6 Paleigh 21313.32 Aichmond 1250.46 San Antonio 21258.36 San Diego 43186.44 Santa Rosa 17060,76 Tampa 21290.4 Trenton. 1284.66 2022 Baltimore Boston 12383.16 Ready P Accessibility: Good to go Ready RAccessibility: Good to go