Process Improvement Project Selection Required Solver method…

Prоcess Imprоvement Prоject Selection Required Solver method: Lineаr Use the provided stаrter Excel spreаdsheet. The spreadsheet already includes formulas, the objective cell, and the constraint calculations. A firm is selecting process-improvement projects. Each project decision must be binary (selected = 1, not selected = 0). Use Solver to maximize total expected NPV subject to the business rules and limits below. Project Cost ($1,000s) Expected NPV ($1,000s) Analyst Hours A 140 210 120 B 220 330 250 C 90 125 80 D 180 260 200 E 130 170 140 F 160 205 170   Base-case rule / limit Value Capital budget 520 ($1,000s) Analyst hours available 520 Maximum number of projects 3 If D is selected, F must also be selected Yes B and D can both be selected No At least one of A or B must be selected Yes