Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

I need to know how to set up the following in Excel in order to run a linear programming. I have the add ons to

I need to know how to set up the following in Excel in order to run a linear programming. I have the add ons to do it. Here is the problem.

Please apply Linear Programming to a following business scenario: A firm plans to use three different types of ads to attract potential customers to its product. The three ad choices are TV ads, Magazine ads, and Sunday Supplement. The following table shows the number of potential customers one ad can reach: TV Ads (TV) Magazine Ads (M) Sunday Supplement (SS) Number of Potential Customers Attracted per Ad 1,500 500 500 There are two categories of spending per ad as below ($, Thousands): Cost Per Ad ($Thousands) TV Ads (TV) Magazine Ads (M) Sunday Supplement (SS) Ad Budget 250 100 100 Planning Budget 100 50 50 There are following constraints: Total Ad Budget 3,500 Total Planning Budget 1,500 Total Number of TV Ads 5 Find the optimal numbers of TV ads, Magazine ads, and Sunday Supplement so that the total number of the potential customers attracted by these ads can be MAXIMIXZED. Use the associated EXCEL file to implement your linear programming procedures. When you run the linear programming, choose both Simplex LP and GRG Nonlinear Solving Method.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To solve this linear programming problem in Excel using the Solver addin follow these steps Step 1 S... blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Ethics Ethical Decision Making And Cases

Authors: O. C. Ferrell, John Fraedrich, Linda Ferrell

12th Edition

9781337614436

Students also viewed these Mathematics questions