Reconsider the example of choosing the advertising budget at VRX that is presented in Section 1.4. In addition to the VRX2000, VRX also has a higher-end virtual-reality headset, the VRX3000. This model sells for $162 and the variable cost for producing the headset is $2. The quarterly fixed costs associated with the VRX3000 are $505. VRX would like to determine the best level of advertising for the VRX3000. Past data for advertising and sales are given in the table below. Click here for the Excel Data File a. Use Excel to create a scatter plot to help visualize the relationship between Sales and advertising. VRX thinks the same type of square-root relationship between sales and advertising found for the VRX2000 in Section 1.4 applies to the VRX3000 as well, that is, Sales Advertising+b. Using Excel, create a new scatter plot with Sales on the vertical axis and the square root of advertising on the horizontal axis. b. Use Excel's trendline feature to determine the value for a and b that provides the best fit for the prediction formula Sales Advertising+b. Using the prediction formula from part b, build an optimization model to determine the best level of advertising for the VRX3000. Solve the model with Solver. c. What is the best level of advertising and the corresponding estimate for total profit? Complete this question by entering your answers in the tabs below. Use Excel to create a scatter plot to help visualize the relationship between Sales and advertising