Determine best way to allocate monthly advertising budget

Assignment Help Operation Management

Reference no: EM131159356

The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1000 between newspaper advertising and radio advertising. Management decided that at least 25 percent of the budget must be spent on each type of media and that the amount of money spent on local newspaper advertising must be at least twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. If the value of the index for local newspaper advertising is 50 and the value of the index for spot radio advertising is 80, how should the restaurant allocate its advertising budget to maximize the value of total audience exposure?

a. Formulate a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure.

b. Develop a spreadsheet model and solve the problem using Excel Solver.

Reference no: EM131159356

Questions Cloud

Wbs around deliverables rather than functions : What are the advantages of organizing the WBS around deliverables rather than functions? What would be the advantages of organizing a WBS by function? Explain your answers with a specific example of your own creation and show how the WBS would look i..

Air and water pollution and discovery before inventions : Consider such things as dangers to humans, the depletion of resources, air and water pollution, discovery before inventions, impact on wildlife and humans (health and safety), long-term and short-term effects, waste disposal, and aesthetic considerat..

Federal trade commission and internal revenue service : Many administrative agencies. such at the Federal Trade Commission and the Internal Revenue Service, have the power to promulgate regulations that have the force of law, to conduct investigations of potential violations of those reglations, to bring ..

Go global by means of e-commerce : Suppose that you are the CEO of an organization that intends to "go global" by means of e-commerce in the next three years. What are the most difficult problems that you should expect to encounter? What are the major considerations to which you shoul..

Determine best way to allocate monthly advertising budget : The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1000 between newspaper advertising and radio advertising. Management decided that at least 25 percent of the budget must be spent on each type ..

Benefits of employee development programs : What are some of the benefits of Employee Development Programs? Have you participated in an employee development program? If so, was it beneficial to you and in what way? If not, would you want to participate and what would be your goal?

Alternate work arrangements include flextime-job sharing : Alternate work arrangements include flextime, job sharing, and telecommuting. Define (1) flextime, (2) telecommuting, and (3) job-sharing. (4) Discuss which, IN YOUR OWN OPINION, is the best alternate work arrangement, and why?

Gasoline product to two distribution terminals : Three refineries send a gasoline product to two distribution terminals through a pipeline network. Any demand that cannot be satisfied through the network is acquired from other sources. The pipeline network is served by three pumping stations, as sh..

Specific challenges to working in multidisciplinary team : From readings in your textbook along with one outside reference, identify at least three specific challenges to working in a multidisciplinary team. How might these problems get in the way of progress? How might you, as a health care leader, resolve ..

User Account

All Pages