A company wants to advertise. The media choices are in Table 3 in the Excel File. They want to maximize the Exposure Quality Units (EQU, a measure of the effectiveness of the advertisement for the target audience). They have the following constraints in addition to what is in the table:
- Total Budget = $50,000
- Total Radio Budget =$29,000
- Minimum Radio Ads = 100
- Minimum TV Ads= 30
- Minimum Airtime = 3000 minutes
Write a linear program that maximizes the EQU and satisfies the constraints.
What is the optimal value? 9969.5 EQU (No answer needed)
- What would raising the total budget by $80,000 do to the optimal value?
- What would raising the radio budget by $10,000 do to the optimal value?
- What would happen to the optimal value if the minimum airtime requirement was changed to 2700?