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.
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
Avg Friday = 3.77/5 = 0.74
Avg Saturday = 4.33/4 = 1.44
Avg. Sunday = 4.18 / 5 = 0.836
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."