Date Sales Rep Shift Cost Price Selling Price Profit Profit %

7/1/2022 Ben Night $1,112.94 $1,288.00

7/1/2022 Jacob Day $1,095.50 $1,250.75
7/4/2022 Ben Night $1,120.94 $1,295.00
7/4/2022 Jacob Day $1,509.73 $1,687.75
7/5/2022 Ben Day $1,235.33 $1,412.25
7/5/2022 Jacob Night $881.93 $962.00
7/6/2022 Ben Night $1,075.70 $1,142.75
7/6/2022 Jacob Day $714.58 $800.50
7/7/2022 Ben Day $1,299.11 $1,360.00
7/7/2022 Jacob Night $1,087.48 $1,268.50
7/8/2022 Ben Night $803.79 $907.75
7/8/2022 Jacob Day $1,113.73 $1,278.75
7/11/2022 Ben Day $843.16 $965.25
7/11/2022 Jacob Night $1,552.52 $1,717.50
7/12/2022 Ben Night $1,382.27 $1,550.25
7/12/2022 Jacob Day $1,515.76 $1,622.75
7/13/2022 Ben Day $1,264.56 $1,328.50
7/13/2022 Jacob Night $1,251.98 $1,402.00
7/14/2022 Ben Night $986.11 $1,054.00
7/14/2022 Jacob Day $1,514.20 $1,571.25
7/15/2022 Ben Day $1,318.85 $1,454.75
7/15/2022 Jacob Night $1,495.11 $1,655.00
7/18/2022 Ben Night $1,187.70 $1,297.75
7/18/2022 Jacob Day $1,150.74 $1,225.75
7/19/2022 Ben Day $1,562.68 $1,736.75
7/19/2022 Jacob Night $1,514.13 $1,620.25
7/20/2022 Ben Night $778.27 $930.25
7/20/2022 Jacob Day $1,270.66 $1,334.75
7/21/2022 Ben Day $766.72 $841.75
7/21/2022 Jacob Night $1,041.13 $1,157.25
7/22/2022 Ben Night $1,218.08 $1,344.00
7/22/2022 Jacob Day $1,016.36 $1,108.25
7/25/2022 Ben Day $1,576.91 $1,683.00
7/25/2022 Jacob Night $870.02 $997.00
7/26/2022 Ben Night $1,145.26 $1,344.25
7/26/2022 Jacob Day $1,313.05 $1,504.00
7/27/2022 Ben Day $833.49 $906.50
7/27/2022 Jacob Night $1,578.85 $1,711.75
7/28/2022 Ben Night $1,314.78 $1,371.75
7/28/2022 Jacob Day $972.81 $1,139.75
7/29/2022 Ben Day $1,551.16 $1,721.25
7/29/2022 Jacob Night $1,366.59 $1,418.50
8/1/2022 Ben Night $1,466.66 $1,624.75
8/1/2022 Jacob Day $1,594.15 $1,682.25
8/2/2022 Ben Night $1,580.98 $1,679.00
8/2/2022 Jacob Day $916.97 $1,025.00
8/3/2022 Ben Night $726.12 $838.00
8/3/2022 Jacob Day $1,461.44 $1,599.50
8/4/2022 Ben Day $1,176.26 $1,263.25
8/4/2022 Jacob Night $825.12 $1,004.00
8/5/2022 Ben Night $1,034.97 $1,091.00
8/5/2022 Jacob Day $939.94 $1,045.00
8/8/2022 Ben Day $1,429.63 $1,570.75
8/8/2022 Jacob Night $1,009.06 $1,189.00
8/9/2022 Ben Night $974.45 $1,152.50
8/9/2022 Jacob Day $1,511.87 $1,688.75
8/10/2022 Ben Night $1,103.76 $1,256.75
8/10/2022 Jacob Day $809.07 $930.00
8/11/2022 Ben Night $1,438.40 $1,560.50
8/11/2022 Jacob Day $1,472.96 $1,637.00
8/12/2022 Ben Day $1,556.29 $1,742.25
8/12/2022 Jacob Night $960.13 $1,088.25
8/15/2022 Ben Night $1,520.43 $1,594.50
8/15/2022 Jacob Day $1,195.05 $1,263.00
8/16/2022 Ben Night $1,357.83 $1,518.75
8/16/2022 Jacob Day $1,440.38 $1,498.50
8/17/2022 Ben Night $801.34 $913.25
8/17/2022 Jacob Day $1,001.99 $1,097.00
8/18/2022 Ben Day $1,121.86 $1,191.75
8/18/2022 Jacob Night $776.22 $961.25
8/19/2022 Ben Night $779.66 $900.75
8/19/2022 Jacob Day $850.14 $932.25
8/22/2022 Ben Day $896.25 $1,008.25
8/22/2022 Jacob Night $1,051.00 $1,133.00
8/23/2022 Ben Night $1,385.50 $1,504.50
8/23/2022 Jacob Day $1,075.76 $1,262.75
8/24/2022 Ben Day $896.05 $957.00
8/24/2022 Jacob Night $843.34 $1,039.25
8/25/2022 Ben Night $1,211.66 $1,325.75
8/25/2022 Jacob Day $1,357.20 $1,463.25
8/26/2022 Ben Night $940.87 $1,027.75
8/26/2022 Jacob Day $1,274.05 $1,455.00
8/29/2022 Ben Night $1,179.06 $1,376.00
8/29/2022 Jacob Day $774.20 $946.25
8/30/2022 Ben Day $1,350.48 $1,509.50
8/30/2022 Jacob Night $1,053.37 $1,136.25
8/31/2022 Ben Night $1,161.92 $1,237.00
8/31/2022 Jacob Day $951.93 $1,136.00
Commission Weekday
This is a dataset about a small electronics retail company. There are
The payment is shift wise. The night shift pays more. The cost price
sold on each shift per day.
We have 5 tasks to solve. Additional data are provided in the "Refe
These are solved in the "Solution" sheet.
 company. There are two sales employees, working on separate shifts.
