Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the same records as in problem P7, assume that the resort only wants to spend a maximum of $2,000 on a marketing campaign. The

Using the same records as in problem P7, assume that the resort only wants to spend a maximum of $2,000 on a marketing campaign. The cost to reach each customer is $4.50 and the response rate for each customer has been given in the same data file.

1. Formulate and solve three 0-1 LP models, each focused on one of the dimensions: recency of stay, frequency of stay, and money spent in each stay. Each model should seek to identify the segment of resort guests to be reached in order to maximize the expected revenue under budget limitations. Compare the results (expected spending and revenue) of the three models and provide recommendations about future marketing campaigns.

2. Formulate and solve three continuous LP models, each focused on one of the same dimensions: recency, frequency, and monetary value. Each model should seek to identify the percentage of guests in each segment be reached in order to maximize the expected revenue under budget limitations. Compare the expected revenue of the three models and provide recommendations about future marketing campaigns.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management in Practice

Authors: Samuel J. Mantel Jr., Jack R. Meredith, Sco

4th edition

470533013, 978-0470533017

More Books

Students also viewed these General Management questions