Question

A tourist center is open on weekends (Friday, Saturday, and Sunday). The owner-manager hopes to improve scheduling of part-time employees by determining seasonal relatives for each of these days. Data on recent traffic at the center have been tabulated and are shown in the following table:

    

	Week
	1	2	3	4	5	6
Friday	143	153	150	151	155	163
Saturday	251	258	263	265	271	279
Sunday	162	165	173	172	180	183

    

a.	Develop seasonal relatives for the shop using the centered moving average method. (Round your intermediate calculations and final answers to 2 decimal places.)

    

	X⎯⎯⎯X¯
Friday
Saturday
Sunday

    

b.	Develop seasonal relatives for the shop using the SA method. (Round your intermediate calculations and final answers to 4 decimal places.)

    

	SA Index
Friday
Saturday
Sunday

Answer 1

a.

Below is the screenshot of the formula applied -

Below is the screenshot of the result -

b.

Below is the screenshot of the formula applied -

Below is the screenshot of the result -