Quantitative methods

posted by .

Assignment Problem 1*
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.

  • Quantitative methods -

    w = # of workday ads
    s = # of sunday ads

    cost constraint
    2,000 w + 8,000 s </= 40,000
    or simplified
    w + 4 s </= 20

    days needed constraints
    8 </= w </= 26
    2 </= s </= 5

    graph these, box for the two days needed with line sloping down from left through the box for cost
    three intersections
    (2,8) , (2,12) , (3,8)

    maximize E = 30,000 w + 80,000 s
    check those three corners and pick the one with the biggest E

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. ADS

    hi for my english hw im suppose to find three ads for the same product one from 2006 one from 1980s-2000 and one from before the 1980s and showing how the ad has developed throughout the years, but the ad has to be provacative like …
  2. math

    An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV time, radio time, and newspaper ads. Information about each medium is shown below. Medium CostPerAd # Reached Exposure Quality TV 500 …
  3. Business Algebra

    After running various advertisements, you have received the statistics from each advertising outlet. A total of 800 ads were run. The following lists the breakdown of each: 380 ads were run over the radio. 240 ads were run in the newspaper. …
  4. Advertising-HELP

    I need an advertisement which hasn't been banned yet, but that you think should be banned. I don't really pay attention to ads, so I don't know which ones should be banned. I actually have to write a complaint letter on one. Advertising-HELP …
  5. math

    An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV time, radio time and newspaper ads. Information about each medium is shown below. Medium Cost Per Ad # Reached Exposure Quality TV …
  6. Art

    Writeacher, I urgently need to revise these sentences. I really hope you can help me. 1) Ads can change and can wash the minds of children. Some years ago people used to switch channels to avoid ads, but we do it less and less 2) Nowadays …
  7. Foreign languages

    Thank you very much for helping me. Here are the very last sentences on the same theme. Thank you very much. 1) Over the years people have started watching ads more and more. 2) The way in which ads are made (?
  8. Art

    I left out a few other things. Could you please check them, too?
  9. Health

    I chose 5 points as you suggested to me. Thank you very much, Writeacher. 1) The difference about advertising today is that….. 2) Children cannot oppose their appearance in ads. Children want to buy everything they see (not all they …
  10. programming logic and design

    The Daily Gazette accepts classified ads in several categories. For most ads, the newspaper charges 10 cents per word for the first 50 words, and 8 cents per word for every word after that. Design a flowchart for a program that accepts …

More Similar Questions