Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Tamarisk Juice Company produces and distributes concentrated orange juice. It has been operating in two key customer segments for years, selling to institutional customers and
Tamarisk 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. Support Departments Operating Segments Administrative Information Systems Maintenance Institutional Retail Original costs $75,000 $109,200 $59,000 $650,000 $347,000 Proportion of Administrative hours used 0.10 0.10 0.45 0.35 Proportion of Information Systems hours used 0.20 0.10 0.40 0.30 Proportion of Maintenance hours 0.10 0.10 0.30 0.50 used Use Excel to determine the total costs that each operating segment would be accountable for if support costs are allocated using the reciprocal method. (Round answers to 2 decimal places, e.g. 15.25.) Operating Units Institutional Retail Total costs $ $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started