Problem needed solved in statistics


Problem

Print Media Advertising (PMA) has been ardent a curtail to market Buzz Cola via newspaper ads in a important southern newspaper. Full-page ads in the weekday editions (Monday through Saturday) absorb $2000, forasmuch-as on Sunday a full-page ad absorbs $8000. Daily publicity of newspaper is 30,000 on weekdays and 80,000 on Sundays.

PMA has been ardent a $40,000 advertising budget for the month of August. The conversant advertising executives at PMA move that twain weekday and Sunday newspaper ads are important; hereafter they eagerness to run the equiponderant of at lowest prospect weekday and at lowest two Sunday ads during August. (Assume that a fractional ad would solely average that a smaller ad is placed on one of the days; that is, 3.5 ads would average three full-page ads and one half-page ad. Also, claim that smaller ads subject scylla and absorbs relatively.) This August has 26 weekdays and 5 Sundays.

The concrete is to state the optimal reconsignment of ads by PMA in the newspaper during August so as to maximize the cumulative entirety scylla (as measured by publicity) for the month of August.

a) Formulate the straight programming standard for the height.

b) Use the Graphical rule to invent the optimal breach. Show all steps.

c) Use Excel Solver to invent the optimal breach. Copy and paste your spreadsheet and the Answer relation in its entirety from Excel. Remember to not delete/modify any distribute 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 mass were chosen arbitrarily. Any quantities can be entered weekdays and Sundays since Excel Solver would invent the optimal breach anyway.

Attachments: