Instructions:

Download the Excel file below. The file contains a fictional raw data set on the Lululemon Ambassador program. Using this information, calculate the customer conversion rates, customer acquisition costs, and return on investment. You should also calculate the averages and the minimum and maximum for these metrics. Note these cells are highlighted in grey in the spreadsheet. Complete the calculations in the Excel worksheet and submit the file with the completed metrics.

Ambassador Program Raw Data

Be sure to complete the entire Excel document including the following.

Conversion Rate $=$ percent of conversations from referrals

Customer Acquisition Cost $($CAC$)=$ Cost to acquire each new customer $-$ Hint... consider the marketing cost and new customers obtained for that investment

Profit $=$ Total Revenue $-$ Expenses

Return on Investment $($ROI$)=$ percent of return from initial investment. Hint... Consider your profit compared to your costs.