Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
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
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
please i need help
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started