Excel Forecast Modeler

Build a forecast model that tracks by week the progression of ppl who need to take 3 sequential classes that each take a week each. But the inputs that affect it are, there is a wait list, number of students enrolled changes per week, the class size changes per week, the number of classes can change per week.

The number of classes and class size varies based on the number of teachers hired and I want to vary the number of teachers available in a given week

The output would show the number of students completing each course per week, the cumulative students that have completed the courses, and the cumulative waitlist of students. The model would project out for 104 weeks

Please share example of forecast models that you have created. Criteria to take on this gig would be heavily dependent on you having created models like this previously and independently.

Please also share how long you think this would take based on your previous experience. You won't get a response if you don't share it.