business analytics

profileshahniti
BUS102-DisneyCaseQuestionsandVisualization-MaddyOrtegaNitiShahLindseyLuksik.xlsx
Home>Business & Finance homework help>Management homework help>business analytics

AttractionTimes

Themed Land Attraction Ride Type Average Wait Time (hh:mm:ss) Duration (in minutes) Theoretical Hourly Ride Capacity (THRC) Operational Hourly Ride Capacity (OHRC)
Adventureland Jungle Cruise Outdoor Boat Ride 1:15:00 9:05 1800 1620
Adventureland Pirates of the Caribbean Dark Ride - Boat 45:00 8:30 2600 2340
Adventureland Swiss Family Tree House Walk Through Exhibit 0:00 13:05 1200 1000
Adventureland The Magic Carpets of Aladdin Thrill Ride - Mild 35:00 1:30 550 495
Adventureland Walt Disney's Enchanted Tiki Room Show - Animatronics 15:00 10:00 1000 900
Fantasyland Dumbo the Flying Elephant Thrill Ride - Mild 30:00 1:30 1000 900
Fantasyland Enchanted Tales with Belle Show - Live Action + FX 30:00 20:00 300 270
Fantasyland it's a small world Dark Ride - Boat 35:00 10:30 3000 2700
Fantasyland Mad Tea Party Thrill Ride - Mild 35:00 1:30 850 765
Fantasyland Mickey's PhilarMagic Show with 4D elements 15:00 12:00 1500 1350
Fantasyland Peter Pan's Flight Dark Ride - Innovative 1:40:00 2:45 800 720
Fantasyland Prince Charming's Regal Carrousel Thrill Ride - Mild 15:00 2:00 1000 900
Fantasyland Seven Dwarfs Mine Train Thrill Ride - Intense 2:45:00 2:30 1650 1485
Fantasyland The Barnstormer Thrill Ride - Mild 35:00 1:03 350 315
Fantasyland The Many Adventures of Winnie the Pooh Dark Ride - Track 45:00 3:08 850 765
Fantasyland Under the Sea - Journey of the Little Mermaid Dark Ride - Track 30:00 6:15 2200 1980
Frontierland Big Thunder Mountain Railroad Thrill Ride - Intense 1:30:00 3:25 1500 1350
Frontierland Country Bear Jamboree Show - Animatronics 15:00 12:00 1140 1000
Frontierland Splash Mountain Water/Thrill Ride - Intense 1:30:00 11:00 1200 1080
Frontierland Tom Sawyer Island Walk Through Exhibit 0:00 30:00 1200 1000
Liberty Square Haunted Mansion Dark Ride - Track 1:00:00 7:30 3200 2880
Liberty Square Liberty Square Riverboat Outdoor Boat Ride 20:00 12:45 900 850
Liberty Square The Hall of Presidents Show - Animatronics 25:00 21:35 1200 1000
Main Street U.S.A. Walt Disney World Railroad Thrill Ride - Mild 5:00 20:00 2190 1440
Tomorrowland Astro Orbiter Thrill Ride - Mild 48:00 1:30 300 250
Tomorrowland Buzz Lightyear's Space Ranger Spin Dark Ride - Game 1:00:00 4:03 800 720
Tomorrowland Monsters, Inc. Laugh Floor Show - Live Action + FX 30:00 11:00 1000 900
Tomorrowland Space Mountain Thrill Ride - Intense 2:15:00 2:30 2000 1800
Tomorrowland Tomorrowland Speedway Thrill Ride - Mild 48:00 4:45 500 450
Tomorrowland Tomorrowland Transit Authority PeopleMover Dark Ride - Track 1:00 10:04 3600 3500
Tomorrowland Walt Disney's Carousel of Progress Show - Animatronics 5:00 20:45 3600 3000
s

MagicBand Attraction Data

