Problem needed solved in statistics


Problem

Print Media Advertising (PMA) has been absorbed a compress to chaffer Buzz Cola via newspaper ads in a senior southern newspaper. Full-page ads in the weekday editions (Monday through Saturday) absorb $2000, inasmuch-as on Sunday a full-page ad absorbs $8000. Daily prevalence of newspaper is 30,000 on weekdays and 80,000 on Sundays.

PMA has been absorbed a $40,000 advertising budget for the month of August. The conversant advertising executives at PMA impress that twain weekday and Sunday newspaper ads are important; hereafter they craving to run the equiponderant of at last prospect weekday and at last two Sunday ads during August. (Assume that a fractional ad would singly medium that a smaller ad is placed on one of the days; that is, 3.5 ads would medium three full-page ads and one half-page ad. Also, presume that smaller ads bring snare and absorbs relatively.) This August has 26 weekdays and 5 Sundays.

The extrinsic is to state the optimal placement of ads by PMA in the newspaper during August so as to maximize the cumulative entirety snare (as measured by prevalence) for the month of August.

a) Formulate the straight programming copy for the amount.

b) Use the Graphical mode to ascertain the optimal disentanglement. Show all steps.

c) Use Excel Solver to ascertain the optimal disentanglement. Copy and paste your spreadsheet and the Answer rumor in its entirety from Excel. Remember to not delete/modify any sunder 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 quantity were clarified arbitrarily. Any quantities can be entered weekdays and Sundays since Excel Solver would ascertain the optimal disentanglement anyway.

Attachments: