FUND.ACCT.PRIN.
25th Edition
ISBN: 9781260247985
Author: Wild
Publisher: RENT MCG
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 24, Problem 6E
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A1
Stage 2 ABC for a Wholesale CompanyInformation is presented for the activity costs of Brighton Wholesale Company:
Activity
Cost per Unit of Activity Driver
Customer relations
$82.00 per customer per month
Selling
0.09 per sales dollar
Accounting
7.00 per order
Warehousing
0.60 per unit shipped
Packing
0.35 per unit shipped
Shipping
0.40 per pound shipped
The following information pertains to Brighton Wholesale Company's activities in Colorado for the month of June 2017:
Number of orders
320
Sales revenue
$218,000
Cost of goods sold
$98,100
Number of customers
40
Units shipped
5,400
Pounds shipped
81,000
RequiredDetermine the profitability of sales in Colorado for June 2017.Do not use a negative sign with your answers.
Profitability of Sales in Colorado
March 2017
Sales revenue
Answer
Less:
Cost of goods sold
Answer
Customer relations
Answer
Selling expenses
Answer
Accounting
Answer
Warehousing
Answer…
Problem 5
The accounting department of the Blanche Corporation provided the
following data for March, 2011.
Sales
P1,200,000
Marketing Expenses
Administrative Expenses
5% of Sales
1% of Sales
P400,000 to
2/3 of DL costs
a P210,000
March 1vi
P100,000
102,350
50,000itec 47,485
Purchases
Factory Overheado
Direct Labor
slin March 31
P82,500
117,135
Inventories:
Finished goods
Work in Process
Materials
Required:
1. Income Statement
2. Cost of Goods sold Statement
to
Chapter 24 Solutions
FUND.ACCT.PRIN.
Ch. 24 - Prob. 1QSCh. 24 - QS 24-2 Basis for cost allocation C1
In each...Ch. 24 - QS 244
Responsibility accounting report...Ch. 24 - QS 24-5
Allocating costs to departments...Ch. 24 - QS 24-6
Allocating costs to departments P2...Ch. 24 - QS 24-7
Allocating costs to departments
P2...Ch. 24 - Prob. 7QSCh. 24 - QS 24-9
Departmental contribution to overhead...Ch. 24 - QS 24-10
Computing return on investment A1...Ch. 24 - QS 24-11
Computing residual income
A1
Refer to...
Ch. 24 -
QS 24-12
Performance measures
A1 A2
Fill in...Ch. 24 - QS 24-13
Computing profit margin and investment...Ch. 24 - Prob. 13QSCh. 24 - Prob. 14QSCh. 24 - Prob. 15QSCh. 24 - Prob. 16QSCh. 24 - Prob. 17QSCh. 24 - Prob. 18QSCh. 24 - Prob. 19QSCh. 24 - Prob. 20QSCh. 24 - Prob. 21QSCh. 24 - Prob. 1ECh. 24 - Prob. 2ECh. 24 - Prob. 3ECh. 24 - Prob. 4ECh. 24 - Prob. 5ECh. 24 - Exercise 24-6 Departmental expense allocation...Ch. 24 - Prob. 7ECh. 24 - Prob. 8ECh. 24 - Prob. 9ECh. 24 - Prob. 10ECh. 24 - Prob. 11ECh. 24 - Prob. 12ECh. 24 - Prob. 13ECh. 24 - Prob. 14ECh. 24 - Prob. 15ECh. 24 - Prob. 16ECh. 24 - Prob. 17ECh. 24 - Prob. 18ECh. 24 - Prob. 19ECh. 24 - Prob. 20ECh. 24 - Prob. 21ECh. 24 - Prob. 22ECh. 24 - Prob. 23ECh. 24 - Prob. 1PSACh. 24 - Prob. 2PSACh. 24 - Prob. 3PSACh. 24 - Prob. 4PSACh. 24 - Prob. 5PSACh. 24 - Prob. 1PSBCh. 24 - Prob. 2PSBCh. 24 - Prob. 3PSBCh. 24 - Prob. 4PSBCh. 24 - Prob. 5PSBCh. 24 - Prob. 24SPCh. 24 - Prob. 1AACh. 24 - Prob. 2AACh. 24 - Prob. 3AACh. 24 - Prob. 1DQCh. 24 - Prob. 2DQCh. 24 - Prob. 3DQCh. 24 - Prob. 4DQCh. 24 - Prob. 5DQCh. 24 - Prob. 6DQCh. 24 - Prob. 7DQCh. 24 - Prob. 8DQCh. 24 - Prob. 9DQCh. 24 - Prob. 10DQCh. 24 - Prob. 11DQCh. 24 - Prob. 12DQCh. 24 - Prob. 13DQCh. 24 - Prob. 14DQCh. 24 - Prob. 15DQCh. 24 - Prob. 16DQCh. 24 - Prob. 17DQCh. 24 - Prob. 18DQCh. 24 - Prob. 1BTNCh. 24 - Prob. 2BTNCh. 24 - Prob. 3BTNCh. 24 - Prob. 4BTN
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Q3 helparrow_forwardPlease do not give solution in image format thankuarrow_forwardQuestion 18 View Policies Current Attempt in Progress E-Flix rents DVDS that are mailed out to customers upon demand. E-Flix has identified three activities involved in getting the videos to its customers. Information on those activities for the month of July follows: Estimated Expected Use of Cost Drivers Cost Pools Cost Drivers Overhead Cost Order taking costs Number of orders $20,592 187,200 orders Technology support Number of minutes $11,700 234,000 minutes Picking and shipping Number of DVDS $39,624 330,200 DVDS costs During July, the Tucker family placed 17 orders consisting of 21 DVDS. Tucker required 7 minutes of tech support. Customers pay $9.00 per month to rent unlimited DVDS. Using ABC, how much overhead is applied to the Tucker family account for technology support? O Some other answer O $1.87 O $0.05 o$0.35 2:28 P ) 10/13/23arrow_forward
- RRarrow_forwardQuestion 1 Green Co. has three production departments Fern, Forest, and Moss and one service department Shade. Green Co. is preparing its annual budget for the final quarter of 2021. Planned overhead costs for the quarter are as follows: Overheads Allocated overheads 40,500 Supervision Plant Depreciation 14,400 20,000 6,000 46,000 Machine Insurance Rates and Rent The following information is available for each department: Departmental details Fern Forest Moss Shade Allocated overhead 11,000 16,500 2,500 9,500 3,500 3,500 1,500 Machine Value (£) Budgeted Direct Labour hours Floor Area Occupied (Sq.metres) Number of employees Plant at cost (£000) 5,000 1,200 600 1,800 1000 3,000 800 200 700 400 40 80 1,845 852 61 142 Of the total overhead costs allocated to the service department Shade, 20% is charged to Forest and the remainder is charged equally to the other two production department. a) Prepare an overhead analysis sheet showing the total overhead cost budgeted for all four…arrow_forwardMarathon 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 2019. Direct Expenses Square Feet 500 Sales Department Advertising Administrative $ 15,000 27,000 103,000 13,000 700 4,100 4,700 $124,000 186,000 Shoes Clothing The advertising department developed and distributed 190 advertisements during the year. Of these, 38 promoted shoes and 152 promoted clothing. Utilities expense of $74,000 is an indirect expense to all departments. Complete a departmental expense allocation spreadsheet for Marathon Running Shop. The spreadsheet should assign (1) direct expenses to each of the four departments, (2) the $74,000 of utilities expense to the four departments on the basis of floor space occupied, (3) the advertising department's expenses…arrow_forward
- Required information The Ferre Publishing Company has three service departments and two operating departments. Selected data from a recent period on the five departments follow: Costs Number of employees Square feet of space occupied Hours of press time Departmental costs before allocations Allocations: Service Departments Administration Janitorial Maintenance $ 144,200 $ 108,150 $ 49,440 140 20,000 Administration costs Janitorial costs Maintenance costs Total costs after allocations 60 15,000 Administration $ The company allocates service department costs by the step-down method in the following order: Administration (number of employees), Janitorial (space occupied), and Maintenance (hours of press time). Service Departments Janitorial $ 144,200 $ 108,150 $ 35 10,000 Required: Using the step-down method, allocate the service department costs to the operating departments. (Please enter allocations from a department as negative and allocations to a department as positive. The line…arrow_forward4 eBook References Caro Manufacturing has two production departments, Machining and Assembly, and two service departments, Maintenance and Cafeteria. Direct costs for each department and the proportion of service costs used by the various departments for the month of August follow. Department Machining Assembly Maintenance Cafeteria Direct Costs $160,000 65,000 45,000 30,000 Maximum Amount Proportion of Services Used by Maintenance Cafeteria Machining Assembly 8.5 0.1 0.3 0.1 Caro estimates that the variable costs in the Maintenance Department total $12,000, and in the Cafeteria variable costs total $17,000. Avoldable fixed costs in the Maintenance Department are $8,000. Required: If Caro outsources the Maintenance Department, what is the maximum It can pay an outside vendor without increasing total costs? (Do not round Intermediate calculations.)arrow_forwardQuestion 2: Bed and Bath, a retailing company has two departments, Hardware and Linens. The company's most recent monthly contribution format income statement is given below: Department Total Hardware Linens Sales $40,00,000 $30,00,000 $10,00,000 Variable expenses 13,00,000 9,00,000 4,00,000 Contribution Margin Fixed expenses 21,00,000 14,00,000 $700,000 600,000 27,00,000 22,00,000 $5,00,000 800,000 ($200,000) Net Operating Income A study indicates that, $340,000 of the fixed expenses charged to Lines are sunk costs or allocated cost that will continue to incur even if the Linens department is dropped. In addition, the elimination of the Lines department will result in a 10% increase in the sales of the Hardware department. Required : If the Linens Department is dropped, what will be the effect on the net operating income of the company as a whole?[arrow_forward
- Service Department Allocations The centralized employee travel department of Bourgeois Company has costs of $405,600. The department has serviced a total of 3,900 travel reservations for the period. The South Division has made 2,260 reservations during the period, and the West Division has made 1,640 reservations. How much should each division be allocated for travel services? South Division $ West Division 24arrow_forwardCurrent Attempt in Progress Blue Spruce's Medical operates three support departments and two operating units, Surgery and ER. The support departments are allocated based on the hours used. The cost of operating the accounting (acct), administration (admin), and human resources (HR) departments is $267800, $150600, and $71600, respectively. Information on the hours used are as follows: Hours in Acct Hours in Admin Hours in HR Acct $0. $276955. $274542. $251890. 16 8 Admin 20 4 HR 48 8 Surgery ER 360 220 120 65 80 130 What are the total costs allocated to the surgery department from the supporting departments? (Do not round the intermediate calculations.)arrow_forwardfcdxdxcfrrrrrarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Managerial 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
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
GE McKinsey Matrix for SBU Strategies; Author: Wolters World;https://www.youtube.com/watch?v=FffD1Ze76JQ;License: Standard Youtube License