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)?

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  

Promotion-Day Staffing Plan Problem Type: Non-Smooth Use the…

Promotion-Day Staffing Plan Problem Type: Non-Smooth Use the provided starter Excel spreadsheet (link above). The spreadsheet already includes formulas, the objective cell, and the constraint calculations. An e-commerce distributor is planning staffing for a one-day promotion event. The starter spreadsheet already contains the IF / MIN / MAX logic for bottlenecks, late orders, and piecewise penalties. Use Solver to minimize total daily cost. All staffing decisions must be nonnegative integers: Pickers, Packers, and Temporary Packing Teams. Demand and productivity Item Value Orders due today (base case) 1,500 Orders picked per picker 250 Orders packed per packer 220 Temporary team productivity Temp Teams Hired Productivity Rule Fewer than 2 teams 180 orders per team 2 or more teams 210 orders per team Cost data Cost Item Amount Picker labor cost (per picker) $180 Packer labor cost (per packer) $170 Temp team cost (per team) $850 Temp mobilization fee (if any temp team is hired) $500 Late-order penalty policy Late Orders Penalty Rule 0 to 100 late orders $4 per late order More than 100 late orders $400 + $10 for each late order above 100 Limits and constraints Limit / Rule Value Floor-space slots available 32 Training budget points 900 Maximum allowed late orders 300 Picker upper bound 8 Packer upper bound 8 Temp team upper bound 4 Staffing code (used for code questions) Code Digit Place Represents Hundreds digit Number of Pickers Tens digit Number of Packers Ones digit Number of Temp Teams Example: Pickers = 6, Packers = 7, Temp Teams = 0 → staffing code = 670.