Excel Stock List Data Cleanup

PROJECT SPECIFICATION
Wilkinson Vintners – Full Stock List Processing
Project: BORDEAUX RESERVE
Source: https://www.wilkinsonvintners.com/the-wines
Deliverable: Processed and updated Excel stock list.
1. SOURCE FILE DOWNLOAD
1. Visit the Wilkinson Vintners website:
https://www.wilkinsonvintners.com/the-wines
2. Locate and download the latest Full Stock List in Excel format.
3. Save an original, unmodified copy of the downloaded file as a backup.
4. Perform all modifications on a separate working copy.
2. PRODUCT SELECTION CRITERIA
Filter the stock list and retain ONLY products meeting the following criteria:
Category A – Cases of 12 Bottles
* Packaging: 12 bottles per case.
* Original listed price: strictly above £4,300.
Category B – Cases of 6 Magnums
* Packaging: 6 magnum per case.
* Original listed price: strictly above £4,300

3. PRICE CALCULATION
For every qualifying product, apply the following pricing formula:
Step 1 – Add a fixed amount
Add £215 to the original listed price.
Adjusted price = Original price + £215
Step 2 – Apply a 10% commercial margin
Multiply the adjusted price by 1.10.
Price including margin = (Original price + £215) × 1.10
Step 3 – Convert GBP into EUR
Convert the resulting GBP price into euros using the agreed GBP/EUR exchange rate.
Final EUR price = (Original price + £215) × 1.10 × GBP/EUR exchange rate

4. EXCEL FILE STRUCTURE
The final Excel spreadsheet must contain the following columns:
Column Description

A Wine
B Vintage
C Quantity
D Case Size
E Final Selling Price (EUR)


This job has to be done once a week every monday.