Orange Company is allocating its advertising budget for its new smartphone targeting graduate and undergraduate students in RTP. The company has invited representatives from the local radio station, television station, and newspaper to make presentations in which they describe their audiences. The television station representative indicates that a TV commercial, which costs $15,000, would reach 25,000 potential customers per ad. The breakdown of the audience is as follows: Male Female Graduate 5,000 5,000 Undergraduate 5,000 10,000 The newspaper representative claims to be able to provide an audience of 10,000 potential customers at a cost of $4,000 per ad. The breakdown of the audience is as follows: Male Female Graduate 4,000 3,000 Undergraduate 2,000 1,000 The radio station representative says that every radio commercial has an audience of 15,000 at a cost of $6,000. The breakdown of the audience is as follows. Male Female Graduate 1,500 1,500 Undergraduate 4,500 7,500 Orange Company has the following advertising policy: • Use at least twice as many radio commercials as newspaper ads. • Reach at least 80,000 customers. • Reach at least twice as many undergraduate students as graduate students. • Make sure that at least 40% of the audience is female. • Available space limits the number of newspaper ads to two. Orange Company wants to know the optimal number of each type of advertising to purchase to minimize total cost. a. Formulate a linear programming model to determine the company's advertising strategy. [16%] b. Solve the model using Excel Solver. [2%] [Extra tip: A constraint of the form f(x1, x2, ...)/g(x1, x2, ...) <= c, where f(x1, x2 , ...), g(x1, x2, ...) are linear functions of the decisions x1, x2,..., and c is a constant, is not linear. But we can "linearize" it by writing it as f(x1, x2, ...) <= cg(x1, x2, ...)]