Question
Please apply Linear Programming to a following business scenario: A firm plans to use three different types of ads to attract potential customers to its
Please apply Linear Programming to a following business scenario:
A firm plans to use three different types of ads to attract potential customers to its product. The three ad choices are TV ads, Magazine ads, and Sunday Supplement. The following table shows the number of potential customers one ad can reach:
TV Ads (TV) Magazine Ads (M) Sunday Supplement (SS)
Number of Potential Customers Attracted per Ad 1,500 500 500
There are two categories of spending per ad as below ($, Thousands):
Cost Per Ad ($Thousands)
TV Ads (TV) Magazine Ads (M) Sunday Supplement (SS)
Ad Budget 250 100 100
Planning Budget 100 50 50
There are following constraints:
Total Ad Budget <= 3,500
Total Planning Budget <= 1,500
Total number of TV ads <= 5
Find the optimal numbers of TV ads, Magazine ads, and Sunday Supplement so that the total number of the potential customers attracted by these ads can be MAXIMIXZED. Please explain how to find answer using solver in excel.
Step 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