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.
At Myrestlab.com, we always work diligently to provide our customers with high-quality nursing assignment help services. We ensure that all papers by our writers possess 100% originality. We also guarantee all students of 100% privacy and confidentiality when working with us.
At Myrestlab.com, our mission is to provide quality services to all students. We, therefore, guarantee money-backs for the rare occasions of satisfaction. Your satisfaction is our goal.Read more
All our nursing assignment help services are 100% original. Each of our professional writers develops custom papers from scratch to reduce the chances of plagiarism. In addition to this, we always run completed papers through advanced anti-plagiarism checkers for 100% originality.Read more
Our free revision guarantee is a courtesy service by Myrestlab.com to ensure that we achieve 100% customer satisfaction rates. In case you feel unsatisfied with the outcome of your paper, you can always request for free unlimited revisions. We recommend a revision request within 14 days after the delivery date for short papers and 30 for dissertations.Read more
Myrestlab.com also guarantee 100 privacy and confidentiality. We do not share any of our customers’ personal details with third parties. We have also fitted our websites with security features to ensure secure connections. Our security features also prevent damages that might occur through attacks by outsiders.Read more
By ordering a paper through My Rest Lab, you agree to receive nursing assignment help services offered by our nursing assignment writers. Our assignment help experts will always endear to provide quality services as promised. We always expect maximum cooperation from our students to help us achieve our mission and vision.Read more