Question: For this Question, i am using excel QM with solver. i need to know where to put the numbers so that i get the answer

For this Question, i am using excel QM with solver. i need to know where to put the numbers so that i get the answer which is 175 radios and 10tv ads.
For this Question, i am using excel QM with
For this Question, i am using excel QM with
16 A candidate for mayor in a small town has allocated $40,000 for last-minute advertising in the days pre- ceding the election. Two types of ads will be used: radio and television. Each radio ad costs $200 and reaches an estimated 3,000 people. Each television ad costs $500 and reaches an estimated 7,000 peo- ple. In planning the advertising campaign, the cam- paign manager would like to reach as many people as possible, but she has stipulated that at least 10 ads of each type must be used. Also, the number of radio ads must be at least as great as the number of tele- vision ads. How many ads of each type should be used? How many people will this reach? A1 . for G H I J K L M Run Excel's Solver Solver Help B C D E F For the values in the shaded area then use the Run Excel's Solver bution Alternatively, open Solver by going to the Data Tab (Excel 2007. 2010, 2013, 2016) or the Tools Excel 2003, 2011). ALL VARIABLES have been set to INTEGER in Solver 4 Integer and Mixed Programming Use one of the three sans below for each constraint less than or equal to equals (You need to enter an apostrophe first.) greater than or equal to 11 Data Problem setup area 1 Slack/Surplus

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!