Scenario

You have been given the task of analyzing a program that provides stable housing for homeless families. The protocol followed by the program involves an intake process that can take a few days during which families are put up at a nearby shelter/hotel at the expense of the program. Once the intake process has been completed, the families are matched with resources and an apartment (and so do not require further resources from your organization). The intake and resource matching process are relatively labor intensive — one staff member can generally handle only one family per week. The organization has been collecting data for the last two years on how many families show up needing services each week.

Your job is to provide the organization with forward looking estimates of how many staff members they should have on the payroll and how much needs to be in the budget to cover the shelter/hotel costs.

housing-office-queue-monte-carlo.xlsx
housing-office-queue-monte-carlo.xlsm