Q: Solve the problem 1 using the input data in the file P06
Solve the problem 1 using the input data in the file P06_02.xlsx. Data from Problem 1: In the capital budgeting model in Figure 6.5, we supplied the NPV for each investment. Suppose instead that you...
See AnswerQ: In the Great Threads model, we found an upper bound on
In the Great Threads model, we found an upper bound on production of any clothing type by calculating the amount that could be produced if all of the resources were devoted to this clothing type. a. W...
See AnswerQ: In the last sheet of the file Fixed Cost Manufacturing Finished.
In the last sheet of the file Fixed Cost Manufacturing Finished.xlsx, we illustrated one way to model the Great Threads problem with IF functions that didn’t work. Try a slightly different approach he...
See AnswerQ: In the Dorian production model, suppose that the production quantity of
In the Dorian production model, suppose that the production quantity of compact cars must either be less than or equal to 100 (a small batch) or greater than or equal to 1000 (a large batch). The same...
See AnswerQ: Suppose in the Dorian production model that no minimum production limits are
Suppose in the Dorian production model that no minimum production limits are placed on the individual vehicle types. However, minimum production limits are placed on all cars and on all minivans. Spec...
See AnswerQ: In the original Western set-covering model, we used the
In the original Western set-covering model, we used the number of hubs as the objective to minimize. Suppose instead that there is a fixed cost of locating a hub in any city, where these fixed costs c...
See AnswerQ: In the original Western set-covering model, we assumed that
In the original Western set-covering model, 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 be...
See AnswerQ: Consider a project with the following cash flows: year 1,
Consider a project with the following cash flows: year 1, 2$400; year 2, $200; year 3, $600; year 4, 2$900; year 5, $1000; year 6, $250; year 7, $230. Assume a discount rate of 15% per year. a. Find t...
See AnswerQ: Set-covering models such as the original Western model often have
Set-covering models such as the original Western model often have multiple optimal solutions. See how many alternative optimal solutions you can find. Of course, each must use three hubs because this...
See AnswerQ: How hard is it to expand a set-covering model to
How hard is it to expand a set-covering model to accommodate new cities? Answer this by modifying the model. Add several cities that must be served: Memphis, Dallas, Tucson, Philadelphia, Cleveland, a...
See Answer