Themed Land Attraction Fast Pass Index Merchandise Index Interactive Queue Participation (%)
Adventureland Swiss Family Tree House N/A 5 --
Frontierland Tom Sawyer Island N/A 5 --
Fantasyland Seven Dwarfs Mine Train 100 85 85
Character Meet & Greet Mickey Mouse 100 100 --
Tomorrowland Space Mountain 99 92 --
Character Meet & Greet Minnie Mouse 99 99 --
Frontierland Splash Mountain 97 78 --
Adventureland Pirates of the Caribbean 96 95 --
Fantasyland Peter Pan's Flight 96 81 77
Adventureland Jungle Cruise 95 82 --
Character Meet & Greet Pluto 95 94 --
Fantasyland it's a small world 92 90 --
Liberty Square Haunted Mansion 92 89 82
Character Meet & Greet Cinderella 92 91 --
Character Meet & Greet Donald Duck 92 88 --
Frontierland Big Thunder Mountain Railroad 91 84 67
Character Meet & Greet Goofy 91 90 --
Fantasyland Enchanted Tales with Belle 89 95 --
Fantasyland Mad Tea Party 89 88 --
Character Meet & Greet Ariel 89 85 --
Character Meet & Greet Peter Pan 89 78 --
Character Meet & Greet Gaston 88 60 --
Character Meet & Greet Daisy Duck 87 85 --
Character Meet & Greet Winnie the Pooh 86 90 --
Tomorrowland Buzz Lightyear's Space Ranger Spin 85 88 40
Character Meet & Greet Tigger 85 89 --
Character Meet & Greet Buzz Lightyear 85 89 -- s
Character Meet & Greet Princess Jasmine 85 83 --
Fantasyland The Many Adventures of Winnie the Pooh 84 100 80
Fantasyland Dumbo the Flying Elephant 83 85 72
Character Meet & Greet Rapunzel 83 70 --
Fantasyland Under the Sea - Journey of the Little Mermaid 82 92 76
Character Meet & Greet Princess Tiana 82 64 --
Tomorrowland Monsters, Inc. Laugh Floor 81 84 --
Character Meet & Greet Elena 80 80 --
Character Meet & Greet Captain Jack Sparrow 80 83 --
Fantasyland Prince Charming's Regal Carrousel 78 82 --
Character Meet & Greet Mary Poppins 78 49 --
Fantasyland The Barnstormer 77 79 --
Tomorrowland Tomorrowland Speedway 70 10 --
Character Meet & Greet Tinker Bell 62 56 --
Character Meet & Greet Merida 62 43 --
Character Meet & Greet Stitch 57 52 --
Adventureland The Magic Carpets of Aladdin 56 73 --
Fantasyland Mickey's PhilarMagic 45 23 --
Character Meet & Greet Anastasia 30 14 --
Character Meet & Greet Drizella 30 14 --
Tomorrowland Walt Disney's Carousel of Progress 24 77 --
Main Street U.S.A. Walt Disney World Railroad 23 45 --
Tomorrowland Tomorrowland Transit Authority PeopleMover 15 4 --
Tomorrowland Astro Orbiter 10 11 --
Adventureland Walt Disney's Enchanted Tiki Room 8 54 --
Frontierland Country Bear Jamboree 6 14 --
Liberty Square Liberty Square Riverboat 5 5 --
Liberty Square The Hall of Presidents 4 12 --

Top-Grossing #1 Films

Rank Movie Release Date Genre MPAA Rating Total Gross Inflation-Adjusted Gross
1 Star Wars Episode VII: The Force Awakens 12/18/15 Adventure PG-13 $936,662,225 $1,006,872,847
2 Avengers: Endgame 4/26/19 Action PG-13 $858,373,000 $858,373,000
3 The Avengers 5/4/12 Action PG-13 $623,357,000 $713,415,897
4 Black Panther 2/16/18 Action PG-13 $700,059,566 $700,059,566
5 Avengers: Infinity War 4/27/18 Action PG-13 $678,815,482 $678,815,482
6 Star Wars Episode VIII: The Last Jedi 12/15/17 Adventure PG-13 $620,181,382 $628,253,896
7 Incredibles 2 6/15/18 Adventure PG $608,181,382 $608,581,744
8 Pirates of the Caribbean: Dead Man's Chest 7/7/06 Adventure PG-13 $423,315,813 $588,764,432
9 Finding Nemo 5/30/03 Adventure G $380,529,370 $559,944,647
10 Rogue One: A Star Wars Story 12/16/16 Adventure PG-13 $532,177,324 $556,450,789
11 The Lion King 7/19/19 Adventure PG $543,638,043 $543,638,047
12 The Sixth Sense 8/6/99 Thriller/Suspense PG-13 $293,506,292 $524,581,166
13 Star Wars: The Rise of Skywalker 12/20/19 Adventure PG-13 $515,202,542 $515,202,542
14 Finding Dory 6/17/16 Adventure PG $486,295,561 $512,156,365
15 Beauty and the Beast 3/17/17 Musical PG $504,014,165 $511,880,606
16 Avengers: Age of Ultron 5/1/15 Action PG-13 $459,005,868 $496,031,246
17 Toy Story 3 6/18/10 Adventure G $415,004,880 $479,175,469
18 Frozen II 11/22/19 Musical PG $477,373,578 $477,373,578
19 Pirates of the Caribbean: The Curse of the Black Pearl 7/9/03 Adventure PG-13 $305,410,819 $461,408,382
20 Iron Man 3 3/3/13 Action PG-13 $408,992,272 $458,292,689
21 Monsters, Inc. 11/2/01 Adventure G $289,423,425 $449,635,428
22 Frozen 11/22/13 Musical PG $400,738,009 $448,472,628
23 Toy Story 2 11/19/99 Adventure G $245,852,179 $437,075,134
24 Toy Story 4 6/21/19 Adventure G $434,038,008 $434,038,008
25 Captain America: Civil War 5/6/16 Action PG-13 $408,084,349 $429,785,941

S1 Questions

Number Question Answer Divide S1 Sheet & Each person does a "S" Sheet
1 Group member 1 - Full name Lindsey Luksik S2 Lindsey
2 Group member 2 - Full name Niti Shah S3 Niti
3 Group member 3 - Full name Madeleine Ortega S4 Maddy
4 Who is the project manager for the group? Today: Meet up & decide sheets (do s1 questions together today)
Saturday: Be done with sheets, meet up again & check over each other's work to submit on Sunday
5 In one sentence, describe the main business "problem" that you are solving. Review the Magic Kingdom property in light of extensive (and well- received) changes at both Epcot and Hollywood Studios, to decide what particular ride had to be closed and switched with a replacement.
6 Look at the survey data about attractions visited and level of satisfaction. If you combine this information, it gives you a picture of the best attractions. Which two rides are high on both lists? 1.Fantasy Land- Seven Dawrfs mine train (85) 2. Liberty Square- Haunted mansion (92)
7 How is this confirmed in the survey data about Fast Pass purchases?
8 What is the mean "Theoretical Hourly ride capacity" ? Mean= 1450.97
9 Which ride has the maximum "Theoretical Hourly ride capacity"? Maximum= 3600
10 What is the correlation between Fast Pass Index and Merchandise Index? (use equation in cell, show two decimal places) Correlation= 0.84
11 In a text box below, write a paragraph about your key takeaways that summarizes your work from ALL FOUR SHEETS. Based on your analysis, what action would you take?

S2 PivotTable + Pie Chart

Adventureland

"What is the relative rider capacity of each of the themed lands?" On this worksheet, you will create a PivotTable and then use the information from that PivotTable to create a Pie Chart. Follow the steps below. 1. Under this text box, create a PivotTable that shows the sum of Theoretical Hourly Ride Capacity and the sum of Operational Hourly Ride Capacity for each Themed Land. Can you show the sum of Theoretical Hourly Ride Capacity as percentage of the grand total? 2. Create a Pie Chart from the table and show the shares of total OHRC for each Themed Land. The Themed Lands should be clearly labeled. 3. Write a statement under your pie chart about how the picture could be used to recommend a change and what that recommendation would be.

S3 PivotTable + Column Chart

Column1

"What is the top-grossing Disney animated film franchise?" Below this text box, you will create a Table and then use the information from that Table to create a Column Chart. A film franchise is a group of related films (e.g., same characters). Some of the top-grossing animated films are related. For instance, Lion King has two versions and some have sequels. You are going to do some analysis of this. Follow the steps below. 1. Under this text box, create a PivotTable that shows the average of Inflation-Adjusted Gross for each MPAA Rating. 2. Create a Column Chart that shows the three MPAA ratings average gross revenues in billions of dollars. It should be in descending order. Your chart should have only one data series - the amounts in billions of dollars. Make sure that each column is labeled. Don't forget about the chart title. 3. Write a statement under the chart about how this chart could be used to make a recommendation to the Disney park.

S4 PivotTable + Column Chart

"What do Fast Pass and Merchandise Index compare across Themed Lands?" Below this text box, you will create a PivotTable and then use the information from that PivotTable to create a Column Chart. 1. Under this text box, create a PivotTable that shows the average of Fast Pass Index and the average of Merchandise Index for each Themed Land. Your PT should be sorted from highest average Fast Pass to lowest average Fast Pass. 2. You may want to copy the contents of PivotTable into the cells just below the PT to use to create the chart. Alternatively, you can create a PivotChart, but the formatting may be more difficult. 3. Create a Column Chart that shows the Avg. Fast Pass Index and the Avg. Merchandise Index for each Themed Land. There will be two columns for each Themed Land. Make sure that the columns are labeled. Give the chart an interesting title. 4. Write a statement under the chart about how this chart could be used to make a recommendation to the Disney park.