Question: In the current no backlogging problem SureStep doesn t hire any workers
In the current no-backlogging problem, SureStep doesn’t hire any workers, and it uses almost no overtime. This is evidently because of low demand. Change the demands to 6000, 8000, 5000, and 3000, and rerun Solver. Is there now any hiring and/or overtime? With this new demand pattern, explore the trade-off between hiring and overtime by running a two-way SolverTable. As inputs, use the hiring cost per worker and the maximum overtime hours allowed per worker per month, varied over reasonable ranges. As outputs, use the total number of workers hired over the four months and the total number of overtime hours used over the four months. Discuss the results.
Answer to relevant QuestionsIn the SureStep no-backlogging problem, change the demands so that they become 6000, 8000, 5000, and 3000. Also, change the problem slightly so that newly hired workers take six hours to produce a pair of shoes during their ...In our Barney-Jones spreadsheet model, we ran investments across columns and years down rows. Many financial analysts prefer the opposite. Modify the spreadsheet model so that years go across columns and investments go down ...Continuing the previous problem in a slightly different direction, continue to use the Money_allocated cell as a changing cell, but add a constraint that it must be less than or equal to any value, such as $195,000, that is ...Suppose in the capital budgeting model in Figure 14.40 that each investment requires $2000 during year 2 and only $5000 is available for investment during year 2.a. Assuming that available money un-invested at the end of ...How hard is it to expand a set-covering model to accommodate new cities? Answer this by modifying the model in Figure 14.55. Add several cities that must be served: Memphis, Dallas, Tucson, Philadelphia, Cleveland, and ...
Post your question