File Home Insert Page Layout Formulas Data Review View Help JMP AM 270 Assignment 1 (1) Excel Tell me what you want to do Cut Arial 10 A A Wrap Text General Copy Paste Format Painter Clipboard 5 BIU Font A Merge & Center $ % +000 00 + Conditional Format as Formatting Table Alignment 5 Number Styles D12 X fxx A B C D E F G H 3 4 IN CLASS ASSIGNMENT #1: PLEASE SHOW ALL OF YOUR WORK ROUND UP TO TWO DECIMAL POINTS! 5 6 Year 19 % of NS Year 18 % of NS Year 17 % of NS 7 Net Sales (NS) 516.20% 100.00% 468.40% 100.00% 433.00% 8 Cost of Goods Sold 277.00% 53.66% 250.90% 53.57% 227.90% 100.00% 52.63% 9 Gross Margin 239.20% 46.34% 217.50% 46.43% 205.10% 47.37 10 Expenses 175.00% 11 Operating profit 82.20% 33.90% 157.80.% 12.44% 33.68 152.60% 35.24% 59.70% 12.75% 52.50% 12.12% 12 13 According to the above scenario, please answer Q1, Q2, and Q3: 14 15 Q1: Please find out the answers to the above 10 blank cells in order. 16 Q2: If customer return rate was 1%, how much was customer return in dollars for each year? 17 Q3: Based on Q2, how much were gross sales for each year when customer allowances were 0 during each of the three years? 18 19. 20 21 22 23 24 25 26