Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you please explain in excel format with calculations. thank you Problem 4: Changing Income Statement Amusement Park WallyWorld is an amusement park in need

image text in transcribed

can you please explain in excel format with calculations. thank you

Problem 4: Changing Income Statement Amusement Park WallyWorld is an amusement park in need of some assistance. They have broken out their income statement to four amounts as follows: Sales: 55,000 customers at $40 per customer . Ticket Sales: $3.50 per ticket sold . Operating the Rides and Attractions; 11,340 runs at $90 per run . Litter Patrol: 1,750 hours at $20 per hour In order to stay competitive, Wally has decided to lower the price to $35 per ticket sold. The number of customers 1s expected to remain the same. In order make up for the disference in lost revenue, Wally has the following plan to reduce costs: Reduce the cost of selling tickets to $3.00 per ticket sold Reduce the number of runs per week by 1,000 per week by closing some rides early Adding more garbage cans in the park at a cost of $500. This is expected to reduce the litter patrol hours by 25% . Required Calculate the sales, all three expenses, total expenses and operating income using the original data Calculate the same amounts with the new changes planned Based on your results, should Wally make the changes? Explain your answer using your financial results . Current With Changes Sales Ticket Sales Operating Rides Litter Patrol Total Expenses Operating Income Comments

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sm Auditing Integrated Appr Review Copy

Authors: ARENS LO, EBBECKE

7th Edition

0135914396, 978-0135914397

More Books

Students also viewed these Accounting questions