What is the total cost of campaign

Assignment Help Operation Management
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?

Reference no: EM131371121

Questions Cloud

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?

Reviews

Write a Review

 

Operation Management Questions & Answers

  Standard deviation of an individual common stock

What is the typical relationship between the standard deviation of an individual common stock and the standard deviation of a diversified portfolio of common stocks?

  What values are at stake

What values are at stake? Do some of the values conflict with one another?

  What is the objective function and constraints

Wood Specialties Company produces wall shelves, bookends, and shadow boxes. It is necessary to plan the production schedule for next week. The wall shelves, bookends, and shadow boxes are made of oak, of which the company has 600 board feet. What is ..

  Organizing drive for both zinnia and acme scenarios

Also, in the second part of your essay critique the current organizing drive and develop your own union organizing drive for both the Zinnia and ACME scenarios. Be sure to include specific tactics and issues you would address.

  Concussion education app on my android and iphone

Determine whether each of the following requirements is adequate.If it is not, state the reason(s) and rewrite the requirement so that it meets the characteristics of good requirements. I want to use the concussion education app on my Android and iPh..

  Reduce the possibility of such a conflict in a corporation

Describe agency conflict and the measures that can reduce the possibility of such a conflict in a corporation. Your response should be at least 250 words in length. You may use only your textbook as source material for your response. All source mater..

  Shares of common stock outstanding

Dinklage Corp. has 9 million shares of common stock outstanding. The current share price is $75, and the book value per share is $6. The company also has two bond issues outstanding. The first bond issue has a face value of $85 million, a coupon r..

  You will recognize key ethical problems facing the company

you will identify key ethical problems facing the company create potential solutions to those problems and explain why

  Culture influenced outcome of ethical decision

Examine the major influences that organizational culture can have on organizational ethical decision making. From your personal experience in your current or past organization, provide one (1) example of how organizational culture influenced the outc..

  What is the name of the damages that b can recover

what is the name of the damages that B can recover from A to compensate B for his loss of the contracts with C, D, and E?

  Widely recognized for its leadership talent

General Electric (GE) is widely recognized for its leadership talent and its succession management system. One of the best examples of succession management is how GE’s former CEO Jack Welch shaped and elevated the company’s phi-losophy, practice, an..

  Discuss the elements of marketing

Various federal agencies impact marketing activities. Research each agency listed below, discuss the elements of marketing that are impacted by that agency, and present a recent marketing case or issue on which each agency has focused. (AACSB: Commun..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd