Looking for someone who is good at FORECASTING: Using the University of Phoenix Material: Summer Historical Inventory Generate a frequency...
vicie.
executivemanagement.pptxRaw Data Used - Heather
The raw data used was from the University of Phoenix Summer Historical Data. It shows the increase or decrease of each month through four years and also includes the forecasted amounts. This data is a good source when it comes to figuring out the busy and slow months for the company.
According to the forecasted amounts each month was above the $40,000 mark and the highest month was May coming in at $64,375. The next highest months were April at $59,210, June at 57,750, and August at $56,638. The last month to come in at a close number was July at $47,520.
The slower months according to the forecasted amounts were January, February, March, September, October, November and December. The amounts were fairly close; January was at $39,600, February was at $37,080 and October was at $39,638. The next lower months were March and September coming in at $30,000 and $29,855. Finally we have November coming in at $27,323 and December with $19,350.
1
Frequency Distribution - Vickie
2
Normal Distribution - Vickie
3
|
Month |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Forecast |
|
1 |
18,000 |
45,100 |
59,800 |
35,500 |
39,600 |
|
2 |
19,800 |
46,530 |
30,740 |
51,250 |
37,080 |
|
3 |
15,700 |
22,100 |
47,800 |
34,400 |
30,000 |
|
4 |
53,600 |
41,350 |
73,890 |
68,000 |
59,210 |
|
5 |
83,200 |
46,000 |
60,200 |
68,100 |
64,375 |
|
6 |
72,900 |
41,800 |
55,200 |
61,100 |
57,750 |
|
7 |
55,200 |
39,800 |
32,180 |
62,300 |
47,520 |
|
8 |
57,350 |
64,100 |
38,600 |
66,500 |
56,638 |
|
9 |
15,400 |
47,600 |
25,020 |
31,400 |
29,855 |
|
10 |
27,700 |
43,050 |
51,300 |
36,500 |
39,638 |
|
11 |
21,400 |
39,300 |
31,790 |
16,800 |
27,323 |
|
12 |
17,100 |
10,300 |
31,100 |
18,900 |
19,350 |
|
Avg. |
38,112 |
43,902 |
44,802 |
45,896 |
42,362 |
