Spreadsheet: 79339d1279627148-problems-with-creating-a-flexible-week-forecast-example1
Sheet: ARr

AR - Revenue movements
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Period |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
AR Terms Current Season |  | 1.380821917808219 | 1.380821917808219 | 1.380821917808219 | 1.380821917808219 | 1.380821917808219 | 1.380821917808219 | 1.380821917808219 | 1.380821917808219 | 1.380821917808219 | 1.380821917808219 | 1.380821917808219 | 1.380821917808219
 |  | Booking month
AR profiling from gross revenue |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Arrival month
Jan |  | 34.52503361543937 | 1.357036232867417 | 0.03421845058855735 | 0 | 0.04780724120346762 | 0 | 0 | 0.06312068675307188 | 0 | 0 | 0 | 1.070663811563169
Feb |  | 58.34256110100451 | 61.77907450128918 | 1.300301122365179 | 0 | 0.04780724120346762 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mar |  | 31.5293047536186 | 44.51078843805129 | 56.3235696687654 | 0.7208073041806824 | 0.04780724120346762 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apr |  | 74.24068654591473 | 76.77432487447415 | 125.5132767588284 | 115.1039163863527 | 1.482024477307496 | 0.3031177829099307 | 0 | 0.06312068675307188 | 0 | 0 | 0 | 0.5353319057815846
May |  | 96.54551925966936 | 87.90202198398697 | 83.86942239255407 | 118.4376501681884 | 150.6406170321265 | 3.074480369515012 | 0.2728761142441332 | 0 | 0.07939868727503706 | 0 | 0 | 0.5353319057815846
Jun |  | 110.9902712963695 | 109.5467498982223 | 104.2294004927457 | 109.7429120615089 | 135.5813360530342 | 138.1784064665127 | 2.183008913953065 | 0.6312068675307188 | 0.2381960618251112 | 0.1213592233009709 | 0 | 0.5353319057815846
Jul |  | 162.837143083129 | 172.4114533858054 | 186.6958664111689 | 204.2137193656896 | 230.8611677715451 | 301.1258660508083 | 254.002183008914 | 3.282275711159737 | 0.4763921236502223 | 0.2427184466019418 | 0.2941176470588235 | 0
Aug |  | 113.0665190223839 | 126.4757769032433 | 120.825349028196 | 128.4839019702066 | 145.1427842937277 | 187.9330254041571 | 313.1708204475168 | 314.404140717051 | 4.684522549227186 | 0.6067961165048544 | 1.176470588235294 | 0
Sep |  | 28.8895040734003 | 32.80635092956982 | 31.99425130030112 | 33.92299375300336 | 40.77957674655788 | 59.93071593533487 | 92.59596143350919 | 219.3443864669248 | 240.3398263815371 | 3.762135922330097 | 0 | 1.070663811563169
Oct |  | 27.49545202879064 | 27.92102049124712 | 29.73583356145634 | 30.36400768861125 | 34.70805711371749 | 45.90069284064665 | 66.35437511369838 | 166.3861302810975 | 399.1372009316112 | 450 | 14.70588235294118 | 2.141327623126339
Nov |  | 1.779640908012339 | 2.069480255122812 | 2.155762387079113 | 2.657976934166266 | 3.681157572667007 | 4.330254041570439 | 6.094233218118974 | 15.65393031476183 | 38.42896464111793 | 146.9660194174757 | 351.4705882352941 | 11.77730192719486
Dec |  | 9.758364312267657 | 6.445922106120234 | 7.322748425951273 | 6.352114368092264 | 6.979857215706273 | 9.223441108545034 | 15.32654175004548 | 30.17168826796836 | 66.61549862375608 | 148.3009708737864 | 382.3529411764706 | 732.3340471092077
 |  | 749.9999999999999 | 749.9999999999998 | 750.0000000000001 | 750 | 749.9999999999999 | 750 | 750 | 750 | 749.9999999999998 | 750 | 750 | 750
Jan
Impact on AR (due to payment terms):
Jan | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Feb | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mar | 3 | 31.5293047536186 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apr | 4 | 74.24068654591473 | 74.24068654591473 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
May | 5 | 96.54551925966936 | 96.54551925966936 | 96.54551925966936 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Jun | 6 | 110.9902712963695 | 110.9902712963695 | 110.9902712963695 | 110.9902712963695 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Jul | 7 | 162.837143083129 | 162.837143083129 | 162.837143083129 | 162.837143083129 | 162.837143083129 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Aug | 8 | 113.0665190223839 | 113.0665190223839 | 113.0665190223839 | 113.0665190223839 | 113.0665190223839 | 113.0665190223839 | 0 | 0 | 0 | 0 | 0 | 0
Sep | 9 | 28.8895040734003 | 28.8895040734003 | 28.8895040734003 | 28.8895040734003 | 28.8895040734003 | 28.8895040734003 | 28.8895040734003 | 0 | 0 | 0 | 0 | 0
Oct | 10 | 27.49545202879064 | 27.49545202879064 | 27.49545202879064 | 27.49545202879064 | 27.49545202879064 | 27.49545202879064 | 27.49545202879064 | 27.49545202879064 | 0 | 0 | 0 | 0
Nov | 11 | 1.779640908012339 | 1.779640908012339 | 1.779640908012339 | 1.779640908012339 | 1.779640908012339 | 1.779640908012339 | 1.779640908012339 | 1.779640908012339 | 1.779640908012339 | 0 | 0 | 0
Dec | 12 | 9.758364312267657 | 9.758364312267657 | 9.758364312267657 | 9.758364312267657 | 9.758364312267657 | 9.758364312267657 | 9.758364312267657 | 9.758364312267657 | 9.758364312267657 | 9.758364312267657 | 0 | 0
 |  | 657.132405283556 | 625.6031005299374 | 551.3624139840226 | 454.8168947243533 | 343.8266234279838 | 180.9894803448549 | 67.92296132247094 | 39.03345724907064 | 11.53800522028 | 9.758364312267657 | 0 | 0