please i need help
Bake-lt shipping and Store Data 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 its worth it! Katie CEO of Perez POPS needs you to analyze this - 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 profitable product in each category? (Hint, you will need to create a formula to calculate profit) 4-Which city orders the most per year doliar wise each year? (Hint, you will need to pick a city outside Kennesaw each year as the answer) 2. Name file yournamebakeitsales. xlsx. Business Letter Recommendation to Investor: Read instructions carefully! Write a formal business letter to Katie's investor. Mr. Johnson, with your recommendations and the details of what you found in your analysis. Bake-lt shipping and Store Data 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 its worth it! Katie CEO of Perez POPS needs you to analyze this - 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 profitable product in each category? (Hint, you will need to create a formula to calculate profit) 4-Which city orders the most per year doliar wise each year? (Hint, you will need to pick a city outside Kennesaw each year as the answer) 2. Name file yournamebakeitsales. xlsx. Business Letter Recommendation to Investor: Read instructions carefully! Write a formal business letter to Katie's investor. Mr. Johnson, with your recommendations and the details of what you found in your analysis
