You are tasked to optimize a project selection decision, with the objective function being to maximize NPV from the projects selected according to the decision constraints. Find real-life cases to obtain data for the project selection optimization process.

The project selection optimization must have the following:

• 3-5 alternative projects to be selected.
• 2-3 resource constraints
• 1-2 project mix constraints

Example project selection decision:

An event organizer (EO) received booking orders for five different events in the same time slot. The EO must consider the constraints before accepting one or more booking orders. There are three resource constraints, namely money, manpower, and vehicles. The company has an operating fund of Rp100 million, 12 full-time employees, and 3 pickup trucks to transport the equipment.

The first booking order promised a fee of Rp 250 million but required an advanced operating fund of Rp35 million, 4 employees, and 1 pickup truck.

The second booking order promised a fee of Rp 150 million but required an advanced operating fund of Rp20 million, 2 employees, and 1 pickup truck.

The third booking order promised a fee of Rp 350 million but required an advanced operating fund of Rp45 million, 4 employees, and 1 pickup truck.

The fourth booking order promised a fee of Rp 500 million but required an advanced operating fund of Rp60 million, 8 employees, and 2 pickup trucks.

The fifth booking order promised a fee of Rp 200 million but required an advanced operating fund of Rp40 million, 3 employees, and 1 pickup truck.

Due to the location, there is one project mix constraint in which if the EO selected the second booking order, it would not be possible to select the fifth booking order, and vice versa.

Considering the constraints, the objective is to maximize the fee from the selected projects.

After collecting data (using primary or secondary data), do linear programming. Additionally, perform what-if analysis and simulations with the resource constraints to determine the effects of adding or subtracting resources from the constraints.