Chai Time Teas; $4,848.

00

Alberta Beverages
Namaste Sold
Iced Teas; $4,897.00

Blueberry Bliss Juice; $4,933.00

$5,500.00
YoYo Smoothies; $4,669.00

$4,500.00
Liquid Sunshine Organic Orange Juice; Vita Filtered Water; $3,528.00
$3,033.00
Tahiti Coconut Milk; $2,830.00 NRG Drink; $2,738.00 Almond Joy Milk; $3,074.00
Replenish Very
Cool Quencher;
Water; Berry; $3,254.00
$2,878.00
$2,243.00
$3,500.00
Number of beverages

$2,500.00

$1,500.00

$500.00

Liquid Tahiti Co- YoYo Vita Fil- NRG Namaste Replenish Cool Very Berry Almond Chai Time Blueberry
Sunshine conut Milk Smoothies tered Wa- Drink Iced Teas Water Quencher Joy Milk Teas Bliss Juice
Organic ter
Orange
Juice
North $3,033.00 $2,830.00 $4,669.00 $3,528.00 $2,738.00 $4,897.00 $2,243.00 $2,878.00 $3,254.00 $3,074.00 $4,848.00 $4,933.00
Cal-
gary
AB
South $2,509.00 $4,231.00 $3,417.00 $3,885.00 $3,376.00 $3,333.00 $2,120.00 $4,576.00 $3,198.00 $2,241.00 $4,171.00 $4,420.00
Ed-
minton
AB

Axis Title
 Markup Impact on profit
90.00%

83.50%
80.00%

70.00%

60.00%

50.00%

40.00%

30.00%

20.00%
17.83%

10.00%

0.00%
ce ilk es er k s er e r
rry ilk s ce
i i at rin Te
a at ch Te
a i
Ju t M th D Be M Ju
e nu oo d
W
G ed h
W en ry Jo
y e s
ng is u im is
oc
o
S m re N
R Ic n lQ Ve d
iT Bl
ra lte te le oo on ry
O ti
C Yo Fi as ep m ha er
ni
c hi Yo ta am R C Al C b
a Ta Vi N ue
O
rg Bl
n e
hi
ns
Su
d
q ui
Li

% Markup Linear (% Markup) % of Total Profit

 Alberta Beverages Sold

$5,500.00

$4,500.00

$3,500.00

NRG Drink, $2,738.00

Number of Beverages

$2,500.00

$1,500.00

$500.00

Liquid Tahiti Co- YoYo Vita Fil- NRG Drink Namaste Replenish Cool Very Berry Almond Chai Time Blueberry
Sunshine conut Milk Smoothies tered Wa- Iced Teas Water Quencher Joy Milk Teas Bliss Juice
Organic ter
Orange
Juice
North $3,033.00 $2,830.00 $4,669.00 $3,528.00 $2,738.00 $4,897.00 $2,243.00 $2,878.00 $3,254.00 $3,074.00 $4,848.00 $4,933.00
Cal-
gary,
AB
South $2,509.00 $4,231.00 $3,417.00 $3,885.00 $3,376.00 $3,333.00 $2,120.00 $4,576.00 $3,198.00 $2,241.00 $4,171.00 $4,420.00
Ed-
mon-
ton, AB

Axis Title

North Calgary, AB South Edmonton, AB

 Markup Impact on Profit
90.00%
% Markup, Replenish
Water, 83.50%
80.00%

70.00%

60.00%

50.00%

40.00%

30.00% % of Total Profit, NRG % Markup

Axis Title

Drink, 17.83% Linear (% Markup)

Linear (% Markup)
20.00%
% of Total Profit

10.00%

0.00%
k
ilk

es

er

er

rry

ilk

ce
ce

he
in

a
at

at
M

M
Te

Te

i
i
i

Be
Dr

Ju
th
Ju

nc
W

W
ut

y
oo

e
e

Jo
G

ry

iss
ge

d
n

ish

m
Ice

Qu
Sm

NR

Ve
co

re
n

Bl
Ti
en
lte
ra

on
Co

te

ol

ai

ry
Yo
cO

pl
as
Fi

Co

Ch

er
iti

Re
Yo

Al
m
ta

eb
ni

Na
Vi
Ta
ga

u
Bl
Or
i ne
sh
n
Su
id
qu
Li

Type of Beverages
 South
North
Types of Beverages; Beverage Category Edmonton,
Calgary, AB
AB

Liquid Sunshine Organic Orange Juice Natural $3,033.00 $2,509.00

