Exercise 24-6
Departmental expense allocation spreadsheet
P2
Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two
operating departments for the year 2017.
The advertising department developed and distributed 120 advertisements during the year. Of these, 90 promoted shoes and 30 promoted clothing. Utilities expense of $64,000 is an indirect expense to all departments. Prepare a departmental expense allocation spreadsheet for Marathon Running Shop. The spreadsheet should assign (1) direct expenses to each of the four departments, (2) the $64,000 of
utilities expense to the four departments on the basis of floor space occupied, (3) the advertising department's expenses to the two operating departments on the basis of the number of ads placed that promoted a department's products, and (4) the administrative department's expenses to the two operating departments based on the amount of sales. Provide supporting computations for the expense allocations.

Want to see the full answer?
Check out a sample textbook solution
Chapter 24 Solutions
FUND OF ACCOUNTING PRIN W/ACC <CUSTOM>
- Can you solve this general accounting question with the appropriate accounting analysis techniques?arrow_forwardPlease provide the accurate answer to this financial accounting problem using appropriate methods.arrow_forwardCompute the number of equivalent full units of production for Department X during October.arrow_forward
- Ruby Electronics Corp. has net sales of $475,000, cost of goods sold of $298,000, operating expenses of $42,000, and interest expense of $8,500. What is the company's gross profit?arrow_forwardSubject: General Accounting 4.2arrow_forwardCan you help me solve this general accounting question using valid accounting techniques?arrow_forward
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub



