In: Accounting
(CO 3) Using the following information regarding actual sales
for Paradise Pools, calculate the seasonal ratio for June of Year
3.
Sales for Paradise Pools ($000s) |
||
Month |
First Year |
Second Year |
January |
84 |
84 |
February |
80 |
82 |
March |
88 |
98 |
April |
100 |
120 |
May |
150 |
160 |
June |
200 |
210 |
July |
240 |
250 |
August |
220 |
215 |
September |
180 |
195 |
October |
160 |
165 |
November |
120 |
130 |
December |
92 |
100 |
Group of answer choices
1.41
0.77
0.67
1.08
Correct answer is 1.41
Month | First Year | Second Year | Seasonal index | Sesonal index | Seasonal forcasting trend | |
January | 84 | 84 | 0.59 | 0.56 | 0.57 | |
February | 80 | 82 | 0.56 | 0.54 | 0.55 | |
March | 88 | 98 | 0.62 | 0.65 | 0.63 | |
April | 100 | 120 | 0.70 | 0.80 | 0.75 | |
May | 150 | 160 | 1.05 | 1.06 | 1.06 | |
June | 200 | 210 | 1.40 | 1.39 | 1.40 | |
July | 240 | 250 | 1.68 | 1.66 | 1.67 | |
August | 220 | 215 | 1.54 | 1.43 | 1.48 | |
September | 180 | 195 | 1.26 | 1.29 | 1.28 | |
October | 160 | 165 | 1.12 | 1.09 | 1.11 | |
November | 120 | 130 | 0.84 | 0.86 | 0.85 | |
December | 92 | 100 | 0.64 | 0.66 | 0.65 | |
Total | 1,714.00 | 1,809.00 | ||||
Average | 142.83 | 150.75 |