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 solutionChapter 24 Solutions
FUND ACCOUNTING PRINCIPLES CONNECT
- 4 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_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_forwardQuestion Content Area Profit center responsibility reporting Championship Sports Inc. operates two divisions—the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y9, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Line Item Description Amount Sales—Winter Sports Division $9,600,000 Sales—Summer Sports Division 15,000,000 Cost of Goods Sold—Winter Sports Division 5,500,000 Cost of Goods Sold—Summer Sports Division 9,500,000 Sales Expense—Winter Sports Division 780,000 Sales Expense—Summer Sports Division 1,000,000 Administrative Expense—Winter Sports Division 700,000 Administrative Expense—Summer Sports Division 1,440,000 Advertising Expense 1,099,000 Transportation Expense 150,000 Accounts Receivable Collection Expense 67,000 Warehouse Expense 966,000 The bases to be used in allocating…arrow_forward
- Chapter 5 Activity-Based Costing and Management Problem 5-57 Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by custom- er type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer catego- ries and their associated annual costs are as follows: Opening and closing accounts Issuing monthly statements Processing transactions Customer inquiries $ 300,000 450,000 3,075,000 0000 Providing automatic teller machine (ATM) services 600,000 Total cost 1,680,000 $6,105,000 Additional data concerning the usage of the activities by the various customers are also provided: Account Balance Low Medium High Number of accounts opened/closed 22,500 4,500 3,000 Number of statements issued 675,000 150,000 75,000 Processing transactions 27,000,000 3,000,000 750,000 Number of telephone minutes 1,500,000 900,000 600,000 Number…arrow_forwardDepartmental Expense Allocation Spatula Galaxy has 3 departments: materials, manufacturing, and packaging. In a recent month the 3 departments incurred 3 shared indirect expenses. The amounts follow: Indirect Expense Supervision Utilities Insurance Departmental data for Spatula Galaxy follows: Department Materials Cost Allocation Base $80,000 Number of employees $60,000 Square footage $30,000 Value of assets in use Manufacturing Packaging Employees 20 20 40 Square Feet 10,000 25,000 5,000 Asset Values $5,000 $35,000 $10,000 Use the information above to allocate the indirect expenses across the 3 departments.arrow_forwardProfit Center Responsibility Reporting XSport Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y9, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Sales—Winter Sports Division $29,295,000 Sales—Summer Sports Division 32,364,000 Cost of Goods Sold—Winter Sports Division 17,577,000 Cost of Goods Sold—Summer Sports Division 18,693,000 Sales Expense—Winter Sports Division 5,022,000 Sales Expense—Summer Sports Division 4,464,000 Administrative Expense—Winter Sports Division 2,929,500 Administrative Expense—Summer Sports Division 2,873,700 Advertising Expense 1,012,000 Transportation Expense 435,000 Accounts Receivable Collection Expense 250,200 Warehouse Expense 2,790,000 The bases to be used in allocating expenses, together with other essential…arrow_forward
- QS 22-7 (Algo) Allocating costs to departments LO P2 SodaPop Company has two operating departments: Mixing and Bottling. Mixing has 375 employees and Bottling has 375 employees. Office costs of $220,000 are allocated to operating departments based on the number of employees. Determine the office costs allocated to each operating department. Department Employees Mixing Bottling Total 0 Percent of Total Cost Allocated % % 0.00% $ 0arrow_forwardRequired information Exercise 11-27 & 11-28 (Algo) (LO 11-2) Skip to question [The following information applies to the questions displayed below.] 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: Proportion of Services Used by Department Direct Costs Maintenance Cafeteria Machining Assembly Machining $ 94,000 Assembly 66,400 Maintenance 41,200 — 0.2 0.6 0.2 Cafeteria 33,000 0.8 — 0.1 0.1 Exercise 11-28 (Algo) Allocating Service Department Costs First to Production Departments and Then to Jobs (LO 11-2) Assume that both Machining and Assembly work on just two jobs during the month of August: CM-22 and CM-23. Costs are allocated to jobs based on machine-hours in…arrow_forwardINCOME STATE MENT WITH DEPARTMENTAL OPERATING INCOME AND TOTAL OPERATING INCOME Alexa Cole owns a business called Alexas Bakery. She has divided her business into two departments: breads and pastries. The following information is provided for the fiscal year ended June 30, 20--: REQUIRED 1. Prepare an income statement showing departmental operating income and total operating income. 2. Calculate departmental operating expense and operating income percentages.arrow_forward
- Budget performance report for a cost center Sneed Industries Company sells vehicle parts to manufacturers of heavy construction equipment. The Crane Division is organized as a cost center. The budget for the Crane Division for the month ended August 31, 20Y6, is as follows (in thousands): During August, the costs incurred in the Crane Division were as follows: Instructions Prepare a budget performance report for the director of the Crane Division for the month of August.arrow_forwardProfit Center Responsibility Reporting XSport Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y9, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Sales—Winter Sports Division $26,775,000 Sales—Summer Sports Division 29,580,000 Cost of Goods Sold—Winter Sports Division 16,065,000 Cost of Goods Sold—Summer Sports Division 17,085,000 Sales Expense—Winter Sports Division 4,590,000 Sales Expense—Summer Sports Division 4,080,000 Administrative Expense—Winter Sports Division 2,677,500 Administrative Expense—Summer Sports Division 2,626,500 Advertising Expense 927,000 Transportation Expense 408,800 Accounts Receivable Collection Expense 224,000 Warehouse Expense 2,550,000 The bases to be used in allocating expenses, together with other essential…arrow_forwardEXERCISE 12-4 The Income Statement columns of the August 31 (year-end) work sheet for Ralley Company are shown here, From the information given, prepare income statement for the company. To save time and space, the expenses have been grouped together into two categories. LO Pra Show m HOV 4 5 ACCOUNT NAME INCOME STATEMENT DEBIT 7 CREDIT 23 Income Summary Sales 32,000.00 31,000.00 324,000.00 24 25 Sales Returns and Allowances 13,310.00 7,700.00 126,360.00 26 Sales Discounts Purchases Purchases Returns and Allowances Purchases Discounts 27 1,200.00 1,300.00 28 29 30 7,500.00 61,560.00 Freight In 31 50,884.00 299,314.00 58.188.00 357,500.00 Selling Expenses 357,500.00 32 General Expenses 33 357,500.00 34 Net Income 35 36 Sheet3 Sheet2 Sheettarrow_forward
- 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 LearningManagerial 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