UDU dicur Pantiem Salespersons' Report and Analysis Dix 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 $453,000 $208,380 $63,420 596,000 321,840 125,160 Johnson 365,000 186,150 51,100 Lafave 608,000 243,200 97.280 Orcas 361,000 137,180 46,930 Sussman 373,000 138,010 74,600 Willbond 464,000 208,300 Required: 60,320 1. Prepare a table indicating contribution martin, variable cotofoods 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 Percent Contribution Margin Salesperson Margin Percent of Sales of Sales Ratio alculator Print Item Willbond 464,000 208,800 60,320 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 Variable Cost of Goods Sold as a Variable Selling Expenses as a Percent Contribution Margin Salesperson Margin Percent of Sales Contribution Ratio Case of Sales % % 96 Dix 9% % 96 Johnson 9