Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please do it in a excel spreadsheet Problem 4: Explanation of ABC Costing The United Center is home to both the Chicago Blackhawks and the

image text in transcribed

please do it in a excel spreadsheet

Problem 4: Explanation of ABC Costing The United Center is home to both the Chicago Blackhawks and the Chicago Bulls in addition to hosting other special events (circus, Disney On Ice, etc). They are trying to determine the profitability of each type of activity (Bulls, Blackhawks, and Special Events). They have identified the following costs and want to use ABC to allocate these costs: Interest on Mortgage / Real Estate Taxes Salaries of Maintenance Personnel Set-Up Costs for Events (games and special events). Ticket Reservations / Ticket Sales $20,000,000 950,000 300,000 1,400,000 Here is other data related to the allocation of the indirect costs. Bulls Blackhawks 45 Special Events 30 Total Dates Total Tickets Sold Total Set-Up Hours 3000 Total Clean-Up Hours Average Ticket Price 45 900,000 800,000 6,000 1,800 450,000 7,500 1,000 1,200 $100 $105 $65 Write a memo to Mary Reinsdorf-Wirtz, CEO of the United Center. In the memo explain to her the concept of ABC and how the above costs should be allocated. Also, attach a partial income statement showing revenues, the indirect costs (all four) and net income for each type of event and the total. You will have to decide how to allocate the indirect costs however use ABC and show the allocation for all four indirect costs. The memo should be professionally typed and reviewed for errors

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

Financial Accounting

Authors: David Spiceland

6th Edition

1260786528, 9781260786521

More Books

Students also viewed these Accounting questions

Question

What is the difference between electronic training and e-learning?

Answered: 1 week ago

Question

Define Administration?

Answered: 1 week ago

Question

2. Information that comes most readily to mind (availability).

Answered: 1 week ago

Question

3. An initial value (anchoring).

Answered: 1 week ago