Phase 1 – Forecasting Applications

Deliverable Length: 300–400 words + 1 Excel spreadsheet

Due Date: 1/15/2014 11:59:59 PM  CT [removed]   

Weekly tasks or assignments (Individual or Group Projects) will be due by Monday and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.

For the following set of data, construct a line graph, and interpret the trend.

 

Sales	2008	2009	2010
Jan	80,250	87,500	91,375
Feb	76,450	79,235	81,180
March	84,278	89,567	94,576
April	74,598	77,891	83,455
May	69,489	71,344	79,511
June	67,777	69,001	74,666
July	58,914	64,577	70,788
August	66,788	73,522	79,234
Sept	67,999	75,354	78,299
Oct	89,444	92,389	98,123
Nov	94,777	99,222	109,511
Dec	101,888	106,666	114,444

 

Answer the following questions:

• When is the peak season period?
• What period of time represents the lowest earnings period?
• What is the trend between 2008 and 2010?
• What kind of company would this represent? Why? 
  • Give specific reasons by explaining the data.

 

Explain your answers.