Tahiti Coconut Milk Healthy Choice $2,830.00 $4,231.00
YoYo Smoothies Healthy Choice $4,669.00 $3,417.00
Vita Filtered Water Healthy Choice $3,528.00 $3,885.00
NRG Drink Fitness $2,738.00 $3,376.00
Namaste Iced Teas Natural $4,897.00 $3,333.00
Replenish Water Fitness $2,243.00 $2,120.00
Cool Quencher Fitness $2,878.00 $4,576.00
Very Berry Natural $3,254.00 $3,198.00
Almond Joy Milk Healthy Choice $3,074.00 $2,241.00
Chai Time Teas Natural $4,848.00 $4,171.00
Blueberry Bliss Juice Natural $4,933.00 $4,420.00
Totals $42,925.00 $41,477.00

Number of Types of Beverages 12

Average Number of Beverages Sold In Calgary 3,577
Lowest Number of Beverages Sold in Alberta 2,120
Highest Total Sales Revenue 62,850
Midpoint of Suggested Retail Prices 3
Most common Wholesale Cost 2
 Total
North
South Number of Total Sales
Winnipeg, Total Recycling Charges - Alberta
Toronto, ON Beverages Revenue
MB
Sold
$4,800.00 $4,989.00 $15,331.00 $42,773.49 $182.89
$2,302.00 $4,356.00 $13,719.00 $34,160.31 $233.01
$3,539.00 $2,925.00 $14,550.00 $50,779.50 $266.84
$4,919.00 $3,990.00 $16,322.00 $29,216.38 $244.63
$4,933.00 $4,705.00 $15,752.00 $62,850.48 $201.76
$3,855.00 $2,957.00 $15,042.00 $29,933.58 $271.59
$4,465.00 $4,543.00 $13,371.00 $25,271.19 $143.98
$2,662.00 $4,569.00 $14,685.00 $36,565.65 $245.98
$2,934.00 $3,452.00 $12,838.00 $34,277.46 $212.92
$4,311.00 $2,520.00 $12,146.00 $31,458.14 $175.40
$4,055.00 $4,104.00 $17,178.00 $44,491.02 $297.63
$2,583.00 $3,551.00 $15,487.00 $46,306.13 $308.65
$45,358.00 $46,661.00 $176,421.00 $468,083.33 $2,785.27

A3:A15 C3:D15.
Total Recycling % of
Distribution
charges- other % Markup Total Profit Total
charges
provinces Profit

$450.29 1411.53 24.00% $8,278.74 5.42%

$306.27 1127.29 46.47% $10,838.01 7.09%
$297.34 1675.72 44.21% $15,568.50 10.18%
$409.81 964.14 43.20% $8,813.88 5.77%
$443.35 2074.07 76.55% $27,250.96 17.83%
$313.35 987.81 74.56% $12,785.70 8.36%
$414.37 833.95 83.50% $11,499.06 7.52%
$332.63 1206.67 44.77% $11,307.45 7.40%
$293.76 1131.16 39.06% $9,628.50 6.30%
$314.23 1038.12 39.25% $8,866.58 5.80%
$375.31 1468.20 39.25% $12,539.94 8.20%
$282.16 1528.10 50.25% $15,487.00 10.13%
$4,232.87 605.07% $152,864.32 100.00%
asdf

South
North
Types of Beverages Beverage Category Edmonton,
Calgary, AB
AB

Liquid Sunshine Organic Orange Juice Natural $3,309.00 $2,036.00

Tahiti Coconut Milk Healthy Choice $2,037.00 $2,189.00
YoYo Smoothies Healthy Choice $4,757.00 $2,808.00
Vita Filtered Water Healthy Choice $4,360.00 $4,795.00
NRG Drink Fitness $3,967.00 $4,664.00
Namaste Iced Teas Natural $4,199.00 $3,416.00
Replenish Water Fitness $3,223.00 $4,826.00
Cool Quencher Fitness $3,755.00 $4,959.00
Very Berry Natural $4,841.00 $4,688.00
Almond Joy Milk Healthy Choice $4,045.00 $4,133.00
Chai Time Teas Natural $5,000.00 $3,210.00
Blueberry Bliss Juice Natural $3,450.00 $3,446.00
Totals $46,943.00 $45,170.00

Number of Types of Beverages 12

Average Number of Beverages Sold In Calgary 3,912
Lowest Number of Beverages Sold in Alberta 2,036
Highest Total Sales Revenue 63,297
Midpoint of Suggested Retail Prices 3
Most common Wholesale Cost 2
 Total
