How to conduct effective marketing campaign

Assignment Help Operation Management

Reference no: EM132151016

In this assignment, you will use Excel's "what if" capabilities to help a company (Lifetime Fitness Center) to decide how to conduct an effective marketing campaign. The question is: What mix of advertising media should be used to maximize the net income? The case background and required analysis are given in this document: DSS CasePreview the documentView in a new window. You can build your own Excel DSS, or using this partially completed design: LFC-DSSPreview the documentView in a new window Submit the DSS Case analysis, including both the DSS spreadsheet and the business memo (MS Word file)

Excel Solver Demo: ExcelSolverView in a new window Note that I did not enter all the constraints. Thus the answer in the demo is NOT correct. You should add those minimum constraints and the limit on total number of ads (Ellen Goldsteinvice president of marketing at LFC she wants to know what sort of advertising media to use, and how many advertisements in each media to place, to maximize net income.

Reference no: EM132151016

Questions Cloud

Which of given principles can you apply at your workplace : The general structure and scope of operations involves the structural, functional, and environmental aspects that affects an organization's decisions.

Benefits and minimize the damages from big data trend : Introduce two specific strategies and/or solutions to maximize the benefits and minimize the damages from big data trend

Explain the programming paradigm in detail : Initial post: Modern-day languages do not subscribe to one programming paradigm; multiple programming paradigms are embedded in a language.

What behaviors does the leader exhibit : Does his or her leadership approach seem to work well in actual business settings? Provide illustrative examples.

How to conduct effective marketing campaign : You will use Excel's "what if" capabilities to help a company (Lifetime Fitness Center) to decide how to conduct an effective marketing campaign.

Describing the purpose of a browser : Use the information in the video and this week's in-class presentation to write a 250-300 word short essay describing the purpose of a browser, browser wars.

Discuss the economic interpretation of your results : After reviewing the ratios of Starbucks there are a few areas that can be commented on. Overall Starbucks is a very consistent and stable company financially.

Discuss microsoft active directory domain group policy : Discuss 5 tweaks you can do in a Microsoft Active Directory domain group policy to enhance an enterprise defense-in-depth (DiD) strategy.

What data management considerations : What data management considerations must be reviewed to ensure success for both companies and assure regulatory compliance

User Account

All Pages