I need a excel which can do my sweater production scheduling.

Well, I need a automated excel format where I can input my order quantity and per machine sweater output for that particular design and according to that my other input of production will be auto adjusted and per month gap will be shown. Here the variables are order quantity and per machine output per hour. I have fixed numbers of machine. So need to do my scheduling of machine to produce all my orders within required deadline and planning looking at the excel, when a machine will be free and how many machines to allocate for particular styles. Hope you got the brief idea. We can video chat for a detailed conversation and I can clear you.