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: Total Sales Variable Cost of Goods Sold Variable Selling Expenses Salesperson Case $610,000 $268,400 $109,800 Dix 603,000 241,200 96,480 Johnson 588,000 305,760 105,840 LaFave 586,000 281,280 123,060 Orcas 616,000 221,760 86,240 Sussman 620,000 310,000 124,000 Willbond 592,000 272,320 88,800 Instructions 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 whole percent. 2. - Which salesperson generated the highest contribution margin ratio for the year and why? 3. Briefly list factors other than contribution margin that should be considered in evaluating the performance of salespersons.

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: Total Sales Variable Cost of Goods Sold Variable Selling Expenses Salesperson Case $610,000 $268,400 $109,800 Dix 603,000 241,200 96,480 Johnson 588,000 305,760 105,840 LaFave 586,000 281,280 123,060 Orcas 616,000 221,760 86,240 Sussman 620,000 310,000 124,000 Willbond 592,000 272,320 88,800 Instructions 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 whole percent. 2. - Which salesperson generated the highest contribution margin ratio for the year and why? 3. Briefly list factors other than contribution margin that should be considered in evaluating the performance of salespersons.

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...

See similar textbooks

Similar questions

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: Instructions 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 whole percent to one digit after decimal point.) 2. Which salesperson generated the highest contribution margin ratio for the year and why? 3. Briefly list factors other than contribution margin that should be considered in evaluating the performance of salespersons.
Ellerson Company provided the following information for the last calendar year: During the year, direct materials purchases amounted to 278,000, direct labor cost was 189,000, and overhead cost was 523,000. During the year, 100,000 units were completed. Refer to Exercise 2.21. Last calendar year, Ellerson recognized revenue of 1,312,000 and had selling and administrative expenses of 204,600. Required: 1. What is the cost of goods sold for last year? 2. Prepare an income statement for Ellerson for last year.
The general merchandise retail industry has a number of segments represented by the following companies: For a recent year, the following cost of goods sold and beginning and ending inventories are provided from corporate annual reports (in millions) for these three companies: a. Determine the inventory turnover ratio for all three companies. Round all calculations to one decimal place. b. Determine the number of days sales in inventory for all three companies. Use 365 days and round all calculations to one decimal place. c. Interpret these results based on each companys merchandising concept.
Park and West, LLC, provides consulting services to retail merchandisers in the Midwest. In 2019, they generated $720,000 in service revenue. Their total cost (fixed and variable) per client was $2,500 and they served 115 clients during the year. If operating expenses for the year were $302,000 what was their net income?
The following data are taken from the general ledger and other records of Phoenix Products Co. on October 31, the end of the first month of operations in the current fiscal year: a. Prepare a statement of cost of goods manufactured. b. Prepare the cost of goods sold section of the income statement.
Prepare a cost of goods sold budget for MacLaren Manufacturing Inc. for the year ended December 31, 2016, from the following estimates. Inventories of production units: Direct materials purchased during the year, 548,000; beginning inventory of direct materials, 36,000; and ending inventory of direct materials, 23,000. Totals from other budgets included:
Kildeer Company makes easels for artists. During the last calendar year, a total of 30,000 easels were made, and 31,000 were sold for 52 each. The actual unit cost is as follows: The selling expenses consisted of a commission of 1.30 per unit sold and advertising copayments totaling 95,000. Administrative expenses, all fixed, equaled 183,000. There were no beginning and ending work-in-process inventories. Beginning finished goods inventory was 132,600 for 3,400 easels. Required: 1. Calculate the number and the dollar value of easels in ending finished goods inventory. 2. Prepare a cost of goods sold statement. 3. Prepare an absorption-costing income statement. Add a column for percentage of sales.
Wyandotte Company provided the following information for the last calendar year: During the year, direct materials purchases amounted to 256,900, direct labor cost was 176,000, and overhead cost was 308,400. There were 40,000 units produced. Required: 1. Calculate the total cost of direct materials used in production. 2. Calculate the cost of goods manufactured. Calculate the unit manufacturing cost. 3. Of the unit manufacturing cost calculated in Requirement 2, 6.62 is direct materials and 7.71 is overhead. What is the prime cost per unit? Conversion cost per unit?
The following data were taken from the general ledger and other data of McDonough Manufacturing on July 31: Compute the cost of goods sold for the month of July.
Cost of goods sold and related items The following data were extracted from the accounting records of Harkins Company for the year ended April 30, 20Y8: Estimated returns of current year sales 11,600 Inventory, May 1, 20Y7 380,000 Inventory, April 30, 20Y8 415,000 Purchases 3,800,000 Purchases returns and allowances 150,000 Purchases discounts 80,000 Sales 5,850,000 Freight in 16,600 a. Prepare the Cost of goods sold section of the income statement for the year ended April 30, 20Y8, using the periodic inventory system. b. Determine the gross profit to be reported on the income statement for the year ended April 30, 20Y8. c. Would gross profit be different if the perpetual inventory system was used instead of the periodic inventory system?
Using the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.
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 TotalSales Variable Costof Goods Sold VariableSellingExpenses Case $610,000 $268,400 $109,800 Dix 603,000 241,200 96,480 Johnson 588,000 305,760 105,840 LaFave 586,000 281,280 123,060 Orcas 616,000 221,760 86,240 Sussman 620,000 310,000 124,000 Willbond 592,000 272,320 88,800 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. Walthman Industries Inc. Salespersons' Analysis For the Year Ended December 31 Salesperson Contribution Margin Variable Cost of…