phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

Develop a Pricing table for Sales Team with Margin calculators

  • Posted:
  • Proposals: 30
  • Remote
  • #4356712
  • OPPORTUNITY
  • Expired
MUHAMMAD Kashif M.Oluwaseyi O.Rodney L.Andrii M.Muhammad Atif K. + 25 others have already sent a proposal.
  • 9

Description

Experience Level: Intermediate
Freelance Excel Specialist Needed – Multi-Currency Pricing Table with SKU Images & Search Functionality

We are looking for an Excel expert to develop a comprehensive pricing tool for our sales team, covering approximately 200 SKUs across three currencies (GBP, USD, EUR). This tool must streamline price calculations, display product images, and allow for quick searches by product name.

Project Scope:
✅ Three Currency Sheets – Separate pricing sheets for GBP, USD, and EUR, with automatic currency conversion.
✅ Dynamic SKU Pricing – Automated calculations based on materials, customizations, and quantity.
✅ Image Integration – Ability to display product images next to SKUs.
✅ Search Functionality – Quick search/filtering by product name for easy navigation.
✅ Cost & Margin Calculation – Include built-in profitability metrics (cost, margin, and contribution calculations).
✅ User-Friendly Interface – Dropdown selections, conditional formatting, and structured layout for ease of use.

Ideal Candidate:
✔ Proficient in Excel (advanced formulas, data validation, pivot tables).
✔ Experience with large datasets (handling 200+ SKUs efficiently).
✔ Knowledge of image embedding in Excel (linking or displaying product visuals).
✔ VBA/macros experience is a plus for automation and enhanced functionality.

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Hassan F.

    Can You contact me Joanna V

  • Aditya M.

    Hi Joanna,
    .
    I understand you need a multi-currency pricing table with automation. Just to confirm,
    .
    1. Should the currency conversion be based on a fixed rate (manually set) or auto-updated via an API?
    .
    2. Will the SKU images be stored within the Excel file, or should they be linked from an external source?
    .
    3. Should the cost & margin calculations be editable manually, or should they be locked/formula-based?
    .
    4. Will the tool be used by multiple team members simultaneously, or is it a single-user file?
    .
    These details will help me ensure my approach aligns with your needs. Thanks!

  • Adelegan O.

    I do have a few questions to better understand your requirements: 1) What version of Excel is in use? 2) How do you handle exchange rate updates? 3) Do you have a current pricing model to follow? 4) What are the image file types you use?