On similar lines, but which can be easily converted to your requirements, i came across a company who provide MRP solutions using MS Excel. They offer 2 very interesting spreadsheets to give an idea how they work.
The spreadsheets themselves are tutorials.
Their website can be located at...
