Products and undertake a direct mail campaign

Assignment Help Operation Management

Reference no: EM131732061

The Krazy Knits Company sells hand-knit hats. The company is planning to print a catalog of its products and undertake a direct mail campaign.

The fixed cost of printing the catalog is $20,000. Variable costs are $0.10 per catalog for printing and $0.15 per catalog for mailing.

In addition, the company will include direct reply envelopes in its mailings. An extra cost of $0.20 is incurred for each direct reply envelope that is used by a customer to place an order.

The average value of a customer order is about $40 (sales revenue) and the company’s variable cost per order averages about 80% of the order’s value.

The company plans to mail between 50000 and 150,000 catalogs but wants to be able to experiment with different values. Response rate (orders placed) may vary from 1% to 8% of the number of catalogs mailed.

Create a spreadsheet model to determine the company’s profit, and use your model to answer the following questions:

Number of catalogs mailed and Response rate are the decision variables.

a. How does a change in the response rate affect profit?

i. Create a one-way table using Excel Data/What-If Analysis/Data Tables and response rates of 1%, 2%, 3%, 4%, 5%, 6%, 7%, 8%

ii. Graph your results

b. For what response rate does the company break even if number of catalogs mailed is 100,000?

Use the Excel Goal-Seek function

c. If the company estimates a response rate of 3%, should it proceed with the mailing of 100,000 catalogs?

Reference no: EM131732061

Questions Cloud

How is scheduling important in your organization : How is scheduling important in your organization.

The response and the other variables as predictors : Using the happy dataset in library (faraway) in R, fit a model with happy as the response and the other variables as predictors.

Violating confidentiality agreements : What are some federal/state laws that are for violating confidentiality agreements?

Investigate some design-for-environment practices : Investigate some design-for-environment practices in some of your local industries.

Products and undertake a direct mail campaign : The Krazy Knits Company sells hand-knit hats. The company is planning to print a catalog of its products and undertake a direct mail campaign.

Casual restaurant has three stations for cooks to make meals : A fast-casual restaurant has 3 stations for cooks to make meals; each cook can make one meal at a time.

Two-stage production line : Gogoma, Inc., has a two-stage production line. The first stage makes an engine and the second stage does the drone assembly.

Any necessary tools for servicing clients : Excluding alarms, Ray offered just about every locksmith service. His company van was used to store these products and any necessary tools for servicing clients

Difference between an option contract and a firm offer : Fully discuss the ways an offer can be terminated. What is the difference between an option contract and a firm offer?

User Account

All Pages