Decision Support Sytem for Accept/Reject Decisions of Orders

Hello everyone! We are a project based company that takes orders of project proposals in each week. At the start of each week, by analyzing our resources, order types, and potential revenue of orders; we decide which projects we will accept and which to reject. Currently, I need an Excel VBA based Decision Support System to optimize the decision making process that we accomplish by using our experienced knowledge. Feel free to write your comments, proposals and past projects.