In the original RedBrand problem (Example 5.4), suppose that the company could add up to 100 tons of capacity, in increments of 10 tons, to any single plant. Use SolverTable to determine the yearly...

In the original RedBrand problem (Example 5.4), suppose that the company could add up to 100 tons of capacity, in increments of 10 tons, to any single plant. Use SolverTable to determine the yearly savings in cost from having extra capacity at the various plants. Assume that the capacity will cost $28,000 per ton right now. Also, assume that the annual cost savings from having the extra capacity will extend over 10 years, and that the total 10-year savings will be discounted at an annual 10% interest rate. How much extra capacity should the company purchase, and which plant should be expanded? (Hint: Use the PV function to find the present value of the total cost saving over the 10-year period. You can assume that the costs occur at the ends of the respective years.)

Example 5.4