This problem should be easier than last weeks but will require a bit of knowledge from the previous lab to complete. a The below table is from a distributor of leading makeup brands. Their Sales Reps earn commission on their sales but receive a different rate of commission if the product is from the Premium' line or Drugstore' line. The Premium' Product Line sales will result in a straight dollar commission (See table 1] on every sale. I.e., a sale of any dollar amount for Chanel will result in a commission of $100.00. The 'Drugstore' Product Line earns commission as a percentage of the Sales Amount (see table 2]. I.e., a sale of $1,000.00 of Nyx product will return $20.00 in commission (1000 x .02). a ) The commission must be calculated in cells F15:F35 for every product sale and should be done in one Excel formula. H | Sales Rep F Commission Check J K Premium Chanel $100.00 MAC $150.00 Dior $125.00 Too Faced $110.00 G Expected result... S $ 125.00 $ 125.00 $ 110.00 $ 85.32 $ 144.07 $ 139.36 $ 100.18 S 150.00 $ 218.58 $ 100.00 S 150.00 $ 128.04 $ 125.00 $ 149.73 $ $ 125.00 $ 89.34 $ 110.00 $ 150.00 $ 110.00 $ 121.94 $ 228.00 Drugstore Nyx E.L.F. Wet N Wild L.A.Girl A B D E 14 Date Sales Product Product Line 15 5/17/2010 $8,855.00 Dior Premium Noreen Surrett 16 5/18/2010 $4,771.00 Dior Premium Darren Rosson 17 5/19/2010 $4,290.00 Too Faced Premium Karina Speier 18 5/20/2010 $4,266.00 Nyx Drugstore Jerri Palos 195/21/2010 $5,239.00 L.A.Girl Drugstore Guy Beem 20 5/22/2010 $6,968.00 Nyx Drugstore Erik Barlowe 21 5/23/2010 $4,007.00 Wet N Wi Drugstore Milagros Roots 225/24/2010 $6,969.00 MAC Premium Annabelle Tobler 23 5/25/2010 $7,286.00 E.L.F. Drugstore Hugh Cutchin 24 5/26/2010 $5,613.00 Chanel Premium Guy Elsea 25 5/27/2010 $4,314.00 MAC Premium Karina Heaps 26 5/28/2010 $4,268.00 E.L.F. Drugstore Julianne Billie 27 5/29/2010 $6,384.00 Dior Premium Avis Koury 28 5/30/2010 $5,989.00 Wet N Wi Drugstore Mathew Hindle 29 5/31/2010 $5,356.00 Dior Premium Penelope Kaspar 30 6/1/2010 $2,978.00 E.L.F. Drugstore Carmella Brey 31 6/2/2010 $4,990.00 Too Faced Premium Lakisha River 326/3/2010 $7,401.00 MAC Premium Rosalinda Mansker 33 6/4/2010 $5,543.00 Too Faced Premium Carlene Wiedeman 34 6/5/2010 $6,097.00 Nyx Drugstore Tyrone Rast 35 6/6/2010 $7,600.00 E.L.F. Drugstore Zelma Greek 36 0.02 0.03 0.025 0.0275
