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
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
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2d5d8571-a566-48dd-93ba-2ac5e7bc1950%2F80000633-9378-4e87-a768-d8812f5026e7%2Fb6rojgk_processed.jpeg&w=3840&q=75)
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2d5d8571-a566-48dd-93ba-2ac5e7bc1950%2F80000633-9378-4e87-a768-d8812f5026e7%2Fqivh3gk_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education