MGMT 651_HW3_SUA2019 .doc - MGMT 651 u2013 Analytics for...

This preview shows page 1 - 2 out of 5 pages.

MGMT 651 – Analytics for Managerial Decision-Making Homework 3 Worth 100 points 1. (20 points) Chapter 4 Problem 1*. Constraint Television Radio Online Audience per Advertisement 100,000 18,000 40,000 Cost per advertisement $2000 $300 $600 Max. media usage 10 20 10 Min% 10% - 3.1 /33.1 Max% 50% Define Variables: T = quantity of television advertising R = quantity of radio advertising O= quantity of online advertising Define Constraints: T+R+O = Total amount of ads Proportion of radio ads = R/(T+R+O) R/(R+T+O)<= .50 Radio advertising must not exceed 50% of the total number of media. R<= .50T+.5R+.5O -.5T+.5.R-0.5O >=0 T>=.10(T+R+O) – Television advertising must be at least 10% T>=.10T + .10R +.50O .90T-.10R-.50O <= 0 Available Media T<= 10 R<= 20 O<=10 Non-negativity T,R,O >= 0 3 Variables and 5 constraint 2000T+300R+600O <= $18,200 Budget Possible Objective functions: Submit your homework as one single attachment. Include POM-QM input and output screenshots wherever applicable. If you submit your homework as an MS-Excel document, make sure that it is properly formatted to 8.5x11 page size!!

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture