3 please help me can you show me step by stephow you get the answer please im reallyconfusedAn ad campaign ror a new snack chip WIll be conaucted in a limited geograpnical area and can use TVtime, 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 achieve anexposure quality of at least 1000, (3) the number of TV ads cannot exceed the number of radio ads bymore than 4.Develop and solve an LP model to determine the number of ads in each medium in order to maximize thetotal number reached.Hint: to avoid errors and confusions, first write down the algebraic formulation on paper before solving themodel in Excel.(a) What is the optimal solution?Optimal number of TV ads isOptimal number of Radio ads isOptimal number of Newspaper ads is(b) The maximum total number reached is(c)How much do they have to pay for the optimal number of TV ads?

Let T, R, and N be the number of ads in TV, radio, and newspaper respectively. Objective function:…

Answered: please help me can you show me step by…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Subject: Engineering Management, Ch. 3 - Planning Technical Activities Marketing plan- this is the written document or blueprint for implementing and controlling an organization's marketing activities related to a particular marketing strategy." Please explain each of the content of Marketing Plan. (just a brief description)•The Executive Summary •Table of Contents •Situational Analysis and Target Market•Marketing Objectives and Goals •Marketing Strategies•Marketing Tactics •Schedules and Budgets •Financial Data and Control
Q.2.1 King 4 recommends that there be a majority of non-executive, independentdirectors on the board of directors. Provide a brief explanation for thisrecommendation. Q.2.2. What is a director and a board of directors? Briefly explain with reference to whatthey do.
Q.6. What are the two types of decision making?
D & R A1 3 - 4 Question 3. Stock Futures with Dividends Today is January 3. Your friend David has just bought a futures contract on a stock index, and the contract specifies one year to expiration. The current share price is $80, and the annually compounded interest rate is 10%. The stock will pay quarterly dividends of $2 during the next year, with dividends payments on the following dates: January 25 April 25 July 25 October 25 Assume that this is a non-leap year. Suppose that, instead of paying a quarterly dividend of $2, the stock index has an annual dividend yield of 10%. The continuously compounded interest rate is 10.52%. What is the price of the index futures on January 3? What is its value on February 17 when the index turns out to be $90?
Q.3: Marketing Managements’ job is to build relationship with customers by creating customer value and satisfaction, however marketing manager cannot do this alone. Describe how the major actors in microenvironment can help marketing manager to create customer value and satisfactions?
Complete the Case Problem (Ch. 15) As the newly named president and CEO of Tourism Banff, the Destination Management Organization for the world-famous iconic tourism community location in Banff National Park (BNP), and Canada’s first and most famous national park, you have been asked to formulate a tourism development and promotion policy which balances the needs of residents of the small community of 6,700 permanent residents and the over 5 million annual visitors to BNP. In formulating the requested policy, keep in mind that the town of Banff is located in a National Park, how would you balance the rights and responsibilities of: ENDNOTES a. permanent residents of the community; b. visitors living in the nearby city of Calgary; and c. visitors from the rest of Canada? How would you decide which kind of tourism activities you would both allow and encourage within the National Park?
18- Ahmed has a business of manufacturing plastic. He sells plastic to a water factory. The water factory uses plastic to make water bottles. What kind of goods does Ahmed manufacture? a. General merchandise b. Building goods c. Consumer goods d. Industrial goods
3. WHAT ARE THE TYPES OF GUESTS IN THE HOTEL WHO ARE GIVEN SPECIAL ATTENTION а. b. c. d.
Topic: “What are some causes of rising food prices and the challenges faced by rural farmers in Mt. Royal, Carriacou.” 1. Based on the topic above provide a hypothesis 2. Provide a rationale and purpose of the topic above.
(lbs)
Q1 Suppose You are running a software house. You are new in the market. What kind of security threats you have? How you will encounter them. Elaborate.
Question 1: HEET company was established in 2013 with an aim to provide household electronics at a competitive price. The company is growing bigger from 95 employees in the beginning to more than 500 employees in 2022. The CEO of the company, Mr Abdulla in an interview said that "Yes we are growing but we still believe in the traditional organization structures. However, given the nature of our products, we may consider moving from mechanistic to organic type of organization". A. Describe the three traditional organization structures that the CEO is referring to. B. Differentiate between mechanistic and organic structures with reference to the above company.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS