Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please put down the formula for these sections as I have no idea. Thank you! L M N O 2010 Compensation 2011 Units 2012 Units
Please put down the formula for these sections as I have no idea. Thank you!
L M N O 2010 Compensation 2011 Units 2012 Units 2011 Flex $ Merit 2011 Rating Compensation 8 7 5 1 5 A B C D E F I J K 1 HH 2009-2011 Sales Force Analysis Date Here 2 Name 3 Employee Sick 2009 2010 % Change Items Base Total Total Work Performance 4 Name Days Units Sold Units Sold In Units Prepared Pay Pay Benefits Allowance Award 5 Harco, Jim 3 4,500 4,750 5.6% 4,200 $ 28,000 6 Grand, Sally 2. 3,100 3,250 4.8% 5,150 $ 22,000 7 Howarty, Bill 0 2,200 2,000 -9.1% 3,875 $ 26,000 8 Hiram, Walker 1 4,400 4,600 4.5% 4,000 $ 40,000 9 Dusty, Steve 3 3,500 3,100 -11.4% 4,600 $ 30,000 10 11 12 Average 2010 Units Sold for the entire department is: Total of 2009 Units Sold that are more than 4,000: 13 14 Median 2011 Units is: Number of employees with an improvement in Units Sold: 15 16 17 18 19 20 21 22 Policy Table Merit % 2011 Rating Increase Flex $ 1 0.5% $ 2 0.8% $ 3 1.2% $ 4 1.7% $ 1,000 5 2.5% $ 1,000 6 3.5% $ 2,000 7 5.0% $ 4,000 8 7.0% $ 6,000 9 9.0% $ 8,000 L M N O 2010 Compensation 2011 Units 2012 Units 2011 Flex $ Merit 2011 Rating Compensation 8 7 5 1 5 A B C D E F I J K 1 HH 2009-2011 Sales Force Analysis Date Here 2 Name 3 Employee Sick 2009 2010 % Change Items Base Total Total Work Performance 4 Name Days Units Sold Units Sold In Units Prepared Pay Pay Benefits Allowance Award 5 Harco, Jim 3 4,500 4,750 5.6% 4,200 $ 28,000 6 Grand, Sally 2. 3,100 3,250 4.8% 5,150 $ 22,000 7 Howarty, Bill 0 2,200 2,000 -9.1% 3,875 $ 26,000 8 Hiram, Walker 1 4,400 4,600 4.5% 4,000 $ 40,000 9 Dusty, Steve 3 3,500 3,100 -11.4% 4,600 $ 30,000 10 11 12 Average 2010 Units Sold for the entire department is: Total of 2009 Units Sold that are more than 4,000: 13 14 Median 2011 Units is: Number of employees with an improvement in Units Sold: 15 16 17 18 19 20 21 22 Policy Table Merit % 2011 Rating Increase Flex $ 1 0.5% $ 2 0.8% $ 3 1.2% $ 4 1.7% $ 1,000 5 2.5% $ 1,000 6 3.5% $ 2,000 7 5.0% $ 4,000 8 7.0% $ 6,000 9 9.0% $ 8,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started