| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||
2 | SALARY PLUS COMMISSION CALCULATOR | |||||||||
3 | ||||||||||
4 | Enter Month: | January | ||||||||
5 | ||||||||||
6 | Employee ID | Sales Representatives | Base Salary | Subsidies and Rewards | Deductions | Commission Computation | Net Salary | |||
7 | Actual Sales | Commission | ||||||||
8 | 1198027 | Jonathan White | $3,637.00 | - | $50.00 | $5,755.00 | $517.95 | $4,104.95 | ||
9 | 1918310 | Jessica Brown | $3,502.00 | - | - | $7,074.00 | $1,061.10 | $4,563.10 | ||
10 | 1697734 | Rachel Martinez | $3,171.00 | $500.00 | $450.00 | $7,656.00 | $1,148.40 | $4,369.40 | ||
11 | 1077684 | David Smith | $3,449.00 | $30.00 | - | $5,679.00 | $511.11 | $3,990.11 | ||
12 | 1449172 | Emily Johnson | $3,624.00 | $10.00 | - | $6,401.00 | $704.11 | $4,338.11 | ||
13 | 1664166 | Sarah Anderson | $3,548.00 | - | - | $6,204.00 | $682.44 | $4,230.44 | ||
14 | 1194437 | Matthew Thompson | $3,481.00 | - | - | $4,242.00 | $127.26 | $3,608.26 | ||
15 | 1288427 | Lauren Wilson | $3,722.00 | $70.00 | - | $6,243.00 | $686.73 | $4,478.73 | ||
16 | 1539232 | Christopher Davis | $3,729.00 | $55.00 | $100.00 | $6,459.00 | $710.49 | $4,394.49 | ||
17 | 1612857 | Michael Williams | $3,077.00 | $10.00 | - | $4,951.00 | $247.55 | $3,334.55 | ||
18 | ||||||||||
19 | Monthly Commission Rate Table | |||||||||
20 | From | To | Rate | |||||||
21 | - | $3,999 | 0.0% | |||||||
22 | $4,000 | $4,499 | 3.0% | |||||||
23 | $4,500 | $4,999 | 5.0% | |||||||
24 | $5,000 | $5,499 | 7.0% | |||||||
25 | $5,500 | $5,999 | 9.0% | |||||||
26 | $6,000 | $6,499 | 11.0% | |||||||
27 | $6,500 | $6,999 | 13.0% | |||||||
28 | $7,000 | $999,999,999 | 15.0% | |||||||
29 | ||||||||||
30 | Employee ID | Sales Rep | Date | Sales ID | Sales Description | Sales Amount | ||||
31 | 1449172 | Jonathan White | 01/01/2023 | 739389 | Glitter Gala Balloons for Jack Smith | $126.00 | ||||
32 | 1449172 | Jonathan White | 01/01/2023 | 243579 | Enchanted Forest Table Runners for Sarah Johnson | $120.00 | ||||
33 | 1539232 | Jessica Brown | 01/01/2023 | 306235 | Sparkling Star Confetti for Emily Williams | $228.00 | ||||
34 | 1664166 | Rachel Martinez | 01/01/2023 | 251094 | Unicorn Horn Party Hats for Michael Brown | $177.00 | ||||
35 | 1539232 | Jessica Brown | 01/01/2023 | 455205 | Tropical Luau Leis for Olivia Davis | $178.00 | ||||
36 | 1288427 | David Smith | 01/01/2023 | 409660 | Vintage Elegance Candle Holders for James Lee | $131.00 | ||||
37 | 1198027 | Emily Johnson | 01/01/2023 | 470679 | Rainbow Ripple Streamers for Sophia Anderson | $278.00 | ||||
38 | 1449172 | Jonathan White | 01/01/2023 | 528255 | Cosmic Glow Party Favors for Ethan Martinez | $133.00 | ||||
39 | 1077684 | Sarah Anderson | 01/01/2023 | 401811 | Mermaid Magic Photo Booth Props for Ava White | $211.00 | ||||
40 | 1918310 | Matthew Thompson | 01/02/2023 | 882464 | Safari Adventure Cupcake Toppers for Liam Harris | $171.00 | ||||
41 | 1697734 | Lauren Wilson | 01/02/2023 | 374067 | Golden Age Wine Glass Charms for Mia Taylor | $127.00 | ||||
42 | 1612857 | Christopher Davis | 01/02/2023 | 763587 | Neon Glowstick Necklaces for Noah Garcia | $271.00 | ||||
43 | 1194437 | Michael Williams | 01/02/2023 | 23834 | Pirate Treasure Chest Piñata for Emma Robinson | $142.00 | ||||
44 | 1449172 | Jonathan White | 01/02/2023 | 831081 | Midnight Masquerade Masks for William Clark | $111.00 | ||||
45 | 1918310 | Matthew Thompson | 01/02/2023 | 680788 | Carnival Candy Buffet Jars for Isabella Scott | $214.00 | ||||
46 | 1288427 | David Smith | 01/02/2023 | 834038 | Hollywood Walk of Fame Banners for Sophia Lewis | $128.00 | ||||
47 | 1697734 | Lauren Wilson | 01/03/2023 | 116449 | Dino Daze Party Plates for Benjamin Turner | $150.00 | ||||
48 | 1539232 | Jessica Brown | 01/03/2023 | 461181 | Vintage Lace Invitations for Charlotte Hall | $221.00 | ||||
49 | 1198027 | Emily Johnson | 01/03/2023 | 78806 | Frozen Wonderland Snowflake Decorations for Daniel Nelson | $259.00 | ||||
50 | 1449172 | Jonathan White | 01/03/2023 | 682001 | Superhero Cape and Mask Sets for Amelia Baker | $269.00 | ||||
51 | 1449172 | Jonathan White | 01/03/2023 | 920830 | Nautical Anchor Balloons for Oliver King | $227.00 | ||||
52 | 1077684 | Sarah Anderson | 01/03/2023 | 599535 | Boho Chic Dreamcatcher Garlands for Harper Green | $228.00 | ||||
53 | 1077684 | Sarah Anderson | 01/03/2023 | 240979 | Magical Wizard Wand Favors for Mia Adams | $262.00 | ||||
54 | 1288427 | David Smith | 01/03/2023 | 644491 | Disco Fever Mirror Ball Centerpieces for Liam Turner | $298.00 | ||||
55 | 1664166 | Rachel Martinez | 01/04/2023 | 266419 | Garden Tea Party Tea Cups for Sophia Walker | $161.00 | ||||
56 | 1697734 | Lauren Wilson | 01/04/2023 | 680808 | Outer Space Rocket Ship Balloons for Jackson Mitchell | $167.00 | ||||
57 | 1664166 | Rachel Martinez | 01/04/2023 | 301401 | Fiesta Maracas and Sombreros for Olivia Perez | $135.00 | ||||
58 | 1077684 | Sarah Anderson | 01/04/2023 | 310972 | Farmyard Friends Balloon Bouquet for Ethan Cook | $175.00 | ||||
59 | 1077684 | Sarah Anderson | 01/04/2023 | 702977 | Princess Crown Cake Toppers for Emma Bailey | $167.00 | ||||
60 | 1539232 | Jessica Brown | 01/04/2023 | 553648 | Sports Fanatic Pennant Flags for Noah Edwards | $196.00 | ||||
61 | 1077684 | Sarah Anderson | 01/04/2023 | 984127 | Egyptian Pharaoh Costume Accessories for Ava Wilson | $260.00 | ||||
62 | 1918310 | Matthew Thompson | 01/04/2023 | 603964 | Wild West Cowboy Boot Cups for Liam Baker | $193.00 | ||||
63 | 1539232 | Jessica Brown | 01/04/2023 | 981418 | Video Game Controller Napkin Rings for Mia White | $167.00 | ||||
64 | 1918310 | Matthew Thompson | 01/04/2023 | 656132 | Hawaiian Tiki Torches for James Martin | $292.00 | ||||
65 | 1664166 | Rachel Martinez | 01/04/2023 | 599417 | Bollywood Bollywood Dance Fans for Olivia Wilson | $262.00 | ||||
66 | 1697734 | Lauren Wilson | 01/04/2023 | 767796 | Under the Sea Jellyfish Lanterns for Sophia Smith | $176.00 | ||||
67 | 1288427 | David Smith | 01/05/2023 | 471935 | Alice in Wonderland Tea Set for Ethan Martinez | $239.00 | ||||
68 | 1539232 | Jessica Brown | 01/05/2023 | 369233 | Medieval Knight Shields for Emma Robinson | $294.00 | ||||
69 | 1664166 | Rachel Martinez | 01/05/2023 | 624272 | Vintage Vinyl Record Coasters for Liam Harris | $251.00 | ||||
70 | 1449172 | Jonathan White | 01/05/2023 | 1303 | Hollywood Red Carpet Runner for Ava Taylor | $162.00 | ||||
71 | 1077684 | Sarah Anderson | 01/05/2023 | 802152 | Robot Invasion Tableware for Noah Garcia | $200.00 | ||||
72 | 1288427 | David Smith | 01/05/2023 | 927847 | Parisian Eiffel Tower Centerpieces for Mia Lewis | $170.00 | ||||
73 | 1664166 | Rachel Martinez | 01/05/2023 | 560361 | Woodland Creatures Favor Bags for Benjamin Turner | $202.00 | ||||
74 | 1918310 | Matthew Thompson | 01/05/2023 | 26323 | Pirate Skull and Crossbones Balloons for Charlotte Hall | $118.00 | ||||
75 | 1918310 | Matthew Thompson | 01/05/2023 | 971383 | Circus Carnival Ticket Invitations for Daniel Nelson | $110.00 | ||||
76 | 1918310 | Matthew Thompson | 01/05/2023 | 551213 | Superhero Cityscape Backdrops for Amelia Baker | $167.00 | ||||
77 | 1697734 | Lauren Wilson | 01/05/2023 | 743555 | Enchanted Castle Cake Stand for Oliver King | $188.00 | ||||
78 | 1449172 | Jonathan White | 01/06/2023 | 416886 | Rock 'n' Roll Guitar Inflatable for Harper Green | $147.00 | ||||
79 | 1077684 | Sarah Anderson | 01/06/2023 | 967844 | Safari Jeep Photo Stand-In for Mia Adams | $298.00 | ||||
80 | 1288427 | David Smith | 01/06/2023 | 577309 | Fiesta Cactus Cupcake Wrappers for Liam Turner | $127.00 | ||||
81 | 1918310 | Matthew Thompson | 01/06/2023 | 540055 | Hawaiian Hula Skirt and Lei Sets for Sophia Walker | $251.00 | ||||
82 | 1077684 | Sarah Anderson | 01/06/2023 | 999650 | Unicorn Rainbow Tutu Dresses for Jackson Mitchell | $201.00 | ||||
83 | 1449172 | Jonathan White | 01/06/2023 | 753575 | Space Explorer Astronaut Helmets for Olivia Perez | $159.00 | ||||
84 | 1449172 | Jonathan White | 01/06/2023 | 118826 | Medieval Dragon Party Cups for Ethan Cook | $229.00 | ||||
85 | 1697734 | Lauren Wilson | 01/06/2023 | 709491 | Disco Fever Platform Shoes for Emma Bailey | $112.00 | ||||
86 | 1449172 | Jonathan White | 01/06/2023 | 442363 | Hollywood Walk of Fame Star Plates for Noah Edwards | $236.00 | ||||
87 | 1449172 | Jonathan White | 01/06/2023 | 244332 | Pirate Treasure Map Tablecloths for Ava Wilson | $228.00 | ||||
88 | 1697734 | Lauren Wilson | 01/07/2023 | 441285 | Dinosaur Dino Egg Piñata for Liam Baker | $183.00 | ||||
89 | 1612857 | Christopher Davis | 01/07/2023 | 990454 | Carnival Popcorn Boxes for Mia White | $100.00 | ||||
90 | 1198027 | Emily Johnson | 01/07/2023 | 907749 | Vintage Typewriter Guestbook for James Martin | $108.00 | ||||
91 | 1194437 | Michael Williams | 01/07/2023 | 463518 | Arabian Nights Magic Lamps for Olivia Wilson | $158.00 | ||||
92 | 1664166 | Rachel Martinez | 01/07/2023 | 14908 | Enchanted Forest Moss Table Skirt for Sophia Smith | $175.00 | ||||
93 | 1288427 | David Smith | 01/08/2023 | 924279 | Superhero Shield Wall Decals for Ethan Martinez | $299.00 | ||||
94 | 1612857 | Christopher Davis | 01/08/2023 | 156184 | Nautical Sailor Hat Party Favors for Emma Robinson | $247.00 | ||||
95 | 1288427 | David Smith | 01/08/2023 | 613420 | Fiesta Maracas Cake Pops for Liam Harris | $235.00 | ||||
96 | 1194437 | Michael Williams | 01/08/2023 | 976958 | Farmyard Animal Face Masks for Ava Taylor | $231.00 | ||||
97 | 1288427 | David Smith | 01/08/2023 | 838462 | Princess Tiara Napkin Rings for Benjamin Turner | $240.00 | ||||
98 | 1539232 | Jessica Brown | 01/08/2023 | 639633 | Sports Fanatic Foam Fingers for Charlotte Hall | $157.00 | ||||
99 | 1077684 | Sarah Anderson | 01/08/2023 | 129432 | Egyptian Pyramid Centerpieces for Daniel Nelson | $167.00 | ||||
100 | 1539232 | Jessica Brown | 01/08/2023 | 504810 | Wild West Cowboy Bandanas for Amelia Baker | $100.00 | ||||