Eodf2034 Company Planning Use 225 000 Advertising Company Considering Facebook Instagram C Q34229823

eodf2034 is a company that is planning to use $225,000 inadvertising. The company is considering Facebook and Instagram. Themore the company uses a particular medium, the less effective iseach additional ad. The table below shows the number of newcustomers reached by each ad.

Number of AdsNew CustomersFacebook1-152,00016-251,60026-351,100Instagram1-920,00010-2018,00021-3514,000

Each Facebook ad costs $2,000, while each Instagram ad costs$5,000. At most, 45 Facebook ads and 30 Instagram ads can beplaced.

1- Formulate a model to help the company maximize the number ofnew customers created by advertising.

Expert Answer

To reach the solution, we will use the GRG Non linear in excelsolver. First of all, we will