QA 305 Chapter 10 Homework Question 1 Diana Nyad: Diana Nyad owns Diva's Independent Event Planning Company, which caters to customer in North and South America. The company uses radio advertising to market its business. Two types of ads are available those during prime-time hours and those at other times. Each prime-time advertising costs $390 and reaches 8,200 people, while the off-peak ads each cost $240 and reach 5,100 people. Nyad, the owner, has budgeted $1,800 per week for advertising. Based on comments from her customers, Nyad wants to have at least two prime-peak ads and no more than six off-peak ads. Create a table in Excel that summarizes the information needed to formulate and solve the problem using Solver, similar to Table 7.1 in the textbook. Find a good or optimal integer solution (i.e., solution value) for Diana Nyad. Note: You MUST include tables AND LP mathematical expressions in your Excel spreadsheet (i.e., objective function - "maximize" or "minimize" and "subject to" constraints).