In the Sales Commission column of the Invoices worksheet, determine the sales commission for each invoice based on the information in the Commission worksheet. An invoice is considered late after 30 days past the invoice date. In the Days Past Due column, create a function that displays 0 if the invoice is not past due. Otherwise, the function should display the number of days past due. Sales Commission Days Past Invoice NumlTInvoice Date Company 10273 5/28/19 Consortium for Ocean Leadership 10282 6/9/19 MRSI Group, Inc 10283 6/12/19 Natural Environment Research Co 10321 5/5/19 Alpharma, Inc 10323 5/8/19 Cardio Tech International Inc. 10329 6/27/19 Image Acoustics, Inc. 10358 6/2/19 Ocean Dynamics Inc. 10370 5/5/19 Materials Sciences Corporation 10401 6/1/19 I. M. A. Dynamite Group, Inc. 10407 2/7/19 Marine BioConversion, LLC 10410 5/10/19 New Medical Center 10413 6/16/19 Advanced Scientific Concepts, Inc. 10418 5/17/19 American Heart Association 10436 5/8/19 Lyme Disease Assoc of NJ 10463 6/6/19 Pro Change Behavior Systems 10471 6/11/19 American Psychology Foundation 10476 6/17/19 CSCS Corp. 10483 5/26/19 Global Environment & Technology Foundation 10500 5/10/19 Perry Institute for Marine Science 10502 5/11/19 Save the Lions 10527 6/5/19 Cape Cod National Seashore NPS 10539 6/16/19 Emitech 10567 6/15/19 Northeast Fisheries Science Center 10571 6/18/19 SAECT 10577 6/26/19 Altuna International Research Co. 10586 5/20/19 BoBell Flavors, Inc 10588 5/28/19 Brossman Engineering 10589 5/29/19 Cadmus Group 10623 6/5/19 Intervet International B.V. 10625 6/6/19 Laser Fare Advanced Technology Group 10667 5/25/19 Northeast Regional Aquaculture Center 10676 6/15/19 Sino Development Corporation Ltd. Sales Rep Johnson Boehmer Lesure Lesure Boehmer Lesure Boehmer Johnson Boehmer Riley Boehmer Lesure Lesure Boehmer Johnson Lesure Riley Lesure Boehmer Johnson Johnson Lesure Invoice Amoun $ 2,142.40 $ 155.40 $ 1,414.80 $ 144.00 $ 164.40 $ 4,819.40 $ 452.00 $ 1,174.00 $ 3,868.60 $ 1,194.00 $ 802.00 $ 2,123.20 $ 1,814.80 $ 2,210.80 $ 713.30 $ 1,328.00 $ 182.40 $ 704.00 $ 550.80 $ 816.30 $ 1,670.00 $ 355.50 $ 3,109.00 $ 647.75 $ 569.00 $ 28.00 $ 3,900.00 $ 72.00 $ 1,429.75 $ 479.75 $ 1,921.00 $ 534.85 Lesure Lesure Lesure Johnson Boehmer Johnson Johnson Lesure Johnson Boehmer In the Sales Commission column of the Invoices worksheet, determine the sales commission for each invoice based on the information in the Commission worksheet. An invoice is considered late after 30 days past the invoice date. In the Days Past Due column, create a function that displays 0 if the invoice is not past due. Otherwise, the function should display the number of days past due. Sales Commission Days Past Invoice NumlTInvoice Date Company 10273 5/28/19 Consortium for Ocean Leadership 10282 6/9/19 MRSI Group, Inc 10283 6/12/19 Natural Environment Research Co 10321 5/5/19 Alpharma, Inc 10323 5/8/19 Cardio Tech International Inc. 10329 6/27/19 Image Acoustics, Inc. 10358 6/2/19 Ocean Dynamics Inc. 10370 5/5/19 Materials Sciences Corporation 10401 6/1/19 I. M. A. Dynamite Group, Inc. 10407 2/7/19 Marine BioConversion, LLC 10410 5/10/19 New Medical Center 10413 6/16/19 Advanced Scientific Concepts, Inc. 10418 5/17/19 American Heart Association 10436 5/8/19 Lyme Disease Assoc of NJ 10463 6/6/19 Pro Change Behavior Systems 10471 6/11/19 American Psychology Foundation 10476 6/17/19 CSCS Corp. 10483 5/26/19 Global Environment & Technology Foundation 10500 5/10/19 Perry Institute for Marine Science 10502 5/11/19 Save the Lions 10527 6/5/19 Cape Cod National Seashore NPS 10539 6/16/19 Emitech 10567 6/15/19 Northeast Fisheries Science Center 10571 6/18/19 SAECT 10577 6/26/19 Altuna International Research Co. 10586 5/20/19 BoBell Flavors, Inc 10588 5/28/19 Brossman Engineering 10589 5/29/19 Cadmus Group 10623 6/5/19 Intervet International B.V. 10625 6/6/19 Laser Fare Advanced Technology Group 10667 5/25/19 Northeast Regional Aquaculture Center 10676 6/15/19 Sino Development Corporation Ltd. Sales Rep Johnson Boehmer Lesure Lesure Boehmer Lesure Boehmer Johnson Boehmer Riley Boehmer Lesure Lesure Boehmer Johnson Lesure Riley Lesure Boehmer Johnson Johnson Lesure Invoice Amoun $ 2,142.40 $ 155.40 $ 1,414.80 $ 144.00 $ 164.40 $ 4,819.40 $ 452.00 $ 1,174.00 $ 3,868.60 $ 1,194.00 $ 802.00 $ 2,123.20 $ 1,814.80 $ 2,210.80 $ 713.30 $ 1,328.00 $ 182.40 $ 704.00 $ 550.80 $ 816.30 $ 1,670.00 $ 355.50 $ 3,109.00 $ 647.75 $ 569.00 $ 28.00 $ 3,900.00 $ 72.00 $ 1,429.75 $ 479.75 $ 1,921.00 $ 534.85 Lesure Lesure Lesure Johnson Boehmer Johnson Johnson Lesure Johnson Boehmer
