Hello, can you help me with this question? The director of advertising for a retail chain is considering how to allocate her $200,000 budget for television advertising among four programs (A, B, C, D) on three channels (1, 2, 3). Market research studies have shown that the chain's customers can be broken down into two groups: "High-end Achievers" and "Aspiring Achievers." High-end Achievers spend twice as much in the store as do Aspiring Achievers. The director wants to maximize the total in-store spending potential of the audience but must have at least three ads on each program and cannot spend more than 50% of the budget on any one channel.

The audience by program and the ad costs are:

Budget:	$ 200,000.00
Channel	Program	Expected Audience	% High-end Achievers	% Aspiring Achievers	Cost/Ad
1	A	100000	25%	75%	$7,500.00
1	B	50000	60%	40%	$4,000.00
2	C	90000	40%	60%	$6,500.00
3	D	80000	50%	50%	$5,000.00

1. What is the most effective ad purchase ignoring the fact that the number of ads on any one program must be integer?

2.. Include an integer constraint on the number of ads and re-solve.

3. Compare the two solutions.

Can you show me how to use Excel Solver (if possible) to solve this problem?