Question: 2. LP modeling - Media selection for advertisements Assume that you want to advertise a new product. Your company assigned $1,000,000 for advertising budget. The

2. LP modeling - Media selection for advertisements Assume that you

2. LP modeling - Media selection for advertisements Assume that you want to advertise a new product. Your company assigned $1,000,000 for advertising budget. The table shows TV stations, time and number of viewers/advertisement costs for different time period for different TV station. All units are in 1,000. For each station, the available time slots (\# of available advertisements) are 5,12 and 3 for morning, afternoon and evening, respectively. You want to select TV stations and time slots to promote your product so that as many as people can watch the ads with limited budget. a) Please formulate this problem as a LP model. - MUST define the decision variables first! Then, write the objective function and constraints. b) Solve the problem using LINDO or Excel Solver and attach the output. No screen shots. c) Please explain the optimal advertisement plan based on your LP model's input and output

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!

Consider the sensitivity report below for problems 1-4. 1. Which of the following constraints are binding? Packing only Additive only Extrusion and Packaging Extrusion only All constraints are...

Read: Magids, Scott, Alan Zorfas, and Daniel Leemon (2015). "The New Science of Consumer Emotions," HBR , November 1.1. The article makes much of quantifying consumer emotions for analysis. Howthe...

I have attached the question. I will post student question when I receive one later. Chapter 2, Customer Behavior and 3, Segmentation of textbook can also be used. Marketing Management: MKT500 Week 1...

CMO: How is our ad budget allocation changing this year compared to last? VP of Advertising: We're doubling our allotment to digital channels like social media ads and online search ads and paring...

Note: write on the above point regarding to the case study please do it time limit 5 hour please do it CBS Broadcasting established Viacom as an independent company in 1970 to comply with regulations...

For the below, make the following assumptions (except where noted in the questions below): All tables provided. D = 0.2 (both for Media General and the media companies in Exhibit 12) The market...

For the purposes of this question, you should make the following assumptions (except where noted in the questions below): all tables provided D = 0.2 (both for Media General and the media companies...

It's Operational Reseach report, please read both cases and do it according to 4 questions on first picture, please write that report not less than 1500 words and please don't delete this uploaded...

Confirming Pages C H A P T E R 19 Analyzing Information and Writing Reports Chapter Outline Using Your Time Efficiently Analyzing Data and Information for Reports Identifying the Source of the Data...

Please make Critical appraisal for the methodology, appropriateness of research design and other critique for the research below. thank you International Journal of Academe and Industry Research...

A new all-purpose cleaner is being testmarketed by placing sales displays in three different locations within various supermarkets.The number of bottles sold from each location within each of the...

Larson and Gray (2021) contend that multiple competing projects, limited skilled resources, dispersed virtual teams, time pressures and limited capital serve as forces for the emergence of project...

Which of the following budgets are NOT needed in service firms? Multiple select question. Selling and administrative Cash Manufacturing overhead Production

Free cash flow valuation You are evaluating the potential purchase of a small business with no debt or preferred stock that is currently generating $ 4 2 , 7 0 0 of free cash flow ( F C F 0 = $ 4 2 ,...