Linear programming. Please put information in excel solver in the layout i attached after the problem

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 budget 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. 3 4 Coupon Amount Increased sales per coupon (cartons) Probability coupon will be used 5 $1.00 1.5 0.8 6 $0.85 1.4 0.75 7 $0.70 1.25 0.6 8 $0.55 1 0.5 9 $0.40 0.9 0.42 For example, every $1-off coupon issued will stimulate sales of 1.5 additional cartons. However, since the probability that a $1-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. 10 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 $1-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? 11A B C D E F G H H Problem 3-11 2 $1.00 coupon $0.85 coupon $0.70 coupon $0.55 coupon $0.40 coupon 3 Number issued 0 0 0 0 0 4 Incr. sales 1.5 1.4 1.25 0.9 5 Prob. of usage 0.8 0.75 0.6 0.5 0.42 6 Net incr sales 1.2 1.05 0.75 0.5 0.378 7 Incr. revenue 8 Coupon value 9 Incr. revenue 10 Constraints: 11 Total coupons 12 Total budget Min $1.00 13 coupon Min $0.85 14 coupon Min $0.70 15 coupon Min $0.55 16 coupon Min $0.40 17 coupon 18 LHS Sign RHS 19