homework #3 - Exercise 3 Demand Forecasting Problem You...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Exercise 3 Demand Forecasting Problem You have been given monthly sales for the Ace Welding Company. This firm sells welding supplies to small and medium size firms in the Bakersfield California area. The firm uses a 4-4-5 week quarter. Use existing sales from the 2003 thru 2007 periods to project monthly sales for the 2008 year. Then write a memo that explains what methods/formula was used to project 2008 sales and what performance metric worked best for you. Avg. Actual Percent Percentage Annual Year Month Sales Growth of Annual Sales Sales 2003 January 13 2003 2.85% 2.43% 2003 February 18 Total sales 3.95% 3.37% 2003 March 30 456 6.58% 5.44% 2003 April 50 10.96% 8.99% 2003 May 78 17.11% 14.69% 2003 June 11 2.41% 20.53% 2003 July 66 1.38 14.47% 12.68% 2003 August 52 11.40% 9.88% 2003 September 49 10.75% 9.10% 2003 October 35 7.68% 6.40% 2003 November 23 5.04% 4.37% 2003 December 31 6.80% 5.74% 2004 January 18 2004 2.24% 2004 February 26 Total sales 3.23% 2004 March 41 805 1.77 5.09% 2004 April 67 8.32% 2004 May 114 14.16% 2004 June 167 20.75% 2004 July 99 12.30%
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/08/2010 for the course BUS 140 at San Jose State University .

Page1 / 9

homework #3 - Exercise 3 Demand Forecasting Problem You...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online