Abby's Cakes has been deemed one of the tastiest cakes in the United States. This new company has skyrocketing sales and has made a large profit over the past 6 months. Abby knows that she can franchise her company and have cake stores all over the United States. However, this is Abby's first business, and she is not sure where the best places to open 3 stores are. Currently, Abby only sells her cakes online and needs help figuring out which states / cities has the most potential cake consumers. She wants to open her stores near her loyal customers. Abby has hired you to clean up her data and make multiple graphs easily showing what states would be the best options for her new store locations and why. Her only request is that the stores are not in the same state or even remotely close to each other. She wants her stores to be scattered around the United States while generating high revenue.  It is up to you to make the data look "pretty" while effectively showing intelligent answers (using stats) to prove where the best locations should be. 

 

Extra Info:

• Abby has given you every transaction invoice since day one; she placed the information in an Excel workbook. (She also provided competitors and their locations)
• She sells 3 cakes. Large - $20 (8 slices), Medium - $17 (6 slices), Small - $12 (4 slices). Medium has been the most popular of the three
• Shipping costs is always constant at $5 per cake shipped
• Abby just started making extra large cakes (15 slices) last month and they are only popular in Texas

 

 Your Task is to:

1. Determine what this problem is asking for. Explain the problem in your own words and detail the specific things asked for in this problem.
2. Determine what data you would need to complete the problem successfully.
3. Devise your plan for solving the problem.

Answer rating: 100% (QA)

Problem Definition Abbys Cakesa popular online cake businessis considering expanding its operations by opening three new franchise locations across th... View the full answer