What is the optimal price and advertising combination

Assignment Help Operation Management

Reference no: EM131694670

Assume that the number of units sold of a product is given by 100-0.5p+26√A , where P is the price (in dollars) charged for the product and A is the amount spent on advertising (in thousands of dollars). Each unit of the product costs $5 to produce. Use a 2-way data table to find the combination of price and advertising that maximizes profit. You must pick out the ranges for the data table, and use trial and error to zoom in on the correct ranges that include the optimal price/advertising combination. (To validate your model, if the price is $10, and the advertising dollars are $10,000, then the profit should be about -$9 thousand [so you’d lose money]) .

Hint: Recall the units of A in the formula. It’s in thousands. So that if you spend 5000 in advertising, then your formula would be 100-0.5p+26√5 . However, you still incur the full 5000 as part of your costs.

Turn in your spreadsheet and answer the following.

1) What is the optimal price/advertising combination?

2) Describe in words why the above equation ( 100-0.5p+26√A) makes sense in a way a non-supply chain person would understand. Plot the relationship of demand vs. price and demand vs. advertising dollars in a rough handsketch as part of this. What might be the reason behind these relationships? Describe.

Reference no: EM131694670

Questions Cloud

Converting parts of a product into an entire finished good : TrueBiz Corp. follows a system wherein all the activities of the company are directed toward converting parts of a product into an entire finished good.

Identify four major options for overcoming labor shortage : Identify Four Major Options for Overcoming a Labor Shortage.

Manufacturer has established itself on the ability to supply : A small printed-circuit board manufacturer has established itself on the ability to supply a large variety of small orders in a timely manner.

Examine the three main ways to organize a resume : Examine the three main ways to organize a resume.

What is the optimal price and advertising combination : What is the optimal price/advertising combination?

Which competitive compensation strategy : Which competitive compensation strategy would you recommend to an employer

Decisions often involve and international component : Buying decisions are complex for retailers as the decisions often involve and international component.

Mean number of days before a cartridge runs out of ink : A manufacturer of a printer determines that the mean number of days before a cartridge runs out of ink is 75 days, with a standard deviation of 6 days.

Background leading up to the passage of new overtime rule : Review the background leading up to the passage of the new overtime rule, as well as the FLSA guidelines for exempt and nonexempt employees.

User Account

All Pages