Question #$2($from Ch#$2)$: What is the value of a loyal customer to Hudson Jewelers for a wealthy individual who visits Naples every February and buys jewelry for her extended family every other year? Assume the following:

Customer Retention Rate

$=70\%$

Contribution Margin

$=\mathrm{.}60$

Price per purchase

$=$ $$200,000$

Please either attach your excel spreadsheet to show how you calculated, or write in what you did.