Solution on excel is needed.. The last column is the Net Pay for each

B C D E F G H Names January Sales Commission on Sales Gross Pay WCB Medical Insurance Federal Tax Total Deductions Amy Paul Stevie Mary Frank Totals Base Salary $2,000 $2,000 $2,000 $2,000 $2,000 $81,250 $95,500 $78,550 $2,000 $2,000 $2,000 $2,000 $2,000 Assumption Table Medical WCB Insurance 6.20% 1.45% Commission Rate 2.00% Federal Tax 20.00%