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

In "Blingblong Takes the World", a famous online role-playing game, the titular character's total damage is computed by taking the product of the critical rate x and critical damage y under the constraint x + % maximum damage to an opponent if c = 100%. = c. Find the critical rate and critical damage needed to inflict the
Example 3. Food I contains 10 units of vitamin A and 12 unit of vitamin R gram and cost 20 paise per gram. Food II contains 7 unit of vitamin A and 15 unis of vitamin B and costs 18 paise per gram. The daily requirement of vitamin A and R are atleast 80 units and 90 units respectively. Formulate the above as an LPP to per minimise the cost. CS Scanned with CamScanner
Entomologists estimate that an average person consumes almost a pound of bug parts each year. There are that many insect eggs, larvae, and miscellaneous body pieces in the foods we eat and the liquids we drink. The Food and drug administration (FDA) sets a food defect action Level (FDAL) for each product: Bug-part concentrations below the FDAL are considered acceptable. The legal limit for peanut butter, for example, is thirty insect fragments per hundred games. Suppose the crackers you just bought from a vending machine are spread with twenty grams of peanut butter. What are the chances that your snack will include at least five crunchy critters?
A company has $19,310 avallable per month for advertlsing. Newspaper ads cost $160 each and can't run more than 22 times per month. Radio ads cost $620 each and can't run more than 31 times per month at this price. Each newspaper ad reaches 6500 potential customers, and each radio ad reaches 7700 potential customers. The company wants to maximize the number of ad exposures to potential customers. Use n for number of Newspaper advertisements and r for number of Radio advertisements. Maximize P = subject to 22 < 31 < $19, 310 Enter the solution below. If needed, round ads to 1 decimal palace and group exposure to the
A pet food factory blends four ingredients into three types of pet food: value, premium, and basic. The maximum quantities available of each ingredient and the costs per ounce are given in the table below: Ingredient Maximum pounds available per day Cost per ounce 5,000 $0.5625 2 2,400 $0.4375 3 4,000 $0.7500 4 1,500 $0.3750 The operations manager has placed limits on the component to be added to each blend. The limits and the selling price for each blend are shown in the table below: Variant Component Specifications Selling Price per pound Value Not less than 40% of 1 $12.00 Value Not more than 20% of 2 $12.00 Value Not less than 30% of 3 $12.00 Premium Not less than 40% of 3 $18.00 Basic Not more than 50% of 2 $10.00 Basic Not less than 10% of 1 $10.00 The marketing manager wants to produce at least 3,000 pounds of each variant of pet food. Develop a linear programming model to help the company determine the best mix to produce to maximize profits. Determine the optimal solution and…
Please solve the last part. g
Please check my attached case problem.
Case Whole Foods Market Grows Through Mergers and Acquisitions Over three decades ago, four businesspeople who had experience in retailing natural foods through food stores believed that there was a demand for a supermarket for natural foods. As a result, in 1980 in Austin, Texas, they founded the first Whole Foods Market store in a building that had around 10,000 square feet and a staff of 19. This store was quite large compared to health food stores at the time. By 1984, the company was successful enough to expand to Houston and Dallas. In 1988, they purchased the Whole Food Company in New Orleans and expanded there. The next year, they moved into the West Coast with a store in Palo Alto, California. Even though the company has built a number of its own stores, much of the company growth has come through mergers and acquisitions, many of which came in the 1990s in such places as North Carolina, Massachusetts, Rhode Island, both Northern and Southern California, and Michigan. After…
1. Mary has been placed on a strict diet. She monitors her food very carefully. One day at lunch, she plans to have tuna fish sandwiches and tomato soup. The nutrients per serving are found in the table below: Fat (g) Sodium (mg) Protein Sandwich 10 200 20 Soup 4 400 10 Mary can have no more than 34 grams of fat and 1000 mg of sodium. How many servings of soup and sandwich can she have for lunch to maximize her protein intake? a) Define the variables: b) What are the constraint inequalities? Inequality concerning sodium: Inequality concerning fat: c) What is the objective function?
You are proxided with the following information about your city: Total population 2020 = 85,000 Median household income 2020 = € 36,000 Average household income 2020 = € 42,000 Sales of clothes and shoes per square meter in 2020 = € 2,340 Make whatever assumptions areneeded and estimate the total required square meters of clothing and shoe stores in your city in 2021. Show clearly and explain all the formulas and assumptions that you use for your calculations.
General Ford produces cars in Los Angeles and Detroit and has a warehouse in Atlanta. The company supplies cars to customers in Houston and Tampa. The costs of shipping a car between various points are listed as the table below. where a blank means that a shipment is not allowed. Los Angeles can produce up to 1600 cars, and Detroit can produce up to 3200 cars. Houston must receive 1800 cars, and Tampa must receive 2900 cars. 1. Determine how to minimize the cost of meeting demands in Houston and Tampa. 2. Modify the answer to part a if no shipments through Atlanta are allowed. From LA Detroit Atlanta Houston Tampa To LA Detroit $97 $94 $87 $129 $147 $100 $103 $145 Atlanta Houston $95 $125 $103 $110 $95 $88 $60 $103 Tampa $156 $148 $56 $100
The new city water company that you have researched charges homeowners based on how much water they use in thousands of gallons. The company progressively charges at a higher rate the more water that is used. Cost of Water Bill (dollars) 240 230 220 210 190 180 170 160 110 Water Usage (in thousands of gallons) 11. Based on the graph above, how much does the city charge when a homeowner uses the following number of gallons of water: a) 1700 gallons of water b) 2000 gallons of water c) 7000 gallons of water 12. Finish filling in the following piece-wise equation below that describes the chart based on the graph 50 if 0 < x <2 5x+50 y = if 6≤x≤8 30x 140

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