1. Now change all of the dollar amounts in the data area of your worksheet so that it looks like this: 1 Chapter 2: Applying Excel 3 Data 4 Sales 5 Variable costs 6 Cost of goods sold 7Variable selling 8 Variable administrative $19,000 $9,500 1,000 $800 9 Fixed costs 10 Fixed selling 11 Fixed administrative $2,500 1,500 12 If your formulas are correct, you should get the correct answers to the following questions (a) What is the gross margin now? HEWLETT-PACKARD CILLROulT H&MUSA N NetflixPeaks&Pines Mtn V If your formulas are correct, you should get the correct answers to the folloving questions (a) What is the gross margin now? ross margin (b) What is the net operating income now? t operating in (c) What is the contribution margin now? ntribution margin HEWLETT-PACKARD 2. Suppose that sales re 8% higher than the data provided in requirement 1. A. 1 Chapter 2: Applying Excel 3 Data 4 Sales 5 Variable costs $20,520 6 |Cost of goods sold 7 Variable selling 8 Variable administrative 9 Fixed costs: 10 Fixed selling 11 Fixed administrative 12 $10,260 $1,080 $864 $2,500 $1,500 Enter this new data into your worksheet. Make sure you enter all of the new data - not just the sales. (a) What is the gross margin now? ross margin HEWLETT PACKA Enter this new data into your worksheet. Make sure you enter all of the new data -not just the sales. (a) What is the gross margin now? s margn (b) What is the net operating income now? Net operating income (c) What is the contribution margin now? tribution margin HEWLETT-PACKAR UNIVERSITY | (d when sales increase by 8%, which of the following should also increase by 8% in a merchandzing company? rou may select more than one answer. Single click the box w the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer.) variable cost Fxed cost Gross margin Cortributionmagn Net operating income (e) when sales r orease by am, which of he folowing should increase by more than 8% in a merharduro con per y? You may select more than one answer single click the box with the question mark to produce check mark for a corect answer and double click the boa with the question mark to ompry the box ror, wong answer) Fined cost Gross margin Contribution margn Net operaing roome