Hello! In the past we have used the direct method to allocate service department costs to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Hello! In the past we have used the direct method to allocate service department costs to our revenue producing departments; however, I just attended a conference where one of the presenters demonstrated how the step method can produce significantly different departmental cost calculations. I don't know how much it would matter at Basic if we used the step down method, but this person at the conference had me convinced that it could matter quite a bit. As soon as I got back from the conference I got into the system and downloaded the attached summary reports (tab delimited) needed to allocate costs from supporting departments to the producing departments for 2020. Please put together a report that shows the allocation using each method (direct and step) as well as a table that shows the differences (totals and as a percentage of support dept. cost) across the two allocation methods. For the step method, let's first allocate the departments that provide the most service to other support departments. Also, let's use the 12 month average of FTES and square footage for assignment where applicable. Otherwise, use the annual totals. Finally, please show me the differences for each department manager, as I'd like to know who will be affected the most if we switch to the step method. Thank you cost accountant! The Controller Upload the following files to complete this assignment: (1) A Microsoft Excel workbook named "allocation. The workbook should have 3 worksheets labeled "Direct," "Step," and "Differences. The worksheets will contain the schedules used to allocate the cost from the support departments to the producing departments in the first two worksheets. In the third worksheet, summarize the differences between the two methods by department and manager. In addition, the workbook will also have one or more additional worksheets that are used to hold the source data (i.e., the information in the files attached to this assignment) and perform interim calculations. Name worksheets that hold source data "sourcedata1," "sourcedata2" and "sourcedata3" Worksheets that contain interim calculations should be named "calc1" "calc2" and so on. The worksheets should be organized in the following order: Direct, Step, Differences, calc worksheets, sourcedata worksheets. (2) A PDF report that incorporates all 3 tables from the "Direct." "Step.," and "Differences" worksheets (in this order). After each allocation schedule, provide a written description of the schedule that explains the allocation technique and how it is applied at Basic Hospital to arrive at cost by department. After the "Differences" table, explain why the differences occur, using the department with the biggest difference as an example. Support Dept. Allocation base Medical Records Total Nursing Hours Accounting Total Direct Cost General Services Human Resources Total Patient Accounts Square Footage FTES Total Patient Revenue Department Medical Records 06-1000 Cohen 06-1001 Dillon Accounting General Services Human Resources 06-1003 Patient Accounts Urology 02-1005 Kline Orthopaedics Opthamology Dpt Current Dept. Manager Gastroenterology Cardiology Burn Center Emergency Oncology Obstetrics Neurology Maternity Intensive Care Unit General Surgery 02-1013 06-1002 Blasco Smith 06-1004 Cohen 02-1006 Dreyfus 02-1007 Kramer 02-1008 James 02-1009 Plammot 02-1010 Barnes 02-1011 Plammot 02-1012 Wellston Piedmont 02-1014 Rax Jills. 02-1015 02-1016 Cordona 02-1017 Jackson Hello! In the past we have used the direct method to allocate service department costs to our revenue producing departments; however, I just attended a conference where one of the presenters demonstrated how the step method can produce significantly different departmental cost calculations. I don't know how much it would matter at Basic if we used the step down method, but this person at the conference had me convinced that it could matter quite a bit. As soon as I got back from the conference I got into the system and downloaded the attached summary reports (tab delimited) needed to allocate costs from supporting departments to the producing departments for 2020. Please put together a report that shows the allocation using each method (direct and step) as well as a table that shows the differences (totals and as a percentage of support dept. cost) across the two allocation methods. For the step method, let's first allocate the departments that provide the most service to other support departments. Also, let's use the 12 month average of FTES and square footage for assignment where applicable. Otherwise, use the annual totals. Finally, please show me the differences for each department manager, as I'd like to know who will be affected the most if we switch to the step method. Thank you cost accountant! The Controller Upload the following files to complete this assignment: (1) A Microsoft Excel workbook named "allocation. The workbook should have 3 worksheets labeled "Direct," "Step," and "Differences. The worksheets will contain the schedules used to allocate the cost from the support departments to the producing departments in the first two worksheets. In the third worksheet, summarize the differences between the two methods by department and manager. In addition, the workbook will also have one or more additional worksheets that are used to hold the source data (i.e., the information in the files attached to this assignment) and perform interim calculations. Name worksheets that hold source data "sourcedata1," "sourcedata2" and "sourcedata3" Worksheets that contain interim calculations should be named "calc1" "calc2" and so on. The worksheets should be organized in the following order: Direct, Step, Differences, calc worksheets, sourcedata worksheets. (2) A PDF report that incorporates all 3 tables from the "Direct." "Step.," and "Differences" worksheets (in this order). After each allocation schedule, provide a written description of the schedule that explains the allocation technique and how it is applied at Basic Hospital to arrive at cost by department. After the "Differences" table, explain why the differences occur, using the department with the biggest difference as an example. Support Dept. Allocation base Medical Records Total Nursing Hours Accounting Total Direct Cost General Services Human Resources Total Patient Accounts Square Footage FTES Total Patient Revenue Department Medical Records 06-1000 Cohen 06-1001 Dillon Accounting General Services Human Resources 06-1003 Patient Accounts Urology 02-1005 Kline Orthopaedics Opthamology Dpt Current Dept. Manager Gastroenterology Cardiology Burn Center Emergency Oncology Obstetrics Neurology Maternity Intensive Care Unit General Surgery 02-1013 06-1002 Blasco Smith 06-1004 Cohen 02-1006 Dreyfus 02-1007 Kramer 02-1008 James 02-1009 Plammot 02-1010 Barnes 02-1011 Plammot 02-1012 Wellston Piedmont 02-1014 Rax Jills. 02-1015 02-1016 Cordona 02-1017 Jackson Hello! In the past we have used the direct method to allocate service department costs to our revenue producing departments; however, I just attended a conference where one of the presenters demonstrated how the step method can produce significantly different departmental cost calculations. I don't know how much it would matter at Basic if we used the step down method, but this person at the conference had me convinced that it could matter quite a bit. As soon as I got back from the conference I got into the system and downloaded the attached summary reports (tab delimited) needed to allocate costs from supporting departments to the producing departments for 2020. Please put together a report that shows the allocation using each method (direct and step) as well as a table that shows the differences (totals and as a percentage of support dept. cost) across the two allocation methods. For the step method, let's first allocate the departments that provide the most service to other support departments. Also, let's use the 12 month average of FTES and square footage for assignment where applicable. Otherwise, use the annual totals. Finally, please show me the differences for each department manager, as I'd like to know who will be affected the most if we switch to the step method. Thank you cost accountant! The Controller Upload the following files to complete this assignment: (1) A Microsoft Excel workbook named "allocation. The workbook should have 3 worksheets labeled "Direct," "Step," and "Differences. The worksheets will contain the schedules used to allocate the cost from the support departments to the producing departments in the first two worksheets. In the third worksheet, summarize the differences between the two methods by department and manager. In addition, the workbook will also have one or more additional worksheets that are used to hold the source data (i.e., the information in the files attached to this assignment) and perform interim calculations. Name worksheets that hold source data "sourcedata1," "sourcedata2" and "sourcedata3" Worksheets that contain interim calculations should be named "calc1" "calc2" and so on. The worksheets should be organized in the following order: Direct, Step, Differences, calc worksheets, sourcedata worksheets. (2) A PDF report that incorporates all 3 tables from the "Direct." "Step.," and "Differences" worksheets (in this order). After each allocation schedule, provide a written description of the schedule that explains the allocation technique and how it is applied at Basic Hospital to arrive at cost by department. After the "Differences" table, explain why the differences occur, using the department with the biggest difference as an example. Support Dept. Allocation base Medical Records Total Nursing Hours Accounting Total Direct Cost General Services Human Resources Total Patient Accounts Square Footage FTES Total Patient Revenue Department Medical Records 06-1000 Cohen 06-1001 Dillon Accounting General Services Human Resources 06-1003 Patient Accounts Urology 02-1005 Kline Orthopaedics Opthamology Dpt Current Dept. Manager Gastroenterology Cardiology Burn Center Emergency Oncology Obstetrics Neurology Maternity Intensive Care Unit General Surgery 02-1013 06-1002 Blasco Smith 06-1004 Cohen 02-1006 Dreyfus 02-1007 Kramer 02-1008 James 02-1009 Plammot 02-1010 Barnes 02-1011 Plammot 02-1012 Wellston Piedmont 02-1014 Rax Jills. 02-1015 02-1016 Cordona 02-1017 Jackson Hello! In the past we have used the direct method to allocate service department costs to our revenue producing departments; however, I just attended a conference where one of the presenters demonstrated how the step method can produce significantly different departmental cost calculations. I don't know how much it would matter at Basic if we used the step down method, but this person at the conference had me convinced that it could matter quite a bit. As soon as I got back from the conference I got into the system and downloaded the attached summary reports (tab delimited) needed to allocate costs from supporting departments to the producing departments for 2020. Please put together a report that shows the allocation using each method (direct and step) as well as a table that shows the differences (totals and as a percentage of support dept. cost) across the two allocation methods. For the step method, let's first allocate the departments that provide the most service to other support departments. Also, let's use the 12 month average of FTES and square footage for assignment where applicable. Otherwise, use the annual totals. Finally, please show me the differences for each department manager, as I'd like to know who will be affected the most if we switch to the step method. Thank you cost accountant! The Controller Upload the following files to complete this assignment: (1) A Microsoft Excel workbook named "allocation. The workbook should have 3 worksheets labeled "Direct," "Step," and "Differences. The worksheets will contain the schedules used to allocate the cost from the support departments to the producing departments in the first two worksheets. In the third worksheet, summarize the differences between the two methods by department and manager. In addition, the workbook will also have one or more additional worksheets that are used to hold the source data (i.e., the information in the files attached to this assignment) and perform interim calculations. Name worksheets that hold source data "sourcedata1," "sourcedata2" and "sourcedata3" Worksheets that contain interim calculations should be named "calc1" "calc2" and so on. The worksheets should be organized in the following order: Direct, Step, Differences, calc worksheets, sourcedata worksheets. (2) A PDF report that incorporates all 3 tables from the "Direct." "Step.," and "Differences" worksheets (in this order). After each allocation schedule, provide a written description of the schedule that explains the allocation technique and how it is applied at Basic Hospital to arrive at cost by department. After the "Differences" table, explain why the differences occur, using the department with the biggest difference as an example. Support Dept. Allocation base Medical Records Total Nursing Hours Accounting Total Direct Cost General Services Human Resources Total Patient Accounts Square Footage FTES Total Patient Revenue Department Medical Records 06-1000 Cohen 06-1001 Dillon Accounting General Services Human Resources 06-1003 Patient Accounts Urology 02-1005 Kline Orthopaedics Opthamology Dpt Current Dept. Manager Gastroenterology Cardiology Burn Center Emergency Oncology Obstetrics Neurology Maternity Intensive Care Unit General Surgery 02-1013 06-1002 Blasco Smith 06-1004 Cohen 02-1006 Dreyfus 02-1007 Kramer 02-1008 James 02-1009 Plammot 02-1010 Barnes 02-1011 Plammot 02-1012 Wellston Piedmont 02-1014 Rax Jills. 02-1015 02-1016 Cordona 02-1017 Jackson Hello! In the past we have used the direct method to allocate service department costs to our revenue producing departments; however, I just attended a conference where one of the presenters demonstrated how the step method can produce significantly different departmental cost calculations. I don't know how much it would matter at Basic if we used the step down method, but this person at the conference had me convinced that it could matter quite a bit. As soon as I got back from the conference I got into the system and downloaded the attached summary reports (tab delimited) needed to allocate costs from supporting departments to the producing departments for 2020. Please put together a report that shows the allocation using each method (direct and step) as well as a table that shows the differences (totals and as a percentage of support dept. cost) across the two allocation methods. For the step method, let's first allocate the departments that provide the most service to other support departments. Also, let's use the 12 month average of FTES and square footage for assignment where applicable. Otherwise, use the annual totals. Finally, please show me the differences for each department manager, as I'd like to know who will be affected the most if we switch to the step method. Thank you cost accountant! The Controller Upload the following files to complete this assignment: (1) A Microsoft Excel workbook named "allocation. The workbook should have 3 worksheets labeled "Direct," "Step," and "Differences. The worksheets will contain the schedules used to allocate the cost from the support departments to the producing departments in the first two worksheets. In the third worksheet, summarize the differences between the two methods by department and manager. In addition, the workbook will also have one or more additional worksheets that are used to hold the source data (i.e., the information in the files attached to this assignment) and perform interim calculations. Name worksheets that hold source data "sourcedata1," "sourcedata2" and "sourcedata3" Worksheets that contain interim calculations should be named "calc1" "calc2" and so on. The worksheets should be organized in the following order: Direct, Step, Differences, calc worksheets, sourcedata worksheets. (2) A PDF report that incorporates all 3 tables from the "Direct." "Step.," and "Differences" worksheets (in this order). After each allocation schedule, provide a written description of the schedule that explains the allocation technique and how it is applied at Basic Hospital to arrive at cost by department. After the "Differences" table, explain why the differences occur, using the department with the biggest difference as an example. Support Dept. Allocation base Medical Records Total Nursing Hours Accounting Total Direct Cost General Services Human Resources Total Patient Accounts Square Footage FTES Total Patient Revenue Department Medical Records 06-1000 Cohen 06-1001 Dillon Accounting General Services Human Resources 06-1003 Patient Accounts Urology 02-1005 Kline Orthopaedics Opthamology Dpt Current Dept. Manager Gastroenterology Cardiology Burn Center Emergency Oncology Obstetrics Neurology Maternity Intensive Care Unit General Surgery 02-1013 06-1002 Blasco Smith 06-1004 Cohen 02-1006 Dreyfus 02-1007 Kramer 02-1008 James 02-1009 Plammot 02-1010 Barnes 02-1011 Plammot 02-1012 Wellston Piedmont 02-1014 Rax Jills. 02-1015 02-1016 Cordona 02-1017 Jackson Hello! In the past we have used the direct method to allocate service department costs to our revenue producing departments; however, I just attended a conference where one of the presenters demonstrated how the step method can produce significantly different departmental cost calculations. I don't know how much it would matter at Basic if we used the step down method, but this person at the conference had me convinced that it could matter quite a bit. As soon as I got back from the conference I got into the system and downloaded the attached summary reports (tab delimited) needed to allocate costs from supporting departments to the producing departments for 2020. Please put together a report that shows the allocation using each method (direct and step) as well as a table that shows the differences (totals and as a percentage of support dept. cost) across the two allocation methods. For the step method, let's first allocate the departments that provide the most service to other support departments. Also, let's use the 12 month average of FTES and square footage for assignment where applicable. Otherwise, use the annual totals. Finally, please show me the differences for each department manager, as I'd like to know who will be affected the most if we switch to the step method. Thank you cost accountant! The Controller Upload the following files to complete this assignment: (1) A Microsoft Excel workbook named "allocation. The workbook should have 3 worksheets labeled "Direct," "Step," and "Differences. The worksheets will contain the schedules used to allocate the cost from the support departments to the producing departments in the first two worksheets. In the third worksheet, summarize the differences between the two methods by department and manager. In addition, the workbook will also have one or more additional worksheets that are used to hold the source data (i.e., the information in the files attached to this assignment) and perform interim calculations. Name worksheets that hold source data "sourcedata1," "sourcedata2" and "sourcedata3" Worksheets that contain interim calculations should be named "calc1" "calc2" and so on. The worksheets should be organized in the following order: Direct, Step, Differences, calc worksheets, sourcedata worksheets. (2) A PDF report that incorporates all 3 tables from the "Direct." "Step.," and "Differences" worksheets (in this order). After each allocation schedule, provide a written description of the schedule that explains the allocation technique and how it is applied at Basic Hospital to arrive at cost by department. After the "Differences" table, explain why the differences occur, using the department with the biggest difference as an example. Support Dept. Allocation base Medical Records Total Nursing Hours Accounting Total Direct Cost General Services Human Resources Total Patient Accounts Square Footage FTES Total Patient Revenue Department Medical Records 06-1000 Cohen 06-1001 Dillon Accounting General Services Human Resources 06-1003 Patient Accounts Urology 02-1005 Kline Orthopaedics Opthamology Dpt Current Dept. Manager Gastroenterology Cardiology Burn Center Emergency Oncology Obstetrics Neurology Maternity Intensive Care Unit General Surgery 02-1013 06-1002 Blasco Smith 06-1004 Cohen 02-1006 Dreyfus 02-1007 Kramer 02-1008 James 02-1009 Plammot 02-1010 Barnes 02-1011 Plammot 02-1012 Wellston Piedmont 02-1014 Rax Jills. 02-1015 02-1016 Cordona 02-1017 Jackson
Expert Answer:
Answer rating: 100% (QA)
Here are the steps involved in allocating service department costs using the direct and step methods Direct Method 1 Calculate the total cost of each ... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0078111006
14th edition
Authors: Ray Garrison, Eric Noreen and Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Aardvark Delivery Service (ADS)' was formed 30 years ago with a mandate to establish a private delivery system in the country of Aardvark. By 20X5, ADS was handling close to 30 million pieces of mail...
-
I cant understand whats happening here, said Mike Holt, president of Severson Products, Inc. We always seem to bid too high on jobs that require a lot of labor time in the Finishing Department, and...
-
What are the costs of healthcare, where does the money come from, and where is it spent?
-
What were the business challenges or opportunities that Isle was facing?
-
Describe the major characteristics that impact inventory decisions. One of the first steps in analyzing an inventory problem should be to describe the essential characteristics of the environment and...
-
How is the concept of encapsulation applied to database management?
-
On January 1, 2014, the Vasquez Company ledger shows Equipment $32,000 and Accumulated Depreciation-Equipment $9,000. The depreciation resulted from using the straight-line method with a useful life...
-
Please solve this question with clear steps.And.Check the answers or make sure that they are right. Image transcription text 4 QUESTION 4 (40 Points) Using the finite element method, determine the...
-
During Year 1, Anthony Company purchased debt securities and holds the securities as available-for-sale. Pertinent data are as follows: Security Cost $20,000 TE 40,000 90,000 $150,000 A B Fair value...
-
Shania bought a $1,455 drum set on the installment plan. The agreement included a 15% down payment and 18 monthly payments of $80.78 each. What was the down payment? A. $218.25 B. $80.78 C. $15.00 D....
-
List any five inception artifacts.
-
Describe the characteristics of real-time software?
-
Which of the following diagrams describe dynamic behavior of the software system? (a) Class diagram and object diagram (b) Use-case diagram and class diagram (c) Collaboration diagram and deployment...
-
What is Inception?
-
If you wanted to organize elements into groups, which of the following you would use? (a) Package (b) Class (c) Class and interface (d) Component
-
You are a manager at an upscale Conference Hotel. You have an Annual Meeting booked for 100 people for a very prestigious company. Due to some error at the back end you and your team mess it up and...
-
When is the indirect pattern appropriate, and what are the benefits of using it?
-
Solex Company produces a high-quality insulation material that passes through two production processes. Data for June for the first process follow: Required: 1. Assume that the company uses the...
-
Krollon Company uses the FIFO method in its process costing system. The following data are for the most recent month of operations in one of the companys processing departments: According to the...
-
Chris Shannon is employed by Acme Company and is paid $18 per hour. Last week she worked 36 hours assembling one of the companys products and was idle 4 hours due to material shortages. Acmes...
-
In the second quarter of 2021, personal consumption expenditures, exports, and imports increased. Investment and government expenditure decreased. Real GDP increased by 6.5 percent following a 6.3...
-
When real GDP increased in the second quarter of 2021, consumption expenditure, exports, and imports increased. Fixed investment decreased, which included a decrease in business inventory investment....
-
Are U.S. exports part of U.S. induced expenditure or autonomous expenditure? Are U.S. imports part of U.S. induced expenditure or autonomous expenditure? U.S. imports are recovering thanks to the $2...
Study smarter with the SolutionInn App