Question

In: Accounting

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 $395,000 $201,450 $79,000
Dix 499,000 174,650 84,830
Johnson 435,000 226,200 87,000
LaFave 400,000 216,000 80,000
Orcas 398,000 191,040 71,640
Sussman 510,000 255,000 102,000
Willbond 557,000 272,930 111,400

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

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

Solutions

Expert Solution


Related Solutions

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 $495,000 $242,550 $79,200 Dix 473,000 170,280 75,680 Johnson 554,000 310,240 116,340 LaFave 623,000 249,200 99,680 Orcas 615,000 344,400 116,850 Sussman 424,000 220,480 55,120 Willbond 441,000 233,730 70,560 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 $343,000 $174,930 $44,590 Dix 558,000 212,040 89,280 Johnson 500,000 250,000 80,000 LaFave 463,000 217,610 74,080 Orcas 499,000 209,580 94,810 Sussman 338,000 121,680 74,360 Willbond 452,000 144,640 85,880 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 $615,000 $313,650 $86,100 Dix 503,000 246,470 75,450 Johnson 585,000 274,950 111,150 LaFave 475,000 247,000 95,000 Orcas 409,000 171,780 61,350 Sussman 507,000 207,870 65,910 Willbond 397,000 146,890 87,340 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 $438,000 $232,140 $96,360 Dix 626,000 363,080 100,160 Johnson 451,000 180,400 99,220 LaFave 485,000 184,300 101,850 Orcas 408,000 171,360 69,360 Sussman 627,000 351,120 100,320 Willbond 426,000 217,260 80,940 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 $472,000 $169,920 $80,240 Dix 322,000 138,460 41,860 Johnson 512,000 215,040 71,680 LaFave 456,000 200,640 91,200 Orcas 480,000 254,400 100,800 Sussman 586,000 334,020 82,040 Willbond 320,000 112,000 70,400 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 $342,000 $181,260 $58,140 Dix 571,000 211,270 125,620 Johnson 360,000 136,800 75,600 LaFave 435,000 143,550 65,250 Orcas 557,000 256,220 105,830 Sussman 452,000 153,680 85,880 Willbond 469,000 272,020 93,800 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 $412,000 $201,880 $65,920 Dix 488,000 239,120 63,440 Johnson 578,000 271,660 80,920 LaFave 402,000 136,680 60,300 Orcas 602,000 228,760 78,260 Sussman 618,000 197,760 111,240 Willbond 406,000 190,820 89,320 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 $620,000 $266,600 $136,400 Dix 360,000 158,400 79,200 Johnson 585,000 193,050 99,450 LaFave 505,000 257,550 90,900 Orcas 423,000 152,280 63,450 Sussman 594,000 285,120 112,860 Willbond 480,000 182,400 72,000 Required: 1. Prepare a table...
Walthman Industries Inc. employs seven salespersons to sell and distribute its product throughout the state. Data...
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 $366,000 $161,040 $54,900 Dix 528,000 300,960 68,640 Johnson 581,000 313,740 92,960 LaFave 448,000 255,360 58,240 Orcas 389,000 140,040 62,240 Sussman 323,000 171,190 54,910 Willbond 422,000 143,480 75,960 Required: 1. Prepare a table indicating contribution margin, variable...
Salespersons' Report and Analysis Pachec Inc. employs seven salespersons to sell and distribute its product throughout...
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: Salesperson Total Sales Variable Cost of Goods Sold Variable Selling Expenses Asarenka $437,500 $196,875 $83,125 Crowell 570,000 228,000 91,200 Dempster 675,000 310,500 141,750 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT