2 A local restaurant needs to determine how to allocate its $10,000 advertising budget. They have estimated the expected profit from each dollar (X) spent on three different platfo 3 4 5 6 Platform Facebook Instagram YouTube Expected Profit 75X0.64 120X.7 50X0.5 Where X is the amount spent on the platform 8 9 Also, the restaurant wants to spend at least $500 on each platform, how should it allocate its advertising budget in order to maximize profit? 10 11 Answer A-C Below 12 (A) Formulate the problem as a nonlinear programming spreadsheet model. Use worksheet tab "Q3 SS Model" to formulate your spreadsheet model. (10 pts) 13 Use tab "Q3 SS Model" 20 Facebook 21 Instagram 22 YouTube 14 15 (B) Solve the formulated model using Excel Solver.(5 pts) 16 Use tab "Q3 SS Model" 17 18 (C) How much should they spend on each platform in order to maximize profit? (5 pts) Spend ($) 19 Platform Ri 6719 1

Also, the restaurant wants to spend at feast $500 on each platform, how should it allocale is advertsing budget in crder to maximize prot? Answer A-C Betow (A) Formulate the problem as a nonlinear programming spreadsheet model, Use wockseet tab "os ss Moder" to formulase yout apceadiheet model. (10 pti) Use tab "Os 58 Model" (B) Solve the fermulasid model uting Excel Solver (5 pts) Use tab "Os 58 Model" (C) How much should they spand on each platform in order to manimize profr? (5 pts) Platiorm Spend (s) Facebook Instagram Q3. Restaurant Ad Problem \begin{tabular}{|c|cc|} \hline Facebook Instagram & YouTube Limit \\ \hline 70 & 100 & 50 \\ 0.75 & 0.7 & 0.5 \end{tabular} alpha beta Budget Facebook Minimum Instagram Minimum YouTube Minimum