Question: 5 G20 A 1 Problem 4 Optimization Using Excel Solver C D F Online and Cable ads that a lot 2 3 Serious Brand Marketing,

5 G20 A 1 Problem 4 Optimization Using Excel

5 G20 A 1 Problem 4 Optimization Using Excel Solver C D F Online and Cable ads that a lot 2 3 Serious Brand Marketing, LLC Cableads should be 4 5 6 Online Pop-up Ads 7 Cable Ads 8 9 Decision Variables: 10 Objective Function: Exposure per Ad 3,000 5,000 Cost per Ad $ 3,400 $ 10,000 Number of Online Ads and Number ol Cable Ads 12 Constraints: Online Ads Cable Ads 15 Recommendation IT 18 styles 1 Number Styles G H Serious Brand is trying to determine what combination of Online and Cable ads will maximize their customer's exposure while staying within the budget of $150,000. The customer is also commited to the importance of cable ads and is requiring that at least 75% of the total ads be on cable. Use Solver- Optimization to identify how many Online and how many Cable ads should be procured

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

serious brand is trying to determine what combination of online and cable ads will maximize their customer's exposure while staying within the budget of $150,000. The customer is also commited to the...

Need help on completing this case via excel all info I have is screen-shotted below ' Fitness Centers Ca 5.; 6: Decision Support Using Excel Selecting the Best Mix of Advertising Media PREVIEW In...

IfyouhaveplayedaSimulationcalledProBankerIneedhelpansweringthesequestionsassoonaspossible from the pro bankerassignment attachment..please use spreadsheet and players manual for reference. Need...

Give your opinion. and give me proper explanation. After reading the attached article, please write a paragraph as article summary and then respond to the following questions: Are there other ways of...

Give your opinion. and give me proper explanation . After reading the attached article, please write a paragraph as article summary and then respond to the following questions: Are there other ways...

post DataXu: Selling Ad Tech On June 20, 2016, DataXu CEO Mike Baker surveyed the beachfront at the Cannes Lions International Festival of Creativity. Each year, Cannes, a seaside town on the French...

What metrics does the company track (or should track)? How do business models and stages of growth drive metrics this company tracks? In your opinion, what is the OMTM for this company? What should...

It is Snapchat A which is found in your course pack. You are to turn in an excel a) excel spreadsheet with formulas for calculations. The spreadsheet should show cash flow, WACC calculation, firm...

Please read attached and Critique: Write critique of the paper. Do you agree with the author that statistics is important? Why? Feel free to provide your own examples of a valuable statistical study....

Give and explain the accounting and extended accounting equation that must be true on the statement of financial position.

1. Why did Argenti need to increase it's notes payable borrowing to more than $1 billion in 20x5? 2. What recommendation would you make regarding the companys request for a $1.5 billion refinancing...

Which of the following best describes the treatment applicable to unused business credits? Are carried forward indefinitely. Are first carried back one year and then forward for 1 0 years. Are first...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...