Hi,
My background: I have worked as pricing analyst for 4+ years. During this stint, I have worked on projects involving elasticity analysis, break-even analysis, regression and price models. In my projects, I work extensively on excel.
Regarding your project: I will use regression to get relationship between dependent and independent variable and get error component. Based on this, I will make equation to predict Y.
I am working on similar project 'predicting next day retail pricing for fuels' for client 'jleonhuang '. It involves predicting next day retail prices based on historical relationship between TGP prices and retail prices.
Please revert back for any questions/clarifications.
Regards!
Vikas