Michigan Motors Corporation (MMC) has just introduced a new luxury-touring sedan. As part of its promotional campaign, the marketing department has decided to send personalized invitations to test drive the new sedan to two target groups
(1) current owners of an MMC luxury automobile and
(2) owners of luxury cars manufactured by one of MMC's competitors. The cost of sending a personalized invitation to each customer is estimated to be $1 per letter. Based on previous experience with this type of advertising, MMC estimates that 25% of the customers contacted from group 1 and 10% of the customers contacted from group 2 will test drive the new sedan.
As part of this campaign, MMC has set the following goals.
- Goal Get at least 10,000 customers from group 1 to test drive the new sedan
- Goal Get at least 5000 customers from group 2 to test drive the new sedan
- Goal Limit the expense of sending out the invitations to $ 70,000
Assume that goals 1 and 2 are P1 priority level goals and that goal 3 is a P2 priority level goal.
- a. (15 points) Suppose that goals 1 and 2 are equally important; formulate a goal programming model of the MMC problem
- b. (20 points) Use the goal programming computer procedure to solve the model formulated in part (a). Enclose the EXCEL output sheets
- c. (10 points) If management believes that contacting customers from group 2 is twice as important as contacting customers from group 1, what should MMC do?