North
South Number of Total Sales
Winnipeg, Total Recycling Charges - Alberta
Toronto, ON Beverages Revenue
MB
Sold
$4,270.00 $2,602.00 $12,217.00 $34,085.43 $176.39
$4,309.00 $4,802.00 $13,337.00 $33,209.13 $139.46
$3,349.00 $4,961.00 $15,875.00 $55,403.75 $249.65
$3,266.00 $3,817.00 $16,238.00 $29,066.02 $302.12
$4,325.00 $2,908.00 $15,864.00 $63,297.36 $284.82
$4,104.00 $2,518.00 $14,237.00 $28,331.63 $251.30
$2,469.00 $3,519.00 $14,037.00 $26,529.93 $265.62
$4,701.00 $2,674.00 $16,089.00 $40,061.61 $287.56
$4,636.00 $4,725.00 $18,890.00 $50,436.30 $314.46
$3,647.00 $4,850.00 $16,675.00 $43,188.25 $269.87
$4,407.00 $3,346.00 $15,963.00 $41,344.17 $270.93
$2,955.00 $3,466.00 $13,317.00 $39,817.83 $227.57
$46,438.00 $44,188.00 $182,739.00 $484,771.41 $3,039.73
Total Recycling % of
Distribution
charges- other % Markup Total Profit Total
charges
provinces Profit

$316.11 1124.82 24.00% $6,597.18 4.17%

$419.11 1095.90 46.47% $10,536.23 6.66%
$382.26 1828.32 44.21% $16,986.25 10.74%
$325.82 959.18 43.20% $8,768.52 5.54%
$332.72 2088.81 76.55% $27,444.72 17.35%
$304.61 934.94 74.56% $12,101.45 7.65%
$275.45 875.49 83.50% $12,071.82 7.63%
$339.25 1322.03 44.77% $12,388.53 7.83%
$430.61 1664.40 39.06% $14,167.50 8.96%
$390.86 1425.21 39.25% $12,172.75 7.69%
$356.64 1364.36 39.25% $11,652.99 7.37%
$295.37 1313.99 50.25% $13,317.00 8.42%
$4,168.80 605.07% $158,204.94 100.00%
 First and Last Names

This Photo by Unknown Author is licensed under CC BY-SA

Team Member #1: Nempal singh

Team Member #2: Inderbir Kooner
Team Member #3: Amanat Kaur Sekhon
 Contributions Tab Colour
(How did you help your team on their worksheets? (SEE STEP 1.2: Each team member should choose
What did each member do within the Project? a different colour: fill this cell with the colour that you
Where you worked together you can use the term chose and change tab colours for worksheets that
"collaboration") you complete)

task 1 t0 4 blue
task 9 to 12 Orange
task 5 to 8 red
Province Salesperson Order Date OrderID Order Amount
Alberta Dodsworth 20-May-22 RT-10716 $ 581.00
Alberta Dodsworth 16-May-22 RT-10705 $ 654.06
Alberta Dodsworth 15-May-22 RT-10703 $ 387.50
Alberta Dodsworth 13-May-22 RT-10701 $ 536.40
Alberta Kamenetz 26-May-22 RT-10730 $ 144.00
Alberta Kamenetz 23-May-22 RT-10725 $ 717.60
Alberta Kamenetz 22-May-22 RT-10724 $ 1,503.60
Alberta Kamenetz 22-May-22 RT-10725 $ 147.00
Alberta Kamenetz 21-May-22 RT-10718 $ 287.80
Alberta Kamenetz 15-May-22 RT-10704 $ 539.50
Alberta Kamenetz 12-May-22 RT-10699 $ 240.40
Alberta Kamenetz 7-May-22 RT-10692 $ 6,375.00
Alberta Kamenetz 5-May-22 RT-10687 $ 560.00
Alberta Kamenetz 4-May-22 OL-10680 $ 2,775.05
Alberta Kamenetz 4-May-22 RT-10683 $ 346.56
Alberta Kamenetz 2-May-22 RT-10673 $ 889.70
Alberta Kamenetz 2-May-22 RT-10675 $ 291.84
Alberta Kamenetz 1-May-22 RT-10671 $ 1,130.40
Alberta Millar 21-May-22 RT-10720 $ 2,942.81
Alberta Millar 18-May-22 RT-10710 $ 86.50
Alberta Millar 13-May-22 RT-10700 $ 8,623.45
Alberta Millar 4-May-22 RT-10684 $ 1,692.00
Alberta Waller 30-May-22 RT-10735 $ 342.00
Alberta Waller 19-May-22 RT-10714 $ 30.00
British Columbia Suyama 31-May-22 RT-10737 $ 442.00
British Columbia Suyama 19-May-22 RT-10715 $ 74.40
British Columbia Suyama 10-May-22 RT-10697 $ 1,990.00
British Columbia Suyama 7-May-22 RT-10690 $ 259.50
British Columbia Suyama 4-May-22 RT-10681 $ 1,031.70
British Columbia Suyama 1-May-22 RT-10670 $ 848.70
Manitoba Davolio 27-May-22 RT-10731 $ 498.50
Manitoba Davolio 16-May-22 RT-10706 $ 601.83
Manitoba Davolio 14-May-22 RT-10702 $ 1,444.80
Manitoba Davolio 1-May-22 RT-10672 $ 480.00
Manitoba Dilfer 29-May-22 RT-10732 $ 2,097.60
Manitoba Dilfer 26-May-22 RT-10728 $ 862.50
Manitoba Dilfer 26-May-22 RT-10729 $ 420.00
Manitoba Dilfer 18-May-22 RT-10713 $ 1,303.19
Manitoba Dilfer 18-May-22 RT-10711 $ 471.20
Manitoba Dilfer 17-May-22 OL-10707 $ 4,666.94
Manitoba Dilfer 17-May-22 RT-10709 $ 2,775.00
Manitoba Dilfer 17-May-22 RT-10708 $ 166.00
Manitoba Dilfer 10-May-22 RT-10698 $ 240.10
Manitoba Dilfer 9-May-22 RT-10696 $ 10,191.70
Manitoba Dilfer 8-May-22 RT-10694 $ 982.00
Manitoba Dilfer 7-May-22 RT-10691 $ 317.75
Manitoba Dilfer 6-May-22 RT-10689 $ 1,893.00
Manitoba Dilfer 4-May-22 RT-10685 $ 1,197.95
Manitoba Dilfer 2-May-22 RT-10676 $ 295.38
Nunavit Tsai 29-May-22 RT-10734 $ 975.00
Nunavit Tsai 29-May-22 RT-10733 $ 412.35
Nunavit Tsai 6-May-22 RT-10688 $ 1,119.90
Nunavit Tsai 2-May-22 RT-10674 $ 139.80
Ontario Manjoo 31-May-22 RT-10736 $ 1,176.00
Ontario Sadri 26-May-22 RT-10727 $ 464.00
Ontario Sadri 22-May-22 RT-10722 $ 1,488.80
Ontario Sadri 21-May-22 RT-10717 $ 48.00
Saskatchewan Bylas 31-May-22 RT-10739 $ 1,500.00
Saskatchewan Bylas 31-May-22 RT-10740 $ 112.00
Saskatchewan Bylas 25-May-22 RT-10726 $ 645.00
Saskatchewan Bylas 8-May-22 RT-10695 $ 3,471.68
Saskatchewan Bylas 3-May-22 RT-10678 $ 2,684.40
Saskatchewan Bylas 3-May-22 OL-10677 $ 1,193.01
Saskatchewan Bylas 3-May-22 RT-10679 $ 243.18
Saskatchewan Heuer 22-May-22 RT-10721 $ 2,490.50
Saskatchewan Heuer 21-May-22 RT-10719 $ 3,597.90
Saskatchewan Heuer 18-May-22 RT-10712 $ 735.00
Saskatchewan Heuer 7-May-22 RT-10693 $ 1,850.00
Saskatchewan Heuer 5-May-22 RT-10686 $ 636.00
Saskatchewan Heuer 4-May-22 RT-10682 $ 417.20
Average $ 1,325.37
Ship Date Delay
5/23/2022 3
5/20/2022 4
5/17/2022 2
5/15/2022 2
6/1/2022 6
5/26/2022 3
5/26/2022 4
5/24/2022 2
5/25/2022 4
5/19/2022 4
5/14/2022 2
5/10/2022 3
5/7/2022 2
5/7/2022 3
5/8/2022 4
5/8/2022 6
5/4/2022 2
5/6/2022 5
5/24/2022 3
5/22/2022 4
5/18/2022 5
5/7/2022 3
6/5/2022 6
5/23/2022 4
6/4/2022 4
5/22/2022 3
5/13/2022 3
5/9/2022 2
5/10/2022 6
5/7/2022 6
5/29/2022 2
5/20/2022 4
5/18/2022 4
5/6/2022 5
6/4/2022 6
5/30/2022 4
5/31/2022 5
5/21/2022 3
5/24/2022 6
5/20/2022 3
5/22/2022 5
5/22/2022 5
5/15/2022 5
5/12/2022 3
5/13/2022 5
5/11/2022 4
5/9/2022 3
5/8/2022 4
5/5/2022 3
5/31/2022 2
6/3/2022 5
5/8/2022 2
5/6/2022 4
6/3/2022 3
5/30/2022 4
5/25/2022 3
5/27/2022 6
6/4/2022 4
6/2/2022 2
5/27/2022 2
5/11/2022 3
5/8/2022 5
5/7/2022 4
5/6/2022 3
5/26/2022 4
5/26/2022 5
5/21/2022 3
5/9/2022 2
5/11/2022 6
5/6/2022 2
3.8
Province Salesperson Order Date OrderID Order Amount Ship Date Dela
Alberta Walker 1-Jun-22 RT-10742 $ 2,169.00 6/04/22
Alberta Walker 22-Feb-22 RT-10534 $ 2,761.94 2/24/22
Alberta Walker 3-Jan-22 RT-10414 $ 1,930.40 1/08/22
Average $ 2,287.11
 Ship Date Delay
0 6/04/22 3
4 2/24/22 2
0 1/08/22 5
1 3.3
 First Name Last Name Province Regional Office Total Annual Sales
Fred Davolio Manitoba Brandon $ 100,000
Shelly Dilfer Manitoba Brandon $ 120,000
Tracy Dodsworth Alberta Calgary $ 75,000
Calvin Heuer Saskatchewan Thunder Bay $ 89,000
Jeff Kamenetz Alberta Calgary $ 130,000
Nadine Manjoo Ontario Thunder Bay $ 140,000
Debbie Millar Alberta Calgary $ 105,600
Don Sadri Ontario Thunder Bay $ 98,000
Kerry Suyama British Columbia Victoria $ 147,000
Allison Tsai Nunavit Brandon $ 120,000
Mary Walker Alberta Calgary $ 97,000
James Waller Alberta Calgary $ 87,000
Ebony Bylas Saskatchewan Thunder Bay $ 99,990
 Sales Bonus Annual Salary Cost of Living Increase Total Income 2022
No Bonus $ 57,600 $1,641.60 $ 59,242
$ 2,000 $ 62,400 $1,747.20 $ 66,147
No Bonus $ 62,400 $1,747.20 $ 64,147
No Bonus $ 73,200 $1,976.40 $ 75,176
$ 3,000 $ 57,600 $1,641.60 $ 62,242
$ 4,000 $ 62,400 $1,747.20 $ 68,147
$ 560 $ 73,200 $1,976.40 $ 75,736
No Bonus $ 57,600 $1,641.60 $ 59,242
$ 4,700 $ 62,400 $1,747.20 $ 68,847
$ 2,000 $ 62,400 $1,747.20 $ 66,147
No Bonus $ 73,200 $1,976.40 $ 75,176
No Bonus $ 57,600 $1,641.60 $ 59,242
No Bonus $ 73,200 $1,976.40 $ 75,176
Basic Provincial Taxation Full Name Full Name and Province
6398.09 Davolio,Fred Davolio,Fred-Manitoba
7143.90 Dilfer,Shelly Dilfer,Shelly-Manitoba
6414.72 Dodsworth,Tracy Dodsworth,Tracy-Alberta
7893.52 Heuer,Calvin Heuer,Calvin-Saskatchewan
6224.16 Kamenetz,Jeff Kamenetz,Jeff-Alberta
3441.43 Manjoo,Nadine Manjoo,Nadine-Ontario
7573.64 Millar,Debbie Millar,Debbie-Alberta
2991.70 Sadri,Don Sadri,Don-Ontario
3483.67 Suyama,Kerry Suyama,Kerry-British Columbia
2645.89 Tsai,Allison Tsai,Allison-Nunavit
7517.64 Walker,Mary Walker,Mary-Alberta
5924.16 Waller,James Waller,James-Alberta
7893.52 Bylas,Ebony Bylas,Ebony-Saskatchewan
Email
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
PROVINCE - multiple -

Sales Averages PRODUCT

SALESPERSON Almond Joy Milk Blueberry Bliss Juice Chai Time Teas Cool Quencher
Bylas $ 3,598.00
Dodsworth $ 3,016.00
Heuer
Kamenetz
Manjoo $ 3,574.00
Miller
Sadri
Suyama $ 3,224.00
Total Result $ 3,574.00 $ 3,224.00 $ 3,598.00 $ 3,016.00
Liquid Sunshine Organic Orange Juice Namaste IceNRG Drink Replenish Water

$ 2,900.00 $ 3,667.00
$ 4,017.00
$3,258.00
$ 4,140.00

$ 3,458.50 $3,258.00 $ 4,140.00 $ 3,667.00

Tahiti Coconut MilkVery Berry Vita Filtered Water YoYo Smoothies Total Result
$ 3,598.00
$ 3,016.00
$ 3,283.50
$ 4,017.00
$ 2,897.00 $ 3,243.00
$ 2,656.00 $ 3,814.00 $ 3,536.67
$ 3,727.00 $ 3,231.00 $ 3,479.00
$ 4,021.00 $ 3,622.50
$ 3,338.50 $ 3,727.00 $ 2,897.00 $ 3,522.50 $ 3,449.33
PROVINCE2 PROVINCE Sum of TOTAL SALES
Group1 43.74%
Saskatchewan 11.13%
Saskatchewan 11.13%
Manitoba 8.11%
Manitoba 8.11%
Ontario 37.02%
Ontario 37.02%
(empty)
(empty)
Total Result 100.00%
 PROVINCE SALESPERSON PRODUCT 1st QTR
British Columbia Heuer Liquid Sunshine Organic Orange Juice $ 868.00
British Columbia Suyama Tahiti Coconut Milk $ 1,267.00
British Columbia Miller YoYo Smoothies $ 617.00
British Columbia Manjoo Vita Filtered Water $ 418.00
British Columbia Miller NRG Drink $ 1,052.00
British Columbia Manjoo Namaste Iced Teas $ 964.00
Alberta Suyama Blueberry Bliss Juice $ 582.00
Alberta Heuer Replenish Water $ 677.00
Alberta Dodsworth Cool Quencher $ 908.00
Alberta Manjoo Almond Joy Milk $ 862.00
Alberta Bylas Chai Time Teas $ 791.00
Alberta Sadri Very Berry $ 863.00
Alberta Kamenetz Liquid Sunshine Organic Orange Juice $ 1,270.00
Alberta Miller Tahiti Coconut Milk $ 617.00
Alberta Sadri YoYo Smoothies $ 837.00
Saskatchewan Dodsworth Vita Filtered Water $ 906.00
Saskatchewan Miller NRG Drink $ 548.00
Saskatchewan Dilfer Namaste Iced Teas $ 870.00
Saskatchewan Manjoo Replenish Water $ 537.00
Manitoba Kamenetz Cool Quencher $ 930.00
Manitoba Sadri Almond Joy Milk $ 985.00
Manitoba Heuer Chai Time Teas $ 418.00
Ontario Differ Blueberry Bliss Juice $ 582.00
Ontario Differ Liquid Sunshine Organic Orange Juice $ 842.00
Ontario Manjoo Tahiti Coconut Milk $ 692.00
Ontario Suyama YoYo Smoothies $ 711.00
Ontario Sadri Vita Filtered Water $ 942.00
Ontario Dilfer NRG Drink $ 840.00
Ontario Sadri Namaste Iced Teas $ 1,271.00
Ontario Sadri Replenish Water $ 545.00
Ontario Dilfer Cool Quencher $ 592.00
Ontario Kamenetz Almond Joy Milk $ 550.00
Ontario Miller Chai Time Teas $ 1,130.00
Ontario Manjoo Blueberry Bliss Juice $ 977.00
Ontario Manjoo Blueberry Bliss Juice $ 977.00
 2nd QTR 3rd QTR 4th QTR TOTAL SALES
