A grocery chain wants to promote the sale of a new flavor of ice cream by issuing

Question:

A grocery chain wants to promote the sale of a new flavor of ice cream by issuing up to 15,000 coupons by mail to preferred customers. The bud-get for this promotion has been limited to $12,000. The following table shows the expected increased sales per coupon and the probability of coupon usage for the various coupon amounts under consideration.
A grocery chain wants to promote the sale of a

For example, every $l-off coupon issued will stimulate sales of 1.5 additional cartons. However, since the probability that a $l-off coupon will actually be used is only 0.80, the expected increased sales per coupon issued is 1.2 (= 0.8 X 1.5) cartons.
The selling price per carton of ice cream is $3.50 before the coupon value is applied. The chain wants at least 20% of the coupons issued to be of the $l-off variety and at least 10% of the coupons issued to be of each of the other four varieties. What is the optimal combination of coupons to be issued, and what is the expected net increased revenue from this promotion?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Decision Modeling With Spreadsheets

ISBN: 718

3rd Edition

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

Question Posted: