Build customized Excel spreadsheet to calculate master production schedule

We manufacture stone veneer using molds. We need an excel spreadsheet that we can input a backorder report of orders that need to be manufactured with the necessary details. Then the spreadsheet will need to calculate when each order can be produced based on known variables and capacity. The spreadsheet should be able to give a projected completion date for each order. It would be re-run daily with updated input data from the sales backorder report in order to have a daily updated master production schedule.