A swim club has the following daily attendance records for 13 weeks from the previous summer (see
Fantastic news! We've Found the answer you've been seeking!
Question:
A swim club has the following daily attendance records for 13 weeks from the previous summer (see table); it thinks the figures would provide accurate estimates for the upcoming summer. Develop a model to forecast daily demand during the summer.
The linear trend line equation computed from the 13 weekly totals is: y = 2,598.23 - 57.56x.
Week | ||||||||||||||
Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Total |
M | 139 | 198 | 341 | 287 | 303 | 242 | 194 | 197 | 275 | 246 | 224 | 258 | 235 | 3,139 |
T | 273 | 310 | 291 | 247 | 223 | 177 | 207 | 273 | 241 | 177 | 239 | 130 | 218 | 3,006 |
W | 172 | 347 | 380 | 356 | 315 | 245 | 215 | 213 | 190 | 161 | 274 | 195 | 271 | 3,334 |
Th | 275 | 393 | 367 | 322 | 258 | 390 | 304 | 303 | 243 | 308 | 205 | 238 | 259 | 3,865 |
F | 337 | 421 | 359 | 419 | 193 | 284 | 331 | 262 | 277 | 256 | 361 | 224 | 232 | 3,956 |
Sa | 402 | 595 | 463 | 516 | 378 | 417 | 407 | 447 | 241 | 391 | 411 | 368 | 317 | 5,353 |
Su | 487 | 497 | 578 | 478 | 461 | 474 | 399 | 399 | 384 | 400 | 419 | 541 | 369 | 5,886 |
Total | 2,085 | 2,761 | 2,779 | 2,625 | 2,131 | 2,229 | 2,057 | 2,094 | 1,851 | 1,939 | 2,133 | 1,954 | 1,901 | 28,539 |
Related Book For
Operations Management Creating Value Along the Supply Chain
ISBN: 978-1118301173
1st Canadian Edition
Authors: Roberta S. Russell, Bernard W. Taylor, Ignacio Castillo, Navneet Vidyarthi
Posted Date: