Develop a linear programming model that can be used

Assignment Help Operation Management
Reference no: EM133299367

Question: American Dream, is a retail and entertainment complex located in the Meadowlands Sports Complex in Rutherford, NJ. The mega-sized mall opened only a few months prior to the start of COVID in the United States. Given their untimely launch and negative press, they have been working hard to promote their 3-million square foot retail and entertainment establishment. The management team requested your recommendations on how to allocate their digital advertising budget across Social Media, Satellite Radio (such as SiriusXM), and Music Streaming Services (such as Spotify). American Dream's digital marketing budget for next quarter is set at $375,000.

The marketing agency has provided the following information about the industry exposure effectiveness rating per ad, the estimate of the number of potential new customers reached per ad, and the cost for each ad.

MEDIA Effectiveness Metric per Ad New customers per Ad Cost per Ad
Social Media  100 4000 $9,000
Satellite Radio  30 2000 $3,000
Music Streaming Services 15 1000 $1,000

The effectiveness metric scores the value of the ad to existing customers and potential new customers. The score is based on qualitative measures such as image satisfaction, message recall, and visual and audio appeal. More expensive Social Media ads will have higher effectiveness scores along with greater potential for reaching new customers.

While the effectiveness metric is a great means to compare campaigns, the score itself is only applicable to the first few advertisements in each medium. For example, Social Media has an effectiveness metric of 100 and a reach to 4000 new customers per ad. These scores are only reliable for the first 14 Social Media ads. After 14 ads, the benefit declines. For purposes of analysis, you can assume that the effectiveness metric for Social Media drops to 65 and the potential new customers reached drops to 1500 per Social Media ad beyond the first 14. For Satellite Radio ads, the effectiveness metric is only reliable for a maximum of 20 ads. After the 20 ads, the effectiveness metric declines to 20 and the number of new customers reached declines to 1200 per ad. Similarly, for Music Streaming Services ads, the effectiveness metric is only reliable for a maximum of 27 ads; the effectiveness metric declines to 8 and the potential number of new customers reached declines to 200 per ad.

American Dream's management team accepted maximizing the total effectiveness metric, across all media, as the objective of this digital advertising campaign; however, they are insisting that the total of all ads purchased must reach at least 100,000 new customers. American Dream's management team also insist on the following guidelines:

Use at least twice as many Satellite Radio ads as Social Media ads
Use no more than 20 Social Media advertisements.
The Social Media budget should be at least $160,000
The Satellite Radio budget is restricted to a maximum of $150,000
The Music Streaming Services budget is to be at least $35,000

Use optimization techniques to provide a recommendation on how to best allocate the $375,000 advertising budget across these three digital marketing options. Develop a linear programming model that can be used to optimize the advertising budget allocation. Enter the problem into Excel and use Solver to solve for the optimal solution.

Reference no: EM133299367

Questions Cloud

Identify each of the managed care models : Describe key Characterists of each managed care model and Identify each of the managed care models - Explain a recommendation for which model you personally
What benefit does a global strategy provide an organization : MGT 600 American InterContinental University, Atlanta What benefit does a global strategy provide an organization? Describe a situation when a global strategy
Describe the ways corporate and brand reputations : Describe three or four ways that a food manufacturer can employ philanthropic programs to enhance their corporate and brand reputations
Established market participants : The threat of new entrants indicates how new market participants offer a threat to established market participants.
Develop a linear programming model that can be used : INFO 562 Montclair State University Develop a linear programming model that can be used to optimize the advertising budget allocation
Apply the different latitudes : Apply the different latitudes in Figure 3.1. to the reactions people might have to your talk. Why would they have these reactions?
What value discipline, or combinations of value disciplines : MBA 662 George Mason University what value discipline, or combinations of value disciplines, is Bombardier espousing? Provide justifications for the one(s) you
What should corporate communications role in a company : Should corporate communications have a say in a company's business decisions, or should they be limited to communicate the decision, what should their role be?
Which type of sourcing calendar gap and zara : Gap, Inc. is considered a competitor of Zara's. Keeping the sourcing calendar in mind, Identify which type of sourcing calendar Zara would follow and why.

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd