Sales Forecast Practice

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.

 

Sample Solution

pp101-107) The extent to which this can be considered a mass atrocity can be measured by the UN’s response. This UN response came rapidly on the 26th of February 2011, just three days after the conflict began, as the UN Security Council unanimously adopted resolution 1970. The resolution expressed a “grave concern for the situation in Libya,” at the “gross and systematic violation of human rights,” crucially it is also explicit in calling upon the Libyan authorities for their “responsibility to protect its population,” and the need to “respect the freedoms of peaceful assembly.” (UN, n.d) Resolution 1970 also imposed sanctions upon the Libyan state such as the freezing of economic resources on Libyan territory. This action was reinforced by the UN adoption of resolution 1973 on March 17th 2011, which “reiterated responsibility of the Libyan authorities to protect the Libyan population,” and that all armed parties within the conflict “take all feasible steps to protect civilians,” yet again reaffirming language of the Responsibility to Protect doctrine. In addition resolution 1973 called for an immediate ceasefire and a no-fly zone over Libya. Two days after this resolution a NATO-led coalition force began bombing governmental forces which resulted in a military victory for the NATO coalition. The extent to which this is seen as an appropriate use of R2P however is debated. A realist concept that whilst a primary objective of the mandate in Libya was ‘civilian protection’, this changed over the course of the conflict towards regime change, a goal which is unlikely to have had the uncontested support of the Security Council. (Abomo 2018, p244) The opposition to this is put forward by Amstutz, who argues that the principal goal of the intervention was to “prevent the slaughter of civilians” in support of the R2P doctrine, as a result of this aim and the military intervention to achieve it, “the downfall of a lunatic,” was necessary.(Amstutz 2018, p161) This is an argument I would tend to concur with as, in my view, the Libyan government failed in its responsibility to protect its citizens, and whilst regime change came as a result of necessary humanitarian intervention, the principal goal was the protection of human rights. A further argument which is made against the intervention in Libya is one which is also levelled against the concept of the R2P doctrine itself, whether it indeed unacceptably breaches a level of sovereignty. In a polemic article regarding Libyan intervention, Keeler argues “it seemed clear that for many politicians, humanitarian intervention has become no more than an inappropriate violation of national sovereignty.” (Keeler, 2011) However, the question still remains at what point does national sovereignty have to be breached to protect human rights? In this case,

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.