Promotion-Day Staffing Plan Question: What is the minimum total daily cost (in dollars) achievable without violating any constraints?

Process Improvement Project Selection Suppose analyst hours increase from 520 to 600. All other values stay the same. Question: With analyst hours increased to 600, what are the new projects selected that maximize NPV without violating any constraints?

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.

Price and Advertising Decision Suppose marketing reduces the maximum allowed ad spend to $1,600 (instead of $2,500). All other values stay the same. Question: With the ad cap reduced to $1,600, what is the new weekly demand (subscriptions) when optimal decisions are made (without violating any constraints)?

Price and Advertising Decision Question: What is the maximum weekly profit (in dollars) achievable without violating any constraints?

Use this starter spreadsheet to help answer the questions in this exam. Starter Spreadsheet Midterm 2.xlsx

Price and Advertising Decision Question: What is the optimal weekly advertising spend (in dollars)?

The tool that is useful to investigate the relationship between two variables is:

The design of process layouts requires all the following information, except

Which of the following is an example of ordering/setup costs?