What formula do I add to the Occupancy cell in regards to Length of stay? F5 Clipboard

What formula do I add to the Occupancy cell in regards to Length of stay?

Transcribed Image Text:

F5 Clipboard Font A B C D E E5+E11*(G23+H23+123)+E10*H22 Alignment 2 Number F G H J K 12345678 $79 $99 $129 Total Sold Occupancy 5 Monday 90 40 30 160 160 6 Tuesday 120 70 40 230 302 7 Wednesday 110 80 60 250 366 8 Thursday 80 60 30 170 291 9 Friday 100 30 10 140 191 10 Saturday 50 10 5 65 137 11 Sunday 30 15 5 50 64 VI VI VI VIVI VIVI 12 Capacity Revenue 180 $32,025.00 180 $42,240.00 180 $41,440.00 180 $26,595.00 180 $24,915.00 180 $7,645.00 180 $5,550.00 $180,410.00 13 14 15 Length of Stay Distributions 16 Forecast D79 D99 D129 1-night 2-night 3-night 4-night avg. stay 17 Monday 90 40 30 50% 30% 15% 5% 1.75 18 Tuesday 120 70 40 60% 20% 20% 0% 1.60 19 Wednesday 110 80 60 70% 20% 10% 0% 1.40 20 Thursday 80 60 30 80% 10% 5% 5% 1.35 21 Friday 100 30 10 50% 40% 5% 5% 1.65 22 Saturday 50 10 23 Sunday 30 15 15 5 90% 10% 0% 0% 1.10 5 100% 0% 0% 0% 1.00 22222 24 25 26 27 28 F5 Clipboard Font A B C D E E5+E11*(G23+H23+123)+E10*H22 Alignment 2 Number F G H J K 12345678 $79 $99 $129 Total Sold Occupancy 5 Monday 90 40 30 160 160 6 Tuesday 120 70 40 230 302 7 Wednesday 110 80 60 250 366 8 Thursday 80 60 30 170 291 9 Friday 100 30 10 140 191 10 Saturday 50 10 5 65 137 11 Sunday 30 15 5 50 64 VI VI VI VIVI VIVI 12 Capacity Revenue 180 $32,025.00 180 $42,240.00 180 $41,440.00 180 $26,595.00 180 $24,915.00 180 $7,645.00 180 $5,550.00 $180,410.00 13 14 15 Length of Stay Distributions 16 Forecast D79 D99 D129 1-night 2-night 3-night 4-night avg. stay 17 Monday 90 40 30 50% 30% 15% 5% 1.75 18 Tuesday 120 70 40 60% 20% 20% 0% 1.60 19 Wednesday 110 80 60 70% 20% 10% 0% 1.40 20 Thursday 80 60 30 80% 10% 5% 5% 1.35 21 Friday 100 30 10 50% 40% 5% 5% 1.65 22 Saturday 50 10 23 Sunday 30 15 15 5 90% 10% 0% 0% 1.10 5 100% 0% 0% 0% 1.00 22222 24 25 26 27 28