Displacement Analysis Projected Revenue without Group $ - Projected Revenue with Group $ 221,016.38 Indicate if they should or should not take the group and why? (Forecasted Transient Revenue ) (Forecasted Transient Revenue + Forecasted Group Revenue - Displaced Transient Revenue) Profit/Loss by taking group $ 221,016.38 Forecasted Transient Forecasted Group Displaced Transient Rooms (Forecasted Transient Rooms + Forecasted Group Rooms - Capacity of the Hotel 450) 14-Apr 15-Apr 16-Apr Total 14-Apr 15-Apr 16-Apr 14-Apr 15-Apr 16-Apr Forecasted Transient Rooms 0 Forecasted Group Rooms 0 Displaced Transient Rooms -450 -450 -450 -1350 Forecasted Transient Rate #DIV/0! Forecasted Group Rate #DIV/0! Forecasted Transient Rate $ 175.00 $ 175.00 $ 175.00 $ 525.00 Forecasted Transient Revenue (Rooms x Rate) $ - $ - $ - #DIV/0! Forecasted Group Revenue (Rooms x Rate) $ - $ - $ - $ - Forecasted Group Revenue (Rooms x Rate) $ (78,750.00) $ (78,750.00) $ (78,750.00) $ (236,250.00) Variable cost per occupied room #DIV/0! Variable cost per occupied room #DIV/0! Variable cost per occupied room $ 20.00 $ 20.00 $ 20.00 $ 60.00 Franchise Fee per occupied room (rate *.08) $ - $ - $ - #DIV/0! Franchise Fee per occupied room (rate *.08) $ - $ - $ - #DIV/0! Franchise Fee per occupied room (rate *.08) $ 14.00 $ 14.00 $ 14.00 $ 42.00 Cost per occupied room (variable cost + franchise fee) $ - $ - $ - #DIV/0! Cost per occupied room (variable cost + franchise fee) $ - $ - $ - #DIV/0! Cost per occupied room (variable cost + franchise fee) $ 34.00 $ 34.00 $ 34.00 $ 102.00 Projected Transient Rooms Revenue (Revenue - costs) $ - $ - $ - #DIV/0! Projected Group Rooms Revenue (Revenue - costs) $ - $ - $ - $ - Projected Group Rooms Revenue (Revenue - costs) $ (63,450.00) $ (63,450.00) $ (63,450.00) $ (190,350.00) Forecasted Food & Beverage Revenue Forecasted Food & Beverage Revenue Forecasted Food & Beverage Revenue Forecasted Breakfast (forecasted rooms * 70% * $8.40) $ - $ - $ - $ - Forecasted Breakfast (forecasted rooms * ($10-$3.60)) $ - $ - $ - $ - Forecasted Breakfast (forecasted rooms * 70% * $8.40) $ (2,646.00) $ (2,646.00) $ (2,646.00) $ (7,938.00) Forecasted Lunch (forecasted rooms * 25% * 16.25) $ - $ - $ - $ - Forecasted Lunch (forecasted rooms *($22-$8.75)) $ - $ - $ - $ - Forecasted Lunch (forecasted rooms * 25% * 16.25) $ (1,828.13) $ (1,828.13) $ (1,828.13) $ (5,484.38) Forecasted Dinner (forecasted rooms * 40% * $30.60) $ - $ - $ - $ - Forecasted Dinner (forecasted rooms * (($41-$14.40)) $ - $ - $ - $ - Forecasted Dinner (forecasted rooms * 40% * $30.60) $ (5,508.00) $ (5,508.00) $ (5,508.00) $ (16,524.00) Forecasted Revenue $ - $ - $ - $ - Net Forecasted Revenue $ - $ - $ - $ - Forecasted Revenue $ (9,982.13) $ (9,982.13) $ (9,982.13) $ (29,946.38) Total Projected Revenue $ - $ - $ - $ - Other Revenue (conf room rental + AV rental $ 330.00 $ 330.00 $ 330.00 $ 990.00 Total Net Revenue $ (73,432.13) $ (73,432.13) $ (73,432.13) $ (220,296.38) Costs (cost of conf room + cost of AV) $ 90.00 $ 90.00 $ 90.00 $ 270.00 Net Other Revenue $ 240.00 $ 240.00 $ 240.00 $ 720.00 Total Net Revenue $ 240.00 $ 240.00 $ 240.00 $ 720.00