Salespersons' Report and Analysis Pachec Inc. employs seven salespersons to sell and distribute its product throughout the state. Data taken from reports received from the salespersons during the year ended June 30 are as follows: Variable Total Variable Cost Selling of Goods Sold Salesperson Sales Expenses Asarenka $437,500 $196,875 $83,125 Crowell 91,200 570,000 228,000 Dempster 675,000 310,500 141,750 587,500 123,375 MacLean 246,750 Ortiz 525,000 126,000 215,250 Sullivan 587,500 246,750 99,875 Williams 575,000 253,000 115,000 Required: 1. Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales, and contribution margin ratio by salesperson. Round percents to the nearest whole number. Enter all amounts as positive numbers. Do Pachec Inc Salespersons' Analysis For the Year Ended June 30 Variable Cost of Goods Sold Variable Selling Expenses Contribution Margin as a Percent of Sales Contribution Margin Salesperson as a Percent of Sales Ratio % Asarenka % Crowell % % % Dempster MacLean % % Ortiz Sullivan % Williams 2. Which salesperson generated the highest contribution margin ratio for the year? 3. Identify the factors other than contribution margin that should be considered in evaluating the performance of salespersons. 1. Rate of growth in sales for the current year compared with past years 2. Years of experience for salespersons 3. Size of sales territory 4. Actual sales compared with budgeted sales 5. All of the above 2/6 96

Financial And Managerial Accounting
15th Edition
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:WARREN, Carl S.
Chapter21: Variable Costing For Management analysis
Section: Chapter Questions
Problem 4PB: Salespersons report and analysis Pachec Inc. employs seven salespersons to sell and distribute its...
icon
Related questions
Question
Salespersons' Report and Analysis
Pachec Inc. employs seven salespersons to sell and distribute its product throughout the state. Data taken from reports received from the
salespersons during the year ended June 30 are as follows:
Variable
Total
Variable Cost
Selling
of Goods Sold
Salesperson
Sales
Expenses
Asarenka
$437,500
$196,875
$83,125
Crowell
91,200
570,000
228,000
Dempster
675,000
310,500
141,750
587,500
123,375
MacLean
246,750
Ortiz
525,000
126,000
215,250
Sullivan
587,500
246,750
99,875
Williams
575,000
253,000
115,000
Required:
1. Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales,
and contribution margin ratio by salesperson. Round percents to the nearest whole number. Enter all amounts as positive numbers.
Do
Transcribed Image Text:Salespersons' Report and Analysis Pachec Inc. employs seven salespersons to sell and distribute its product throughout the state. Data taken from reports received from the salespersons during the year ended June 30 are as follows: Variable Total Variable Cost Selling of Goods Sold Salesperson Sales Expenses Asarenka $437,500 $196,875 $83,125 Crowell 91,200 570,000 228,000 Dempster 675,000 310,500 141,750 587,500 123,375 MacLean 246,750 Ortiz 525,000 126,000 215,250 Sullivan 587,500 246,750 99,875 Williams 575,000 253,000 115,000 Required: 1. Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales, and contribution margin ratio by salesperson. Round percents to the nearest whole number. Enter all amounts as positive numbers. Do
Pachec Inc
Salespersons' Analysis
For the Year Ended June 30
Variable Cost of Goods Sold Variable Selling Expenses Contribution Margin
as a Percent of Sales
Contribution Margin
Salesperson
as a Percent of Sales
Ratio
%
Asarenka
%
Crowell
%
%
%
Dempster
MacLean
%
%
Ortiz
Sullivan
%
Williams
2. Which salesperson generated the highest contribution margin ratio for the year?
3. Identify the factors other than contribution margin that should be considered in evaluating the performance of salespersons.
1. Rate of growth in sales for the current year compared with past years
2. Years of experience for salespersons
3. Size of sales territory
4. Actual sales compared with budgeted sales
5. All of the above
2/6
96
Transcribed Image Text:Pachec Inc Salespersons' Analysis For the Year Ended June 30 Variable Cost of Goods Sold Variable Selling Expenses Contribution Margin as a Percent of Sales Contribution Margin Salesperson as a Percent of Sales Ratio % Asarenka % Crowell % % % Dempster MacLean % % Ortiz Sullivan % Williams 2. Which salesperson generated the highest contribution margin ratio for the year? 3. Identify the factors other than contribution margin that should be considered in evaluating the performance of salespersons. 1. Rate of growth in sales for the current year compared with past years 2. Years of experience for salespersons 3. Size of sales territory 4. Actual sales compared with budgeted sales 5. All of the above 2/6 96
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
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
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage