Problem $2$

Suppose ABC company is developing an advertising campaign. They would like to reach three groups of people: High Income Women $($HIW$),$ Teenage Boys $($TB$),$ and Retired Men $($RM$).$ They can advertise on TV and$/$or in a magazine. An ad in each of these gives the following audience:

Their budget is $\backslash (\backslash$$ $600,000\backslash ).$

ABC company has established the following goals:

Goal $1$: The ads would reach at least $42$ million HIW

Goal $2$: The ads would reach at least $60$ million TB

Goal $3$: The ads would reach at least $40$ million RM

Q: $\backslash (\backslash$quad $\backslash )$ Suppose the weight of Goal $1$ is $5$ and the weights of other Goals are each equal to $1,$ please solve the weighted GP in Excel.