Blitz Beer has allotted $10,080 for radio advertising in Gotham City and must determine the placement of spot advertisements that will maximize increased sales. Top-40 stations attract a heavier beer-drinking audience than golden-oldie stations do, but top-40 stations also charge more for each spot. The following data apply. 8 ots available Format $100 $300 Tan-40 E- Golden-oldie Golden-oldie II $150 $400 _ To-4o At least 25% of the spots must be placed with golden-oldie stations. a) Formulate Blitz's problem as a Linear Programming problem, by assuming all the decision variables as non-negative real numbers. b) Using Excel Solver, find the optimal solution of the Blitz's problem, i.e., the optimal values of all the decision variables and the optimal objective value. (Attach the computer printout, which includes the Formulation at the optimal solution, Answer report and Sensitivity report to your solution.) c) Now, consider all the decision variables as integers. Using Excel Solver, find the optimal solution of the Blitz's problem, i.e., the optimal values of all the decision variables and the optimal objective value. (Attach the computer printout, which includes the Formulation at the optimal solution and the Answer report to your solution.) d) Comment on the results of (b) and (c)