Walthman Industries 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 December 31 are as follows: Salesperson Total Sales Variable Cost of Goods Sold Variable Selling Expenses Case $429,000   $184,470     $90,090     Dix 417,000   212,670     58,380     Johnson 465,000   195,300     102,300     LaFave 585,000   204,750     87,750     Orcas 418,000   229,900     66,880     Sussman 407,000   215,710     85,470     Willbond 580,000   191,400     127,600

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

Walthman Industries 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 December 31 are as follows:

Salesperson Total Sales Variable Cost of Goods Sold Variable Selling Expenses
Case $429,000   $184,470     $90,090    
Dix 417,000   212,670     58,380    
Johnson 465,000   195,300     102,300    
LaFave 585,000   204,750     87,750    
Orcas 418,000   229,900     66,880    
Sussman 407,000   215,710     85,470    
Willbond 580,000   191,400     127,600    

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.

Waltham Industries Inc.
Salespersons' Analysis
For the Year Ended December 31
Contribution
Variable Cost of Goods Sold as a
Variable Selling Expenses as a
Contribution Margin
Salesperson
Margin
Percent of Sales
Percent of Sales
Ratio
Case
%
%
%
Dix
%
%
Johnson
%
%
%
LaFave
%
%
%
Orcas
%
%
%
Sussman
%
%
Willbond
%
%
%
Transcribed Image Text:Contribution Variable Cost of Goods Sold as a Variable Selling Expenses as a Contribution Margin Salesperson Margin Percent of Sales Percent of Sales Ratio Case % % % Dix % % Johnson % % % LaFave % % % Orcas % % % Sussman % % Willbond % % %
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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