Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. can someone help with the steps on excel, i am stu

Can someone help with the steps on Excel, I am stuck in this question. ...

90.2K

Verified Solution

Question

Accounting

image

Can someone help with the steps on Excel, I am stuck in this question.

The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and newspaper. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Audience per advertisement Cost per advertisement Maximum media usage Television 100,000 $2,000 10 Radio 18,000 $300 Newspaper 40,000 $600 10 20 To ensure a balanced use of advertising media, radio advertisements must not exceed 50 percent of the total number of advertisements authorized. In addition, television should account for at least 10 percent of the total number of advertisements authorized. a. If the promotional budget is limited to $18,200, how many commercial messages should be run on each medium to maximize total audience contact? What is the allocation of the budget among the three media, and what is the total audience reached? b. By how much would audience contact increase if an extra $100 were allocated to the promotional budget

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Consider an industry comprised of a dominant firm with a competitive fringe. Each firm produces a...

Economics
Q

Anxiety disorders are among the most commonly diagnosed psychological issues in children, with numbers at any...

Psychology
Q

The past few modules introduced various ways to solve a differential equation, separation of variables, integrating...

Advance Math
Q

For the rhombus below find the measures of Z1 Z2 Z3 and 24 2 1...

Geometry
Q

2 Evaluate the double integral where R is the triangle given below y 2 4...

Algebra
Q

Find the matrix P if it exists which diagonalize the matrix 1 3 3 3...

Algebra
Q

Black Litterman Model (25pt) Consider a market with one risk-free asset and...

Accounting
Q

Accounting Information Systems and Technology Introduction: Accounting Information Systems (AIS)...

Accounting
Q

Data concerning Cranur Architects Corporations two major business lines are given below: ...

Accounting
Q

) Prepaid rent shows a beginning balance of $500 and an ending balance of $600....

Accounting
Q

Rahm Robotics Inc (RRI) is considering a large investment of $20,000,000 in a new project....

Finance
Q

34. A newly issued 10 -year maturity, 4% coupon bond making annual coupon payments is...

Finance