Question

1 Approved Answer

Posted on Aug 11, 2024

As part of the annual audit of Coliseum Entertainments 20X5 financial statements, the engagement audit partner has encouraged you a third-year associate auditor to develop

As part of the annual audit of Coliseum Entertainments 20X5 financial statements, the engagement audit partner has encouraged you a third-year associate auditor to develop a substantive analytical procedure to test Coliseums 20X5 Ticket Sales Revenue account for the Reel Wheel attraction. After carefully reviewing the appropriate auditing standards, you approach the appropriate personnel at Coliseum and request the data needed to create your data analytic.

Appendix A of this case contains a copy of the requested data related to ticket sales revenue generated by the Reel Wheel during 20X5. Use Excel to create analytics showing your solutions to the following three questions. Use separate tabs to show your work in analyzing each question.

2.3 Using all of the disaggregated data provided by the client, develop an audit work paper to calculate the most precise estimate you can for Ticket Sales Revenue in 20X5 at the Reel Wheel. Compare this 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.

image text in transcribed

20x5 Unaudited Account Balance (Ticket Sales Revenue) Account Data Point Ticket Sales Revenue (unaudited) $ 73,468,219.00 Allocated tolerable difference 675,000.00 Unit Label dollars dollars Tickmark PBC WP Reference from Trial Balance AA.09 WP Reference Unit Label feet cars square feet passengers minutes 30 20x5 Summary Information & Data for "The Reel Wheel" Description Data Point Observation Wheel Height 550 Number of Passenger Cars 28 Interior Space per Car 225 Maximum Capacity per Car 40 Time Required for Car Revolution Hours of Operation (Open) 11:00am Hours of Operation (Close) 2:00am Description (20x5 calendar year) Data Point Days in Operation 361 Total Passengers 3,058,452 Total Children Passengers 250,389 Description (20x5 calendar year) Data Point Regular Ticket Price (Child; Age 0-12) Regular Ticket Price - Day (Adult; Age 13+) 24.95 Regular Ticket Price - Night (Adult; Age 13+) 34.95 Summer Ticket Price - Day (Adult; Age 13+) 19.95 Summer Ticket Price - Night (Adult; Age 13+) 29.95 Wholesale Ticket Price 12.95 WP Reference Tickmark PBC, RW PBC, RW PBC, RW PBC, RW PBC, RW PBC, RW PBC, RW Tickmark PBC PBC PBC Tickmark RW RW RW RW RW PBC Unit Label days passengers passengers Unit Label dollars dollars dollars dollars dollars dollars from A.02 A.02, A.03 WP Reference Notes 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. A.02 Coliseum Entertainment Substantive Analytical Procedure - Ticket Sales Revenue: The Reel Wheel Year-end Audit: December 31, 20X5 Workpaper (WP) ID: Date: Prepared By: 20X5 Ticket Sales Data for "The Reel Wheel" [Provided by Client] WP Reference Unit Label people Tickmark PBC people January February March Q1 20X5 April May June Q2 20x5 July August September Q3 20X5 October November December Q4 20X5 20x5 Total Total Passengers 245,163 228,455 261,996 735,614 255,898 270,268 256,758 782,924 270,000 260,209 256,207 786,416 273,523 246,589 233,385 753,497 3,058,451 people people people people people people people people people people people people people people people PBC to A.01 Tickmark Legend PBC Provided by client (Coliseum Entertainment) A.03 Colisum Entertainment Substantive Analytical Procedure - Ticket Sales Revenue: The Reel Wheel Year-end Audit: December 31, 20X5 Workpaper (WP) ID: Date: Prepared By: 20X5 Ticket Sales Mix (%) for "The Reel Wheel" [Provided by Client] Tickmark PBC January February March Q1 Children (0-12) Day Night 4.2% 3.3% 4.7% 3.1% 4.1% 3.3% 4.3% 3.2% Adults (13+) Day Night 22.4% 43.8% 22.8% 41.6% 23.1% 43.6% 22.8% 43.0% Locals Day Night 4.5% 8.7% 4.9% 9.4% 4.0% 7.8% 4.5% 8.6% Wholesale Day Night 5.2% 7.9% 5.0% 8.5% 5.8% 8.3% 5.3% 8.2% 100.0% 3.8% 3.0% April May June Q2 4.3% 4.6% 4.9% 4.6% 23.9% 24.1% 23.6% 23.9% 41.2% 44.2% 44.7% 43.4% 4.7% 4.3% 4.6% 4.5% 9.0% 8.9% 9.3% 9.1% 5.1% 4.2% 3.7% 4.3% 8.0% 6.7% 4.9% 6.5% 4.3% 3.7% / 100.0% / July August September Q3 4.9% 4.9% 4.1% 4.6% 4.0% 4.1% 3.4% 3.8% 22.2% 21.6% 22.9% 22.2% 41.2% 43.3% 42.6% 42.4% 5.2% 4.8% 4.6% 4.9% 10.4% 11.0% 10.4% 10.6% 4.9% 4.4% 5.3% 4.9% 7.2% 5.9% 6.7% 6.6% 1 100.0% / / October November December Q4 4.5% 4.5% 4.3% 4.4% 3.7% 4.1% 4.1% 4.0% 23.1% 23.7% 23.0% 23.3% 43.2% 42.9% 42.5% 42.9% 4.1% 4.0% 4.2% 4.1% 9.7% 8.8% 8.4% 9.0% 4.9% 5.0% 5.4% 5.1% 6.8% 7.0% 8.1% 7.3% | 100.0% PBC Tickmark Legend PBC Provided by client (Coliseum Entertainment) 20x5 Unaudited Account Balance (Ticket Sales Revenue) Account Data Point Ticket Sales Revenue (unaudited) $ 73,468,219.00 Allocated tolerable difference 675,000.00 Unit Label dollars dollars Tickmark PBC WP Reference from Trial Balance AA.09 WP Reference Unit Label feet cars square feet passengers minutes 30 20x5 Summary Information & Data for "The Reel Wheel" Description Data Point Observation Wheel Height 550 Number of Passenger Cars 28 Interior Space per Car 225 Maximum Capacity per Car 40 Time Required for Car Revolution Hours of Operation (Open) 11:00am Hours of Operation (Close) 2:00am Description (20x5 calendar year) Data Point Days in Operation 361 Total Passengers 3,058,452 Total Children Passengers 250,389 Description (20x5 calendar year) Data Point Regular Ticket Price (Child; Age 0-12) Regular Ticket Price - Day (Adult; Age 13+) 24.95 Regular Ticket Price - Night (Adult; Age 13+) 34.95 Summer Ticket Price - Day (Adult; Age 13+) 19.95 Summer Ticket Price - Night (Adult; Age 13+) 29.95 Wholesale Ticket Price 12.95 WP Reference Tickmark PBC, RW PBC, RW PBC, RW PBC, RW PBC, RW PBC, RW PBC, RW Tickmark PBC PBC PBC Tickmark RW RW RW RW RW PBC Unit Label days passengers passengers Unit Label dollars dollars dollars dollars dollars dollars from A.02 A.02, A.03 WP Reference Notes 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. A.02 Coliseum Entertainment Substantive Analytical Procedure - Ticket Sales Revenue: The Reel Wheel Year-end Audit: December 31, 20X5 Workpaper (WP) ID: Date: Prepared By: 20X5 Ticket Sales Data for "The Reel Wheel" [Provided by Client] WP Reference Unit Label people Tickmark PBC people January February March Q1 20X5 April May June Q2 20x5 July August September Q3 20X5 October November December Q4 20X5 20x5 Total Total Passengers 245,163 228,455 261,996 735,614 255,898 270,268 256,758 782,924 270,000 260,209 256,207 786,416 273,523 246,589 233,385 753,497 3,058,451 people people people people people people people people people people people people people people people PBC to A.01 Tickmark Legend PBC Provided by client (Coliseum Entertainment) A.03 Colisum Entertainment Substantive Analytical Procedure - Ticket Sales Revenue: The Reel Wheel Year-end Audit: December 31, 20X5 Workpaper (WP) ID: Date: Prepared By: 20X5 Ticket Sales Mix (%) for "The Reel Wheel" [Provided by Client] Tickmark PBC January February March Q1 Children (0-12) Day Night 4.2% 3.3% 4.7% 3.1% 4.1% 3.3% 4.3% 3.2% Adults (13+) Day Night 22.4% 43.8% 22.8% 41.6% 23.1% 43.6% 22.8% 43.0% Locals Day Night 4.5% 8.7% 4.9% 9.4% 4.0% 7.8% 4.5% 8.6% Wholesale Day Night 5.2% 7.9% 5.0% 8.5% 5.8% 8.3% 5.3% 8.2% 100.0% 3.8% 3.0% April May June Q2 4.3% 4.6% 4.9% 4.6% 23.9% 24.1% 23.6% 23.9% 41.2% 44.2% 44.7% 43.4% 4.7% 4.3% 4.6% 4.5% 9.0% 8.9% 9.3% 9.1% 5.1% 4.2% 3.7% 4.3% 8.0% 6.7% 4.9% 6.5% 4.3% 3.7% / 100.0% / July August September Q3 4.9% 4.9% 4.1% 4.6% 4.0% 4.1% 3.4% 3.8% 22.2% 21.6% 22.9% 22.2% 41.2% 43.3% 42.6% 42.4% 5.2% 4.8% 4.6% 4.9% 10.4% 11.0% 10.4% 10.6% 4.9% 4.4% 5.3% 4.9% 7.2% 5.9% 6.7% 6.6% 1 100.0% / / October November December Q4 4.5% 4.5% 4.3% 4.4% 3.7% 4.1% 4.1% 4.0% 23.1% 23.7% 23.0% 23.3% 43.2% 42.9% 42.5% 42.9% 4.1% 4.0% 4.2% 4.1% 9.7% 8.8% 8.4% 9.0% 4.9% 5.0% 5.4% 5.1% 6.8% 7.0% 8.1% 7.3% | 100.0% PBC Tickmark Legend PBC Provided by client (Coliseum Entertainment)