Table 8.4 The Furniture Super Mart is a furniture retailer in Evansville, Indiana. The Marketing Manager wants to prepare a media budget based on the next quarter's business plan. The manager wants to decide the mix of radio advertising and newspaper advertising needed to generate varying levels of Weekly Gross Revenue. The manager has collected data for the past five weeks, and has recorded the following average Weekly Gross Revenues and expenditures for Weekly Radio (X1) and Newspaper (X2) advertising: AVERAGE WEEKLY GROSS REVENUE AVERAGE WEEKLY AVERAGE WEEKLY RADIO ADVERTISING NEWSPAPER ADVERTISING WEEK ($000) ($000) ($000) 1 60 6 1 2 45 3 3 3 55 4 2 4 70 40 5 2 5 3 1 The Manager uses the multiple regression model in OM Explorer and obtains the following results: Solver - Regression Analysis R-squared 0.840 R 0.916 Constant 20.5 Standard Error of Estimate 6.755 Trial X1 Value 7 X1 Coefficient 6.500 Trial X2 Value 4 X2 Coefficient 3.750 Trial X3 Value X3 Coefficient 0.000 Trial X4 Value Trial X5 Value X4 Coefficient 0.000 X5 Coefficient 0.000 Predicted Y Value 81.000 Use the information provided in Table 8.4. What is the estimated Weekly Gross Revenue if $4,000 is spent on Radio Advertising (X1) and $7,000 is spent on Newspaper Advertising (X2)? O $72,750 $52,250 $20,500 $26,250