Hello , I have a major project ?

Jwertz
SeasonalityCalculations--replicateModelwithpricesgivenforMajorProject.xlsx

Model

Seasonality calculation: Weekday, Weekend, and Total
Rental Price
Weekday Weekend Total Weekday Weekend
Orders % Avg Orders % Avg Orders % Avg Month Comp Univ Comp Univ
Nov 849,670 100% 346,614 101.5% 1,196,284 100.5% Nov $38.00 $36.00 $32.00 $31.00
Dec 773,465 91.1% 334,863 98.1% 1,108,328 93.1% Dec $37.00 $36.00 $31.00 $31.00
Jan 862,274 101.5% 325,765 95.4% 1,188,039 99.8% Jan $35.00 $36.00 $31.00 $31.00
Feb 885,938 104.3% 345,412 101.2% 1,231,350 103.4% Feb $36.00 $36.00 $31.00 $31.00
Mar 895,752 105.5% 358,171 104.9% 1,253,923 105.3% Mar $36.00 $36.00 $31.00 $31.00
Apr 854,340 100.6% 344,395 100.9% 1,198,735 100.7% Apr $37.00 $36.00 $31.00 $31.00
May 862,883 101.6% 347,839 101.9% 1,210,722 101.7% May $37.00 $36.00 $31.00 $31.00
Jun 870,157 102.5% 354,320 103.8% 1,224,477 102.8% Jun $37.00 $36.00 $31.00 $31.00
Jul 860,058 101.3% 347,432 101.8% 1,207,490 101.4% Jul $36.00 $36.00 $31.00 $31.00
Aug 807,137 95.0% 329,805 96.6% 1,136,942 95.5% Aug $36.00 $36.00 $31.00 $31.00
Sep 820,720 96.6% 321,101 94.0% 1,141,821 95.9% Sep $36.00 $36.00 $31.00 $31.00
Average 849,309 100.0% 341,429 100.0% 1,190,737 100.0% Average $36.45 $36.00 $31.09 $31.00
Note: Looking at the graphs below, it seems that there is no trend in background demand; only seasonal changes around the average.
For this reason, we treat all month-to-month changes as seasonal changes.
Note: Weekday seasonality diverges from weekend seasonality in Dec and Jan, suggesting that business renters stay away in Dec, but return in Jan,
whereas, leisure renting is almost average in Dec, but drops off in Jan.
Note: Weekend prices are almost constant for both competitor and universal throughout the year. Competitor's weekday prices vary slightly around an average of $35.45.
The price variations are small enough not to affect the seasonality calcuations significantly.
Nov 849,670 346,614
Dec 773,465 334,863
Jan 862,274 325,765
Feb 885,938 345,412
Mar 895,752 358,171
Apr 854,340 344,395
May 862,883 347,839
Jun 870,157 354,320
Jul 860,058 347,432
Aug 807,137 329,805
Sep 820,720 321,101

Orders by Month: Weekday & Weekend

Weekday Orders Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep 849670 773465 862274 885938 895752 854340 862883 870157 860058 807137 820720 Weekend Orders Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep 346614 334863 325765 345412 358171 344395 347839 354320 347432 329805 321101

Major Project

Seasonality calculation: Weekday, Weekend, and Total
Rental Price
Weekday Weekend Total Weekday Weekend
Orders % Avg Orders % Avg Orders % Avg Month Comp Univ Comp Univ
Nov ERROR:#DIV/0! ERROR:#DIV/0! - 0 ERROR:#DIV/0! Nov $37.00 $32.00
Dec ERROR:#DIV/0! ERROR:#DIV/0! - 0 ERROR:#DIV/0! Dec $37.00 $32.00
Jan ERROR:#DIV/0! ERROR:#DIV/0! - 0 ERROR:#DIV/0! Jan $37.00 $32.00
Feb ERROR:#DIV/0! ERROR:#DIV/0! - 0 ERROR:#DIV/0! Feb $37.00 $32.00
Mar ERROR:#DIV/0! ERROR:#DIV/0! - 0 ERROR:#DIV/0! Mar $37.00 $32.00
Apr ERROR:#DIV/0! ERROR:#DIV/0! - 0 ERROR:#DIV/0! Apr $37.00 $32.00
May ERROR:#DIV/0! ERROR:#DIV/0! - 0 ERROR:#DIV/0! May $37.00 $32.00
Jun ERROR:#DIV/0! ERROR:#DIV/0! - 0 ERROR:#DIV/0! Jun $37.00 $32.00
Jul ERROR:#DIV/0! ERROR:#DIV/0! - 0 ERROR:#DIV/0! Jul $37.00 $32.00
Aug ERROR:#DIV/0! ERROR:#DIV/0! - 0 ERROR:#DIV/0! Aug $37.00 $32.00
Sep ERROR:#DIV/0! ERROR:#DIV/0! - 0 ERROR:#DIV/0! Sep $37.00 $32.00
Average ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! Average ERROR:#DIV/0! $37.00 ERROR:#DIV/0! $32.00
Note: Run the simulation with prices of $37 weekday and $32 weekend for every month. Fill in the table above.
Compare seasonality you find with these prices to that found in the Model tab.