In my department, we have a problem in trying to determine how many credits of electives we should offer. At first, it seems that it should be a simple equation to take the number of students enrolled at the department multiplied by the elective credits they will take on average that semester, and then divide by the minimum student enrollment for a course to help estimate how many credits to offer. The problem is that not only is the average elective credits to be taken not known in advance, but also that students often take electives outside the department, and students from other departments will sometimes take our department's courses.
As a result, the department makes no effort to estimate elective credits, and often offers more credits than could reasonably be filled. This results in under-enrollment of the electives, which means that many do not meet their minimum enrollment numbers, and are cancelled before the semester even starts.
Does anyone have a tool their department uses that works well to mitigate this problem?