Price Elasticity Modeling Tool for Food and Beverage Industry

Project Description

For one of the our clients we are looking at developing a PRICE ELASTICITY tool, ideally in EXCEL, that can be shared with their Sales Leaders in the marekts so that they can calculate their local price elasticity.

• The client is a Food & Beverage company
• The tool will be deployed to the market to standardize the way Price Elasticity is calculated
• Today's price elasticity is calculated sporadically and inconsitently across markets
• The tool needs to be in a format that can be shared with the market given they don't have access to softwares like Tableau or similar and that they will have restrictions to do any cloud based deployment. Alternative could be to have the tool online but it would need to be deloyed within their intranet.
• Attached is a sample of their data / metrics

Please list your questions in your proposal and I will respond accordingly.