July 30, 2013
Assignment # 2
Sales Analysis
1. Over the five year period, how has the company done in sales and in profits? Why have these changes occurred? In fact, we can clearly see that the company has done very well in terms of Sales. Actually, from the sales table (main table), we can notice how the company’s sales were growing year by year from 2009 to 2012. In addition, the average change in sale is approximately %11.91 each year (The sum of total Change each year then dividing it by the number of years). In other words, the amounts money generated from sales had also increased on an average of $529,750 each year from 2009 to 2012. Moreover, by looking at the (Return on sales table) we can notice that there is a minor shortage from year to another. On the other hand, we can clearly recognize that the profit is increasing as well. Actually, the overall performance of the company’s profit is growing slightly year by year. However, the company’s profit and sales performance are maintained in a good situation for the time specified period we have. In fact, we can say that the good condition of the company’s financial situation is due to strategies and procedures that the company follows in their production cycle. However, regarding the changes occurred on their performance, those changes are somehow related to the introduction of (product D). In fact, after product D has been introduced, other product got affected. Actually, the profit and sales of some products has either increased or decreased for others.
2. What has been the impact of introducing the new product? (Product D)
On one hand, the action that occurred after the introduction of the product D, we can clearly see how products B and C got influenced. In fact, introducing product D has boost the sales for products B and C. In addition, this impact will be reflected positively on the profit generated from selling those products, which means that the