Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I cannot attach a file nor copy and paste Kitie is really irmpresend wilh all your work so farl She has just fromd cut that
I cannot attach a file nor copy and paste
Kitie is really irmpresend wilh all your work so farl She has just fromd cut that there is a shap in the! shopping center where she plans to open whore the owner is looking to sel his bakery. BelselT! Kate wanta you to look at Bakelt numbers and heip her decide if this is the kind of businass that would work well with hers and she might oonsider taking on RakelJI's products as part of the Perez pops family. After you have completed the analysis, she has asked that you write a formal business letter to her inwestor, Mr. Johnson, with your recommendations and the dedais of what you found in your analysis. What to do: Analysisiplvot Tables 1. Use the atlached Excel dala file to anslyze and create the appropriate pivat tables needed to provide the appropriate information for the follawing. Place each pivot table on its cwn worksheed and label ead apertopriateely for each cuestion: Bake-lt is a local comperyy in Kenneesw, GA which has a store frout bestion in the sarre shapping ceriler atere Perez POPS wil be apering. The onner is considering making a move out of town and hes eppoeeched Perez FOFS about pessby buying their exiabing bushess. Bake-lt sels twa waye. They sal drect to custamers in the Kenneses Lozation, and they aso ship to several cities and statee thoughout the US where indepencent shope sell Bake-lt's gadeda. Bake-tie awner has provided raw tois of the sales fram 2020,2021 and 2022 They sell 2 primary catcogarics of products. First, thny sall Soft Bakod Coakics. Coakes are lage and can esily feed 2 people as a dessert or 8neck. and second, they sel Tral Bers. Tral bers are sold in mini hags wte multipin bas in the bag. Thny arn chesy, heaty murfin cockin hytrid snacks that are lower in sugar and use local honey to eveeteri. Ell.p[ the Bake-lt products are organic ntich daes have higher casts, bur they think it's worth it Katie CEO af Perez POPS noads yau to analyze this - should they ask the invesior to help them take oher the Bake-ll buaines?? Create 4 Puoc Tebles to angwer the following queetions: 1- What ere the top products ty cetegory for each yeer thet ane sold at Beke It? \Hrt look at this in terms of Units sold and Dolare) 2 - What is the top eelling procuct for egch of the yeare? 3 - What is the most proftaole product in each category? iHint, you will need to creebe a formule ta caleulate prritit) 4 - Which city orders the most per yeer eollar wise eech year? IHint, you wil read to pick a city autside Konnesaw cach yoar as the anewer? Kitie is really irmpresend wilh all your work so farl She has just fromd cut that there is a shap in the! shopping center where she plans to open whore the owner is looking to sel his bakery. BelselT! Kate wanta you to look at Bakelt numbers and heip her decide if this is the kind of businass that would work well with hers and she might oonsider taking on RakelJI's products as part of the Perez pops family. After you have completed the analysis, she has asked that you write a formal business letter to her inwestor, Mr. Johnson, with your recommendations and the dedais of what you found in your analysis. What to do: Analysisiplvot Tables 1. Use the atlached Excel dala file to anslyze and create the appropriate pivat tables needed to provide the appropriate information for the follawing. Place each pivot table on its cwn worksheed and label ead apertopriateely for each cuestion: Bake-lt is a local comperyy in Kenneesw, GA which has a store frout bestion in the sarre shapping ceriler atere Perez POPS wil be apering. The onner is considering making a move out of town and hes eppoeeched Perez FOFS about pessby buying their exiabing bushess. Bake-lt sels twa waye. They sal drect to custamers in the Kenneses Lozation, and they aso ship to several cities and statee thoughout the US where indepencent shope sell Bake-lt's gadeda. Bake-tie awner has provided raw tois of the sales fram 2020,2021 and 2022 They sell 2 primary catcogarics of products. First, thny sall Soft Bakod Coakics. Coakes are lage and can esily feed 2 people as a dessert or 8neck. and second, they sel Tral Bers. Tral bers are sold in mini hags wte multipin bas in the bag. Thny arn chesy, heaty murfin cockin hytrid snacks that are lower in sugar and use local honey to eveeteri. Ell.p[ the Bake-lt products are organic ntich daes have higher casts, bur they think it's worth it Katie CEO af Perez POPS noads yau to analyze this - should they ask the invesior to help them take oher the Bake-ll buaines?? Create 4 Puoc Tebles to angwer the following queetions: 1- What ere the top products ty cetegory for each yeer thet ane sold at Beke It? \Hrt look at this in terms of Units sold and Dolare) 2 - What is the top eelling procuct for egch of the yeare? 3 - What is the most proftaole product in each category? iHint, you will need to creebe a formule ta caleulate prritit) 4 - Which city orders the most per yeer eollar wise eech year? IHint, you wil read to pick a city autside Konnesaw cach yoar as the anewerStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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