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 Salesperson Sales of Goods Sold Expenses Asarenka $437,500 $196,875 $83,125 Crowell 570,000 228,000 91,200 Dempster 141,750 675,000 310,500 MacLean 587,500 246,750 123,375 Ortiz 525,000 215,250 126,000 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. Pachec Inc. Salespersons' Analysis For the Year Ended June 30 Contribution Margin Variable Cost of Goods Sold Variable Selling Expenses Contribution Margin Salesperson as a Percent of Sales as a Percent of Sales Ratio Asarenka Crowell % % Dempster % MacLean Ortiz % 0% % 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

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
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
Salesperson
Sales
of Goods Sold
Expenses
Asarenka
$437,500
$196,875
$83,125
Crowell
570,000
228,000
91,200
Dempster
141,750
675,000
310,500
MacLean
587,500
246,750
123,375
Ortiz
525,000
215,250
126,000
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.
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 Salesperson Sales of Goods Sold Expenses Asarenka $437,500 $196,875 $83,125 Crowell 570,000 228,000 91,200 Dempster 141,750 675,000 310,500 MacLean 587,500 246,750 123,375 Ortiz 525,000 215,250 126,000 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.
Pachec Inc.
Salespersons' Analysis
For the Year Ended June 30
Contribution Margin Variable Cost of Goods Sold Variable Selling Expenses Contribution Margin
Salesperson
as a Percent of Sales
as a Percent of Sales
Ratio
Asarenka
Crowell
%
%
Dempster
%
MacLean
Ortiz
%
0%
%
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
Transcribed Image Text:Pachec Inc. Salespersons' Analysis For the Year Ended June 30 Contribution Margin Variable Cost of Goods Sold Variable Selling Expenses Contribution Margin Salesperson as a Percent of Sales as a Percent of Sales Ratio Asarenka Crowell % % Dempster % MacLean Ortiz % 0% % 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
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
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