$ 976.00 $ 541.00 $ 515.00 $ 2,900.00
$ 668.00 $ 965.00 $ 1,121.00 $ 4,021.00
$ 1,164.00 $ 773.00 $ 1,260.00 $ 3,814.00
$ 415.00 $ 852.00 $ 1,212.00 $ 2,897.00
$ 1,074.00 $ 877.00 $ 1,137.00 $ 4,140.00
$ 681.00 $ 451.00 $ 1,162.00 $ 3,258.00
$ 1,183.00 $ 576.00 $ 883.00 $ 3,224.00
$ 716.00 $ 1,064.00 $ 1,210.00 $ 3,667.00
$ 1,089.00 $ 464.00 $ 555.00 $ 3,016.00
$ 847.00 $ 1,151.00 $ 714.00 $ 3,574.00
$ 1,031.00 $ 1,021.00 $ 755.00 $ 3,598.00
$ 1,175.00 $ 1,240.00 $ 449.00 $ 3,727.00
$ 1,096.00 $ 877.00 $ 774.00 $ 4,017.00
$ 668.00 $ 762.00 $ 609.00 $ 2,656.00
$ 1,299.00 $ 569.00 $ 526.00 $ 3,231.00
$ 1,214.00 $ 463.00 $ 462.00 $ 3,045.00
$ 1,189.00 $ 847.00 $ 613.00 $ 3,197.00
$ 883.00 $ 1,064.00 $ 1,171.00 $ 3,988.00
$ 770.00 $ 932.00 $ 690.00 $ 2,929.00
$ 913.00 $ 1,099.00 $ 1,127.00 $ 4,069.00
$ 681.00 $ 645.00 $ 921.00 $ 3,232.00
$ 476.00 $ 581.00 $ 819.00 $ 2,294.00
$ 1,183.00 $ 576.00 $ 883.00 $ 3,224.00
$ 1,062.00 $ 1,251.00 $ 401.00 $ 3,556.00
$ 533.00 $ 755.00 $ 1,038.00 $ 3,018.00
$ 1,063.00 $ 572.00 $ 453.00 $ 2,799.00
$ 410.00 $ 1,207.00 $ 1,294.00 $ 3,853.00
$ 673.00 $ 751.00 $ 1,138.00 $ 3,402.00
$ 1,048.00 $ 874.00 $ 1,125.00 $ 4,318.00
$ 1,009.00 $ 1,097.00 $ 451.00 $ 3,102.00
$ 536.00 $ 1,174.00 $ 751.00 $ 3,053.00
$ 1,292.00 $ 1,286.00 $ 674.00 $ 3,802.00
$ 1,022.00 $ 987.00 $ 1,163.00 $ 4,302.00
$ 482.00 $ 681.00 $ 538.00 $ 2,678.00
$ 482.00 $ 681.00 $ 538.00 $ 2,678.00
Product Number SKU Product Category Total Product Sales Salesperson
SKU2359592 Natural $695,721 Davolio
SKU2372983 Healthy Choice $317,695 Dilfer
SKU2372988 Healthy Choice $542,964 Dodsworth
SKU2377712 Healthy Choice $721,965 Heuer
SKU2385533 Fitness $567,478 Tsai
SKU2387611 Natural $675,506 Walker
SKU3101309 Fitness $404,903 Waller
SKU3101648 Healthy Choice $717,217 Bylas
SKU3101971 Healthy Choice $449,560 Dodsworth
SKU3101974 Natural $635,956 Heuer
SKU3105111 Natural $798,928 Kamenetz
SKU3105152 Natural $674,567 Manjoo
SKU3106671 Healthy Choice $611,045 Miller
SKU3106785 Healthy Choice $328,663 Sadri
SKU3106981 Healthy Choice $441,449 Suyama
SKU3107115 Fitness $471,893 Tsai
SKU3113825 Natural $462,924 Davolio
SKU3203483 Fitness $386,418 Dilfer
SKU2439203 Fitness $658,003 Dodsworth
SKU2528345 Healthy Choice $477,543 Heuer
SKU2569876 Natural $770,183 Kamenetz
SKU2749043 Natural $523,251 Manjoo
SKU2789387 Natural $537,729 Bylas
SKU2833783 Healthy Choice $674,619 Miller
SKU2842342 Healthy Choice $679,361 Sadri
SKU3107591 Healthy Choice $470,076 Suyama
SKU9626986 Healthy Choice $735,527 Tsai
SKU9625665 Healthy Choice $583,093 Walker
SKU9669825 Healthy Choice $619,955 Waller
SKU9229489 Fitness $432,154 Bylas
SKU2499229 Natural $505,543 Tsai
SKU2528945 Fitness $556,400 Davolio
SKU2569856 Fitness $535,039 Dilfer
SKU2549249 Healthy Choice $380,757 Dodsworth
SKU2589985 Natural $777,084 Heuer
SKU2899589 Healthy Choice $564,787 Kamenetz
SKU2842942 Healthy Choice $284,925 Tsai
SKU9625596 Healthy Choice $422,035 Walker
SKU9625597 Fitness $689,846 Waller
SKU8659598 Fitness $586,450 Bylas
SKU8678986 Fitness $468,969 Davolio
SKU8678988 Healthy Choice $437,003 Dilfer
SKU8677718 Natural $659,542 Dodsworth
SKU8685566 Fitness $502,434 Heuer
SKU8687611 Healthy Choice $743,084 Kamenetz
SKU6101609 Natural $691,676 Manjoo
SKU6101648 Fitness $619,292 Heuer
SKU6101971 Healthy Choice $679,681 Kamenetz
SKU6101974 Natural $302,757 Manjoo
SKU6105111 Fitness $669,995 Miller
SKU6105158 Healthy Choice $650,144 Sadri
SKU6106671 Natural $348,977 Suyama
SKU6106785 Fitness $651,548 Tsai
SKU6106981 Healthy Choice $765,258 Walker
SKU2322983 Healthy Choice $519,610 Dilfer
SKU2322988 Healthy Choice $687,272 Dodsworth
SKU2322212 Healthy Choice $417,722 Heuer
SKU2382511 Natural $386,369 Walker
SKU3191399 Fitness $317,359 Waller
SKU3191598 Fitness $728,799 Bylas
SKU3191921 Healthy Choice $621,263 Dodsworth
SKU3191929 Natural $412,718 Heuer
SKU3195111 Natural $589,083 Kamenetz
SKU3195152 Natural $761,498 Manjoo
SKU3195521 Healthy Choice $666,733 Miller
SKU3195285 Healthy Choice $362,700 Sadri
SKU3195981 Healthy Choice $430,987 Suyama
SKU3192115 Fitness $379,555 Tsai
SKU3293983 Fitness $482,673 Dilfer
SKU2939293 Fitness $463,231 Dodsworth
SKU2528395 Healthy Choice $753,638 Heuer
SKU2559825 Natural $627,739 Kamenetz
SKU2299993 Natural $643,921 Manjoo
SKU2289382 Natural $615,498 Bylas
SKU2833283 Healthy Choice $348,567 Miller
SKU2892392 Healthy Choice $669,573 Sadri
SKU3192591 Healthy Choice $798,439 Suyama
SKU9525985 Healthy Choice $648,109 Tsai
SKU9525555 Healthy Choice $451,095 Walker
SKU9559825 Healthy Choice $420,187 Waller
SKU9229989 Fitness $751,000 Bylas
SKU2999229 Fitness $442,768 Tsai
SKU2528995 Fitness $311,143 Davolio
SKU2559855 Fitness $582,467 Dilfer
SKU2599299 Healthy Choice $569,055 Dodsworth
SKU2892992 Healthy Choice $511,689 Tsai
SKU9525595 Healthy Choice $287,401 Walker
SKU9525592 Fitness $449,966 Waller
SKU8559598 Fitness $305,507 Bylas
SKU8528985 Fitness $737,673 Davolio
SKU8528988 Healthy Choice $793,628 Dilfer
SKU8522218 Natural $326,232 Dodsworth
SKU8585555 Fitness $680,034 Heuer
SKU8582511 Healthy Choice $556,639 Kamenetz
SKU5191599 Natural $346,059 Manjoo
SKU5191598 Fitness $460,908 Heuer
SKU5191921 Healthy Choice $332,677 Kamenetz
SKU5191929 Natural $719,816 Manjoo
SKU5195111 Fitness $329,482 Miller
SKU5195158 Healthy Choice $345,441 Sadri
SKU5195521 Natural $671,253 Suyama
SKU5195285 Fitness $377,203 Tsai
SKU5195981 Healthy Choice 398987 Walker
Product Category Number of Products Sold
Natural $26
Healthy Choice $46
Fitness $31

