Reference no: EM131371121
A group of students in MSIS 3233 class is working on advertising the bedlam game 2016 (OSU Vs OU). There are three forms of advertisement possible: radio, television ad and newspaper. Each television ad costs $20,000 and reaches to 10,000 viewers (4,000 men and 6,000 women). Each radio ad per month cost $10,000 and reaches 7,000 viewers (4,000 men and 3,000 women). A newspaper ad for a month costs $5,000 and reaches 3,000 viewers (2,200 men and 800 women). The group wants to reach at least 120,000 men viewers (consider it as a HARD constraint). Find the optimal number of each type of ad (integer numbers) to run so that the following goals are achieved.
Goal 1: To reach at least 190,000 viewers.
Goal 2: To spend no more than $250,000.
Goal 3: To run no more than 6 television ads.
Goal 4: To run at least 12 radio ads.
Goal 5: To run no more than 15 newspaper ads.
Submit your Excel solution and answer the following questions (along with the model formulation) based on your solution in a separate word document:
a) Which of the goals are underachieved/overachieved in your solution?
b) What is the total cost of campaign?
c) What is the total number of viewers?
|
Probability that random variable will be above it is 0.25
: If X is a normally distributed random variable with mean -61 and standard deviation 22, find the value such that the probability that the random variable will be above it is 0.25.
|
|
Identify and discuss the key steps in the closing process
: Identify and discuss the key steps in the closing process that provide the most opportunity to make mistakes in processing account transactions. Why did you select these steps and what makes them confusing?
|
|
Oats and corn are principal ingredients of the hog feed
: Nutrifeed, a hog feedlot operation near Houston, Texas blends ingredients to make low cost teed tor its hogs. Oats and corn are the principal ingredients of the hog feed. The current costs tor oats and corn are 12 cents and 7 cents respectively. Form..
|
|
Evaluate criminal justice in selected countries
: you will evaluate criminal justice in selected countries. Since mens rea refers to criminal intent, the concept of guilty but insane sounds like an oxymoron to most people. Chapters 1 and 3 in the course text discuss international perspectives on ..
|
|
What is the total cost of campaign
: A group of students in MSIS 3233 class is working on advertising the bedlam game 2016 (OSU Vs OU). There are three forms of advertisement possible: radio, television ad and newspaper. Each television ad costs $20,000 and reaches to 10,000 viewers (4,..
|
|
What should be the balance in account receivable at december
: At the end of its first year of operations, December 31, 2010, Darden Inc. reported. What should be the balance in accounts receivable at December 31, 2010, before subtracting the allowance for doubtful accounts?
|
|
Find two values x1 and x2
: Let X be a normally distributed random variable with mean 600 and variance 10,000. Find two values x1 and x2 such that P(X > x1) = 0.01 and P(X > x2) = 0.05.
|
|
Find the required amount of dollars to carry
: Pierre would like to carry overnight an amount of money such that the demand on 85% of the nights will not exceed this amount. Can you help Pierre find the required amount of dollars to carry?
|
|
Do you believe this to be a correct statement
: the Tamil Diaspora has created a transitional government and it serves as an incubator for radicalization (White, 2015 p.215).In your view, what does he mean? Do you believe this to be a correct statement?
|