Regarding potential customer reached-costs per advertisement

Assignment Help Financial Management
Reference no: EM131238024

Set up and solve in Excel Solver the following problems:

A company is considering various advertising media to promote its new toy. Pertinent information regarding potential customers reached and costs per advertisement is given below:

No. of Customers Maximum Times Cost per

Media Reached Available per Month Advertisement

Daytime TV 1000 10 $2000

Evening TV 3000 8 $3500

Daytime Radio 500 15 $1000

Evening radio 750 15 $1500

Newspaper 900 4 $500

Currently, the company has a monthly advertising budget of $150,000. The marketing department has imposed the following restrictions:

• No more than $20,000 may be spent on radio advertising each month.

• At least 5 TV ads must be used each month.

Write the linear programming formulation to determine what media should be used to maximize monthly audience exposure.

Reference no: EM131238024

What is the npv of the proposal and should it be undertaken

Corregin Ind. is trying to analyze it capital structure and the various cost components therein. Various inputs include the risk free rate which is 2.8%, ß for the firm is .97

Investment return-what was your percent return

Investment Return MedTech Corp stock was $51.80 per share at the end of last year. Since then, it paid a $1.30 per share dividend. The stock price is currently $63.35. If you

Has exchange in your state gained broad market recognition

Given your state’s choices regarding EHBs, type of exchange (state-run, state-federal partnership, or federally run), Medicaid expansion efforts, and so forth, how would you a

Interest in the account is compounded semiannually

You deposit ?$500 in a bank in a 9 ?-year time deposit. With a time deposit you cannot withdraw funds from the account until the end of the term. Interest in the account is co

Preparing savings plan to meet the objectives

Ms. Ieda Silva plans to retire in 30 years and expects to live for 20 years after retirement. She is preparing a savings plan to meet the following objectives. First, after re

Lost annual income from savings on those refunds

If 400,000 people each receive an average refund of $2,400, based on an interest rate of 4 percent, what would be the lost annual income from savings on those refunds? Assume

What would happen to exchange and interest rates

An asset manager has conducted an extensive econometric study and proposes a forecasting model. What type of forward transaction would you conduct to capitalize on your fore

What is the cross rate of the zloty with respect to yen

Cross exchange rate. Assume Poland's currency (the zloty) is worth £0.17 and the Japanese yen is worth £0.005. What is the cross (implied) rate of the zloty with respect to


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd