Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Statistics and Probability Expert

Problem

Print Media Advertising (PMA) has been given a contract to the market Buzz Cola through newspaper ads in a major southern newspaper. Full-page ads in weekday editions (Monday through Saturday) cost $2000, while on Sunday a full-page ad costs $8000. Daily circulation of newspaper is 30,000 on weekdays and 80,000 on Sundays.

PMA has been given a $40,000 advertising budget for month of the August. The experienced advertising executives at PMA feel that both weekday and Sunday newspaper ads are significant; therefore they wish to run the equivalent of at least eight weekday and at least two Sunday ads during August. (Suppose that a fractional ad would simply mean that a smaller ad is placed on one of the days; that is, 3.5 ads would mean three full-page ads and one half-page ad. Also, suppose that smaller ads diminish exposure and costs proportionately.) This August has 26 weekdays and 5 Sundays.

The objective is to find out the optimal placement of ads by PMA in the newspaper throughout August so as to maximize the cumulative total exposure (as measured by circulation) for the month of August.

a) Formulate linear programming model for the problem.
b) Use Graphical method to find out the optimal solution. Show all steps.
c) Use Excel Solver to find out the optimal solution. Copy and paste your spreadsheet and the Answer report in its entirety from Excel.

Remember to not modify /delete any part of the Answer Report.

Here is how the spreadsheet was set up for Excel Solver. The spreadsheet shows 10 weekdays and 10 for Sundays.  These numbers were selected arbitrarily. Any quantities can be entered weekdays and Sundays since Excel Solver would find the optimal solution anyway.

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M91525

Have any Question? 


Related Questions in Statistics and Probability

The department of education would like to determine if

The Department of Education would like to determine if there are gender differences in the performance of twins on the state mandated mathematics examination. As a result, they have collected data on twelve sets of twins ...

Anbsppsychologist would like to examine the effects of a

A psychologist would like to examine the effects of a new drug on the activity level of animals. Three samples of rats are selected with n = 5 in each sample. The rats in the first sample serve as a control and do not ge ...

Identify a business related management problem translate

Identify a business related management problem translate the management problem into a hypothesis assumption accurately state the null hypothesis and alternative hypothesis.

Statistics assignmentquestions address all of the following

Statistics Assignment Questions: Address all of the following questions in a brief but thorough manner. • What are the most common measures of central tendency? Include brief definitions for the common measures of centra ...

Just want to have a simple answer for this question how did

Just want to have a simple answer for this question: How did the Cold War shape decolonization?

On a 2-d regular not wrapped-around mesh a message from a

On a 2-D regular (not wrapped-around) mesh, a message from a source (X s , Y s ) is to be sent to a destination (X d , Y d ). If any shortest path can be used, what is the probability that the message follows the shortes ...

Another simple question can you give me 3 points regarding

Another simple question, can you give me 3 points regarding to origins of the Cold War.

In a recent survey of high school seniors a random sample

In a recent survey of high school seniors, a random sample of 1000 females showed that 650 were planning on pursuing a college degree, while a random sample of 1000 females showed that 600 were planning on pursuing a col ...

Risk taking is an important part of investing in order to

Risk taking is an important part of investing. In order to make suitable investment decisions on behalf of their customers, portfolio managers give a questionnaire to new customers to measure their desire to take financi ...

The setup is again as in exercise 931 but this time peter

The setup is again as in Exercise 9.31, but this time Peter chooses the integer k randomly according to a geometric distribution with parameter 1/2, that is, P(k = n) = 1/2n for each n ∈ N. How does this affect your answ ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro