CramX Logo
Analysis of Factors Influencing Weekly Sales in Coffee House Chains: A Case Study for Expansion to Tallahassee - Document preview page 1

Analysis of Factors Influencing Weekly Sales in Coffee House Chains: A Case Study for Expansion to Tallahassee - Page 1

Document preview content for Analysis of Factors Influencing Weekly Sales in Coffee House Chains: A Case Study for Expansion to Tallahassee

Analysis of Factors Influencing Weekly Sales in Coffee House Chains: A Case Study for Expansion to Tallahassee

This case study analyzes factors affecting sales in coffee house chains, specifically examining the potential for expansion to Tallahassee.

Leo Campbell
Contributor
4.7
0
12 months ago
Preview (5 of 15 Pages)
100%
Log in to unlock
Page 1 of 5
Analysis of Factors Influencing Weekly Sales in Coffee House Chains: A Case Study for Expansion to Tallahassee - Page 1 preview imageAnalysis of Factors Influencing Weekly Sales in Coffee House Chains: A CaseStudy for Expansion to TallahasseeBob Roaster, vice president of sales at Peoria’s Best Coffee Houses, is considering expanding toTallahassee and needs to determine optimal store size and expected weekly sales. Using theprovided data, analyze the descriptive statistics, correlation, and regression results to assess theimpact of store size, proximity to a college, and drive-thru availability on weekly sales. Based onyour analysis, provide recommendations for store size, location, and amenities for futureopenings.Word Count Requirement: 1,5002,000 words
Page 2 of 5
Analysis of Factors Influencing Weekly Sales in Coffee House Chains: A Case Study for Expansion to Tallahassee - Page 2 preview image
Page 3 of 5
Analysis of Factors Influencing Weekly Sales in Coffee House Chains: A Case Study for Expansion to Tallahassee - Page 3 preview imageIntroductionBob Roaster, the vice president for sales atPeoria’s Best Coffee Houses(located in suburbanPrescott Florida) is considering expanding this company’s chain of coffee houses to Tallahassee.But before he can commit to opening one or two stores in the state capital, he needs to figure outwhat size stores he might open and how much could they make in revenue per week. He wantedto ask his friend Marvin Bloomy at PC (Prescott College) for help, but old Marvin just left on a4-week trip to Alaska to see the “sights and to commune with bears” and is out of touch.
Page 4 of 5
Analysis of Factors Influencing Weekly Sales in Coffee House Chains: A Case Study for Expansion to Tallahassee - Page 4 preview imageDescriptive StatisticsWeekly SalesStore Size (Sq.Ft.)College Nearby =YESDrive Thru =YESMean4492.570338925.81132080.226415090.132075472Standard Error64.2982664216.743866940.058037010.0469516Median4591.28284993900Mode#N/A91100Standard Deviation468.0984452121.89719130.422515790.341812806Sample Variance219116.154414858.925250.178519590.116835994Kurtosis0.391582439-0.400069452-0.197704453.121519912Skewness-0.582855357-0.1096039041.345813492.237206651Range2132.25965454511Minimum3250.04852767300Maximum5382.308181121811Sum238106.227949068127Count53535353It isobserved from the rows of mean and median that on an average the weekly sales andstore size for given set of data points is 4492.57 and 925.7113 respectively.While half of thedata values are above 4591.2829 units of weekly sales and other half is below this value. And forstore size, cut point (regarded as median) is 939.In both the cases, median is greater than mean.From the row of Skewness it is observed thatweekly sales and store size is negativelyskewed.Kurtosis is the measure for flatness of the distribution.Here,store size has a negativevalue of kurtosis implyingaslightlyflat distribution. And weekly sales havea positive valueofkurtosis implyingdistribution withslightpeak.
Page 5 of 5
Analysis of Factors Influencing Weekly Sales in Coffee House Chains: A Case Study for Expansion to Tallahassee - Page 5 preview imageHistogramThe class interval for Weekly Sales and thecorresponding histogram is shown below.Weekly SalesBinFrequency3000035002400054500195000195500860000More0The above histogram isslightly skewed to the left. For anegatively skewed distribution,mean<median<mode andthe same is observed from the descriptive statistics above.This implies thatthe number of small weekly sales is very less.05101520FrequencyBinHistogramFrequency
Preview Mode

This document has 15 pages. Sign in to access the full document!