Question

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:

WEEK
AVERAGE WEEKLY GROSS REVENUE ($000)
AVERAGE WEEKLY RADIO ADVERTISING ($000) AVERAGE WEEKLY NEWSPAPER ADVERTISING ($000)
1 60 6 1
2 45 3 3
3 55 4 2
4 70 5 3
5 40 2 1

The Manager uses the multiple regression model in OM Explorer and obtains the following results:

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)?

A) $52,250

B) $26,250

C) $72,750

D) $20,500

Answer

This answer is hidden. It contains 76 characters.