Grader Hw Advertise Question Description The Painted Paradise Resort and Spa has been inve …

Grader Hw AdvertiseQuestion Description The Painted Paradise Resort and Spa has been investing in advertising using different media. When guests check in, the employee asks them how they heard about Painted Paradise Resort & Spa. Based on the customerÂ’s response, the employee then notes in the system either magazine, radio, television, Internet, word of mouth, or other. Since almost every guest is asked, the number surveyed represents a significant portion of the actual guests. The past yearÂ’s data is located on the GuestData worksheet. Every time a guest answers the question by mentioning an advertising source, it is considered a guest result. Ideally, the resort wants to purchase advertising at a low cost but then see as many guest results from that advertising as possible.Every year, upper management sets the advertising budget before the beginning of the fiscal year, July 1. For the coming year, upper management has given you a larger television budget because of a new video marketing campaign. Also, the advertising contracts get negotiated every year, because the media vendors require a one-year commitment. The contracts are negotiated after the budget has been set. You will develop charts for an upcoming presentation that will discuss a marketing strategy, potential changes to the budget given the new media prices, anticipated monthly guest results, and the prospect of hiring a marketing consulting company with a high retainer that would require a loan.
THE WORD FILE IS JUST AN INSTRUCTIONS. SO YOU DON’T HAVE TO DO ANYTHING ON IT. JUST USE IT AS INSTRUCTION. THE WORK HAS TO BE ON EXCEL FILE.