Total Sales by Product Category

Salesperson Total Sales Average Sales Natural
Davolio $3,232,830 $538,805 $1,158,645
Dilfer $4,054,533 $506,817 $0
Dodsworth $5,357,879 $535,788 $985,774
Heuer $6,459,294 $587,209 $1,825,758
Kamenetz $5,662,801 $629,200 $2,785,933
Manjoo $4,663,545 $582,943 $4,663,545
Miller $3,300,441 $550,074 $0
Sadri $3,035,882 $505,980 $0
Suyama $3,161,181 $526,864 $1,020,230
Tsai $5,576,238 $506,931 $505,543
Walker $3,969,744 $496,218 $1,061,875
Waller $2,902,216 $483,703 $0
Bylas $4,674,354 $584,294 $1,153,227
Total Sales by Product Category
Healthy Choice Fitness
$0 $2,074,185
$2,067,936 $1,986,597
$3,250,871 $1,121,234
$2,370,868 $2,262,668
$2,876,868 $0
$0 $0
$2,300,964 $999,477
$3,035,882 $0
$2,140,951 $0
$2,180,250 $2,890,445
$2,907,869 $0
$1,040,142 $1,862,074
$717,217 $2,803,910
Current Date: 31-Dec-23
Salesperson Territory Sales Position Dated Hired Salary Total Sales
Fred Davolio Manitoba Inside Sales Representative 6-Mar-16 65,000 106,516
Shelly Dilfer Manitoba Outside Sales Representative 9-Sep-16 47,000 120,480
Tracy Dodsworth Alberta Business Development Specialist 31-Oct-16 75,000 95,742
Calvin Heuer Saskatchewan Business Development Specialist 5-May-19 57,000 112,224
Jeff Kamenetz Alberta Inside Sales Representative 22-Apr-19 65,000 75,306
Nadine Manjoo Ontario Outside Sales Representative 3-Jul-20 45,000 118,906
Debbie Miller Alberta Business Development Specialist 22-Apr-19 54,000 106,921
Don Sadri Ontario Inside Sales Representative 12-Apr-21 68,000 92,046
kerry Suyama British Columbia Inside Sales Representative 27-Dec-16 45,000 103,688
Allison Tsai Ontario Outside Sales Representative 11-Jul-14 67,500 104,429
Mary Walker Alberta Business Development Specialist 24-Jul-12 57,000 82,644
James Waller Alberta Inside Sales Representative 1-Oct-19 65,000 109,767
Ebony Bylas Saskatchewan Outside Sales Representative 18-Mar-19 59,000 83,598

Salary Increases
Inside Sales Representative 3000
Outside Sales Representative 3500
Business Development Specialist 4000
Bonus Increase 3.5%
Standard Increase 1.0%
Years Bonus Bonus
7.8 3.5% 70275
7.3 3.5% 52145
7.2 1.0% 79750
4.7 3.5% 62995
4.7 1.0% 68650
3.5 3.5% 126568
4.7 3.5% 59890
2.7 1.0% 71680
7.0 3.5% 49575
9.5 3.5% 73363
11.4 1.0% 87470
4.3 3.5% 70275
4.8 1.0% 63090
 Business Property Expansion Planning
Amount:
Interest Rates (Apr): 2.75%
Term (Years): 8.00
Monthly Payment:

9 10 11 12
3.00%