50.1K

Verified Solution

Link Copied!

The Reel Wheel

The Reel Wheel is an observation wheel located at a new outdoor mall situated between two of Coliseums hotel properties on the Las Vegas Strip. The Reel Wheel is the largest observation wheel in the world, standing 550 feet tall. There are 28 observation cars, each holding up to 40 people. The cars have 225 square feet of interior space, and each weighs roughly 44,000 pounds. It takes approximately 30 minutes for the wheel to make a complete rotation.

The Reel Wheel operates daily year-round from 11:00 a.m. to 2:00 a.m. Operations between 11:00am and 5:00pm are considered day time rides; those between 5:00pm and 2:00am are considered night time rides. During night time operations, the wheel lights up with more than 2,000 LED lights that bathe the wheel and its riders in a rainbow of bright and colorful lights.

Within each of the 28 observation cars, interior lighting, TV monitors, music, and sound effects entertain guests while the wheel is in motion. Although Coliseum primarily displays its own advertising images in each of the Reel Wheel observation cars, it also sells advertising space to complementary businesses.

In addition to ticket sales and advertising revenue, the Reel Wheel generates additional revenue through the sale of food and beverages, photos, and Coliseum-themed souvenirs from a gift shop located at the base of the observation wheel.

Because of the allure of seeing the Las Vegas Strip at night, ticket sales for night time rides are charged a premium. Children 12 and under always ride free on the Reel Wheel, and Las Vegas locals receive a 40% discount off of regularly-priced tickets. In order to entice more people to ride the Reel Wheel during the hottest summer months, a discounted price structure ($5.00 off each ticket) was offered during the third quarter of 20X5 (July through September). Locals are not eligible for the summer pricing structure, but they continued to get 40% off of regular ticket prices.

In addition to selling tickets to tourists and locals, the Reel Wheel also sells tickets in wholesale batches to travel agencies, local hotels, and other tourism-related services that bundle the tickets together with vacation packages and other offerings. The wholesale ticket prices do not vary based on time of day or season.

Use Excel to create analytics showing your solutions to the following three questions. Use separate tabs to show your work in analyzing each question.

1. In order to better understand whether the reported number of total passengers in 20X5 (as advertised by Coliseum) is reasonable, develop a quick estimate of the maximum number of passengers possible during 20X5. In other words, how many passengers could ride on the Reel Wheel if every passenger car was filled to capacity for the entire year? Given that not every car will be filled to capacity, develop a rough estimate for a reasonable number of reported passengers during the year. Does the number of reported passengers seem reasonable?

2. Develop an independent estimate of Ticket Sales Revenue using highly-aggregated data (e.g., Total Number of Paying Passengers, Average Ticket Price). Evaluate this independent estimate by comparing it to the client's reported account balance. Determine if the reported balance is within a tolerable range of your independent estimate using this aggregated data approach.

3. Using the disaggregated data available to you, develop an audit work paper to report a more precise estimate for Ticket Sales Revenue in 20X5 at the Reel Wheel. Compare your revised estimate using disaggregated data with the clients reported account balance and determine (1) whether or not the clients amount appears to be materially misstated and (2) what, if any, additional audit work is required to test the account balance.

Part 2: Reflect on the Engagement

Given your objective of using the analytical procedure to provide most of the assurance needed regarding the Ticket Sales Revenue account for the Reel Wheel, is the estimate developed in 2.3 precise enough, or is more precision needed? Explain.

Given that much of the data used in your analytical procedure is provided by your client, what additional audit procedures could you supplement this substantive analytic with to provide additional corroborating evidence that these ticket sales actually occurred?

Some companies use a third-party service provider to sell tickets to customers and to collect tickets upon entrance into the venue. Consider how your approach to auditing the Ticket Sales Revenue account would be different if a third-party ticket provider with a SOC 1 Type II report were providing these services for the client and was therefore the provider of ticket sales data (e.g. number of passengers, ticket prices, seasonality, daytime vs. nighttime rides, etc.).

Here I have put the above excels for ease of use:

