Question: I keep getting a 0 when I use the Solver in Excel so not sure what im doing wrong some help to solve these would

I keep getting a 0 when I use the Solver in Excel so not sure what im doing wrong some help to solve these would be appreciated.

maximum media usage limitations are as shown. (a) If the promotional budqet is limited to $27,400, 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? (Round your answer to the nearest whole number.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

I keep getting a 0 when I use the Solver in Excel so not sure what im doing wrong some help to solve these would be appreciated. maximum media usage limitations are as shown. (a) If the promotional...

atter? 7.8 AD-ROBIC EXERCISES A. Briefing for New Business Select a business in your town that is of interest to you. This can be a retail business with competition in the market. Or it can be a...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

This text was adapted by The Saylor Foundation under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License without attribution as requested by the work's original creator or licensee. 1...

CASE its lose in ROSE TREE REGIONAL AIRLINE or ad- ying Decision Support Using Microsoft Excel Solver PREVIEW onse Tree Regional Airline provides passenger transportation services and small-parcel...

Business Event Analysis: Complete the following table based on the specified NBD event. Receive Shipment (From Supplier) Trigger(s) (also indicate type) Collected Data (originates as input for event)...

PLEASE HELP ME!! THIS IS AN EMERGENCY!!! CAN YOU PLEASE DO THIS AS SOON AS HUMANLY POSSIBLE.. New Perspectives Excel 2019 | Module 8: End of Module Project 2 Expo Events EXPLORE BUSINESS OPTIONS WITH...

\fNew research suggests that the most effective executives use a collection o f distinct leadership styles each in the right measure, at just the right time. Such flexibility is tough to put into...

I'm having a hard time understanding this fact sheet assignment. I was wondering if someone could direct me into what to do with this assignment. I don't know what a fact sheet is. I'm thinking that...

HI, Need assistance with this data case. It does not has to be every single question, any help is much appreciated. Data case 2 Econ 670 Show all your work to receive full credit. Completed...

Solve the following problems, state all your assumptions and considerations: 4. Using data for the 2x3-10 pump (Fig. 4-16) at 3,560 rpms: (a) Estimate the performance characteristics (H, Q,...

When an OH molecule undergoes a transition from the n = 0 to the n = 1 vibrational level, its internal vibrational energy increases by 0.463eV. Calculate the frequency of Vibration and the force...

LO 4 . 6 . Why is accurate assessment and measurement of ROM important?

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...