# Revenue operations internships: a CRM and pipeline project you can explain

## Reconcile a duplicated sales pipeline

All opportunities, amounts and stage weights are fictional. Only A, B and C have target-quarter close dates.

### Raw opportunity export; amounts in USD

| ID | Amount | Weight | Target-quarter date |
| --- | --- | --- | --- |
| A | 120000 | 0.50 | Yes |
| B | 80000 | 0.25 | Yes |
| C | 50000 | 0.80 | Yes |
| C (duplicate) | 50000 | 0.80 | Yes |
| D | 30000 | 0.20 | Missing |

## Your turn

Calculate raw, unique and dated-unique pipeline amounts and weighted amounts. Explain why the final weighted amount is not automatically a forecast.

## Your answer

[Write your approach here.]

## For your own application

Build the reconciliation in a spreadsheet or SQL project and retain an exception log instead of deleting uncertain records.

Return to the guide for the worked answer and source notes:
https://internshipdeadlines.com/guides/revenue-operations-internships-crm-project