Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Use the attached Excel data file to analyze and create the appropriate pivot tables needed to provide the appropriate information for the following. Place

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
1. Use the attached Excel data file to analyze and create the appropriate pivot tables needed to provide the appropriate information for the following. Place each pivot table on its own worksheet and label each appropriately for each question: Bake-It 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 posalbly buying their existing business. Bake-it sells two ways. They sell direct to customers in the Konnesaw Location, and they also ship to several cities and states throughout the US where independent shops sell Bake-If's goods. Bake-lt's owner has provided raw data of the sales from 2020, 2021 and 2022. They sell 2 primary categories of products. First, they sell Sof Baked Cookles. Cookles are large and can easily foed 2 people as a dessert or snack. and second, they sell Trall Bars. Trall 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 it's worth it Katie CEO of Perez POPS needs you to analyze this - should they ask the investor to help them take over the Bake-it 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 dollar wise each year? (Hint, you will need to pick a cily outside Kennasaw each year as the answer) 2. Name file yournamebakeitsales.xlsx. Business Letter Recommendation to Investor: Write a formal business letter to Katie's investor, Mr. Johnson, with your recommendations and the details of what you found in your analysis. Write a formal business letter to Katie's investor, Mr. Johnson, with your recommendations and the details 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 complate 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 Katie Perez, owner of Perez POPS. You have completed the analysis on the BakeITI 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 Alpharetta, GA 30022 4. Integrate the 4 pivot tables in an Informative and useful way to 5. answer the questions regarding the Bakelti Sales and store data. 5. Create a Word table that provides the pros and cons for acquiring and investing in the 6. BakeIT] business for Perez POPS. 6. Include your recommendation based on the data. 7. Conclusion 8. Name your flie: youmamebusletter.docx What to Submit: 1. Submit your Pivot Table Analyais (Exce) document to D2L. A link is not acceptable. (Additionally Numbers files and Google Sheets are unacceptabio) You must submit the Excel fle. 2. Submit your Business Letter (Word Doc) document to D2L. A link is not accoptablo. (Additionelly Pages files and Google Docs are unacceptable) You must submit the Word flle. 1. Use the attached Excel data file to analyze and create the appropriate pivot tables needed to provide the appropriate information for the following. Place each pivot table on its own worksheet and label each appropriately for each question: Bake-It 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 posalbly buying their existing business. Bake-it sells two ways. They sell direct to customers in the Konnesaw Location, and they also ship to several cities and states throughout the US where independent shops sell Bake-If's goods. Bake-lt's owner has provided raw data of the sales from 2020, 2021 and 2022. They sell 2 primary categories of products. First, they sell Sof Baked Cookles. Cookles are large and can easily foed 2 people as a dessert or snack. and second, they sell Trall Bars. Trall 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 it's worth it Katie CEO of Perez POPS needs you to analyze this - should they ask the investor to help them take over the Bake-it 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 dollar wise each year? (Hint, you will need to pick a cily outside Kennasaw each year as the answer) 2. Name file yournamebakeitsales.xlsx. Business Letter Recommendation to Investor: Write a formal business letter to Katie's investor, Mr. Johnson, with your recommendations and the details of what you found in your analysis. Write a formal business letter to Katie's investor, Mr. Johnson, with your recommendations and the details 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 complate 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 Katie Perez, owner of Perez POPS. You have completed the analysis on the BakeITI 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 Alpharetta, GA 30022 4. Integrate the 4 pivot tables in an Informative and useful way to 5. answer the questions regarding the Bakelti Sales and store data. 5. Create a Word table that provides the pros and cons for acquiring and investing in the 6. BakeIT] business for Perez POPS. 6. Include your recommendation based on the data. 7. Conclusion 8. Name your flie: youmamebusletter.docx What to Submit: 1. Submit your Pivot Table Analyais (Exce) document to D2L. A link is not acceptable. (Additionally Numbers files and Google Sheets are unacceptabio) You must submit the Excel fle. 2. Submit your Business Letter (Word Doc) document to D2L. A link is not accoptablo. (Additionelly Pages files and Google Docs are unacceptable) You must submit the Word flle

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

The Audit Process Principles Practice And Cases

Authors: Iain Gray, Stuart Manson

5th Edition

1408030497, 9781408030493

More Books

Students also viewed these Accounting questions

Question

=+Could you create an interactive game on the website?

Answered: 1 week ago