Homework Help is Here – Start Your Trial Now!
Business
Accounting
P14.2 (LO 1, 2), AP Excel Sunshine Juice Company produces and distributes concentrated orange juice. It has been operating in two key customer segments for years, selling to institutional customers and retail customers. The production departments are supported by the following three services: Administrative, Information Systems, and Maintenance. To date, the accounting team has simply allocated the support costs evenly between the two operating segments in order to determine total costs. Realizing that there are more accurate ways of assigning these costs, the new controller has asked you to prepare support department cost allocations using three other (and arguably more accurate) methods. Financial information is as follows. Original costs Proportion of Administrative hours used Determine and evaluate support department cost allocations under th direct, step, and reciprocal methods. Operating Segments Institutional Administrative Support Departments Information Systems Maintenance Retail $75,000 - $110,000 0.10 $60,000 $650,000 $350,000 0.10 0.45 0.35 0.10 0.40 0.30 0.10 - 0.30 0.50 Proportion of Information Systems hours used Proportion of Maintenance hours used 0.20 0.10 Required a. Determine the total costs that each operating segment would be accountable for if support costs are allo- cated using the direct method. b. Determine the total costs that each operating segment would be accountable for if the step method is used to allocate support costs; assume support departments are ranked according to their original cost. c. Use Excel to determine the total costs that each operating segment would be accountable for if support costs are allocated using the reciprocal method. d. Evaluate the accuracy of each method while considering the time involved to perform the allocation. Spec- ify which method you think the controller should use going forward and explain why.

P14.2 (LO 1, 2), AP Excel Sunshine Juice Company produces and distributes concentrated orange juice. It has been operating in two key customer segments for years, selling to institutional customers and retail customers. The production departments are supported by the following three services: Administrative, Information Systems, and Maintenance. To date, the accounting team has simply allocated the support costs evenly between the two operating segments in order to determine total costs. Realizing that there are more accurate ways of assigning these costs, the new controller has asked you to prepare support department cost allocations using three other (and arguably more accurate) methods. Financial information is as follows. Original costs Proportion of Administrative hours used Determine and evaluate support department cost allocations under th direct, step, and reciprocal methods. Operating Segments Institutional Administrative Support Departments Information Systems Maintenance Retail $75,000 - $110,000 0.10 $60,000 $650,000 $350,000 0.10 0.45 0.35 0.10 0.40 0.30 0.10 - 0.30 0.50 Proportion of Information Systems hours used Proportion of Maintenance hours used 0.20 0.10 Required a. Determine the total costs that each operating segment would be accountable for if support costs are allo- cated using the direct method. b. Determine the total costs that each operating segment would be accountable for if the step method is used to allocate support costs; assume support departments are ranked according to their original cost. c. Use Excel to determine the total costs that each operating segment would be accountable for if support costs are allocated using the reciprocal method. d. Evaluate the accuracy of each method while considering the time involved to perform the allocation. Spec- ify which method you think the controller should use going forward and explain why.

Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
8th Edition
ISBN:9781305961883
Author:Carl Warren
Publisher:Carl Warren
Chapter14: Decentralized Operations
Section: Chapter Questions
Problem 14.16E
See similar textbooks
icon
Related questions
Question
P14.2 (LO 1, 2), AP Excel Sunshine Juice Company produces and distributes concentrated orange juice. It has been operating in two key customer segments for years, selling to institutional customers and retail customers. The production departments are supported by the following three services: Administrative, Information Systems, and Maintenance. To date, the accounting team has simply allocated the support costs evenly between the two operating segments in order to determine total costs. Realizing that there are more accurate ways of assigning these costs, the new controller has asked you to prepare support department cost allocations using three other (and arguably more accurate) methods. Financial information is as follows. Original costs Proportion of Administrative hours used Determine and evaluate support department cost allocations under th direct, step, and reciprocal methods. Operating Segments Institutional Administrative Support Departments Information Systems Maintenance Retail $75,000 - $110,000 0.10 $60,000 $650,000 $350,000 0.10 0.45 0.35 0.10 0.40 0.30 0.10 - 0.30 0.50 Proportion of Information Systems hours used Proportion of Maintenance hours used 0.20 0.10 Required a. Determine the total costs that each operating segment would be accountable for if support costs are allo- cated using the direct method. b. Determine the total costs that each operating segment would be accountable for if the step method is used to allocate support costs; assume support departments are ranked according to their original cost. c. Use Excel to determine the total costs that each operating segment would be accountable for if support costs are allocated using the reciprocal method. d. Evaluate the accuracy of each method while considering the time involved to perform the allocation. Spec- ify which method you think the controller should use going forward and explain why.
Transcribed Image Text:P14.2 (LO 1, 2), AP Excel Sunshine Juice Company produces and distributes concentrated orange juice. It has been operating in two key customer segments for years, selling to institutional customers and retail customers. The production departments are supported by the following three services: Administrative, Information Systems, and Maintenance. To date, the accounting team has simply allocated the support costs evenly between the two operating segments in order to determine total costs. Realizing that there are more accurate ways of assigning these costs, the new controller has asked you to prepare support department cost allocations using three other (and arguably more accurate) methods. Financial information is as follows. Original costs Proportion of Administrative hours used Determine and evaluate support department cost allocations under th direct, step, and reciprocal methods. Operating Segments Institutional Administrative Support Departments Information Systems Maintenance Retail $75,000 - $110,000 0.10 $60,000 $650,000 $350,000 0.10 0.45 0.35 0.10 0.40 0.30 0.10 - 0.30 0.50 Proportion of Information Systems hours used Proportion of Maintenance hours used 0.20 0.10 Required a. Determine the total costs that each operating segment would be accountable for if support costs are allo- cated using the direct method. b. Determine the total costs that each operating segment would be accountable for if the step method is used to allocate support costs; assume support departments are ranked according to their original cost. c. Use Excel to determine the total costs that each operating segment would be accountable for if support costs are allocated using the reciprocal method. d. Evaluate the accuracy of each method while considering the time involved to perform the allocation. Spec- ify which method you think the controller should use going forward and explain why.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
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