Process Improvement Project Selection Required Solver method…

Process Improvement Project Selection Required Solver method: Linear Use the provided starter Excel spreadsheet. 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  

Price and Advertising Decision Continue to suppose that mark…

Price and Advertising Decision Continue to suppose that marketing reduces the maximum allowed ad spend to $1,600 (instead of $2,500). All other values stay the same. Question: What is the change in weekly profit (new − base), in dollars, after the maximum allowed ad spend is reduced to $1,600 (instead of $2,500)?