Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assume you have designed a new line of humorous birthday cards for college students. Last year there were 70 million birthday cards sold in the

Assume you have designed a new line of humorous birthday cards for college students. Last year there were 70 million birthday cards sold in the U.S. and that number is expected to grow by 2% per year. The average revenue manufacturers received per birthday card last year was $2.50, and that price is expected to grow by 1% per year. You forecast that you can get a 0.5% unit market share this year, and you can increase your unit sales by 30% per year after that. Your selling price per card will be $5.00 for direct to customer sales through your website, and $2.00 for the wholesale channel (selling to card shops, drugstores, etc.) You don't anticipate changing your prices for the foreseeable future. You estimate a 50/50 split of your unit volume between the website and wholesale channels. Create a 5 year sales forecast spreadsheet in Excel for your business: this coming year and the following four years. Include Units, Price and Revenue for each of the two channels and in total. Also include the total industry # of cards sold, price per card, and total dollar sales for each year, starting with Last Year's base data, so you can calculate your share of the total addressable market in terms of both units and total revenues.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forecasting Principles And Practice

Authors: Rob J Hyndman, George Athanasopoulos

1st Edition

0987507109, 978-0987507105

More Books

Students also viewed these Finance questions

Question

=+a) Why is it difficult to use a simple random sample here?

Answered: 1 week ago