$1.$ Using the data provided and using the provided Hotel Madison spreadsheet, fill in the segmentation mix day by day for group and transient $($yellow cells$).$

$2.$ Fill in the average historical occupancies based on the day of the week $($yellow cells$).$

$>$Answer below's questions on Canvas based on the case's analysis and based on what you've learned in this chapter.

$3.$ Based on the group's arrival pattern, calculate the displacement value for the new group for each day.

$4.$ Should this group business be accepted based on historical averages for the month of May? If so$,$ why?

$5.$ Often, negotiations take place. Would your recommendation change if the group were to specifically ask for arrival on the $3$rd Monday of the month?