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.