problems,ch13 (1) (Compatibility Mode]- Encel |HOME INSERT PAGE LANOUT FORMULAS DATA REVIEW WEW Clipboard GNumberG Font D33 | Chapter 13: Problem #1 Worksheet a Instructons Insert the net sales fgures and the number of sales calls for each salesperson 4 in the boxed sections. Bailey ar Craig Kennedy $135,000 S115,000 132,000 $121,000 $503,000 $188,000 $198,000 $205,000 $190,000 781,000 6 Net Sales 7 Forged steel products 8 Stainless steel products 9 Pre-fabricated products 10 11 Total Sales 12 13 COGS and Commissions 14 Forged steel products 15 Stainless steel products $95000 $101500 $105500 $103,000 405,000 $418,000 $414,500 $442,500 $414,000 $1,689,000 $121,500 $103,500 $118,800 108,900 $452,700 165,440 174,240 180,400 167,200 687 280 66500 71050 73850 72 100 283500 $353,440 $348,790 $373,050 $348,200 $1,423,480 16 Pre-fabricated products 17 Total COGS 18 19 Contribution Margin 20 Selling Expenses 21 Salary 22 Travel S64,560 $65,710 $69450 $65,800 $265,520 $42,000 $50,000 $50,000 $55,000 $197,000 5,100 4,560 4,800 6,750 21,210 Problem 1 Problem 2 Clipboard Font Alignment Number 17 Total COGS 353,440 $348,790 373050 $348,200 $1,423,480 $64560 $65,710 $69,450 $65,800 $265,520 19 Contribution Margin 20 Selling Expenses 21 Salary 22 Travel 23 Food and Lodging 24 Entertainment $42,000 $50,000 $50,000 $55,000 $197,000 5,100 2,350 4,560 4 2,200 6,750 3,500 850 1100 1200 1500 4,800 2,100 21,210 9 10,150 $49,610 $58,000 58,650,75$233,010 $32,510 s Total Sing xperses Profit contribution 28 PC as a percentage of sales 358% 1 86% 2 44% -0 23% Number of Cost per Sales Calls Call Information by Salesperson 33 Bailey 34 Karr 35 Craig 36 Kennedy 94 617.02 81724.07 688.14 Problem 1 Problem 2 2 5 6 FGH oe Sescalis o eachempioyee 2. identify the best and worst performing salespeople based on performance relative to sales quotas 3, Identify the best and worst performing salespeople based on profit contribution 4. Identify the best and worst performing salespeople based on cost-per-call analysis 5. Make a final recommendation: Recommend candidate for lowest performance rating and explain your reasoning