Promotional pieces mailed and anticipated response rate

Assignment Help Operation Management
Reference no: EM132184543

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.25 per unit for quantities less than 200,000; $0.20 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: EM132184543

Explain the steps used to develop a forecasting system

Explain the steps used to develop a forecasting system. How would these steps be specifically utilized by this company? What do you predict would be the result of implementi

How define evm financial and costing management techniques

In a paper, provide a detailed explanation of how the knowledge gained in this course provided you with an understanding of a critical component of project management: EVM,

Four-station transfer line is to be designed without buffers

A four-station transfer line is to be designed without buffers. Demand dictates that 100 products must be produced every hour the line is in operation. A cycle time of 0.5 min

Maintaining participant interest in training

Conduct research to identify techniques for maintaining participant interest in training. List a minimum of three specific techniques not found in the Blanchard and Thacker (2

What concerns about consumer privacy

What concerns about consumer privacy are raised by the use of wireless computing and handheld devices? Does this concern you? Does it concern you enough to change your use of

What are most conflicts about

Evaluate the conflict management patterns of your work group. What are most conflicts about? Are they functional or dysfunctional? What guidelines and tactics could be used to

Economic order quantity-what is total ordering cost for year

An energy company orders railcar loads of coal at a rate of 62,500 tons per year. Delivery lead time is variable, but has averaged 5 days. The annual cost to hold inventory is

Capital requirement for the company and break-even point

A pop-up agency for the art industryin London. A platform where artist studios and emerging galleries can be temporarily rented by other players in the field seeking exposure.


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd