H
Huyeote
Hi there,
I'm working for a manufacturing company in FMCG industry. One of m
jobs is to build and maintain an activity based financial model i
Excel which simulates the whole group's financial performance based o
current/projected sales & manufacturing conditions. The model ca
enable user to drill down to SKU level to analyse the profitability
Because I don't have access to our ERP system's database, I have t
replicate all master data I need in various tables in the mode
workbook. That means the model has its build-in database in Exce
worksheets. The model is 100% dynamic which means the workbook is ful
of formulae and any change in one area will ripple through the whol
modle and impact the bottom line. The model works fine so far t
simulate the performance down to contribution level (meanin
calculation of profit after taking account of promotion, warehousing
distribution costs). Guess what my model looks like now - has more tha
1 million formulae and more than 100MB in size and take more than 3
minutes to do a full-scale recalculation (if successful at all)! But m
company wants me progress to EBIT level, which means I need take in mor
& more data and build more formula and store more data. I know I'v
reached the critical point beyond which will be out of Excel'
capacity. I remember I saw an article on Internet about the superiosit
of Access to Excel regarding financial modelling. But I just could fin
it now by all means.
My questions: could anyone show me how to do modelling in Access?
mean those dynamic things in Access as in Excel. Can I have a sampl
Access DB for financial modelling? Or is there any other software tha
can handle industrial level modelling like mine?
Any comment is welcome.
Cheers
Huyeot
I'm working for a manufacturing company in FMCG industry. One of m
jobs is to build and maintain an activity based financial model i
Excel which simulates the whole group's financial performance based o
current/projected sales & manufacturing conditions. The model ca
enable user to drill down to SKU level to analyse the profitability
Because I don't have access to our ERP system's database, I have t
replicate all master data I need in various tables in the mode
workbook. That means the model has its build-in database in Exce
worksheets. The model is 100% dynamic which means the workbook is ful
of formulae and any change in one area will ripple through the whol
modle and impact the bottom line. The model works fine so far t
simulate the performance down to contribution level (meanin
calculation of profit after taking account of promotion, warehousing
distribution costs). Guess what my model looks like now - has more tha
1 million formulae and more than 100MB in size and take more than 3
minutes to do a full-scale recalculation (if successful at all)! But m
company wants me progress to EBIT level, which means I need take in mor
& more data and build more formula and store more data. I know I'v
reached the critical point beyond which will be out of Excel'
capacity. I remember I saw an article on Internet about the superiosit
of Access to Excel regarding financial modelling. But I just could fin
it now by all means.
My questions: could anyone show me how to do modelling in Access?
mean those dynamic things in Access as in Excel. Can I have a sampl
Access DB for financial modelling? Or is there any other software tha
can handle industrial level modelling like mine?
Any comment is welcome.
Cheers
Huyeot