Urgent Retail Pricing Analysis & Model
Budget: $10 – $30 USD
I have a retail pricing dataset covering 1–5 product categories and three selling durations (30, 60, and 90 days). I need a seasoned analyst who can, within the next 24 hours, interrogate those numbers, expose any inconsistencies, and turn the insight into an actionable pricing strategy.
Here’s what has to happen in that single sprint:
• Build a clean, well-structured Excel model. I want dynamic formulas, clear naming conventions, and separate tabs for raw data, calculations, scenario testing, and final summaries.
• Diagnose price consistency within each category and across the three time horizons, flagging gaps or outliers.
• Recommend optimized prices for every item–duration pair and quantify projected revenue lift.
• Package the story in 10–15 crisp PowerPoint slides, weaving in key visuals and your recommendations.
Acceptance criteria:
• Every figure in the deck must tie back to the spreadsheet via traceable formulas.
• All calculations are free of circular references and hard-coded numbers (except assumptions clearly marked).
• Recommendations are supported by sensitivity or scenario analysis.
You’ll need deep Excel skills, a solid grasp of pricing strategy, and the ability to communicate findings visually and concisely. If you are available to start immediately and confident you can meet the 24-hour deadline, send a quick confirmation along with a link or screenshot of similar pricing work you have done. Dataset is ready to share the moment we agree.
Here’s what has to happen in that single sprint:
• Build a clean, well-structured Excel model. I want dynamic formulas, clear naming conventions, and separate tabs for raw data, calculations, scenario testing, and final summaries.
• Diagnose price consistency within each category and across the three time horizons, flagging gaps or outliers.
• Recommend optimized prices for every item–duration pair and quantify projected revenue lift.
• Package the story in 10–15 crisp PowerPoint slides, weaving in key visuals and your recommendations.
Acceptance criteria:
• Every figure in the deck must tie back to the spreadsheet via traceable formulas.
• All calculations are free of circular references and hard-coded numbers (except assumptions clearly marked).
• Recommendations are supported by sensitivity or scenario analysis.
You’ll need deep Excel skills, a solid grasp of pricing strategy, and the ability to communicate findings visually and concisely. If you are available to start immediately and confident you can meet the 24-hour deadline, send a quick confirmation along with a link or screenshot of similar pricing work you have done. Dataset is ready to share the moment we agree.