Linear programming problem-print media advertising

Reference no: EM1397249

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.

Reference no: EM1397249

Questions Cloud

Regression-gpa and startsal : A university has studied the relationship between the GPA (grade point average) of its graduates and StartSal, their starting salaries (in thousands of dollars). A sample of seven graduates was randomly selected.

Define partial pressure of a gas : Define partial pressure of a gas and identify 3 different units used to measure partial pressure. What is the PO2 of the atmosphere at sea level? Express in units of torr.

Explain home school and public education : Create the introduction paragraph for essay. Incorporate thesis statement in paragraph. Home school and Public Education.

What will be the theoretical yield of bromobenzene : what will be the theoretical yield of bromobenzene in given reaction as C6H6 + Br2 → C6H5Br + HBr also find out percentage yield when actual yield of bromobenzene was found 56.7 g?

Linear programming problem-print media advertising : 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.

Calculate empirical formula of compound : Calculate empirical formula of this compound & molecular formula and calculate the molality of solution of sulfuric acid?

What is the mean rate of flagellar regeneration : The return of motility is sudden. What does this suggest about flagellar function in these organisms?

Linear programming model for ore extraction : Formulate and LP model for this problem using Excel. Sketch the feasible region for this problem using Excel. Find the optimal solution

Marketing analyst can use inependent samples : Explain how the marketing analyst can use independent samples to collect the data.

User Account

All Pages