20X5 Summary Information & Data for "The Reel Wheel"
Description				Data Point	Unit Label	Tickmark	WP Reference
Observation Wheel Height				550	feet	PBC, RW
Number of Passenger Cars				28	cars	PBC, RW
Interior Space per Car				225	square feet	PBC, RW
Maximum Capacity per Car				40	passengers	PBC, RW
Time Required for Car Revolution				30	minutes	PBC, RW
Hours of Operation (Open)				11:00am	.	PBC, RW
Hours of Operation (Close)				2:00am	.	PBC, RW
Description (20X5 calendar year)				Data Point	Unit Label	Tickmark	WP Reference
Days in Operation				361	days	PBC
Total Passengers				3,058,452	passengers	PBC	from A.02
Total Children Passengers				250,389	passengers	PBC	A.02, A.03
Description (20X5 calendar year)				Data Point	Unit Label	Tickmark	WP Reference
Regular Ticket Price (Child; Age 0 - 12)				$ -	dollars	RW
Regular Ticket Price - Day (Adult; Age 13+)				24.95	dollars	RW
Regular Ticket Price - Night (Adult; Age 13+)				34.95	dollars	RW
Summer Ticket Price - Day (Adult; Age 13+)				19.95	dollars	RW
Summer Ticket Price - Night (Adult; Age 13+)				29.95	dollars	RW
WholesaleTicket Price				12.95	dollars	PBC

	Total Passengers	Unit Label
January	245,163	people
February	228,455	people
March	261,996	people
Q1 20X5	735,614	people
April	255,898	people
May	270,268	people
June	256,758	people
Q2 20X5	782,924	people
July	270,000	people
August	260,209	people
September	256,207	people
Q3 20X5	786,416	people
October	273,523	people
November	246,589	people
December	233,385	people
Q4 20X5	753,497	people
20X5 Total	3,058,451	people

	Children (0 - 12)		Adults (13+)		Locals		Wholesale
	Day	Night	Day	Night	Day	Night	Day	Night
January	4.2%	3.3%	22.4%	43.8%	4.5%	8.7%	5.2%	7.9%
February	4.7%	3.1%	22.8%	41.6%	4.9%	9.4%	5.0%	8.5%
March	4.1%	3.3%	23.1%	43.6%	4.0%	7.8%	5.8%	8.3%
Q1	4.3%	3.2%	22.8%	43.0%	4.5%	8.6%	5.3%	8.2%	100.0%
April	4.3%	3.8%	23.9%	41.2%	4.7%	9.0%	5.1%	8.0%
May	4.6%	3.0%	24.1%	44.2%	4.3%	8.9%	4.2%	6.7%
June	4.9%	4.3%	23.6%	44.7%	4.6%	9.3%	3.7%	4.9%
Q2	4.6%	3.7%	23.9%	43.4%	4.5%	9.1%	4.3%	6.5%	100.0%
July	4.9%	4.0%	22.2%	41.2%	5.2%	10.4%	4.9%	7.2%
August	4.9%	4.1%	21.6%	43.3%	4.8%	11.0%	4.4%	5.9%
September	4.1%	3.4%	22.9%	42.6%	4.6%	10.4%	5.3%	6.7%
Q3	4.6%	3.8%	22.2%	42.4%	4.9%	10.6%	4.9%	6.6%	100.0%
October	4.5%	3.7%	23.1%	43.2%	4.1%	9.7%	4.9%	6.8%
November	4.5%	4.1%	23.7%	42.9%	4.0%	8.8%	5.0%	7.0%
December	4.3%	4.1%	23.0%	42.5%	4.2%	8.4%	5.4%	8.1%
Q4	4.4%	4.0%	23.3%	42.9%	4.1%	9.0%	5.1%	7.3%	100.0%

