B E G H J K M N 0 P Q F D F Calculate the number of roomnights for each market segment then put those figures in place for the growth of demand table. Calculate the growth factors for each segment. Welcome Center N.C 5% % Food Service Rerenue 20% State Park Attendance 15% Growth Rate: Trip Duration NC 10% weight Tourist Segment Duplin County Economic Touri Welcome Center 140 5% 5% 2015 30.+S 927,87 2016 31.88 985,468 2017 89.1+ 1,022,575 2018 SS.29 1,043,263 2019 34.26 999,082 4.1 8,552,811 8,616,062 8,068,637 7,+50.273 12,108,114 12,357,13 13,114,540 14,589,120 5.1 5.+ 5.9 7.2 S. Average Weight X Ave Hotel stay N.C. Retail Impact T's. Other 15% Growth Rate: Econ Impact Lodging NC 25% Billions Food Service Revenue 25% weight 15% Billions Commercial Segment: NC Welcome Center Attendan. Welcome Center 140 15% 5% 2015 989,587 2016 8,552,811 985,468 2017 8,711,541 1,022,575 2018 8,063,637 1,043,268 2019 8,400,318 999,082 3.10 1.70 +1% ++% % +5% S S $ S S.+5 4.00 S S S 5.10 5.+0 5.0 S S $ S 1.80 1.70 Average Weight X Ave Growth Rate: Group Segment: N.C Arg. Visitor Trip Spending N.C. Retail Impact +5% 95% 2015 Billions NC Transportation Impact 10% billions Welcome Center N.C 5% weight 2016 Welcome Center 140 5% 927.87 985,468 1,022,575 1,043,269 999,082 4.S 2017 2018 $677 $697 $777 8,552,811 8,616,062 8,068,697 7,450,273 1.2 1.8 1.9 4.7 2019 5.2 Average Weight X Ave PartA:2 Are these reasonable growth rates? Do the economic indicators make sense for the segment they are being used in? Part B: Use the following data: (Label your w Calculate the needed market segment numbers for the growth table below 1) 81,737 annual available room nights in the subject hotel 12.9% FAIR SHARE OF SUPPLY 84.6% market occupancy Market Mix of demand is 41% commercial, 17% group, 42% tourist Use the growth rates from part A Using these data to fill in the table completely. Growth of Demand Table Total TOURIST GRTH Latent Tour MLX TOTAL Total DEMANI FACTOR Demand DEM DEMAND GRTH MLX OF DEMAND 8741 YEAR COMM. MLX OF GROUP GRTH MLX OF DEMAND GRTH * DEMAND DEMANI FACTOR DEM. 2019) FACTOR % Unsatisfied Den 7,777 237+ Adjusted total 2020 2021 2022 2023 2024 2025 2026 Is this a healthy market? Always tell me why! 3,500 2,000 1,000 500 Sheet1 B E G H J K M N 0 P Q F D F Calculate the number of roomnights for each market segment then put those figures in place for the growth of demand table. Calculate the growth factors for each segment. Welcome Center N.C 5% % Food Service Rerenue 20% State Park Attendance 15% Growth Rate: Trip Duration NC 10% weight Tourist Segment Duplin County Economic Touri Welcome Center 140 5% 5% 2015 30.+S 927,87 2016 31.88 985,468 2017 89.1+ 1,022,575 2018 SS.29 1,043,263 2019 34.26 999,082 4.1 8,552,811 8,616,062 8,068,637 7,+50.273 12,108,114 12,357,13 13,114,540 14,589,120 5.1 5.+ 5.9 7.2 S. Average Weight X Ave Hotel stay N.C. Retail Impact T's. Other 15% Growth Rate: Econ Impact Lodging NC 25% Billions Food Service Revenue 25% weight 15% Billions Commercial Segment: NC Welcome Center Attendan. Welcome Center 140 15% 5% 2015 989,587 2016 8,552,811 985,468 2017 8,711,541 1,022,575 2018 8,063,637 1,043,268 2019 8,400,318 999,082 3.10 1.70 +1% ++% % +5% S S $ S S.+5 4.00 S S S 5.10 5.+0 5.0 S S $ S 1.80 1.70 Average Weight X Ave Growth Rate: Group Segment: N.C Arg. Visitor Trip Spending N.C. Retail Impact +5% 95% 2015 Billions NC Transportation Impact 10% billions Welcome Center N.C 5% weight 2016 Welcome Center 140 5% 927.87 985,468 1,022,575 1,043,269 999,082 4.S 2017 2018 $677 $697 $777 8,552,811 8,616,062 8,068,697 7,450,273 1.2 1.8 1.9 4.7 2019 5.2 Average Weight X Ave PartA:2 Are these reasonable growth rates? Do the economic indicators make sense for the segment they are being used in? Part B: Use the following data: (Label your w Calculate the needed market segment numbers for the growth table below 1) 81,737 annual available room nights in the subject hotel 12.9% FAIR SHARE OF SUPPLY 84.6% market occupancy Market Mix of demand is 41% commercial, 17% group, 42% tourist Use the growth rates from part A Using these data to fill in the table completely. Growth of Demand Table Total TOURIST GRTH Latent Tour MLX TOTAL Total DEMANI FACTOR Demand DEM DEMAND GRTH MLX OF DEMAND 8741 YEAR COMM. MLX OF GROUP GRTH MLX OF DEMAND GRTH * DEMAND DEMANI FACTOR DEM. 2019) FACTOR % Unsatisfied Den 7,777 237+ Adjusted total 2020 2021 2022 2023 2024 2025 2026 Is this a healthy market? Always tell me why! 3,500 2,000 1,000 500 Sheet1