• Suppose that you are the owner of the Original Italian Pizza restaurant chain and would like to predict the sales of your specialty, deep-dish pizza. You have gathered data on the monthly sales of deep-dish pizzas at your restaurants and observations on other potentially relevant variables for each of your 15 outlets in central Indiana. These data are provided in the file “Excel” . Analyze the results in Excel and find the best combination of advertising and pricing to obtain the highest profit. (Variable cost of deep-dish pizza is around $5 per pizza in all your locations.) Explain the analyses you executed and the results you obtained. Please also upload the Excel file containing your analyses.

Transcribed Image Text:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 A Outlet Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 dataset B Quantity Sold 72,300 67,500 56,800 42,800 51,600 71,400 71,400 69,700 69,600 62,900 70,200 52,200 57,100 68,500 65,100 + с D E F G H Average Price Monthly Advertising Expenditures Disposable Income per Household This is fictitious data. $10.14 $42,100 $64,800 $42,800 $10.88 $38,300 $12.33 $58,600 $41,000 $12.70 $46,500 $43,300 $12.29 $50,700 $44,000 $9.79 $60,100 $41,200 $11.26 $55,600 $41,700 $11.23 $57,900 $43,600 $11.97 $52,100 $39,900 $12.07 $60,700 $44,800 $10.68 $64,400 $41,800 $12.49 $55,600 $44,200 $12.36 $60,900 $40,100 $9.96 $47,200 $39,100 $11.77 $46,100 $38,000 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 A Outlet Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 dataset B Quantity Sold 72,300 67,500 56,800 42,800 51,600 71,400 71,400 69,700 69,600 62,900 70,200 52,200 57,100 68,500 65,100 + с D E F G H Average Price Monthly Advertising Expenditures Disposable Income per Household This is fictitious data. $10.14 $42,100 $64,800 $42,800 $10.88 $38,300 $12.33 $58,600 $41,000 $12.70 $46,500 $43,300 $12.29 $50,700 $44,000 $9.79 $60,100 $41,200 $11.26 $55,600 $41,700 $11.23 $57,900 $43,600 $11.97 $52,100 $39,900 $12.07 $60,700 $44,800 $10.68 $64,400 $41,800 $12.49 $55,600 $44,200 $12.36 $60,900 $40,100 $9.96 $47,200 $39,100 $11.77 $46,100 $38,000

Answer rating: 100% (QA)

STEP1 The data on monthly sales of deepdish pizzas are given below Outlet Number Quantity Sold Avera... View the full answer