a) Calculate the bid prices and determine the restrictions and the Best Available Rate(BAR) by Length of Stay(LOS) for April 10 - 16 for each guest segment

b) Budget Occ, ADR, and RevPAR for April 10-16

Capacity 300 LOS DoW 1 US$99.00 2 US$99.00 3 US$99.00 April 10 - 16 Occ Adr Date 6 45 5 0 RevPAR 7 8 1 0 1 24 11 8 2 26 0 0 5 8 3 4 7 ROH 1 2 3 1 2 3 US$120.00 US$120.00) US$120.00 US$150.00 US$150.00 US$150.00 42 0 0 21 0 0 6 0 0 2 0 0 14 11 6 11 8 8 21 12 5 14 21 11 11 5 1 11 3 0 22 1 0 9 2 0 29 5 2 22 7 1 24 0 0 6 0 0 11 3 0 5 5 0 15 8 1 3 3 3 5 1 2 5 1 2 5 11 0 5 8 0 4/6/19 4/7/19 4/8/19 4/9/19 4/10/19 4/11/19 4/12/19 4/13/19 4/14/19 4/15/19 4/16/19 4/17/19 5 19 11 109 49 5 9 6 0 42 16 24 29 7 28 0 1 44 9 2 65 2 0 100 3 11 6 5 LOS 3 DoW Date 4/10/19 4/11/19 1 US$99.00 11 55 2 US$99.00 13 US$99.00 1 3 4 11 3 5 109 34 4/12/19 4/13/19 Expected Pickup 1 2 3 1 2 3 US$120.00 US$120.00 US$120.00 US$150.00 US$150.00 US$150.00 32 12 2 5 1 0 45 14 12 29 22 12 33 17 2 49 8 1 32 2 0 23 3 1 28 23 0 12 13 2 55 12 2 33 11 6 15 3 0 22 2 1 46 35 18 11 22 22 6 60 9 4 33 9 7 89 99 84 18 11 4/14/19 4/15/19 4/16/19 4/17/19 -| -| N| 66 2 0 31 90 42 LOS1 US$99.00 LOS2 US$99.00 LOS3 US$99.00 LOS1 LOS2 LOS3 LOS1 LOS2 LOS3 US$120.00 US$120.00) US$120.00 US$150.00 US$150.00 US$150.00 Bid Price LOS1 LOS2 LOS3 DoW 3 4 Date 4/10/19 4/11/19 4/12/19 4/13/19 4/14/19 4/15/19 4/16/19 5 6 7 1 2 B.A.R. RATES LOS 2 Date DoW LOS 1 LOS 3 4/10/19 3 Segment Restriction US$99.00 US$120.00 US$150.00 US$99.00 US$120.00 US$150.00 US$99.00 US$120.00 US$150.00 4/11/19 4 4/12/19 01 Capacity 300 LOS DoW 1 US$99.00 2 US$99.00 3 US$99.00 April 10 - 16 Occ Adr Date 6 45 5 0 RevPAR 7 8 1 0 1 24 11 8 2 26 0 0 5 8 3 4 7 ROH 1 2 3 1 2 3 US$120.00 US$120.00) US$120.00 US$150.00 US$150.00 US$150.00 42 0 0 21 0 0 6 0 0 2 0 0 14 11 6 11 8 8 21 12 5 14 21 11 11 5 1 11 3 0 22 1 0 9 2 0 29 5 2 22 7 1 24 0 0 6 0 0 11 3 0 5 5 0 15 8 1 3 3 3 5 1 2 5 1 2 5 11 0 5 8 0 4/6/19 4/7/19 4/8/19 4/9/19 4/10/19 4/11/19 4/12/19 4/13/19 4/14/19 4/15/19 4/16/19 4/17/19 5 19 11 109 49 5 9 6 0 42 16 24 29 7 28 0 1 44 9 2 65 2 0 100 3 11 6 5 LOS 3 DoW Date 4/10/19 4/11/19 1 US$99.00 11 55 2 US$99.00 13 US$99.00 1 3 4 11 3 5 109 34 4/12/19 4/13/19 Expected Pickup 1 2 3 1 2 3 US$120.00 US$120.00 US$120.00 US$150.00 US$150.00 US$150.00 32 12 2 5 1 0 45 14 12 29 22 12 33 17 2 49 8 1 32 2 0 23 3 1 28 23 0 12 13 2 55 12 2 33 11 6 15 3 0 22 2 1 46 35 18 11 22 22 6 60 9 4 33 9 7 89 99 84 18 11 4/14/19 4/15/19 4/16/19 4/17/19 -| -| N| 66 2 0 31 90 42 LOS1 US$99.00 LOS2 US$99.00 LOS3 US$99.00 LOS1 LOS2 LOS3 LOS1 LOS2 LOS3 US$120.00 US$120.00) US$120.00 US$150.00 US$150.00 US$150.00 Bid Price LOS1 LOS2 LOS3 DoW 3 4 Date 4/10/19 4/11/19 4/12/19 4/13/19 4/14/19 4/15/19 4/16/19 5 6 7 1 2 B.A.R. RATES LOS 2 Date DoW LOS 1 LOS 3 4/10/19 3 Segment Restriction US$99.00 US$120.00 US$150.00 US$99.00 US$120.00 US$150.00 US$99.00 US$120.00 US$150.00 4/11/19 4 4/12/19 01