Question

Telemarketers receive $15 commission on all new customers they sign up for cell phone service through Movill Networks. Each telemarketer works 40 hours. The company ran a competition this week to see who could sign up the most new people and the winner would get a bonus of $34. Because these employees are paid solely on commission, the employer must ensure that they earn the federal minimum wage for 40 hours each week. Required: Compute the gross pay for each of the following outbound sales representatives. Enter difference when the commission pay is less than the gross pay at minimum wage. Number of New Customers Signed 27 Total Commission Difference Between Minimum Pay and Commission Employee S. McCulloch Total Gross Pay F. Odell 18 S. Heller 37 V. Caro 15

Answer 1

XI - Book2 - Microsoft Excel File Home Insert Page Layout Formulas Data Review View O x I AutoSum - Calibri 11 - A À Wrap Text General H Fill * Cut E Copy Paste Format Painter Clipboard BI U А Merge & Center % +.0 .00 .00.0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles Clear Sort & Find & Filter - Select Editing Font Alignment Number Cells J7 In A B с D E F G H I J K L M N O P 0 R S 1 2 Minimim federal wage rate per hour is $7.25 per hour Minimum wages per week = 40 * $7.25 = $290 3 4 5 When Commission is less tha $290, we will add difference to calculate gross pay 6 7 Employee O 8 No of New Total Customer Commission (B) C=B* $15 Difference Total Gross Pay D = $290 - [C] E=(C+D) 9 (A) 10 11 12 13 14 S. McCulloch F. Odell S. Heller V.Caro 27 $ 18 $ 37 $ 15 $ 405.00 $ 270.00 $ 555.00 $ 225.00 $ $ 405.00 20.00 $ 290.00 $ 555.00 65.00 $ 290.00 15 16 17 Note: If we add bonus, than Gross pay of S. Heller will be $555 + $34 = $589, as he is winner (most new customer signed) 18 19 20 21 22 23 24 25 Sheet1 Sheet2 Sheet3 K Ready 100% + o Type here to search 1 e o x O la 4x ENG 23:56 23-09-2020 6

XI - Book2 - Microsoft Excel File Home Insert Page Layout Formulas Data Review View O x AutoSum - Calibri 11 AA Wrap Text General H Fill % Cut Ea Copy - Paste Format Painter Clipboard BI U А Merge & Center % +.0 .00 .00.0 Insert Delete Format Clear Conditional Format Cell Formatting as Table Styles Styles Sort & Find & Filter - Select Editing Font Alignment Number Cells C20 A B с D E F Difference Total Commission C=B* $15 Total Gross Pay E = (C+D) D = $290 - [C] 1 2 Minimim federal wage rate per hour is $7.25 per hour 3 Minimum wages per week = 40 $7.25 = $290 4 5 When Commission is less tha $290, we will add difference to calculate gross pay 6 7 Employee No of New 8 Customer 9 (A) ( (B) 10 11 12 S. McCulloch 27 13 F. Odell 18 14 S. Heller 37 15 V.Caro 15 16 17 Note: If we add bonus, than Gross pay of S. Heller will be $555 + $34 = $589, as he is winner (most new customer signed 18 19 20 21 22 23 24 25 =B12.15 =B13-15 =B14-15 =B15 15 0 =290-270 0 =C12-D12 =C13+D13 =C14+D14 =C15+D15 =290-225 26 27 28 29 30 KI Sheet1 Sheet2 Sheet3 IL Ready 85% - + Type here to search 1 o i e X M la 4x ENG 23:57 23-09-2020 6

Note

If you have any queries kindly post a comment, i will solve it earliest.

If you satisfied with my answer, kindly give a thumbs up, it will help to encourage me.