Answered step by step
Verified Expert Solution
Link Copied!

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 image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions