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

Of the people who fished at clearwater park today 63 had a

Of the people who fished at Clearwater Park today, 63 had a fishing license, and 27 did not. Of the people who fished at Mountain View Park today, 60 had a license, and 40 did not. (No one fished at both parks.) Suppose ...

The state police are trying to crack down on speeding on a

The State Police are trying to crack down on speeding on a particular portion of the Massachusetts Turnpike. To aid in this pursuit, they have purchased a new radar gun that promises greater consistency and reliability. ...

There are 1000 students in a high school among the 1000

There are 1000 students in a high school. Among the 1000 students, 150 students take AP Statistics, and 300 students take AP French. 100 students take both AP courses. Let S be the event that a randomly selected student ...

You are purchasing a home for 220000 the down payment is 30

You are purchasing a home for $220,000. The down payment is 30% and the balance will be financed with a 20- year mortgage at 9% and 2 discount points. You put down a deposit of $5,000 (applied to the down payment) when t ...

Assignmentstatistical analysisdirections be sure to save an

ASSIGNMENT Statistical Analysis Directions: Be sure to save an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure to us ...

Read the scenario related to identifying variables and

Read the scenario related to identifying variables and developing problem statements and then answer the three questions. Scenario: Retention of minority women in the workplace is becoming more and more difficult. Not fi ...

Shoesmith wave inc a new and largely unproven economic

Shoesmith Wave, Inc., a new and largely unproven economic forecasting service, expects the inflation rate in South Korea to average 9 percent per year over the next five years. In comparison, Shoesmith expects a U.S. inf ...

Twenty years ago 40 children were born in the same hospital

Twenty years ago 40 children were born in the same hospital in Denmark. Researchers classified the children by whether or not they were breast-fed for at least 3 months. They were interested in whether breast-feeding ten ...

Jullian was curious if regular excise really helps weight

Jullian was curious if regular excise really helps weight loss,she decided to perform a hypothesis test. A random sample of 5 Kansas State students was chosen. The students took a 30-minute exercise every day for 6 month ...

1 find the p valuep for the indicated hypothesis test with

1) Find the P value(P= ?) for the indicated hypothesis test with the given standardized test statistic z. Decide whether to reject Ho for the given level of significance.  Two tail test, z = 2.30, alpha = 0.01 2) Find th ...

  • 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