Executive summary of Improving Summer Concerts in the Park Improve Phase

.docx

School

Grand Canyon University *

*We aren’t endorsed by this school

Course

445

Subject

Economics

Date

Jan 9, 2024

Type

docx

Pages

5

Uploaded by MagistrateHorse3918

Report
Executive summary of Improving Summer Concerts in the Park Project: Summer Concerts in the Park is a 5 month event (one weekday concert per month, May- September) of music, food, vendors of arts and crafts and recreation. Brief Synopsis of the Business Case: The Board of Commissioners of a medium-sized municipal park district in the Midwestern United States has charged this team with increasing participation (attendance) of local patrons and their subsequent use of Park District facilities while being fiscally responsible and providing the best experience for each attendee. The Board of Commissioners has indicated that they have a strong preference for music based recreational activities during summer evenings at our flagship location, a 180 acre open park property, situated in the center of a suburban area of approximately 35,000 residents. Past Summer Concert Series have made profits of $3,267 in 2022 and $10,419 in 2023. While sponsorship revenue was up in 2023, attendance per concert was down. This team is tasked with the following: 1) Increase attendance at each monthly concert. An average of 175.5 patrons attended each show in 2023. 2) Stay within budget. Sponsors provided $9,500 in 2023 and patrons donated a total of $2,919 at the door for a total of $12,419. 3) Use budgeted resources on creature comforts that provide bang for the buck. Food trucks, bounce houses, water slides, vendors of arts and crafts were employed in 2023. Summary Analysis of All Tools: Observed Data: 1) Analysis of data from 2022 and 2023: attendance, sponsorships, donations, vendor fees, expenses, high temperature, weather conditions, and day of the week were all entered into an Excel spread sheet. Pearson r correlations and Single Regression were run on the dependent variable of attendance as it relates to the independent variable of “weather”, “temperature”, and “day of the week”. The results reveled the following: a) Attendance and High Temperature : -0.15563 (as temps went up, attendance went down slightly) b) Attendance and Weather Conditions: -0.45616239 (as weather got worse, attendance went down moderately) c) Attendance and Day of the Week: -0.414010348 (attendance went down as we shifted from Tuesday to Thursdays, this was moderately correlated) R2 (r squared) value: based on this small sample size, 2% of attendance can be explained by temperature, 20.8% by weather conditions, and 17% by change in the day of the week. That means 60.2% of attendance can be attributed to be by other factors. A fishbone analysis will be conducted at the beginning of the Improvement Phase to try and identify the other 60.2% of factors affecting concert attendance.
One Way Anova and an 2 way ANOVA with replication were conducted. The results were non- significant. This supports the above conclusion that other factors are responsible for the 60.2% of the variance and thus need to be further investigated. Anova: Two-Factor Without Replication SUMMARY Count Sum Average Varianc e 659 4 311 77.75 11168.2 5 645 4 347 86.75 15026.2 5 532 4 328 82 12498.6 7 667 4 322 80.5 12801.6 7 418 4 272 68 7720 339 4 222 55.5 5109.66 7 601 4 326 81.5 13181.6 7 374 4 210 52.5 3628.33 3 604 4 309 77.25 11552.9 2 379 4 201 50.25 3058.25 724 4 421 105.25 25570.2 5 368 4 209 52.25 3334.25 328 4 195 48.75 3284.91 7 227 4 217 54.25 4436.25 Attendance 14 270 8 193.428 6 5057.80 2 temperature 14 113 8 81.2857 1 70.2197 8 weather 14 4 0.28571 4 0.21978 day of the week 14 40 2.85714 3 1.05494 5 ANOVA Source of SS df MS F P-value F crit
Variation Rows 15773.9 3 13 1213.37 9 0.92957 5 0.53288 7 1.98052 8 Columns 346207. 1 3 115402. 4 88.4102 1.91E- 17 2.84506 8 Error 50906.9 3 39 1305.30 6 Total 412887. 9 55 Anova: Single Factor SUMMARY Groups Count Sum Average Variance Donations 14 6865 490.357 1 25369.9 4 Attendance 14 2708 193.428 6 5057.80 2 temperature 14 1138 81.2857 1 70.2197 8 weather 14 4 0.28571 4 0.21978 day of the week 14 40 2.85714 3 1.05494 5 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 2330296 4 582574 95.5063 3 1.75E- 26 2.51304 Within Groups 396490. 1 65 6099.84 7 Total 2726786 69 Qualitative and Quantitative Data from Surveys, Interviews and Focus Groups: 2) Results from Surveys, anecdotal interviews, and Focus Groups: five focus groups were conducted with 8 participants in each (n=40), 50 patrons participated in short interviews (n=50) and 1186 (a response rate of 4.56%) community members responded to the electronic survey (n=1186). The following were reported and triangulated from the sources using Descriptive Statistics, ANOVA and Qualitative Thematic Coding and Analysis analyzed with software program Atlas.ti. 1276 total humans shared their opinions with our researchers.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help