Excel assignment
Keer49
Sharma_e02_grader_hw_Advertise.xlsxGuestData
| 2017 Fiscal Year Guest Survey - Advertisement Results | |||||||||||
| Survey Duration | Months | Year(s) | |||||||||
| 2017 Fiscal Start Date: | 7/1/16 | 2018 Fiscal Start Date: | 7/1/17 | ||||||||
| How did you hear about the Resort? (# Guest Results = # of times a Guest Responded with this answer) | Resort Seasonality | ||||||||||
| M/Year | Month | Season | Magazine | Radio | Television | Internet | Word Of Mouth | Other | Total Surveyed | Month | Season |
| 2016 JUL | 925 | 41 | 1,887 | 1,239 | 422 | 395 | 4,909 | Jan | Low | ||
| 2016 AUG | 660 | 16 | 965 | 406 | 317 | 26 | 2,390 | Feb | Low | ||
| 2016 SEP | 694 | 46 | 928 | 681 | 323 | 46 | 2,718 | Mar | Mid | ||
| 2016 OCT | 304 | 28 | 646 | 568 | 339 | 79 | 1,964 | Apr | Mid | ||
| 2016 NOV | 892 | 46 | 374 | 307 | 266 | 149 | 2,034 | May | Mid | ||
| 2016 DEC | 1,551 | 36 | 247 | 283 | 313 | 138 | 2,568 | Jun | High | ||
| 2017 JAN | 722 | 20 | 837 | 63 | 12 | 12 | 1,666 | Jul | High | ||
| 2017 FEB | 375 | 84 | 819 | 36 | 231 | 79 | 1,624 | Aug | Mid | ||
| 2017 MAR | 1,387 | 113 | 269 | 539 | 315 | 84 | 2,707 | Sep | Low | ||
| 2017 APR | 331 | 50 | 675 | 71 | 149 | 240 | 1,516 | Oct | Low | ||
| 2017 MAY | 1,476 | 119 | 196 | 609 | 25 | 21 | 2,446 | Nov | Low | ||
| 2017 JUN | 1,893 | 14 | 131 | 22 | 358 | 283 | 2,701 | Dec | High | ||
| Total | 11,210 | 613 | 7,974 | 4,824 | 3,070 | 1,552 | 29,243 | ||||
| Average | |||||||||||
AdvertisingPlan
| New Budget Analysis | |||||||||||
| Today's Date | |||||||||||
| Past Year, Monthly Advertising | New Monthly Advertising Negotiation for Next Fiscal Year | ||||||||||
| Type | Cost Per Ad | Ads Placed | Past Guest Results | Amount Spent | Cost per Guest Result | New Budget | New Cost Per Ad | Ads To Place | Amount to Spend | Consider a Change? | Anticipated Guest Results |
| Magazine | $ 1,200 | 3 | $ 4,000 | $ 1,300 | |||||||
| Radio | $ 300 | 1 | $ 300 | $ 325 | |||||||
| Television | $ 5,000 | 1 | $ 12,000 | $ 5,500 | |||||||
| Internet | $ 1,100 | 2 | $ 2,200 | $ 1,200 | |||||||
| Totals | |||||||||||
| Budget +/- | Guest Results +/- | ||||||||||
| Type | Notes | ||||||||||
| Magazine | Lowest Cost per Guest Result, yet same number Ads placed. | ||||||||||
| Radio | Budget no longer supports even one Ad. | ||||||||||
| Television | Budget > than doubled, yet highest Cost per Guest Result. | ||||||||||
| Internet | Budget not increased thus # Ads stayed the same. |
MarketingConsultants
| Hiring Marketing Consultants Analysis | ||||
| Retainer Amount | $ 125,000 | |||
| Term (Years) | 5 | |||
| Monthly Loan Payments | ||||
| Down Payment | ||||
| $ 10,000 | $ 15,000 | $ 20,000 | $ 25,000 | $ 30,000 |
| Annual Rate | 2.0% | |||
| 2.5% | ||||
| 3.0% | ||||
| 3.5% |
