The director of advertising for a retail chain is considering how to allocate her $200,000 budget for television advertising among four programs (A,...

Review the following question and help determine the use of analytics and data in today's business environment. Please also attach your Excel Worksheet to illustrate how you constructed your simulation model.

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 Achieversspend twice as much in the store as do Aspiring Achievers. The director wants to maximize the total tn-store spending potential of the audience but must have at least three adson each program, and cannot spend more than 50% of the budget on any one channel. The audience by program and the ad costs are: 1 A 100,000 25 75 $7,5001 a 50,000 00 40 $4,0002 c 90,000 40 00 $6,5003 D 80000 so 50 $5,000 1. What is the most effective ad purchase ignoring the fact that the number of ads on anyr one program must be integer?2. Include an integer constraint on the number of ads and re-solve.3. Compare the two solutions.