In The Green Cells Calculate Commissions As Follows

Please help calculate in Excel Table with step by step and showing formulas. Thanks

In the green cells calculate Commissions as follows: COMMISSIONS = 5% if COGS is between less than or equal to 35% of Sales; 4%if COGS is greater than 35% of Sale but less than or equal to 50%; 3% if COGS is greater than 50% of Sales but less than or equal to60%; 2% if COGS is greater than 60%.DateProductRegionSalesRepCustomerSalesCOGS4/25/2019CommissionsProduct3Region3SalesRep2Customer16$14,046.00$5,337.484/25/2019Product7Region4SalesRep15Customer72$2,504.001,702.724/25/2019Product2Region4SalesRep18Customer71$1,505.00842.804/25/2019Product6Region4SalesRep14Customer884,232.00$2,793.124/25/2019Product3Region4SalesRep3Customer65$5,947.00$3,389.794/25/2019Product1Region8SalesRep6Customer100$5,721.00$3,203.764/25/2019Product10Region8SalesRep16Customer6814,744.004/25/20195,307.84Product7Region2SalesRep1Customer85S4,018.00$2,370.624/25/2019Product10Region5SalesRep6Customer6$6,442.00$4,444.98

Need your ASSIGNMENT done? Use our paper writing service to score good grades and meet your deadlines.


Order a Similar Paper Order a Different Paper