A tourist center is open on weekends (Friday, Saturday, and Sunday). The owner-m

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:

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

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

Week 1 2 3 4 5 6 Friday 142 152 152 152 157 162 Saturday 252 252 262 262 277 277 Sunday 162 162 172 172 172 182

Explanation / Answer

b. Average demand = Sum of all values / no. of monts in the sample = 195.6

Ratio for friday (Week 1) = Demand / Avg. demand = 142/ 195.6 = 0.72

Ratio for week 2 = 152 /195.6 = 0.77

  Ratio for week 3 = 152 /195.6 = 0.77

Ratio for week 4 = 152 /195.6 = 0.77

Ratio for week 5 = 157 /195.6 = 0.8

Ratio for week 6 = 162 / 195.6 = 0.82

Avg ratio for friday = Ratios from week 1 to 6 / 6 = 77.5

Similarly Avg ratio for Saturday = 2(252 /195.6 ) + 2 ( 262 / 195.6) + 2( 277/195.6) /6

= 2.57 +2.67 +2.83 /6 = 1.34

Avg Ratio for sunday = 2 ( 162 /195.6) + 3 ( 172/ 195.6) + 182/195.6 /6

= 1.64 +2.63 +0.93 /6 = 0.86

a.

Avg Friday = 3.77/5 = 0.74

Avg Saturday = 4.33/4 = 1.44

Avg. Sunday = 4.18 / 5 = 0.836

Wk Traffic MA5 Tr. / MA5 F 142 S 252 S 162 192 0.84 F 152 196 0.77 S 252 176 1.43 S 162 196 0.82 F 152 200 0.76 S 262 180 1,45 S 172 200 0.86 F 152 204 0.74 S 262 183 1.43 S 172 204 0.84 F 157 208 0.75 S 277 188 1.47 S 172 209 0.82 F 162 214 0.75 S 277 S 182

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.