In Progress

Excel Business Model for Commodities Oct 07 2012 14:13:18

Dear Imranamin:

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.

Best Regards,

Patrick

Skills: Accounting, Business Analysis, Excel

See more: region 13, overall business, l.g. india, i want to buy a business, i want make my new business, global p, global cash, excel singapore, cost flows, buy spreadsheet, best buy model number, excel spreadsheet formula, wheat, tilt, sales excel, Roll up, Patrick, one sugar, new model, make business model, lease business, india excel, global startup, excel us, excel model

About the Employer:
( 0 reviews ) Castro Valley, United States

Project ID: #2546973

Awarded to:

imranamin

Hired by the Employer

$15 USD / hour
(48 Reviews)
6.0