User Account

All Pages

Linear programming to a business scenario

Assignment Help Basic Statistics
Reference no: EM132072977

The question my professor asked was to apply Linear Programming to a 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) - Number of Potential Customers Attracted per Ad 1,500

Magazine Ads (M) - Number of Potential Customers Attracted per Ad 500

Sunday Supplement - (SS)Number of Potential Customers Attracted per Ad 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

The question is to 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. I don't understand how to use excel to implement a linear programming procedures. Can someone give me steps or tell me where to begin as starting point?

Reference no: EM132072977

Questions Cloud

What is the standard deviation of your portfolio : A pension fund manager is considering three mutual funds. What is the standard deviation of your portfolio?
Population mean amount spent on groceries : Using the following data, construct and interpret a 95% confidence interval for the population mean amount spent on groceries (in dollars) by Connecticut
How well does the american government of today reflect : How well does the American Government of today reflect the will of the American people?
How a sample of dna is collected and prepared for study : Deoxyribonucleic acid (DNA) profiling is a laboratory method used by forensic scientists to determine the identification of individuals by their unique DNA.
Linear programming to a business scenario : The question my professor asked was to apply Linear Programming to a business scenario.
Record entries for the disposal : Wang Co. has delivery equipment that cost $54,470 and has been depreciated $24,880. Record entries for the disposal
Demonstrate personal passion for your position : Demonstrate personal passion for your position and critical thinking with persuasive language, sound logic, valid claims, and credible support for the claims.
Appropriate for examining the association : What type of analysis is most appropriate for examining the association between race/ethnicity and treatment arm in large sample size.
What is the capitalized equivalent worth of infinite annuity : What is the Capitalized Equivalent worth of an infinite annuity of $1,000 paid every other year, when the interest rate is 11% annually?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Constructive replication and participant replication

What is an example of Exact replication, conceptual replication, constructive replication and participant replication?

  A researcher has been hired by a pizzeria to determine

question a researcher has been hired by a pizzeria to determine which type of crust customers prefer. the restaurant

  Main effects are dear of blocks

How would you design a 25-1 design in eight blocks of size 2 so that main effects are dear of blocks? Comment on the two runs that comprise each block.

  Randomized groups and repeated measures factorial designs

Describe a 2 x 2 x 3 factorial design. How many independent variables are involved, and how many levels are there of each variable? How many experimental conditions are in a 2 x 2 x 3 factorial design?

  Find probability of security system

RELIABILITY OF SECURITY SYSTEMS Before being allowed to enter a maximum-security area at a military installation, a person must pass three independent.

  Computing expected values and decision making

There is a probability that the river will flood next year. Riverside's profits for the coming year depend on whether Laura buys the flood insurance and whether the river floods.

  General population of adults in united states

Dr. Bundy recently earned permission from the warden of a local prison to use prisoners to study the effects of the drug Zoloft on depression.

  What is the value of the preferred stock

The preferred stock of Callahan Equipment Corp. has a $50 par value and 5.5% annual dividend. If the required rate of return is 7.5%, what is the value.

  Number of american voters

Use the frequency? distribution, which shows the number of American voters? (in millions) according to? age, to find the probability that a voter

  What is distribution of the nonconforming items in sample

What is the distribution of the nonconforming items in the sample?- Find the probability of obtaining no more than 3 nonconforming items in the sample.

  Average number of inferior quality grapefruit per box

Adverse growing conditions have caused 5% of grapefruit grown in a certain region to be of inferior quality. Grapefruit are sold by the dozen.

  Problem regarding the marketing communications mix

Marketing communications are the means by which firms seek to inform, persuade, and remind consumers-directly and indirectly-about the products and brands that they offer.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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