Homework Help is Here – Start Your Trial Now!
Business
Accounting
Requirement 1. Allocate the support departments' costs to the operating departments using the direct method. (Do not round intermediary calculations. Only round the amount you input in the cell to the nearest dollar. Use parentheses or a minus sign when decreasing departments by allocating costs. Enter a "0" for any zero balances. Abbreviations used: HR = Human resources; Info. = Information.) Support Departments Operating Departments HR Info. Systems Consumer - X Corporate | Total O Data Tabler Costs incurred 80000|| 260000 950000|| 465000 1755000 Allocation of HR costs -80000 33000 27000 Allocation of Info. System costs -260000 Support Departments Information Operating Departments 1755000 Corporate Consumer Sales Human Total budgeted costs of operating departments Resources Systems Sales Budgeted costs incurred before any interdepartment cost allocations Support work supplied by human resources department O Requirements - X 80,000 $ 260,000 $ 950,000 $ 465,000 Budgeted number of employees Support work supplied by information systems department 20 44 36 1. Allocate the support departments' costs to the operating departments using the direct method. 2. Rank the support departments based on the percentage of their services provided to other support departments. Use this ranking to allocate the support departments' costs to the operating departments based on the step-down method. Budgeted processing time (in minutes) 400 2,500 2,100 3. How could you have ranked the support departments differently? Print Done

Requirement 1. Allocate the support departments' costs to the operating departments using the direct method. (Do not round intermediary calculations. Only round the amount you input in the cell to the nearest dollar. Use parentheses or a minus sign when decreasing departments by allocating costs. Enter a "0" for any zero balances. Abbreviations used: HR = Human resources; Info. = Information.) Support Departments Operating Departments HR Info. Systems Consumer - X Corporate | Total O Data Tabler Costs incurred 80000|| 260000 950000|| 465000 1755000 Allocation of HR costs -80000 33000 27000 Allocation of Info. System costs -260000 Support Departments Information Operating Departments 1755000 Corporate Consumer Sales Human Total budgeted costs of operating departments Resources Systems Sales Budgeted costs incurred before any interdepartment cost allocations Support work supplied by human resources department O Requirements - X 80,000 $ 260,000 $ 950,000 $ 465,000 Budgeted number of employees Support work supplied by information systems department 20 44 36 1. Allocate the support departments' costs to the operating departments using the direct method. 2. Rank the support departments based on the percentage of their services provided to other support departments. Use this ranking to allocate the support departments' costs to the operating departments based on the step-down method. Budgeted processing time (in minutes) 400 2,500 2,100 3. How could you have ranked the support departments differently? Print Done

Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter25: Segment Income Statement (dept)
Section: Chapter Questions
Problem 6R
See similar textbooks
icon
Related questions
Question
|- books, an online book retailer, has two operating departments-corporate sales and consumer sales-and two support departments-human resources and information systems. Each sales department conducts merchandising and marketing operations independently. I- books uses number of employees to allocate human resources costs and processing time to allocate information systems costs. The following data are available for September 2017: E (Click the icon to view the data.) Read the requirements. Requirement 1. Allocate the support departments' costs to the operating departments using the direct method. (Do not round intermediary calculations. Only round the amount you input in the cell to the nearest dollar. Use parentheses or a minus sign when decreasing departments by allocating costs. Enter a "0" for any zero balances. Abbreviations used: HR = Human resources; Info. = Information.) Support Departments Operating Departments HR Info. Systems Corporate Consumer Total Data Table Costs incurred 80000 260000 950000 465000 1755000 Allocation of HR costs -80000 33000 27000 -260000 Allocation of Info. System costs Support Departments Operating Departments 1755000 Human Information Corporate Sales Consumer Total budgeted costs of operating departments Resources Systems Sales Budgeted costs incurred before any interdepartment cost allocations Requirements $ 80,000 $ 260,000 $ 950,000 $ 465,000 Support work supplied by human resources department Budgeted number of employees 20 44 36 1. Allocate the support departments' costs to the operating departments using the direct method. Support work supplied by information systems department 2. Rank the support departments based on the percentage of their services provided to other support departments. Use this ranking to allocate the support departments' costs to the operating departments based on the step-down method. Budgeted processing time (in minutes) 400 2,500 2,100 3. How could you have ranked the support departments differently? Print Done
Transcribed Image Text:|- books, an online book retailer, has two operating departments-corporate sales and consumer sales-and two support departments-human resources and information systems. Each sales department conducts merchandising and marketing operations independently. I- books uses number of employees to allocate human resources costs and processing time to allocate information systems costs. The following data are available for September 2017: E (Click the icon to view the data.) Read the requirements. Requirement 1. Allocate the support departments' costs to the operating departments using the direct method. (Do not round intermediary calculations. Only round the amount you input in the cell to the nearest dollar. Use parentheses or a minus sign when decreasing departments by allocating costs. Enter a "0" for any zero balances. Abbreviations used: HR = Human resources; Info. = Information.) Support Departments Operating Departments HR Info. Systems Corporate Consumer Total Data Table Costs incurred 80000 260000 950000 465000 1755000 Allocation of HR costs -80000 33000 27000 -260000 Allocation of Info. System costs Support Departments Operating Departments 1755000 Human Information Corporate Sales Consumer Total budgeted costs of operating departments Resources Systems Sales Budgeted costs incurred before any interdepartment cost allocations Requirements $ 80,000 $ 260,000 $ 950,000 $ 465,000 Support work supplied by human resources department Budgeted number of employees 20 44 36 1. Allocate the support departments' costs to the operating departments using the direct method. Support work supplied by information systems department 2. Rank the support departments based on the percentage of their services provided to other support departments. Use this ranking to allocate the support departments' costs to the operating departments based on the step-down method. Budgeted processing time (in minutes) 400 2,500 2,100 3. How could you have ranked the support departments differently? Print Done
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Cost allocation
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS