static forecast & winter's model

Project Description:

a gift shop in tourist center is open on weekends (friday, saturday, and sunday). the owner-manager hopes to improve scheduling of part-time employees by choosing an appropriate forecasting method. data on recent activity at the store (sale transactions per day) is shown in the table below.
day period demand dt
week 1 fri 1 149
sat 2 250
sun 3 166
week 2 fri 4 154
sat 5 255
sun 6 162
week 3 fri 7 152
sat 8 260
sun 9 171
week 4 fri 10 150
sat 11 268
sun 12 173
week 5 fri 13 159
sat 14 273
sun 15 176
week 6 fri 16 163
sat 17 276
sun 18 183

please evaluate the quality of the two forecasts (the static forecast, and the winter’s model) in terms of mad, mape, mse, and tracking signal. which forecast method would you prefer (please provide your excel worksheet) ?
note: for winter’s model, alpha=0.1, beta=0.1, and gamma=0.1. also for this problem, p(the periodicity)=3.
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 2
1 Current viewersl
7 Total views
Project posted by:

Proposals

Proposals Reputation Price offered