{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

homework #3

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

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

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% 2004 August 76 9.44% 2004 September 71 8.82% 2004 October 48 5.96% 2004 November 34 4.22% 2004 December 44 5.47% 2005 January 27 2005 2.36% 2005 February 37 total sales 3.24% 2005 March 60 1143 1.42 5.25% 2005 April 99 8.66% 2005 May 161 14.09% 2005 June 233 20.38%

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online