A car dealership needs to determine how to allocate its $20,000 advertising budget. They have estimated the

Question:

A car dealership needs to determine how to allocate its $20,000 advertising budget. They have estimated the expected profit from each dollar (X) spent in four different advertising media as follows:

Medium Expected Profit

Newspaper ......100X0.7

Radio ........125X0.65

TV .........180X0.6

Direct Mail ......250X0.5

If the company wants to spend at least $500 on each medium, how should it allocate its advertising budget to maximize profit?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science

ISBN: 978-0324656633

5th edition

Authors: Cliff T. Ragsdale

See More Books

Question Posted: Oct 22, 2012 06:33 AM

See More Questions

A company is trying to determine how to allocate its $145,000 advertising budget for a new product. The company is considering newspaper ads and television commercials as its primary means for...
What is the expected profit from this trading strategy?
You have estimated the expected NPV from a project to be $3,000,000 with a standard deviation of $4,000,000. The distribution of the possible NPVs is approximately normal. If you are willing to...
What is the payback period? Name and discuss three possible reasons that the payback period is used to help make capital investment decisions.
Suppose that V and W are vector spaces. The Cartesian product space, denoted by V W is defined as the set of all ordered pairs (v. w) where v V, w W, with vector addition (v, w) + ( , ) = (v + ,w...
Problem 1.28 on the page 15 describes a survey of 44 graduate students (see the file ). For these data, construct all appropriate tables and charts and write a report summarizing your conclusions. In...
You should have found that the confidence interval when utilizing the paired structure of the data was narrower than the confidence interval ignoring this structure (this will generally be the case,...
Horne executed a $100,000 note in favor of R. C. Clark. On the back of the instrument was a restriction stating that the note could not be transferred, pledged, or otherwise assigned without Hornes...
Can you explain how to set up this problem by providing a response to each prompt using physics concepts or formulas? Please include each math step so I can check my own work. This may involve the...
Examine the AI literature to discover whether the following tasks can currently be solved by computers: a. Playing a decent game of table tennis (Ping-Pong). b. Driving in the center of Cairo, Egypt....
The PENTEL Corporation manufactures three different types of computer chips. Each type of chip requires different amounts of processing time in three different departments as summarized in the...
The XYZ Company produces two products. The total profit achieved from these products is described by the following equation: Every 1,000 units of X1 requires one hour of time in the shipping...
Spontaneous heat transfer from hot to cold is an irreversible process. Calculate the total change in entropy if 4000 J of heat transfer occurs from a hot reservoir at T h = 600 K(327C) to a cold...
Maple syrup ( = 1300 kg/m 3 , = 0.1 Pas) flows through a pipe of cross-sectional area A = 0.1 m2 . Near the end of the pipe, an angled attachment is glued to the pipe to redirect the flow through an...
Assume a price of $ 1 and a contribution margin percentage of 1 5 0 % on cost . Next, calculate ( a ) the variable costs and ( b ) the contribution margin percentage on price.
Long - term debt Deferred income tax liabilities Retiree health care benefits Pension liabilities Operating lease liabilities Other long - term liabilities what type of activity is each ?
You work in the accounting department at Accountants-R-Us, Inc. and just received the December bank statement. Use the following information to create the bank reconciliation for the month-ended...
Daniel and Ashlee are long-term clients of yours, and are getting a divorce. Because of the divorce, their interests will no longer be the same and they are not amicable. Ashlee has said that's he...
Corms differ from bulbs in that they are solid and have nodes and inner nodes. True/False
List four items of financial information you consider to be important to a manager of a business that has been operating for a year.
Mutual funds have a wide variety of investment strategies. And in a particular quarter or over a particular year, some will have substantially higher returns than others. Would you expect these same...
KPS Communications is planning to bring wireless Internet access to the town of Ames, Iowa. Using a geographic information system, KPS has divided Ames into the following 5 by 5 grid. The values in...
A car dealer specializing in late model used cars collected the following data on the selling price and mileage of five cars of the same make and model year at an auto auction: Mileage Price 43,890...
Refer to the previous question. Suppose that the car dealer wanted to find values for A and B that minimized the maximum absolute deviation between the actual and estimated selling price for each...
The Big Beaver Company is trying to choose between the following two mutually exclusive projects: Cash Flow (A) Cash Flow (B) Year 0 -$15,000 -$2,000 1 8,500 2,500 2 8,500 2,500 3 8,500 2,500 A. If...
The following is a list of items that could be included in the intangible assets section of the balance sheet. (a) Indicate which items on the list below would generally be reported as intangible...
How does organizational culture intersect with broader societal norms, values, and trends, and what challenges and opportunities does this present for fostering inclusivity, diversity, and ethical...

A car dealership needs to determine how to allocate its $20,000 advertising budget. They have estimated the

Question:

Step by Step Answer:

Spent Minimum Profit Coefficients Expected Profit Newsp...View the full answer

Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science

Students also viewed these Management Leadership questions