more. The cost price and selling price are the accumulation of all items
ovided in the "Reference Data" sheet.
 Date Sales Rep Shift Cost Price Selling Price Profit % Commission
7/1/2022 Ben Night $1,112.94 $1,288.00 15.73% $6.44
7/1/2022 Jacob Day $1,095.50 $1,250.75 14.17% $6.25
7/4/2022 Ben Night $1,120.94 $1,295.00 15.53% $6.48
7/4/2022 Jacob Day $1,509.73 $1,687.75 11.79%
7/5/2022 Ben Day $1,235.33 $1,412.25 14.32% $7.06
7/5/2022 Jacob Night $881.93 $962.00 9.08%
7/6/2022 Ben Night $1,075.70 $1,142.75 6.23%
7/6/2022 Jacob Day $714.58 $800.50 12.02% $4.00
7/7/2022 Ben Day $1,299.11 $1,360.00 4.69%
7/7/2022 Jacob Night $1,087.48 $1,268.50 16.65% $6.34
7/8/2022 Ben Night $803.79 $907.75 12.93% $4.54
7/8/2022 Jacob Day $1,113.73 $1,278.75 14.82% $6.39
7/11/2022 Ben Day $843.16 $965.25 14.48% $4.83
7/11/2022 Jacob Night $1,552.52 $1,717.50 10.63%
7/12/2022 Ben Night $1,382.27 $1,550.25 12.15% $7.75
7/12/2022 Jacob Day $1,515.76 $1,622.75 7.06%
7/13/2022 Ben Day $1,264.56 $1,328.50 5.06%
7/13/2022 Jacob Night $1,251.98 $1,402.00 11.98%
7/14/2022 Ben Night $986.11 $1,054.00 6.88%
7/14/2022 Jacob Day $1,514.20 $1,571.25 3.77%
7/15/2022 Ben Day $1,318.85 $1,454.75 10.30%
7/15/2022 Jacob Night $1,495.11 $1,655.00 10.69%
7/18/2022 Ben Night $1,187.70 $1,297.75 9.27%
7/18/2022 Jacob Day $1,150.74 $1,225.75 6.52%
7/19/2022 Ben Day $1,562.68 $1,736.75 11.14%
7/19/2022 Jacob Night $1,514.13 $1,620.25 7.01%
7/20/2022 Ben Night $778.27 $930.25 19.53% $4.65
7/20/2022 Jacob Day $1,270.66 $1,334.75 5.04%
7/21/2022 Ben Day $766.72 $841.75 9.79%
7/21/2022 Jacob Night $1,041.13 $1,157.25 11.15%
7/22/2022 Ben Night $1,218.08 $1,344.00 10.34%
7/22/2022 Jacob Day $1,016.36 $1,108.25 9.04%
7/25/2022 Ben Day $1,576.91 $1,683.00 6.73%
7/25/2022 Jacob Night $870.02 $997.00 14.60% $4.99
7/26/2022 Ben Night $1,145.26 $1,344.25 17.38% $6.72
7/26/2022 Jacob Day $1,313.05 $1,504.00 14.54% $7.52
7/27/2022 Ben Day $833.49 $906.50 8.76%
7/27/2022 Jacob Night $1,578.85 $1,711.75 8.42%
7/28/2022 Ben Night $1,314.78 $1,371.75 4.33%
7/28/2022 Jacob Day $972.81 $1,139.75 17.16% $5.70
7/29/2022 Ben Day $1,551.16 $1,721.25 10.97%
7/29/2022 Jacob Night $1,366.59 $1,418.50 3.80%
8/1/2022 Ben Night $1,466.66 $1,624.75 10.78%
8/1/2022 Jacob Day $1,594.15 $1,682.25 5.53%
8/2/2022 Ben Night $1,580.98 $1,679.00 6.20%
8/2/2022 Jacob Day $916.97 $1,025.00 11.78%
8/3/2022 Ben Night $726.12 $838.00 15.41% $4.19
8/3/2022 Jacob Day $1,461.44 $1,599.50 9.45%
8/4/2022 Ben Day $1,176.26 $1,263.25 7.40%
8/4/2022 Jacob Night $825.12 $1,004.00 21.68% $15.06
8/5/2022 Ben Night $1,034.97 $1,091.00 5.41%
8/5/2022 Jacob Day $939.94 $1,045.00 11.18%
8/8/2022 Ben Day $1,429.63 $1,570.75 9.87%
8/8/2022 Jacob Night $1,009.06 $1,189.00 17.83% $5.95
8/9/2022 Ben Night $974.45 $1,152.50 18.27% $5.76
8/9/2022 Jacob Day $1,511.87 $1,688.75 11.70%
8/10/2022 Ben Night $1,103.76 $1,256.75 13.86% $6.28
8/10/2022 Jacob Day $809.07 $930.00 14.95% $4.65
8/11/2022 Ben Night $1,438.40 $1,560.50 8.49%
8/11/2022 Jacob Day $1,472.96 $1,637.00 11.14%
8/12/2022 Ben Day $1,556.29 $1,742.25 11.95%
8/12/2022 Jacob Night $960.13 $1,088.25 13.34% $5.44
8/15/2022 Ben Night $1,520.43 $1,594.50 4.87%
8/15/2022 Jacob Day $1,195.05 $1,263.00 5.69%
8/16/2022 Ben Night $1,357.83 $1,518.75 11.85%
8/16/2022 Jacob Day $1,440.38 $1,498.50 4.04%
8/17/2022 Ben Night $801.34 $913.25 13.97% $4.57
8/17/2022 Jacob Day $1,001.99 $1,097.00 9.48%
8/18/2022 Ben Day $1,121.86 $1,191.75 6.23%
8/18/2022 Jacob Night $776.22 $961.25 23.84% $14.42
8/19/2022 Ben Night $779.66 $900.75 15.53% $4.50
8/19/2022 Jacob Day $850.14 $932.25 9.66%
8/22/2022 Ben Day $896.25 $1,008.25 12.50% $5.04
8/22/2022 Jacob Night $1,051.00 $1,133.00 7.80%
8/23/2022 Ben Night $1,385.50 $1,504.50 8.59%
8/23/2022 Jacob Day $1,075.76 $1,262.75 17.38% $6.31
8/24/2022 Ben Day $896.05 $957.00 6.80%
8/24/2022 Jacob Night $843.34 $1,039.25 23.23% $15.59
8/25/2022 Ben Night $1,211.66 $1,325.75 9.42%
8/25/2022 Jacob Day $1,357.20 $1,463.25 7.81%
8/26/2022 Ben Night $940.87 $1,027.75 9.23%
8/26/2022 Jacob Day $1,274.05 $1,455.00 14.20% $7.28
8/29/2022 Ben Night $1,179.06 $1,376.00 16.70% $6.88
8/29/2022 Jacob Day $774.20 $946.25 22.22% $14.19
8/30/2022 Ben Day $1,350.48 $1,509.50 11.78%
8/30/2022 Jacob Night $1,053.37 $1,136.25 7.87%
8/31/2022 Ben Night $1,161.92 $1,237.00 6.46%
8/31/2022 Jacob Day $951.93 $1,136.00 19.34% $5.68
Profit Weekday
$175.06 5
$155.25 5
$174.06 1
$178.02 1
$176.92 2
$80.07 2
$67.05 3
$85.92 3
$60.89 4
$181.02 4
$103.96 5
$165.02 5
$122.09 1
$164.98 1
$167.98 2
$106.99 2
$63.94 3
$150.02 3
$67.89 4
$57.05 4
$135.90 5
$159.89 5
$110.05 1
$75.01 1
$174.07 2
$106.12 2
$151.98 3
$64.09 3
$75.03 4
$116.12 4
$125.92 5
$91.89 5
$106.09 1
$126.98 1
$198.99 2
$190.95 2
$73.01 3
$132.90 3
$56.97 4
$166.94 4
$170.09 5
$51.91 5
$158.09 1
$88.10 1
$98.02 2
$108.03 2
$111.88 3
$138.06 3
$86.99 4
$178.88 4
$56.03 5
$105.06 5
$141.12 1
$179.94 1
$178.05 2
$176.88 2
$152.99 3
$120.93 3
$122.10 4
$164.04 4
$185.96 5
$128.12 5
$74.07 1
$67.95 1
$160.92 2
$58.12 2
$111.91 3
 $95.01 3
$69.89 4
$185.03 4
$121.09 5
$82.11 5
$112.00 1
$82.00 1
$119.00 2
$186.99 2
$60.95 3
$195.91 3
$114.09 4
$106.05 4
$86.88 5
$180.95 5
$196.94 1
$172.05 1
$159.02 2
$82.88 2
$75.08 3
$184.07 3