Bramble 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 Proportion of Information Systems hours used Proportion of Maintenance hours used Administrative $77,000 0.20 0.10 Support Departments Information Systems $110,600 0.10 0.10 Maintenance $62,000 0.10 0.10 Operating Segments Institutional $648,000 $351,000 0.45 0.40 Retail 0.30 0.35 0.30 0.50

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

dont handwrite solution

Bramble 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
Proportion of Information Systems
hours used
Proportion of Maintenance hours
used
Administrative
$77,000
0.20
0.10
Support Departments
Information
Systems
$110,600
0.10
0.10
Maintenance
$62,000
0.10
0.10
Operating Segments
Institutional
$648,000 $351,000
0.45
0.40
Retail
0.30
0.35
0.30
0.50
Transcribed Image Text:Bramble 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 Proportion of Information Systems hours used Proportion of Maintenance hours used Administrative $77,000 0.20 0.10 Support Departments Information Systems $110,600 0.10 0.10 Maintenance $62,000 0.10 0.10 Operating Segments Institutional $648,000 $351,000 0.45 0.40 Retail 0.30 0.35 0.30 0.50
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.)
Total costs
$
Institutional
Operating Units
Retail
Transcribed Image Text: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.) Total costs $ Institutional Operating Units Retail
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Quality control
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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education