Question: 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  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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!