I would like to build a fairly sophisticated spreadsheet model. The model is to enable us to quickly analyze the startup costs for a new region (for a commodities trading company), to analyze the projected P&L, as well as the required cash-flows.
We have a single holding company (entity) to which all the P&Ls roll-up. After that we have regions and sub-regions. For example, Singapore is a regional headquarter and encompasses Singapore (Regional HQ), with Myanmar, Sri-Lanka and India all with independent P&Ls, but rolling up to Singapore, which will then rollup to the overall Global P&L.
We would like to be able to build a model in the following way'
1) At the lowest level, we would have objects, such as warehouses, which would have some business rules or attributes attached. An example is a warehouse could be bought or leased. If it is leased, there is a simple formula for monthly lease cost (sq. meters x lease rate ). If you buy a warehouse, there is a purchase price. If you build one, there is a tilt-up cost, which might further decompose.
2) We would also have the commodities themselves, which would have some associated characteristics. For example, Sugar has a current source price, a current London Exchange price (which we could feed in via RSS), and a proposed sales price.
3) We would like to be able to build a regional model by selecting these "objects", e.g., for Colombo, we will lease a warehouse, sell sugar, lease 2 vehicles, etc., etc, etc. For Myanmar, we will source Pulses, sell sugar and wheat, buy a warehouse, etc. Ideally, the regional models would be templated worksheets or workbooks with the ability to select the "objects", such as warehouse, vehicle, commodity type, etc.
So, my questions are:
1) Does this make sense to you?
2) How would we go about getting a decent estimate?
We want to undertake this work as soon as possible. We understand that we are probably too early on for a firm estimate, but I have put a number in based on our timeline. We look forward to hearing from you.