Coliseum Entertainment Substantive Analytical Procedure - Ticket Sales Revenue: The Reel Wheel Year-end Audit: December 31, 20X5 Workpaper (WP) ID: Date: Prepared By: 20X5 Unaudited Account Balance (Ticket Sales Revenue) WP Reference from Trial Balance AA.09 Account Unit Label dollars dollars Tickmark PBC Data Point Ticket Sales Revenue (unaudited) Allocated tolerable difference 73,468,219.00 675,000.00 20X5 Summary Information & Data for "The Reel Wheel" Description Data Point WP Reference Unit Label feet cars Observation Wheel Height Number of Passenger Cars Interior Space per Car Maximum Capacity per Car Time Required for Car Revolution Hours of Operation (Open) Hours of Operation (Close Tickmark PBC, RW PBC, RVV PBC, RW PBC, RW PBC, RW PBC, RVV PBC, RW Tickmark PBC PBC PBC Tickmark 550 225 square feet 40 passengers minutes 11:00am 2:00am Data Point Description (20X5 calendar year) Unit Label days WP Reference Days in Operation Total Passengers Total Children Passengers 361 3,058,452 passengers from A.02 A.02, A.03 WP Reference 250,389 assengers Unit Label dollars dollars dollars dollars dollars dollars Description (20X5 calendar year) Data Point Regular Ticket Price (Child; Age 0 12) Regular Ticket Price - Day (Adult; Age 13+) Regular Ticket Price - Night (Adult; Age 13+) Summer Ticket Price - Day (Adult; Age 13+) Summer Ticket Price - Night (Adult; Age 13+) WholesaleTicket Price RW RW RW RW PBC 12.95 Where noted, data is verified at multiple sources (e.g., PBC, RW). The Reel Wheel sells some tickets to wholesalers-such as third-party travel websites-if booked as part of a travel package that includes a stay at a Coliseum hotel. . Although not specifically listed on the RW website, prices for Las Vegas locals Photo ID required) are 40% off of Regular Adult (Day, Night) prices. No summer discount for locals. Tickmark Legend PBC RW Provided by client (Coliseum Entertainment) Sourced from Reel Wheel public website Coliseum Entertainment Substantive Analytical Procedure - Ticket Sales Revenue: The Reel Wheel Year-end Audit: December 31, 20X5 Workpaper (WP) ID: Date: Prepared By: 20X5 Unaudited Account Balance (Ticket Sales Revenue) WP Reference from Trial Balance AA.09 Account Unit Label dollars dollars Tickmark PBC Data Point Ticket Sales Revenue (unaudited) Allocated tolerable difference 73,468,219.00 675,000.00 20X5 Summary Information & Data for "The Reel Wheel" Description Data Point WP Reference Unit Label feet cars Observation Wheel Height Number of Passenger Cars Interior Space per Car Maximum Capacity per Car Time Required for Car Revolution Hours of Operation (Open) Hours of Operation (Close Tickmark PBC, RW PBC, RVV PBC, RW PBC, RW PBC, RW PBC, RVV PBC, RW Tickmark PBC PBC PBC Tickmark 550 225 square feet 40 passengers minutes 11:00am 2:00am Data Point Description (20X5 calendar year) Unit Label days WP Reference Days in Operation Total Passengers Total Children Passengers 361 3,058,452 passengers from A.02 A.02, A.03 WP Reference 250,389 assengers Unit Label dollars dollars dollars dollars dollars dollars Description (20X5 calendar year) Data Point Regular Ticket Price (Child; Age 0 12) Regular Ticket Price - Day (Adult; Age 13+) Regular Ticket Price - Night (Adult; Age 13+) Summer Ticket Price - Day (Adult; Age 13+) Summer Ticket Price - Night (Adult; Age 13+) WholesaleTicket Price RW RW RW RW PBC 12.95 Where noted, data is verified at multiple sources (e.g., PBC, RW). The Reel Wheel sells some tickets to wholesalers-such as third-party travel websites-if booked as part of a travel package that includes a stay at a Coliseum hotel. . Although not specifically listed on the RW website, prices for Las Vegas locals Photo ID required) are 40% off of Regular Adult (Day, Night) prices. No summer discount for locals. Tickmark Legend PBC RW Provided by client (Coliseum Entertainment) Sourced from Reel Wheel public website

Answer & Explanation Solved by verified expert

See Answer