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
Connect Access Card For Fundamental Accounting Principles
- Current 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 2 XYZ company ltd. Comprises 3 production departments and 2 service departments. The budget for 2016 has been compiled and broken down as follows: Production Departments Service Departments Departments I II III A B $ $ $ $ $ Total Overheads 12,200 8,400 7,750 600 200 Additional information: Service departments’ costs are to be apportioned as follows: Production Departments Service Departments Departments I II III A B Service A 20% 25% 35% - 20% Service B 45% - 25% 30% - You are required to apportion the service department costs to production departmentsarrow_forwardChapter 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_forward
- Departmental 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_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_forwardSupport department allocations The centralized computer technology department of Hardy Company has expenses of 320,000. The department has provided a total of 4,000 hours of service for the period. The Retail Division has used 2,750 hours of computer technology service during the period, and the Commercial Division has used 1,250 hours of computer technology service. How much should each division be allocated for computer technology department services?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_forwardA-3arrow_forwardProvide this question solution general accountingarrow_forward
- View Policies Current Attempt in Progress Blossom'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 $274500, $164700, and $66000, respectively. Information on the hours used are as follows: Acct Admin HR Surgery ER Hours in Acct 20 48 360 220 Hours in Admin 16 8 120 80 Hours in HR 8 4 65 130 What amount of costs would be allocated from the HR department to the other support departments (Acct and Admin) using the reciprocal method to allocate costs? (Do not round the intermediate calculations.) $5438. $0. $7203. $6894. eTextbook and Mediaarrow_forwardH1 . Accountarrow_forwardQuestion Content Area Zoe Corporation has the following information for the month of March: Purchases $92,000 Materials inventory, March 1 6,000 Materials inventory, March 31 8,000 Direct labor 25,000 Factory overhead 37,000 Work in process inventory, March 1 22,000 Work in process inventory, March 31 23,500 Finished goods inventory, March 1 21,000 Finished goods inventory, March 31 30,000 Sales 257,000 Selling and administrative expenses 79,000 Question Content Area a. Prepare a schedule of cost of goods manufactured. Zoe CorporationStatement of Cost of Goods ManufacturedFor the Month Ended March 31 $- Select - Direct Materials: $- Select - - Select - $- Select - - Select - Cost of direct materials used $fill in the blank 4894e1fcf050fd3_11 - Select - - Select - Total manufacturing costs incurred fill in the blank 4894e1fcf050fd3_16 Total manufacturing…arrow_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 LearningFinancial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning