Hello there, pI am seeking an experienced Excel and data modelling expert to create a comprehensive global export sales template for our premium spirits brand. This project is crucial to our international expansion strategy and requires expertise in advanced Excel formulas, market-specific cost analysis, and a deep understanding of COGS (Cost of Goods Sold) and pricing structures across multiple territories.
Key Deliverables: 1. Global Template Framework: • A functional and dynamic Excel template tailored for global export sales, including editable fields and automated calculations. • Consolidated summary tab providing a dynamic overview of all markets. 2. Market-Specific Tabs: • Include dedicated tabs for Australia, China (Hong Kong and Beijing), the US, and South America. • Market research data integrated into the model to calculate COGS, duties, shipping costs, and RRP (Recommended Retail Price) per SKU. 3. Product SKU Calculations: • Accurately calculate excise and duties for spirits with 40% ABV (applying Australian regulations as an example). • Incorporate formulas to reflect costs for London Dry Gin, Pink Gin, Barrel-Aged Gin, Botanical Rum, Aged Rum, and Vodka. 4. Automated Features: • Dynamic fields and formulas for profit margins and other key metrics. • Editable fields for local tax rates, shipping, and market-specific costs.
Step-by-Step Guide: Global Expansion Pricing Spreadsheet
1. Structure of the Spreadsheet
The spreadsheet includes: • Tabs for each market: Australia, China, US, South America. • A Global Summary Tab: Consolidated view of costs, margins, and profitability across markets.
2. Columns in Each Market Tab
Each market tab includes the following columns: 1. SKU: Product name (e.g., London Dry Gin, Pink Gin, etc.). 2. Base COGS (GBP): Fixed production costs in GBP. 3. Shipping (Local Currency): Editable field for shipping costs in the market’s currency. 4. Freight (Local Currency): Editable field for freight costs in the market’s currency. 5. Duty (Local Currency, per bottle): Editable field for excise or duty costs, based on the market’s regulations. 6. Total COGS (GBP): • Formula: = [Base COGS] + ([Shipping] × Exchange Rate) + ([Freight] × Exchange Rate) + ([Duty] × Exchange Rate) 7. UK RRP (GBP): Fixed recommended retail price in GBP. 8. Adjusted RRP (Local Currency): Editable field for suggested RRP in the market. 9. Margin (%): • Formula: = ((Adjusted RRP - Total COGS) / Adjusted RRP) × 100 10. Profit (100 Cases GBP): • Formula: = (Adjusted RRP - Total COGS) × 100 11. Profit (1000 Cases GBP): • Formula: = (Adjusted RRP - Total COGS) × 1000
3. Market-Specific Adjustments
1. Australia: • Excise duty per bottle based on 40% ABV (current rate: AUD 28.52, converted to GBP). • Exchange rate: 1 AUD = 0.54 GBP. 2. China (Hong Kong & Beijing): • Unique excise and duty rates for each region, editable fields. • Exchange rate: 1 CNY = 0.11 GBP. 3. US: • Include local taxes and tariffs. • Exchange rate: 1 USD = 0.74 GBP. 4. South America: • Account for import tariffs and duties (e.g., Brazil-specific rates). • Exchange rate: 1 BRL = 0.18 GBP.
4. Global Summary Tab
1. Pulls data dynamically from all market tabs: • Total COGS by SKU. • Average margins across markets. • Consolidated profit projections for 100 and 1,000 cases. 2. Formulas reference each market tab using =SUM(Australia!Cell, China!Cell, US!Cell, SouthAmerica!Cell).
5. Editable Fields
• Ensure all shipping, freight, and duty costs are editable for flexibility. • Adjust exchange rates dynamically for real-time updates.
6. Tools for Collaboration
• Conditional Formatting: • Highlight margins below 30% in red for easy visibility. • Data Validation: • Add dropdown menus for currency selection or pre-set SKUs.
Candidate Requirements: • Proven expertise in creating complex Excel templates. • Strong understanding of international trade costs and pricing strategies. • Ability to incorporate multiple data points into clear and concise spreadsheets. • Experience working in FMCG, particularly in spirits or beverages, is a plus.
If you are passionate about crafting game-changing tools and have the expertise to deliver on this high-stakes project, I’d love to hear from you! Please include examples of similar work or projects when applying.
Facebook & Instagram Awareness Campaign Category: Content Creation, Digital Marketing, Facebook Marketing, Instagram Marketing, Internet Marketing, Marketing, SEO, Social Media Marketing Budget: $15 - $25 USD
25-Jan-2026 05:04 GMT
Public Space Wallpaper Design Category: Adobe Illustrator, Photoshop, Graphic Design, Illustration, Logo Design, Pattern Design, Print Design, Textile Design, Visual Design Budget: $10 - $30 USD
25-Jan-2026 05:02 GMT
Website Design Refresh & Maintenance Category: Content Management System (CMS), CSS, Graphic Design, HTML, SEO, User Interface / IA, Web Design, Web Development Budget: $30 - $250 AUD
25-Jan-2026 05:00 GMT
Storytime 2d Animator in Hindi -- 2 Category: 2D Animation, 2D Animation Explainer Video, 2D Game Art, 2D Layout, 3D Animation, Adobe Animate, Animation, Caricature & Cartoons, Creative Design, Illustration Budget: ₹12500 - ₹37500 INR
25-Jan-2026 04:58 GMT
Roblox Pistol Creation & Integration Category: 3D Animation, 3D Modelling, ActionScript, Animation, Game Development, Lua, Maya, Roblox Budget: $10 - $30 CAD
25-Jan-2026 04:57 GMT
Amazon Brand Approval Assistance Category: Amazon, Brand Management, Business Consulting, Compliance, Content Strategy, Customer Service, Digital Marketing, Market Research Budget: $30 - $250 USD
25-Jan-2026 04:57 GMT
Kontes Logo Modern Monokrom Category: Adobe Illustrator, Branding, Graphic Design, Illustration, Logo Design, Photoshop, Vector Design, Visual Design Budget: $15 - $25 USD
25-Jan-2026 04:57 GMT
Music Album Multi-Platform Marketing Category: Brand Management, Content Creation, Copywriting, Digital Marketing, Facebook Marketing, Graphic Design, Internet Marketing, Social Media Marketing, Video Editing, YouTube Budget: ₹12500 - ₹37500 INR
25-Jan-2026 04:56 GMT
Edit Foto & Video HD Category: Adobe Lightroom, Photoshop, Adobe Premiere Pro, After Effects, Graphic Design, Photo Editing, Social Media Marketing, Video Editing, Video Production, Video Services Budget: $250 - $750 USD
25-Jan-2026 04:56 GMT
SEO YouTube Titles & Descriptions Category: Article Writing, Content Marketing, Content Writing, Copywriting, Digital Marketing, Keyword Research, SEO, Social Media Marketing Budget: ₹750 - ₹1250 INR
25-Jan-2026 04:54 GMT
Web Scraper GPU Optimization -- 2 Category: CUDA, Data Processing, Java, NumPy, Parallel Processing, Python, Software Architecture, Web Scraping Budget: ₹600 - ₹1500 INR
25-Jan-2026 04:53 GMT
Correct Actress Neck Distortion Category: Adobe Premiere Pro, After Effects, Animation, Video Editing, Video Post Editing, Video Production, Video Services, Visual Effects Budget: $125 - $150 USD
25-Jan-2026 04:53 GMT
Corporate Talking-Head Infographic Animation Category: 2D Animation, After Effects, Animation, Explainer Videos, Graphic Design, Motion Graphics, Video Editing, Video Production, Video Services, Visual Effects Budget: $10 - $30 AUD
