If you have a business school locally, ask a MBA student/professor. It is a standard resource allocation problem in decision support model, supply/resource all

If you have a business school locally, ask a MBA student/professor. It is a standard resource allocation problem in decision support model, supply/resource allocation and management courses in MBA program. If you do little bit digging online for textbooks in this area and available supplemental materials, you should be able to find a pre-designed spreadsheet to solve your problem.