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

1 a study was conducted at a local college to analyze the

1. A study was conducted at a local college to analyze the average GPA of students graduated from Arizona State in 2012. 100 students graduated from Arizona in 2012 were randomly selected,and the average GPA for the grou ...

A survey of 68 courses delivered fully online found a mean

A survey of 68 courses delivered fully online found a mean of 13.5 videos with a standard deviation of 2.81. You can assume that the number of videos in an online course is normally distributed. Find the 89% confidence i ...

The western way of war thesis posits that western societies

The Western Way of War thesis posits that western societies throughout history have generally fought wars in fundamentally similar ways. The precise elements of the Western Way of War are described succinctly in Geoffrey ...

The probability that a light bulb of a given brand is

The probability that a light bulb of a given brand is faulty is .1. You want to find the probability that fewer than 5% of a shipment of 1000 light bulbs is faulty. Use the Binomial Distribution to determine this.

Joshua and his army are planning to circle jericho seven

Joshua and his army are planning to circle Jericho seven times. Will the wall come tumbling down? The king of Jericho reports that: I ascribe probability 0.8 to "the wall of the city will fall, and Joshua ascribes probab ...

A researcher collected sample data for women ages to the

A researcher collected sample data for women ages to. The sample had a mean serum cholesterol level (measured in mg/100 mL) of , with a standard deviation of. Assuming that serum cholesterol levels for women ages to are ...

A spinoff of the anti-war and civil rights movements of the

A spinoff of the anti-war and civil rights movements of the 1960s that affected women was? increased desire to return to the security of homes and families decreased political involvement. the birth of the women's libera ...

Focusing on leadership and changeintroductionin this

Focusing on leadership and change Introduction In this assignment, we will focus on you, your relationship to leadership and change in your work context and the management ideas that have influenced those topics. Rather ...

1 what is an interaction2 how many interactions can be

1. What is an interaction? 2. How many interactions can be tested in a 2 x 2 design? In a 3 x 3 design? In a 2 x 2 x 3 design? 3. Why do researchers use expericorr designs?

1 what are the advantages and disadvantages of using

1. What are the advantages and disadvantages of using narrative records in observational research? 2. Distinguish between a structured and unstructured observation method. 3. Distinguish between checklists and observatio ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen