Determine the advertising budget for your company

Assignment Help Other Subject

Reference no: EM131230782

For each of the following, build a model on excel. In addition, for problem 1 perform a sensitivity analysis and construct a Tornado Chart.

1. You have been asked to build a model to help determine the advertising budget for your company for a specific product. The product sells for $10 and has a $9 cost to produce each unit as well as a fixed cost of $10,000. Your marketing department estimates that demand as a function of advertising budget can be expressed as follows:

Demand = 333.8 * Advertising^(.454)Only build excel models for 2 and 3

2. An electronics firm is currently manufacturing an item that has a variable cost of $0.60 per unit and selling price of $1.10 per unit. Fixed costs are $15,500. Current demand is 32,000 units. The firm can substantially improve the product quality by adding a new piece of equipment at an additional fixed cost of $8,000. Variable cost would increase to $0.70 but the demand is expected to jump to 50,000 units due to the higher quality of the product. Should the company buy the new equipment?

3. Your publishing company is launching a new book soon and it has decided to release a hard cover and a paperback version at the same time. The cost to produce each hard cover book is $12 and the cost to produce each paperback book is $8.

You company wants you to build a model to estimate the total profit associated with the two books based on the price for each book and the advertising budget. The company's marketing department has estimated the total number of books that will be sold according to the following equations:

Hardcover: QHardCover = (10,000*(12 - PHardCover*.03) * Advertising^0.2

Paperback: QPaperback = (15,000*(8 - PPaperback*.04) * Advertising^0.2

Notes:

QHardCover - Quantity of hardcover books sold

PHardCover - Price of hardcover book

QPaperback - Quantity of paperback books sold

PPaperback - Price of paperback book

Advertising - Amount spent on advertising the book.

Reference no: EM131230782

Questions Cloud

Determine the expected payments to be received by iowa city : Determine the initial fee paid, and also determine the expected payments to be received by Iowa City if LIBOR moves as forecasted.

Explain the exchange rate system : Explain the exchange rate system that existed during the 1950s and 1960s. How did the Smithsonian Agreement in 1971 revise it?

Discuss possible causes of action as well as relevant defens : Discuss any possible causes of action as well as relevant defenses. Only discuss relevant issues! I am not as interested in your outcome (who will end up winning) as I am in how you use the law to support your points.

Difference between freely floating system and a dirty float : Explain the difference between a freely floating system and a dirty float. Which type is more representative of the U.S. system?

Determine the advertising budget for your company : You have been asked to build a model to help determine the advertising budget for your company for a specific product. The product sells for $10 and has a $9 cost to produce each unit as well as a fixed cost of $10,000

How quotas affect the value of the euro : Assume that European countries impose a quota on goods imported from the United States and that the United States does not plan to retaliate. - How could this affect the value of the euro? Explain.

Discuss the influence the decision-making process : Describe ways the team overcame barriers to creativity to identify solutions. Discuss how critical thinking was applied to come up with potential solutions and to motivate change.

Explain the value of the cba for each constituency : Evaluate the value of the CBA for each constituency and integrate these estimates into a scenario model and/or decision tree. Analyze the results.

Briefly discuss school bonding practices : What role has the federal government usually played in providing capital outlay funding - Briefly discuss school bonding practices.

User Account

All Pages