Cannister, Inc., specializes in the manufacture of plastic containers. EE Click

ID: 356412 • Letter: C

Question

Cannister, Inc., specializes in the manufacture of plastic containers. EE Click the lcon to view the data on the monthly sales of 10-ounce shampoo bottles for the past five years method, calculate the monthly seasonal indices. (Enter your responses rounded to three decimal places.) More Info Year January March May July 801 780 708 957 802 1,090 1,112 1,060 1,080 1,134 1,310 956 873 819 February777 710 923 941 872 ,006 1,075 1,180 1,250 1,444 1,073 1,1891,292 1,388 1,603 1,299 1,376 1,286 1,161 August 1,156 1,289 1,032 764 1,482 1,495 1,665 1,501 1,321 1,607 ,548 1,589 September 1,269 1,402 1,534 October 1,197 1,354 1,067 1,152 1,256 1,489 1,205 1,004 December 882 1,190 994

Explanation / Answer

Avg

Seasonal index

Jan

802

801

956

1011

1090

932

0.801353 (932/1163)

Feb

777

780

873

941

1112

896.6

0.770915

Mar

710

708

819

872

1060

833.8

0.716918

Apr

923

957

1080

1134

1310

1080.8

0.929294

May

1006

1075

1180

1250

1444

1191

1.024046

Jun

1073

1189

1292

1388

1603

1309

1.125505

Jul

1161

1286

1299

1482

1607

1367

1.175375

Aug

1156

1289

1376

1495

1548

1372.8

1.180362

Sep

1269

1402

1534

1665

1589

1491.8

1.28268

Oct

1032

1197

1354

1501

1321

1281

1.10143

Nov

1067

1152

1256

1489

1205

1233.8

1.060847

Dec

764

882

1004

1190

994

966.8

0.831275

1163.033

Avg