Print media advertising, Print Media Advertising (PMA) has

Print media advertising

Reference no: EM13173458

Print Media Advertising (PMA) has been given a contract to market Buzz Cola via newspaper ads in a major southern newspaper. Full-page ads in the weekday editions (Monday through Saturday) cost $2000, whereas 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 the month of August. The experienced advertising executives at PMA feel that both weekday and Sunday newspaper ads are important; hence they wish to run the equivalent of at least eight weekday and at least two Sunday ads during August. (Assume 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, assume that smaller ads reduce exposure and costs proportionately.) This August has 26 weekdays and 5 Sundays.

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

a) Formulate the linear programming model for the problem.

b) Use the Graphical method to find the optimal solution. Show all steps.

c) Use Excel Solver to find the optimal solution. Copy and paste your spreadsheet and the Answer report in its entirety from Excel.

Remember to not delete/modify 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.

Reference no: EM13173458

Questions Cloud

Sex receives quite a bit of attention in story lines : In the media, sex receives quite a bit of attention in story lines, plots, and news events. Describe what you consider to be the role that sex plays in the realm of human adjustment overall.

Managed care organizations physician credentialing process : Managed care organizations and Physician credentialing process. Evaluate the main points of the articles, and relate it to your course and text readings.

How toy stimulate physical development-skills developed : Explain specifically how this toy can stimulate physical development (large or small motor skills). Which skills are developed? Explain specifically how this toy can help a child develop cognitive skills, giving a few example of what might be learned..

Adopted in accordance with statutory procedural requirement : A standard may be invalid if it was not adopted in accordance with a statutory procedural requirement. An example of this is which one of the following?

Print media advertising : Print Media Advertising (PMA) has been given a contract to market Buzz Cola via newspaper ads in a major southern newspaper.

Nuclear health care organization : The nuclear health care organization-whether hospital or something other than the hospital-will be organized ten years from now? Describe how major changes in the role of healthcare workers, the culture of healthcare consumers, and methods of communi..

Marx described alienation as involving : Marx described alienation as involving which of the following.

Productive power of which type of society : Many people have marveled at the Great Wall in China and the Great Pyramids in Egypt. These monuments stand as evidence of the productive power of which type of society?

Women and men in hunting and gathering societies : The social standing of women and men in hunting and gathering societies.

User Account

All Pages