Q: How difficult is it to expand the Great Threads model to accommodate
How difficult is it to expand the Great Threads model to accommodate another type of clothing? Answer by assuming that the company can also produce sweatshirts. The rental cost for sweatshirt equipmen...
See AnswerQ: Referring to the previous problem, if it is optimal for the
Referring to the previous problem, if it is optimal for the company to produce sweatshirts, use SolverTable to see how much larger the fixed cost of sweatshirt machinery would have to be before the co...
See AnswerQ: In the Great Threads model, we didn’t constrain the production quantities
In the Great Threads model, we didn’t constrain the production quantities in row 16 to be integers, arguing that any fractional values could be safely rounded to integers. See whether this is true. Co...
See AnswerQ: In the optimal solution to the Great Threads model, the labor
In the optimal solution to the Great Threads model, the labor hour and cloth constraints are both binding—the company is using all it has. a. Use SolverTable to see what happens to the optimal solutio...
See AnswerQ: In the optimal solution to the Great Threads model, no pants
In the optimal solution to the Great Threads model, no pants are produced. Suppose Great Threads has an order for 300 pairs of pants that must be produced. Modify the model appropriately and use Solve...
See AnswerQ: In the Dorian production model, the optimal solution calls for the
In the Dorian production model, the optimal solution calls for the minimum number of compact cars and midsize minivans to be produced, but for more than the minimum number of large minivans to be prod...
See AnswerQ: Assume the demand for a company’s drug Wozac during the current year
Assume the demand for a company’s drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it w...
See AnswerQ: As the Dorian production model is currently stated, each vehicle type
As the Dorian production model is currently stated, each vehicle type has a minimum production level; if this type is produced at all, its production quantity must be at least this minimum. Suppose th...
See AnswerQ: The optimal solution to the Dorian production model appears to be sensitive
The optimal solution to the Dorian production model appears to be sensitive to the model inputs. For each of the following inputs, create a one-way Solver Table that captures all decision variable cel...
See AnswerQ: If Solver could handle IF functions correctly, how would you use
If Solver could handle IF functions correctly, how would you use them in the Dorian production example to create an arguably more natural model—without binary variables? Run Solver on your modified mo...
See Answer
