Hello , I have a major project ?
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. |