Question

Salespersons' Report and Analysis Walthman Industries Inc. employs seven salespersons to sell and distribute its product...

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 $547,000 $213,330 $71,110
Dix 346,000 148,780 44,980
Johnson 615,000 221,400 86,100
LaFave 330,000 148,500 52,800
Orcas 420,000 163,800 54,600
Sussman 370,000 170,200 74,000
Willbond 481,000 278,980 72,150

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
Salesperson Contribution Margin Variable Cost of Goods
Sold as a Percent of Sales		 Variable Selling Expenses
as a Percent of Sales		 Contribution Margin
Ratio
Case $ % % %
Dix % % %
Johnson % % %
LaFave % % %
Orcas % % %
Sussman % % %
Willbond % % %
Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
Salesperson Total Sales Variable Cost of Goods Sold Variable Selling Expenses
Case $547,000 $213,330 $71,110
Dix 346,000 148,780 44,980
Johnson 615,000 221,400 86,100
LaFave 330,000 148,500 52,800
Orcas 420,000 163,800 54,600
Sussman 370,000 170,200 74,000
Willbond 481,000 278,980 72,150
Contribution margin = (sales - Variable cost of goods sold - Variable selling expenses)
Salesperson Contribution Margin Variable Cost of Goods Variable Selling Expenses Contribution Margin
Sold as a Percent of Sales as a Percent of Sales Ratio
Case $262,560 39.00% 13.00% 48.00%
Dix $152,240 43.00% 13.00% 44.00%
Johnson $307,500 36.00% 14.00% 50.00%
LaFave $128,700 45.00% 16.00% 39.00%
Orcas $201,600 39.00% 13.00% 48.00%
Sussman $125,800 46.00% 20.00% 34.00%
Willbond $129,870 58.00% 15.00% 27.00%
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Salespersons' Report and Analysis Walthman Industries Inc. employs seven salespersons to sell and distribute its product...
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 $560,000 $218,400 $84,000 Dix 497,000 288,260 99,400 Johnson 501,000 220,440 110,220 LaFave 332,000 109,560 59,760 Orcas 562,000 179,840 78,680 Sussman 448,000 219,520 58,240 Willbond 539,000 291,060 86,240 Required: 1. Prepare a table...
Salespersons' Report and Analysis Walthman Industries Inc. employs seven salespersons to sell and distribute its product...
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 $619,000 $346,640 $117,610 Dix 409,000 159,510 65,440 Johnson 517,000 258,500 108,570 LaFave 341,000 167,090 54,560 Orcas 555,000 277,500 116,550 Sussman 405,000 206,550 68,850 Willbond 492,000 241,080 83,640 Required: 1. Prepare a table...
Salespersons' Report and Analysis Walthman Industries Inc. employs seven salespersons to sell and distribute its product...
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 $604,000 $295,960 $114,760 Dix 375,000 131,250 56,250 Johnson 411,000 226,050 65,760 LaFave 450,000 189,000 58,500 Orcas 423,000 241,110 84,600 Sussman 424,000 165,360 93,280 Willbond 588,000 264,600 99,960 Required: 1. Prepare a table...
Sales Territory and Salesperson Profitability Analysis Havasu Off-Road Inc. manufactures and sells a variety of commercial...
Sales Territory and Salesperson Profitability Analysis Havasu Off-Road Inc. manufactures and sells a variety of commercial vehicles in the Northeast and Southwest regions. There are two salespersons assigned to each territory. Higher commission rates go to the most experienced salespersons. The following sales statistics are available for each salesperson: Northeast Southwest Rene Steve Colleen Paul Average per unit: Sales price $11,600 $15,500 $9,800 $18,800 Variable cost of goods sold $7,424 $8,990 $6,076 $10,528 Commission rate 7% 14% 11% 8% Units...
Excelsior Company has three salespersons. Average sales price per unit sold, average variable manufacturing costs per...
Excelsior Company has three salespersons. Average sales price per unit sold, average variable manufacturing costs per unit, and number of units sold for each salesperson are shown below. Commissions are earned according to the following schedule: Total Sales Percentage $0 to 49,999 6% $50,000 to $52,999 7% Over $53,000 8% Salesperson Mary Q. John A. Susan B. Avg. selling price per unit $50.00 $65.00 $45.00 Avg. var. mfg. costs per unit   25.00   30.00   35.00 Number of units sold   1,000     750...
Contribution Margin Analysis Mathews Company manufactures only one product. For the year ended December 31, the...
Contribution Margin Analysis Mathews Company manufactures only one product. For the year ended December 31, the contribution margin increased by $10,290 from the planned level of $514,710. The president of Mathews Company has expressed some concern about this increase and has requested a follow-up report. The following data have been gathered from the accounting records for the year ended December 31: Actual Planned Difference—Increase (Decrease) Sales $1,008,000 $993,510 $14,490 Variable costs: Variable cost of goods sold $378,000 $395,010 $(17,010) Variable...
Contribution Margin Analysis Mathews Company manufactures only one product. For the year ended December 31, the...
Contribution Margin Analysis Mathews Company manufactures only one product. For the year ended December 31, the contribution margin increased by $34,200 from the planned level of $745,800. The president of Mathews Company has expressed some concern about this increase and has requested a follow-up report. The following data have been gathered from the accounting records for the year ended December 31: Actual Planned Difference—Increase (Decrease) Sales $1,500,000 $1,457,700 $42,300 Variable costs: Variable cost of goods sold $570,000 $593,250 $(23,250) Variable...
Contribution Margin Analysis—Sales The following data for Romero Products Inc. are available: For the Year Ended...
Contribution Margin Analysis—Sales The following data for Romero Products Inc. are available: For the Year Ended December 31 Actual Planned Difference—Increase or (Decrease) Sales $1,904,000 $1,720,500 $183,500 Variable costs: Variable cost of goods sold $1,008,000 $914,500 $93,500 Variable selling and administrative expenses 192,000 186,000 6,000 Total variable costs $1,200,000 $1,100,500 $99,500 Contribution margin $704,000 $620,000 $84,000 Number of units sold 16,000 15,500 Per unit: Sales price $119 $111 Variable cost of goods sold 63 59 Variable selling and administrative expenses...
Product Profitability Analysis PowerTrain Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs),...
Product Profitability Analysis PowerTrain Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs), the Mountain Monster and Desert Dragon, from a single manufacturing facility. The manufacturing facility operates at 100% of capacity. The following per-unit information is available for the two products: Mountain Monster Desert Dragon Sales price $5,800 $3,400 Variable cost of goods sold 3,650 2,280 Manufacturing margin $2,150 $1,120 Variable selling expenses 990 508 Contribution margin $1,160 $612 Fixed expenses 550 240 Income from operations...
amby Inc. has sales of $2,000,000 for the first quarter of 2020. In making the sales,...
amby Inc. has sales of $2,000,000 for the first quarter of 2020. In making the sales, the company incurred the following costs and expenses. Variable Fixed Cost of goods sold $760,000 $600,000 Selling expenses 95,000 60,000 Administrative expenses 79,000 66,000 Prepare a CVP income statement for the quarter ended March 31, 2020. HAMBY INC. Income Statement For the Year Ended March 31, 2020For the Quarter Ended March 31, 2020March 31, 2020 Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesGross ProfitNet Income/(Loss)SalesSelling...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT