Hi,
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.
My approach (for your project) will be to divide it into 3 modules:
1) User form: Here we will have buttons for profitability analysis, business options (drop down list), scenarios (drop down list) reversing transactions, drop-down lists for vehicle selection etc.
2) Data-base & calculations: This will have all data related to cost, products etc, and logic connecting user form to database.
3) Output: Quotation template, analysis results for breakeven, profitability etc.
I have successfully completed similar projects for 'Sadebow'. You may have a look at review provided.
Please revert back for any questions/clarifications.
Regards!
Vikas