Answered step by step
Verified Expert Solution
Question
1 Approved Answer
experts only. derive the constraints, decision varieble, LP Model and explain comprehensively. 2. LP modeling - Media selection for advertisements Assume that you want to
experts only. derive the constraints, decision varieble, LP Model and explain comprehensively.
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 outputStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started