According to the Rosewood case study, moving to a corporate brand from an individual brand is expected to improve customer lifetime value (CLV). Use the Rosewood excel file Rosewood_students V4.xlsx Download Rosewood_students V4.xlsx( also available in files menu) to calculate the impact of the new brand strategy on customer lifetime value. Please note that there are items in the spreadsheet to be included in the analysis that are not mentioned in the case study that will impact the lifetime value. Please see the "Notes: Additional Information for your analysis" at the lower left of the spreadsheet. The anticipated 115,000 new guests has been increased to 125,000 guests due to the planned inflight advertising campaign targeting business class customers of Delta Airlines. After determining the increase in CLV resulting from the changes, use it to calculate the additional sales Rosewood needs to achieve to realize the new total CLV (see Cells B59 to B61). Please submit your spreadsheet with the analysis (in Excel format) along with a word file (single-spaced not more then 1/2 page): Explaining your analysis, and Suggesting some possible reasons for the reduction in customer acquisition cost from $150 to $125 with the new brand strategy (Hint: the reason can't be improved cross-property stays because these have not yet been realized). Note: You only need to make changes to row 37 downwards of the spreadsheet. No changes are needed above row 37.