An ad campaign for a new snack chip will be conducted in a limited geographical area and can useTV time, radio time, and newspaper ads. Information about each medium is shown below.MediumCost Per Ad # ReachedExposure QualityTV5001000030Radio250250040Newspaper150200025Consider the following limitations: (1) the advertising budget is $20,000, and (2) they must achievean exposure quality of at least 1000, (3) the number of TV ads cannot exceed the number of radioads by more than 4.Develop and solve an LP model to determine the number of ads in each medium in order tomaximize the total number reached.Hint: to avoid errors and confusions. first ikrite down the algebraic formulation on paper before solvingthe model in Excel.(a) What is the optimal solution?Optimal number of TV ads is 910Optimal number of Radio ads is11Optimal number of Newspaper ads is(b) The maximum total number reached is 12(c)How much do they have to pay for the optimal number of TV ads? 13

Answered: Image /qna-images/answer/a12689d3-87ec-4626-9c6b-55a50755ef0f.jpg

Answered: An ad campaign for a new snack chip be…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

show the work of part a and b and explain
NEED ASAP!!! I'll rate positive for sure...
1. A company produces two colors of cloth, namely red and pink. In order to produce these colors, 2 special raw materials are being used by the company. The production data is given below: Meters of raw material per meter of Maximum daily availability Red Cloth Pink Cloth Raw Material 1 2 1 6 Raw Material 2 4 24 Profit per ton (1000) According to the dealer, the daily maximum demand for red cloth is 2 meters and the daily demand for red cloth can't exceed that for pink cloth by more than 1 meter. The company wants to maximize its daily profit. a. Construct the LP Model of this problem. b. Find the optimal solution using Graphs. (graphing paper or desmos) c. Find the optimal solution using Excel Solver. (Sheet 1) d. Find the optimal solution using Algebraic Solution. e. Find the optimal solution using the Simplex Method. (Not in excel)
You are part of a government task force evaluating whether new models of cars will meet fuel efficiency standards set out by the newly signed climate bill. You have run an ANCOVA model that predicts fuel efficiency (in miles per gallon) as a function of vehicle weight (measured in thousands of lbs, where a value of 2.5 would correspond to 2,500 lbs), horsepower, and number of cylinders in the car (cylinders is a factor in this model with 3 levels: 4 cylinders, 6 cylinders, and 8 cylinders). Your analysis tells you the following; The mean miles per gallon of all cars analyzed is 20.09 The mean weight of all cars analyzed is 3.217 thousand lbs The mean horsepower of all cars analyzed is 146.7 The regression coefficient for weight is -3.18 miles per gallon per additional thousand lbs The regression coefficient for horsepower is -0.023 miles per gallon per additional unit of horsepower Cars with 4 cylinders get 2.13 more miles per gallon, on average, than the average car Toyota is…
Another question is what is the minimum total cost?
C (gross cost of UPS Inc. in billions of $) and R (gross revenue of UPS Inc. in billions of $) O E (years since 2010) and P (gross profit of UPS Inc. in billions of $) (b) Find an equation for a model of these data. (Use the first and last values in the table to calculate your equation. Round the slope and the vertical intercept to one decimal place. Note th -Select- () Give a reasonable domain and range for this model. domain O (-10, 10] O [11, 15] O -0, 0) O [0, 20] O [-2, 8] range [41.9, 47.8] O [-50, 50] [37.3, 52.3] [0, 100] O (-o, co) (d) What is the slope of your model? Explain its meaning in this situation. (Round your slope to one decimal place. Do not include units in your answer.) The slope is This means that the gross profit for UPS Inc. --Select--- by about that value in billions of dollars each year. (e) Estimate the gross profit for UPS in 2019. (Round your answer to the nearest tenth of a billion dollars. Include units in your answer. More information.) In 2019, the…
Question number 3
use graphical method to solve this LP problem.
An advertising company offer three types of mediums: television, newspaper and radio. The cost for each medium with its audience coverage is given below, Television Newspaper Radio Cost per advertisement (S) 1500 k00 b00 Audience per advertisement 97,000 43,000 18,000 The company is capable of using a number of newspaper advertisement slots up to 9. Morcover, in order to balance the advertising among the three types of media, the total number of advertisements on radio should not occur more than 40% of total number of advertisement, and at least 9% of the total number of advertisements should occur on television. The weekly advertising budget is S19400. How many advertisements should be run in each of the thre types of media to maximize the total audience? If we assume the number of ads on each type of meduim as follows : T, N, R respectively Given the following Radio constrain 40T - 40N + mR 0 What is the value of m? Remark: Write your answer in percentage not decimal ( for example…
You have taken a job with Afford Motor Company. The CEO, Kit Carson, has proposed that Afford Motors develop, manufacture, and sell an electric car that she claims will present a great business opportunity for Afford Motors and save the environment from global warming.After investigating numerous prototypes, you and your project team have determined that there are two cars that should be seriously considered: Model A and Model B. Characteristics of these two prototypes are indicated in the table below:R&D and tooling CostMSRPAvg Variable CostRange between Charges(KMS)No of Passengers(Including Driver)Crash test safety ratingModel A$100,000,000$17,500$5,0005024Model B$140,000,000$26,000$7,6008048.5The market research department has estimated that number of electric cars demanded will be a function of the future price of gasoline as well as the car’s characteristics. To forecast the future price of gas, you hired Sandy Shores, a well-known professor and consultant in the Puget…
please do this by hand, not in excel
Needs Complete typed solution with 100 % accuracy.

SEE MORE QUESTIONS

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS