How much time to allocate in radio-television advertising

Assignment Help Financial Management

Reference no: EM131187995

A brand manager for ColPal Products must determine how much time to allocate between radio and television advertising during the next month. Market research has provided estimates of the audience exposure for each minute of advertising in each medium, which it would like to maximize. Costs per minute of advertising are also known, and the manager has a limited budget of $25,000. The manager has decided that because television ads have been found to be much more effective than radio ads, at least 70% of the time should be allocated to television. Suppose that we have the following data:

Type of Ad Exposure/Minute Cost/Minute

Radio 350 $ 400

TV 800 $2000'

c. Set up your linear program in Microsoft Excel. Solve it using the Solver add-in.

d. What is the optimal solution? Identify the number of desks to build and the total profit.

e. Which constraints use all of the available resources? Which constraints have resources remaining?

Reference no: EM131187995

Questions Cloud

Assuming that corporate bond pays coupon : Assuming that corporate bond pays coupon of 7% of par value of the bond. If par value/face value of the bond is $10,000, how much you would pay for this bond if your discount rate/required rate of return is equal to 8%

Difference between net income and cash flow : Using the table below, explain the difference between net income and cash flow from operating activities for Techno in 2009 and analyze their cash flows for 2008 and 2009. (in thousands) 2009 2008 Net income $ 316,354 $ 242,329 Noncash charges (credi..

Total amount of interest the person : A customer come to you and asks to receive valuable advice supported with calculations on the purchase of used car. Assuming the car costs $91,500 and would be fully financed from bank for 4 years and at interest of 7%, Total amount of interest the p..

How many shares are outstanding : The authorized share capital of the Alfred Cake Company is 120,000 shares. The equity is currently shown in the company's books as follows: How many shares are issued? How many shares are outstanding?

How much time to allocate in radio-television advertising : A brand manager for ColPal Products must determine how much time to allocate between radio and television advertising during the next month. Market research has provided estimates of the audience exposure for each minute of advertising in each medium..

Excluded from the state unemployment tax : Jania makes $2,130 in January of this year. If her employer is entitled to the maximum FUTA credit, what SUTA and FUTA tax does her employer owe on these wages if the SUTA tax rate is 5.4%? If all of the employees wages were excluded from the state u..

What is its self-supporting growth rate : Maggie's Muffins, Inc., generated $4,000,000 in sales during 2016, and its year-end total assets were $2,400,000. Also, at year-end 2016, current liabilities were $1,000,000, consisting of $300,000 of notes payable, $500,000 of accounts payable, and ..

Studied financial ratios and other quantitative measures : Throughout this course we have studied financial ratios and other quantitative measures. In at least three well composed paragraphs, select what financial ratios or measures you believe are most useful in identifying business risks. What would you lo..

Calculate times-interest-earned ratio : As the chief finacial officer of Cascade Designs, Calculate Cascade's times-interest-earned ratio for next year assuming the firm raises $70 million of new debt at an interest rate of 6%. Calculate Cascade's time-burden-covered ratio for next year as..

User Account

All Pages