AUB Protection Office Projects

AUB Protection Office is considering improving security on campus. The table below shows all projects

considered with their annual costs and the number of new employees needed.

AUB's budget for all projects is $$100,000.$ The number of new employees hired should not exceed $10.$

Additionally, if project $1$ or project $2$ are selected, then project $5$ should also be selected.

Formulate a model that can be used to select the set of projects that maximizes the total value subject

to the above constraints. Solve it in Excel. Make sure your solution satisfies all constraints.

SHOW EVERY STEP ON EXCEL SOLVER