The WorldCorp sales team uses a Customer Relationship Management (CRM) software to keep track of customer data. It tells them when they should call their customers again, how much the customer has ordered in the past, and other notes about the customer. The sales agents receive a salary, but if their customer orders are over $20,000, they are given an additional 5 percent commission. Use the information and the data in the figure to design a formula that can calculate the total commission the sales agent will receive and an overall total for commissions paid.

Date Item Description Quantity FOBS 5% Commission for sales 3/29/2021 Tablets, 7in 143 $10,582.00 $2,736.00 3/27/2021 Computer Server Accessories 2500 $21,350.00 $3,552.00 3/22/2021 Headphones 542 $26,016.00 $10,140.00 3/21/2021 LED TVs, 55in and 65in 53 $14,575.00 $432.00 3/17/2021 LCD TVs, 32in and 45in 97 $64,505.00 $480.00 3/15/2021 Cellular Phone Accessories 3000 $22,920.00 $30,800.00 3/10/2021 Home Stereo Systems 74 $7,252.00 $10,920.00 3/7/2021 Blu-Ray Players 127 $10,922.00 $768.00 3/5/2021 HDTV Antennas 768 $21,504.00 $18,240.00 1/13/2021 Plasma 65 $855.00 12 $10,260.00 1/13/2021 Headphones $48.00 85 $4,080.00 1/15/2021 Headphones $48.00 158 $7,584.00 1/17/2021 LCD 42 $380.00 55 $20,900.00 1/17/2021 Headphones $48.00 115 $5,520.00 1/21/2021 Plasma 65 $855.00 11 $9,405.00 1/22/2021 Headphones $48.00 15 $720.00 1/25/2021 LCD 42 $380.00 154 $20,520.00 1/27/2021 QLED SS $620.00 10 $6,200.00 1/30/2021 LED 55 $550.00 10 $5,500.00 2/4/2021 LCD 32 $170.00 43 $7,310,00 2/7/2021 OLED 55 $620.00 15 $9,300.00 2/9/2021 OLED 45 $400.00 37 $14,800.00 2/11/2021 Plasma 65 $855.00 34 $29,070.00 2/15/2021 DLP 32 $250.00 97 $24,250.00 2/18/2021 LED 65 $780.00 54 $42,120.00 2/21/2021 LED 55 $550.00 21 $11,550.00 2/25/2021 LCD 42 $380.00 54 $20,520.00 2/27/2021 LCD 32 $170.00 14 $2,380.00