| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||
2 | REVENUE-BASED COMMISSION CALCULATOR | ||||||||
3 | |||||||||
4 | |||||||||
5 | Company Name | Covered Period | |||||||
6 | XYZ Corp. | Start Date: | End Date: | ||||||
7 | 01/02/2019 | 10/04/2024 | |||||||
8 | |||||||||
9 | |||||||||
10 | Sales Representatives | Base Salary | Subsidies/ Deductions | Sales Amount | Commission Amount | Net Salary | |||
11 | Jonathan White | $3,637.00 | - | $48,700.00 | $1,779.56 | $5,416.56 | |||
12 | Jessica Brown | $3,502.00 | - | $53,704.00 | $2,186.05 | $5,688.05 | |||
13 | Rachel Martinez | $3,171.00 | $500.00 | $44,804.00 | $1,866.51 | $5,537.51 | |||
14 | David Smith | $3,449.00 | -$30.00 | $43,690.00 | $1,847.05 | $5,266.05 | |||
15 | Emily Johnson | $3,624.00 | $10.00 | $40,504.00 | $1,450.85 | $5,084.85 | |||
16 | Sarah Anderson | $3,548.00 | - | $37,703.00 | $1,504.74 | $5,052.74 | |||
17 | Matthew Thompson | $3,481.00 | - | $54,443.00 | $2,070.93 | $5,551.93 | |||
18 | Lauren Wilson | $3,722.00 | $70.00 | $59,501.00 | $2,438.09 | $6,230.09 | |||
19 | Christopher Davis | $3,729.00 | -$55.00 | $35,146.00 | $1,182.93 | $4,856.93 | |||
20 | Michael Williams | $3,077.00 | $10.00 | $35,243.00 | $1,467.17 | $4,554.17 | |||
21 | |||||||||
22 | Sales Description | Sales Rep | Date won | Sales Amount | Commission Rate | Commission Amount | |||
23 | Glitter Gala Balloons for Jack Smith | Jonathan White | 03/27/2023 | $1,100.00 | 2.00% | $22.00 | |||
24 | Enchanted Forest Table Runners for Sarah Johnson | Jonathan White | 12/09/2020 | $1,646.00 | 6.00% | $98.76 | |||
25 | Sparkling Star Confetti for Emily Williams | Jessica Brown | 04/19/2021 | $1,008.00 | 4.00% | $40.32 | |||
26 | Unicorn Horn Party Hats for Michael Brown | Rachel Martinez | 04/25/2022 | $1,073.00 | 5.00% | $53.65 | |||
27 | Tropical Luau Leis for Olivia Davis | Jessica Brown | 05/13/2023 | $1,894.00 | 5.00% | $94.70 | |||
28 | Vintage Elegance Candle Holders for James Lee | David Smith | 10/03/2022 | $1,433.00 | 3.00% | $42.99 | |||
29 | Rainbow Ripple Streamers for Sophia Anderson | Emily Johnson | 04/05/2023 | $1,461.00 | 3.00% | $43.83 | |||
30 | Cosmic Glow Party Favors for Ethan Martinez | Jonathan White | 04/19/2020 | $1,840.00 | 3.00% | $55.20 | |||
31 | Mermaid Magic Photo Booth Props for Ava White | Sarah Anderson | 04/08/2023 | $1,335.00 | 4.00% | $53.40 | |||
32 | Safari Adventure Cupcake Toppers for Liam Harris | Matthew Thompson | 04/23/2021 | $1,886.00 | 5.00% | $94.30 | |||
33 | Golden Age Wine Glass Charms for Mia Taylor | Lauren Wilson | 05/02/2020 | $1,949.00 | 1.00% | $19.49 | |||
34 | Neon Glowstick Necklaces for Noah Garcia | Christopher Davis | 08/02/2020 | $1,346.00 | 2.00% | $26.92 | |||
35 | Pirate Treasure Chest Piñata for Emma Robinson | Michael Williams | 03/01/2022 | $1,997.00 | 4.00% | $79.88 | |||
36 | Midnight Masquerade Masks for William Clark | Jonathan White | 01/31/2022 | $1,864.00 | 3.00% | $55.92 | |||
37 | Carnival Candy Buffet Jars for Isabella Scott | Matthew Thompson | 11/23/2020 | $1,922.00 | 4.00% | $76.88 | |||
38 | Hollywood Walk of Fame Banners for Sophia Lewis | David Smith | 01/10/2020 | $1,840.00 | 3.00% | $55.20 | |||
39 | Dino Daze Party Plates for Benjamin Turner | Lauren Wilson | 04/11/2020 | $1,467.00 | 6.00% | $88.02 | |||
40 | Vintage Lace Invitations for Charlotte Hall | Jessica Brown | 04/17/2020 | $1,995.00 | 5.00% | $99.75 | |||
41 | Frozen Wonderland Snowflake Decorations for Daniel Nelson | Emily Johnson | 08/06/2022 | $1,434.00 | 2.00% | $28.68 | |||
42 | Superhero Cape and Mask Sets for Amelia Baker | Jonathan White | 10/31/2020 | $1,939.00 | 1.00% | $19.39 | |||
43 | Nautical Anchor Balloons for Oliver King | Jonathan White | 07/30/2021 | $1,234.00 | 4.00% | $49.36 | |||
44 | Boho Chic Dreamcatcher Garlands for Harper Green | Sarah Anderson | 01/20/2020 | $1,399.00 | 3.00% | $41.97 | |||
45 | Magical Wizard Wand Favors for Mia Adams | Sarah Anderson | 04/13/2020 | $1,212.00 | 6.00% | $72.72 | |||
46 | Disco Fever Mirror Ball Centerpieces for Liam Turner | David Smith | 06/27/2023 | $1,719.00 | 7.00% | $120.33 | |||
47 | Garden Tea Party Tea Cups for Sophia Walker | Rachel Martinez | 07/13/2023 | $1,464.00 | 6.00% | $87.84 | |||
48 | Outer Space Rocket Ship Balloons for Jackson Mitchell | Lauren Wilson | 10/06/2021 | $1,631.00 | 7.00% | $114.17 | |||
49 | Fiesta Maracas and Sombreros for Olivia Perez | Rachel Martinez | 09/18/2022 | $1,569.00 | 4.00% | $62.76 | |||
50 | Farmyard Friends Balloon Bouquet for Ethan Cook | Sarah Anderson | 02/04/2021 | $1,553.00 | 6.00% | $93.18 | |||
51 | Princess Crown Cake Toppers for Emma Bailey | Sarah Anderson | 06/25/2023 | $1,179.00 | 3.00% | $35.37 | |||
52 | Sports Fanatic Pennant Flags for Noah Edwards | Jessica Brown | 08/30/2021 | $1,242.00 | 6.00% | $74.52 | |||
53 | Egyptian Pharaoh Costume Accessories for Ava Wilson | Sarah Anderson | 11/22/2020 | $1,522.00 | 1.00% | $15.22 | |||
54 | Wild West Cowboy Boot Cups for Liam Baker | Matthew Thompson | 02/06/2022 | $1,495.00 | 3.00% | $44.85 | |||
55 | Video Game Controller Napkin Rings for Mia White | Jessica Brown | 06/27/2022 | $1,856.00 | 5.00% | $92.80 | |||
56 | Hawaiian Tiki Torches for James Martin | Matthew Thompson | 09/08/2020 | $1,653.00 | 1.00% | $16.53 | |||
57 | Bollywood Bollywood Dance Fans for Olivia Wilson | Rachel Martinez | 02/04/2020 | $1,640.00 | 7.00% | $114.80 | |||
58 | Under the Sea Jellyfish Lanterns for Sophia Smith | Lauren Wilson | 10/04/2020 | $1,485.00 | 7.00% | $103.95 | |||
59 | Alice in Wonderland Tea Set for Ethan Martinez | David Smith | 05/25/2022 | $1,443.00 | 7.00% | $101.01 | |||
60 | Medieval Knight Shields for Emma Robinson | Jessica Brown | 09/15/2023 | $1,072.00 | 1.00% | $10.72 | |||
61 | Vintage Vinyl Record Coasters for Liam Harris | Rachel Martinez | 08/13/2022 | $1,267.00 | 6.00% | $76.02 | |||
62 | Hollywood Red Carpet Runner for Ava Taylor | Jonathan White | 05/31/2020 | $1,530.00 | 5.00% | $76.50 | |||
63 | Robot Invasion Tableware for Noah Garcia | Sarah Anderson | 11/20/2022 | $1,403.00 | 3.00% | $42.09 | |||
64 | Parisian Eiffel Tower Centerpieces for Mia Lewis | David Smith | 12/26/2020 | $1,068.00 | 3.00% | $32.04 | |||
65 | Woodland Creatures Favor Bags for Benjamin Turner | Rachel Martinez | 07/10/2020 | $1,032.00 | 5.00% | $51.60 | |||
66 | Pirate Skull and Crossbones Balloons for Charlotte Hall | Matthew Thompson | 07/13/2021 | $1,092.00 | 3.00% | $32.76 | |||
67 | Circus Carnival Ticket Invitations for Daniel Nelson | Matthew Thompson | 07/12/2020 | $1,425.00 | 1.00% | $14.25 | |||
68 | Superhero Cityscape Backdrops for Amelia Baker | Matthew Thompson | 04/02/2023 | $1,001.00 | 1.00% | $10.01 | |||
69 | Enchanted Castle Cake Stand for Oliver King | Lauren Wilson | 07/16/2020 | $1,698.00 | 4.00% | $67.92 | |||
70 | Rock 'n' Roll Guitar Inflatable for Harper Green | Jonathan White | 06/12/2020 | $1,332.00 | 4.00% | $53.28 | |||
71 | Safari Jeep Photo Stand-In for Mia Adams | Sarah Anderson | 02/17/2022 | $1,112.00 | 2.00% | $22.24 | |||
72 | Fiesta Cactus Cupcake Wrappers for Liam Turner | David Smith | 05/31/2022 | $1,937.00 | 3.00% | $58.11 | |||
73 | Hawaiian Hula Skirt and Lei Sets for Sophia Walker | Matthew Thompson | 03/20/2023 | $1,750.00 | 5.00% | $87.50 | |||
74 | Unicorn Rainbow Tutu Dresses for Jackson Mitchell | Sarah Anderson | 10/06/2023 | $1,507.00 | 2.00% | $30.14 | |||
75 | Space Explorer Astronaut Helmets for Olivia Perez | Jonathan White | 10/12/2022 | $1,072.00 | 4.00% | $42.88 | |||
76 | Medieval Dragon Party Cups for Ethan Cook | Jonathan White | 02/04/2023 | $1,876.00 | 4.00% | $75.04 | |||
77 | Disco Fever Platform Shoes for Emma Bailey | Lauren Wilson | 08/27/2021 | $1,335.00 | 7.00% | $93.45 | |||
78 | Hollywood Walk of Fame Star Plates for Noah Edwards | Jonathan White | 05/20/2022 | $1,791.00 | 5.00% | $89.55 | |||
79 | Pirate Treasure Map Tablecloths for Ava Wilson | Jonathan White | 07/14/2021 | $1,523.00 | 3.00% | $45.69 | |||
80 | Dinosaur Dino Egg Piñata for Liam Baker | Lauren Wilson | 04/26/2020 | $1,055.00 | 2.00% | $21.10 | |||
81 | Carnival Popcorn Boxes for Mia White | Christopher Davis | 03/12/2022 | $1,550.00 | 5.00% | $77.50 | |||
82 | Vintage Typewriter Guestbook for James Martin | Emily Johnson | 09/05/2021 | $1,020.00 | 4.00% | $40.80 | |||
83 | Arabian Nights Magic Lamps for Olivia Wilson | Michael Williams | 02/03/2021 | $1,747.00 | 4.00% | $69.88 | |||
84 | Enchanted Forest Moss Table Skirt for Sophia Smith | Rachel Martinez | 02/06/2020 | $1,881.00 | 2.00% | $37.62 | |||
85 | Superhero Shield Wall Decals for Ethan Martinez | David Smith | 06/30/2020 | $1,371.00 | 4.00% | $54.84 | |||
86 | Nautical Sailor Hat Party Favors for Emma Robinson | Christopher Davis | 02/26/2021 | $1,373.00 | 6.00% | $82.38 | |||
87 | Fiesta Maracas Cake Pops for Liam Harris | David Smith | 01/22/2023 | $1,468.00 | 2.00% | $29.36 | |||
88 | Farmyard Animal Face Masks for Ava Taylor | Michael Williams | 09/14/2021 | $1,538.00 | 5.00% | $76.90 | |||
89 | Princess Tiara Napkin Rings for Benjamin Turner | David Smith | 10/18/2021 | $1,957.00 | 4.00% | $78.28 | |||
90 | Sports Fanatic Foam Fingers for Charlotte Hall | Jessica Brown | 12/14/2020 | $1,795.00 | 4.00% | $71.80 | |||
91 | Egyptian Pyramid Centerpieces for Daniel Nelson | Sarah Anderson | 09/16/2023 | $1,491.00 | 4.00% | $59.64 | |||
92 | Wild West Cowboy Bandanas for Amelia Baker | Jessica Brown | 08/17/2023 | $1,674.00 | 2.00% | $33.48 | |||
93 | Video Game Controller Balloons for Oliver King | Michael Williams | 07/28/2022 | $1,416.00 | 3.00% | $42.48 | |||
94 | Hawaiian Tiki Bar Sign for Harper Green | Sarah Anderson | 12/03/2020 | $1,074.00 | 7.00% | $75.18 | |||
95 | Bollywood Sari Table Runners for Mia Adams | Lauren Wilson | 03/20/2023 | $1,752.00 | 5.00% | $87.60 | |||
96 | Under the Sea Seashell Plates for Liam Turner | Lauren Wilson | 07/09/2021 | $1,624.00 | 6.00% | $97.44 | |||
97 | Alice in Wonderland Mad Hatter Tea Party Set for Sophia Walker | Sarah Anderson | 08/15/2021 | $1,641.00 | 6.00% | $98.46 | |||
98 | Medieval Knight Sword Swizzle Sticks for Jackson Mitchell | Jessica Brown | 01/03/2020 | $1,808.00 | 2.00% | $36.16 | |||
99 | Vintage Film Reel Garland for Olivia Perez | Rachel Martinez | 09/19/2023 | $1,283.00 | 1.00% | $12.83 | |||
100 | Hollywood Movie Clapperboard Decorations for Ethan Cook | Jonathan White | 04/04/2020 | $1,524.00 | 4.00% | $60.96 | |||