Dynamic Excel Price Master Dashboard
Budget: ₹100 – ₹400 INR
I need a single, well-structured Excel workbook that pulls together data from my existing sheets—fabric details, consumption tables, and manufacturing cost breakdowns—into one formula-driven “Price Master”. The end result will feed our product listings, so every SKU must show price, fabric info, calculated consumption, and all associated costs in a clear, traceable format.
Here’s the flow I have in mind:
• Source Sheet 1: fabric price, width, category, catalog.
• Source Sheet 2: width-based consumption table.
• Source Sheet 3: overhead, packaging, and any other manufacturing costs.
Your job is to link these sheets (VLOOKUP, XLOOKUP, INDEX/MATCH—whatever’s cleanest) so the final price per SKU = fabric price × consumption + summed manufacturing costs. I’d like a front-facing dashboard sheet that summarizes each product, plus the detailed, linked sheets sitting behind it for quick edits later.
Acceptance criteria for the workbook:
• No hard-coded figures—everything runs off formulas referencing the source sheets.
• All references remain inside the workbook (no external links).
• Columns and ranges are sensibly named so future maintenance is painless.
• Dashboard instantly updates when any source value changes.
This is straightforward work for an experienced Excel user, but accuracy and a tidy structure are critical. If this first build goes smoothly, I’ll have ongoing tweaks and additions.
Here’s the flow I have in mind:
• Source Sheet 1: fabric price, width, category, catalog.
• Source Sheet 2: width-based consumption table.
• Source Sheet 3: overhead, packaging, and any other manufacturing costs.
Your job is to link these sheets (VLOOKUP, XLOOKUP, INDEX/MATCH—whatever’s cleanest) so the final price per SKU = fabric price × consumption + summed manufacturing costs. I’d like a front-facing dashboard sheet that summarizes each product, plus the detailed, linked sheets sitting behind it for quick edits later.
Acceptance criteria for the workbook:
• No hard-coded figures—everything runs off formulas referencing the source sheets.
• All references remain inside the workbook (no external links).
• Columns and ranges are sensibly named so future maintenance is painless.
• Dashboard instantly updates when any source value changes.
This is straightforward work for an experienced Excel user, but accuracy and a tidy structure are critical. If this first build goes smoothly, I’ll have ongoing tweaks and additions.