6. Based on past performance, what would happen to total commission paid, if Mr. Bob increased the sales quota for each position by $75 per hour? You have to do scenarios for this. Create the scenarios in the HrlyWage&Quota worksheet. All the cells needed in defining scenarios have to come from the same worksheet. So, you may have to use formulas in HrlyWage&Quota worksheet to get the numbers from the Wholeweek worksheet. These numbers are what you would like to identify as the result cells.

7. What would happen (total amount of commission paid) if Mr. Bob increased each sales position's commission rate by a quarter of a percent?

Do scenario summary report to get answer to #6, and #7.

F H J K L M N o R 09 Commissi Hours Worked Base Pay Xtra Sale Commission Gross Pay Made Quota 1 on Rate Sales Base Pay Commission Gross Pay Grand Total Average Minimum Maximum $576,557.47 $13,727.56 $2,907.63 $59,984.31 $14,211.25 $338.36 $117.00 $680.00 $7,568.76 $180.21 $14.01 $1,517.53 $21,780.01 $518.57 132.13 $2,077.53 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 30 12 37.5 27 34 16 40 16 20 35 27 32.5 33 15 18 40 32 20 34 28 32 36 20 28 14 40 39 18 33.5 13 $600.00 $117.00 $450.00 $324.00 $680.00 $152.00 $420.00 $152.00 $195.00 $420.00 $283.50 $341.25 $346.50 $142.50 $175.50 $420.00 $640.00 $195.00 $357.00 $560.00 $336.00 $432.00 $190.00 $560.00 $136.50 $420.00 $468.00 $171.00 $351.75 $123.50 $399.00 $560.00 $117.00 $117.00 $336.00 $346.50 $171.00 $600.00 $480.00 $456.00 $351.75 $117.00 Quota for the day $6,000.00 $1,500.00 $6,562.50 $4,725.00 $6,800.00 $1,600.00 $6,000.00 $1,600.00 $2,500.00 $6,125.00 $4,050.00 $4,875.00 $4,950.00 $1,500.00 $2,250.00 $6,000.00 $6,400.00 $2,500.00 $5,100.00 $5,600.00 $4,800.00 $6,300.00 $2,000.00 $5,600.00 $1,750.00 $6,000.00 $6,825.00 $1,800.00 $5,025.00 $1,300.00 $5,700.00 $5,600.00 $1,500.00 $1,500.00 $4,900.00 $4,950.00 $1,800.00 $6,000.00 $7,000.00 $6,650.00 $5,025.00 $1,500.00 $1,210.37 $1,512.61 $1,983.12 $2,022.17 $466.99 $4,224.31 $6,998.78 $4,870.59 $3,257.08 $3,031.41 $39,796.14 $700.31 $2,516.07 $31,660.64 $35,480.24 $1,851.01 $1,999.42 $57,484.31 $6,112.24 $5,763.99 $5,062.87 $7,007.23 $5,606.25 $50,584.18 $2,858.75 $9.463.78 $5,663.61 $2,644.29 $7,678.32 $7.474.49 $43,411.96 $1,681.28 $3,184.63 $2,591.60 $4,095.17 $10,297.75 $5,703.99 $2.013.00 $5,583.44 $4,530.00 $5,771.83 $1,979.88 3.00% 1.00% 2.50% 2.50% 3.00% 1.50% 2.00% 1.50% 1.00% 2.50% 2.00% 2.00% 2.00% 1.50% 1.00% 2.00% 3.00% 1.00% 2.00% 3.00% 2.00% 2.50% 1.50% 3.00% 1.00% 2.00% 2.50% 1.50% 2.00% 1.50% 2.00% 3.00% 1.00% 1.00% 2.50% 2.00% 1.50% 3.00% 2.50% 2.50% 2.00% 1.00% $36.31 $636.31 $15.13 $132.13 $49.58 $499.58 $50.55 $374.55 $14.01 $694.01 $63.36 $215.36 $139.98 $559.98 $73.06 $225.06 $32.57 $227.57 $75.79 $495.79 $795.92 $1,079.42 $14.01 $355.26 $50.32 $396.82 $474.91 $617.41 $354.80 $530.30 $37.02 $457.02 $59.98 $699.98 $574.84 $769.84 $122.24 $479.24 $172.92 $732.92 $101.26 $437.26 $175.18 $607.18 $84.09 $274.09 $1,517.53 $2,077.53 $28.59 $165.09 $189.28 $609.28 $141.59 $609.59 $39.66 $210.66 $153.57 $505.32 $112.12 $235.62 $868.24 $1,267.24 $50.44 $610.44 $31.65 $148.65 $25.92 $142.92 $102.38 $438.38 $205.96 $552.46 $85.56 $256.56 $60.39 $660.39 $139.59 $619.59 $113.25 $569.25 $115.44 $467.19 $19.80 $136.80 3 3 4 1 1 2 4 3 3 4 4 2 5 2 3 3 4 3 5 4 4 5 5 4 3 5 3 3 5 2 5 3 3 2 4 5 2 2 5 5 4 2 28 12 12 28 33 18 30 40 38 33.5 12 NUNUN Thursday Friday Saturday HrlyWage&Quotas pie dept comm sales avg by pos Whole Week A B c D E F G H J K L Rank Total Commission Assistant Manager Sales Assistant Sales Partner Sales Associate Sales Consultant Hourly Wage $20.00 $9.50 $9.75 $10.50 $12.00 Hourly Quota $200.00 $100.00 $125.00 $150.00 $175.00 Commission Rate 0.030 0.015 0.01 0.02 0.025 1 Rank 2 Code 3 AM 4 PT1 5 PT2 6 S1 7 S2 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 147 an Thursday Friday Saturday HrlyWage&Quotas pie dept comm sales avg by pos WholeWeek F H J K L M N o R 09 Commissi Hours Worked Base Pay Xtra Sale Commission Gross Pay Made Quota 1 on Rate Sales Base Pay Commission Gross Pay Grand Total Average Minimum Maximum $576,557.47 $13,727.56 $2,907.63 $59,984.31 $14,211.25 $338.36 $117.00 $680.00 $7,568.76 $180.21 $14.01 $1,517.53 $21,780.01 $518.57 132.13 $2,077.53 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 30 12 37.5 27 34 16 40 16 20 35 27 32.5 33 15 18 40 32 20 34 28 32 36 20 28 14 40 39 18 33.5 13 $600.00 $117.00 $450.00 $324.00 $680.00 $152.00 $420.00 $152.00 $195.00 $420.00 $283.50 $341.25 $346.50 $142.50 $175.50 $420.00 $640.00 $195.00 $357.00 $560.00 $336.00 $432.00 $190.00 $560.00 $136.50 $420.00 $468.00 $171.00 $351.75 $123.50 $399.00 $560.00 $117.00 $117.00 $336.00 $346.50 $171.00 $600.00 $480.00 $456.00 $351.75 $117.00 Quota for the day $6,000.00 $1,500.00 $6,562.50 $4,725.00 $6,800.00 $1,600.00 $6,000.00 $1,600.00 $2,500.00 $6,125.00 $4,050.00 $4,875.00 $4,950.00 $1,500.00 $2,250.00 $6,000.00 $6,400.00 $2,500.00 $5,100.00 $5,600.00 $4,800.00 $6,300.00 $2,000.00 $5,600.00 $1,750.00 $6,000.00 $6,825.00 $1,800.00 $5,025.00 $1,300.00 $5,700.00 $5,600.00 $1,500.00 $1,500.00 $4,900.00 $4,950.00 $1,800.00 $6,000.00 $7,000.00 $6,650.00 $5,025.00 $1,500.00 $1,210.37 $1,512.61 $1,983.12 $2,022.17 $466.99 $4,224.31 $6,998.78 $4,870.59 $3,257.08 $3,031.41 $39,796.14 $700.31 $2,516.07 $31,660.64 $35,480.24 $1,851.01 $1,999.42 $57,484.31 $6,112.24 $5,763.99 $5,062.87 $7,007.23 $5,606.25 $50,584.18 $2,858.75 $9.463.78 $5,663.61 $2,644.29 $7,678.32 $7.474.49 $43,411.96 $1,681.28 $3,184.63 $2,591.60 $4,095.17 $10,297.75 $5,703.99 $2.013.00 $5,583.44 $4,530.00 $5,771.83 $1,979.88 3.00% 1.00% 2.50% 2.50% 3.00% 1.50% 2.00% 1.50% 1.00% 2.50% 2.00% 2.00% 2.00% 1.50% 1.00% 2.00% 3.00% 1.00% 2.00% 3.00% 2.00% 2.50% 1.50% 3.00% 1.00% 2.00% 2.50% 1.50% 2.00% 1.50% 2.00% 3.00% 1.00% 1.00% 2.50% 2.00% 1.50% 3.00% 2.50% 2.50% 2.00% 1.00% $36.31 $636.31 $15.13 $132.13 $49.58 $499.58 $50.55 $374.55 $14.01 $694.01 $63.36 $215.36 $139.98 $559.98 $73.06 $225.06 $32.57 $227.57 $75.79 $495.79 $795.92 $1,079.42 $14.01 $355.26 $50.32 $396.82 $474.91 $617.41 $354.80 $530.30 $37.02 $457.02 $59.98 $699.98 $574.84 $769.84 $122.24 $479.24 $172.92 $732.92 $101.26 $437.26 $175.18 $607.18 $84.09 $274.09 $1,517.53 $2,077.53 $28.59 $165.09 $189.28 $609.28 $141.59 $609.59 $39.66 $210.66 $153.57 $505.32 $112.12 $235.62 $868.24 $1,267.24 $50.44 $610.44 $31.65 $148.65 $25.92 $142.92 $102.38 $438.38 $205.96 $552.46 $85.56 $256.56 $60.39 $660.39 $139.59 $619.59 $113.25 $569.25 $115.44 $467.19 $19.80 $136.80 3 3 4 1 1 2 4 3 3 4 4 2 5 2 3 3 4 3 5 4 4 5 5 4 3 5 3 3 5 2 5 3 3 2 4 5 2 2 5 5 4 2 28 12 12 28 33 18 30 40 38 33.5 12 NUNUN Thursday Friday Saturday HrlyWage&Quotas pie dept comm sales avg by pos Whole Week A B c D E F G H J K L Rank Total Commission Assistant Manager Sales Assistant Sales Partner Sales Associate Sales Consultant Hourly Wage $20.00 $9.50 $9.75 $10.50 $12.00 Hourly Quota $200.00 $100.00 $125.00 $150.00 $175.00 Commission Rate 0.030 0.015 0.01 0.02 0.025 1 Rank 2 Code 3 AM 4 PT1 5 PT2 6 S1 7 S2 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 147 an Thursday Friday Saturday HrlyWage&Quotas pie dept comm sales avg by pos WholeWeek