EXHIBIT 2 A small business wants to find out which social me…
EXHIBIT 2 A small business wants to find out which social media ads it should buy in order to maximize its exposure in its local market. It has a monthly advertising budget of $10,000. The company is considering three possible websites: Facebook, Instagram and LinkedIn. Information regarding cost and exposure of the different media is given in the table below. In addition, each social media website allows only a limited number of ads from the same company (see in table below). The decision variables are defined as: x1 = Number of Facebook ads per month x2 = Number of Instagram ads per month x3 = Number of LinkedIn ads per month Facebook (x1) Instagram (x2) LinkedIn (x3) Exposure (audience reached per ad) 8,500 7,000 2,500 Cost per ad $1,000 $800 $500 Maximum ads per month 7 10 5 Please solve the problem described in this Exhibit using the Excel Solver. You will find the template for this problem in the file Final_Exam_Exhibit 2_DATA.xlsm Important: When clicking on the link, if the file does not open you will find it in the “download” section of your browser (bottom left of the page) and you can open it from there. If it still does not open, make sure that you are not editing a formula in another Excel file (this sometimes prevents you from opening a new file). Please note that this file is protected against saving. Do not close this file until you submit the exam, otherwise you may loose its content. In case you inadvertently closed the file, please download it again.
Read Details