# Question: The current solution to Sure Step s no backlogging aggregate planning model

The current solution to Sure Step’s no-backlogging aggregate planning model does quite a lot of firing. Run a one-way SolverTable with the firing cost as the input variable and the numbers fired as the outputs. Let the firing cost increase from its current value to double that value in increments of $400. Do high firing costs eventually induce the company to fire fewer workers?

## Answer to relevant Questions

SureStep is currently getting 160 regular-time hours from each worker per month. This is actually calculated from 8 hours per day times 20 days per month. For this, they are paid $9.375 per hour (=1500/160). Suppose workers ...Modify the Barney-Jones investment problem so that there is a minimum amount that must be put into any investment, although this minimum can vary by investment. For example, the minimum amount for investment A might be $0, ...Our pension fund model is streamlined, perhaps too much. It does all of the calculations concerning cash flows in row 20. James decides he would like to break these out into several rows of calculations: Beginning cash ...In the capital budgeting model in Figure 14.40, investment 4 has the largest ratio of NPV to cash requirement, but it is not selected in the optimal solution. How much NPV is lost if Tatham is forced to select investment 4? ...In the original Western Airlines set-covering model in Figure 14.52, we assumed that each city must be covered by at least one hub. Suppose that for added flexibility in flight routing, Western requires that each city must ...Post your question