Window Help FA ExcelFile Edit View Insert Format Tools Data bo AutoSave OFF D U Home Insert Page Layout Formulas Data Review & Calibri (Body) - 11 AA = = = Paste B IV . S.A. E I View = Wrap Text Merge & Cent Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates &x fx Net Pro II Gross sales were $400,000.00 and customer returns were $60,000.00. Determine the customer return %: customer return % = Net sales = $330,000.00 and customer returns were 20%. Determine gross sales: gross sales = Page 2 The children's department has four salespeople. Calculate the return for each salesperson and for the total department: Customer Salesperson Gross Sales Returns Net Sales Return Jason $ 7,500.00 $ 1,500.00 Allie $ 6,000.00 $ 900.00 Monica 5,500.00 $ 1,100.00 James $ 4,500.00 $ 450.00 Total Dept