Please see attached. Q 5

QUESTION 5 5 points Save Answer Please see the Budget Allocation excel file. The file outlines the historical statistics for the use of different advertising channels by Turbotax. You are the Digital Marketing Manager for Turbotax and you are asked to provide the allocation of budgets across channels by maximizing profits for the firm. The max budget you cal allocate across all channels is $75000. Please use Excel Solver to complete this exercise. You can copy and paste the table with the optimal budget allocation in the response or attach the excel sheet itself as the final response by clicking the @ sign. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIUS Paragraph Arial 10pt v IEv A v & v IX E E X2 X2 IT . . . +, ABC X A EX i( 3)Source Clicks CPC Total Cost Coversion Rate Max Budget Conversions ROI Google Paid Search Ads 6000 15.37 92,220 1.46% $20,000.00 88 141% Facebook Ads 9054 16 144864 1.17% $30,000.00 106 88% Bing Ads 4000 15.9 63,600 1.13% $35,000.00 45 151% Display Ads 5460 12 65,520 1.10% $40,000.00 60 191% WSJ ads 4123 17 70,091 1.57% $16,000.00 65 56%