Question


    Tutorial

    Category :Math/Stat Homework

    Posted By:AccountingExpert

    Price Offered : $10

    Posting Date : 2014/06/29 00:29

    Due Date : 2014/06/30 12:00

    Answered (1 time)



    QSO 510: Module 8
    Notes: Before doing this assignment, do the practice problem posted under Apply and Discover. Wordprocess your answers within this document. Do not create a new file. Copy and paste the reports from
    Excel to this document. Show all steps used in arriving at the final answers. Incomplete solutions will
    receive partial credit.
    Problem
    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.

    Answer
    Submitted by AccountingExpert on 2014/06/29 00:30
    teacher rated 211 times

    Price: $10.00

     

    QSO510 Module 8 100% Correct Detailed Tutorial Top Level solution A+++Solution Guide




    ---- file 1.docx preview (446 words)---

    QSO510 xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx this xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Discover. xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx a xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx to xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx the xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Media xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Buzz xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Full-page xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx $2000, xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx circulation xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Sundays.PMA xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx month xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx that xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx they xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx weekday xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx that xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx ad xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx 3.5 xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx ad. xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx proportionately.) xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx is xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx in xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx cumulative xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx of xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Graphical xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Excel xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx your xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Excel. xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx Report.Here xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx

    - - - more text follows - - -



    Login or Register to buy answer

    Down payment will be adjusted against total price. You can see full view of answer or download document after purchase.

    Social Share