We are a contract manufacturer looking to replace an excel based SKU forecast and MRP system and wondering if this can be done within File Maker.
Our current system consists of 2 excel files.
The first is a forecast file with multiple worksheets containing forecasts by SKU by month by customer. This is updated each month by our sales managers to reflect changes in forecast as well as load prior month actuals by SKU, by month , by customer.
The second file is an Materials Requirement Planning (MRP) file that pulls in the aggregated forecast by SKU by month, and calculates production levels required to meet the forecast using a formula that starts with beginning inventory by SKU, adds planned purchases and subtracts forecasted demand.