Promotional pieces mailed and anticipated response rate

Assignment Help Financial Management

Reference no: EM131989817

A firm wishes to analyze the relationship between the number of promotional pieces mailed and the anticipated response rate. It wants you to perform a sensitivity analysis of the effect on net profit using the following parameters:

Unit costs for printing the mailer are related to the number printed as follows: $0.20 per unit for quantities less than 200,000; $0.15 per unit for quantities from 200,000 to through 300,000; and $0.10 per unit if print more than 300,000.

Mailing costs are fixed at $0.24 per unit mailed.

The company knows that it will realize an average gross profit per response of $18.50

Their net profit for this example consists of the gross profit minus the printing and mailing costs.

Create a sensitivity analysis model in Excel that allows the firm to analyze the following:

They wish to explore the joint effects of allowing response rates to vary from 1.50 % to 3.25% (in steps of 0.25%) while the number mailed varies from 100,000 to 325,000 (in increments of 25,000).

Present your results as a table that shows the interaction response rate and number mailed on net profit. Be sure to clearly label all elements of your model. Highlight key findings that are of use to the firm.

Reference no: EM131989817

Questions Cloud

Reflects that government tries to manipulate its value : While an exchange rate is determined by the market, reflects that a government tries to manipulate its value.

Calculate the trader end of day profit and loss in dollars : Calculate the trader’s end of day profit / loss in US Dollars.

How much is dominique savings worth : How much is Dominique's savings worth today given that the earned an annual return of 5.5% until just after she made the 15th payment and 6% since then.

Should real estate investor try to be debt-free : Should a real estate investor try to be "debt-free?" Why or why not?

Promotional pieces mailed and anticipated response rate : A firm wishes to analyze the relationship between the number of promotional pieces mailed and the anticipated response rate.

Fair value of the non controlling interest at acquisition : The fair value of the non -controlling interest at acquisition was $22,000 What was the goodwill arising on acquisition of Rap Co?

Calculate the net income and calculate the taxable income : You are given the following information for Sookie’s Cookies Co.: sales = $52,100; costs = $38,700; Calculate the net income.

The dividend is expected to increase : A firm recently paid a $0.75 annual dividend. The dividend is expected to increase by 10 percent in each of the next four years. In the fourth year,

The present value of what you get is equal to present value : What interest rate, r, would you need so that the present value of what you get is equal to the present value of what you give up?

User Account

All Pages