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, want buy business, want make 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, excel formula

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