LINES 37 AND DOWN. LINES 1-36 NO NEED TO EDIT.

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 fileRosewood_students V3.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 thecase study that will impactlifetime value. The assumed of 115,000 guests has been increased to 125,000 guests as a result of an inflight adverting campaign with business class customers of Delta airlines.

After determining the increase in CLV resulting from the changes, use it to estimate the additional sales to be targeted (see lower left of the spreadsheet).

NOTE: You only need to make changes to row 37 downwards of the spreadsheet. No changes are needed above row 37.