Vaughn is a manufacturer that specializes in three types of toy instruments: xylophones, electronic keyboards, and drum sets. Grandparents across the globe flock to stores so they can buy their kids' kids these especially noisy toys. Company managers are equally excited about their products and await the profit report for this year's performance. The following partial income statement was released to all managers last week. Sales Cost of goods sold Gross margin Operating expenses Operating income Xylophone $505,000 217,000 288,000 Keyboard $896,000 444,000 452,000 Drums Total $602,000 $2,003,000 339,000 263,000 1,000,000 1,003,000 808,170 $194.830

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
100%
Current Attempt in Progress
Vaughn is a manufacturer that specializes in three types of toy instruments: xylophones, electronic keyboards, and drum sets.
Grandparents across the globe flock to stores so they can buy their kids' kids these especially noisy toys. Company managers are
equally excited about their products and await the profit report for this year's performance. The following partial income statement
was released to all managers last week.
Sales
Cost of goods sold
Gross margin
Operating expenses
Operating income
(a)
Use Excel to complete the following.
Xylophone
$505,000
Operating
income
217,000
Your answer is correct.
Profit
margin
percentage
288,000
3
Keyboard
$896,000
444,000
Xylophone
452,000
112527
Drums
12
$602,000
339,000
263,000
The company has not previously allocated its operating expenses to the three product lines but wants to do so now. Managers
believe operating expenses are incurred in a proportion similar to COGS for each product line. Allocate the operating expenses
using each product line's proportion of its own COGS to total COGS, then determine operating income and profit margin
percentage by product line. (Round proportion of total cost of goods sold and profit margin percentage to 2 decimal places, e.g. 15.25%.
Round final answers to O decimal places, e.g. 5,125. Enter loss using either a negative sign preceding the number e.g.-5.145 or -45% or
parentheses e.g. (5.145) or (45)%.)
Total
5
$2,003,000
1,000,000
1,003,000
808,170
$194,830
Keyboard
$4
3
Drums
Transcribed Image Text:Current Attempt in Progress Vaughn is a manufacturer that specializes in three types of toy instruments: xylophones, electronic keyboards, and drum sets. Grandparents across the globe flock to stores so they can buy their kids' kids these especially noisy toys. Company managers are equally excited about their products and await the profit report for this year's performance. The following partial income statement was released to all managers last week. Sales Cost of goods sold Gross margin Operating expenses Operating income (a) Use Excel to complete the following. Xylophone $505,000 Operating income 217,000 Your answer is correct. Profit margin percentage 288,000 3 Keyboard $896,000 444,000 Xylophone 452,000 112527 Drums 12 $602,000 339,000 263,000 The company has not previously allocated its operating expenses to the three product lines but wants to do so now. Managers believe operating expenses are incurred in a proportion similar to COGS for each product line. Allocate the operating expenses using each product line's proportion of its own COGS to total COGS, then determine operating income and profit margin percentage by product line. (Round proportion of total cost of goods sold and profit margin percentage to 2 decimal places, e.g. 15.25%. Round final answers to O decimal places, e.g. 5,125. Enter loss using either a negative sign preceding the number e.g.-5.145 or -45% or parentheses e.g. (5.145) or (45)%.) Total 5 $2,003,000 1,000,000 1,003,000 808,170 $194,830 Keyboard $4 3 Drums
Your answer is partially correct.
After reviewing the profit report, one product line manager was concerned by how the operating expenses were allocated. He felt
that a disproportionate amount was being directed at his product line and requested that the accounting team review these
expenses. After doing so, the accounting team observed that while some operating activity usage follows the COGS trend, not all
operating activity usage does. The accountants incorporated this new information and prepared the following for product line
managers.
Operating Expense Activities
Design
Engineering
Selling
General
Administrative
Total operating Expenses
New profit margin
percentage
Cost
Drums and Keyboard
$63,000
255,000
180,270
236,400
73,500
5808,170
Xylophone
Xylophone
200
800
7,900
7
Quantity of Cost Driver
Keyboard
1,100
800 Design hours
2,400 1,900 Engineering hours
16
6.900 4,900 Direct labor hours
Drums
12
Based on this updated information, prepare new allocations and profit analysis by product line. Which product line manager(s)
will likely prefer this new ABC version of profitability? (Round answers to 2 decimal places, eg. 15.25%.)
Keyboard
% of dollar sales
Number of employees
36
managers will ikely prefer new ABC version of profitability.
Drums
55
Transcribed Image Text:Your answer is partially correct. After reviewing the profit report, one product line manager was concerned by how the operating expenses were allocated. He felt that a disproportionate amount was being directed at his product line and requested that the accounting team review these expenses. After doing so, the accounting team observed that while some operating activity usage follows the COGS trend, not all operating activity usage does. The accountants incorporated this new information and prepared the following for product line managers. Operating Expense Activities Design Engineering Selling General Administrative Total operating Expenses New profit margin percentage Cost Drums and Keyboard $63,000 255,000 180,270 236,400 73,500 5808,170 Xylophone Xylophone 200 800 7,900 7 Quantity of Cost Driver Keyboard 1,100 800 Design hours 2,400 1,900 Engineering hours 16 6.900 4,900 Direct labor hours Drums 12 Based on this updated information, prepare new allocations and profit analysis by product line. Which product line manager(s) will likely prefer this new ABC version of profitability? (Round answers to 2 decimal places, eg. 15.25%.) Keyboard % of dollar sales Number of employees 36 managers will ikely prefer new ABC version of profitability. Drums 55
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Pricing Decisions
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
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