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

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING 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!

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