# Question

One of the products of the G.A. Tanner Company is a special kind of toy that provides an estimated unit profit of $3. Because of a large demand for this toy, management would like to increase its production rate from the current level of 1,000 per day. However, a limited supply of two subassemblies (A and B) from vendors makes this difficult. Each toy requires two subassemblies of type A, but the vendor providing these subassemblies would only be able to increase its supply rate from the current 2,000 per day to a maximum of 3,000 per day. Each toy requires only one subassembly of type B, but the vendor providing these subassemblies would be unable to increase its supply rate above the current level of 1,000 per day. Because no other vendors currently are available to provide these subassemblies, management is considering initiating a new production process internally that would simultaneously produce an equal number of subassemblies of the two types to supplement the supply from the two vendors. It is estimated that the company’s cost for producing one subassembly of each type would be $2.50 more than the cost of purchasing these subassemblies from the two vendors. Management wants to determine both the production rate of the toy and the production rate of each pair of subassemblies (one A and one B) that would maximize the total profit.

The following table summarizes the data for the problem.

(a) Formulate and solve a spreadsheet model for this problem.

The following table summarizes the data for the problem.

(a) Formulate and solve a spreadsheet model for this problem.

## Answer to relevant Questions

Reconsider Prob. 7.3-4. After further negotiations with each vendor, management of the G.A. Tanner Co. has learned that either of them would be willing to consider increasing their supply of their respective subassemblies ...Consider the following problem. Maximize Z = c1x1 + c2x2, Subject to and x1 ≥ 0, x2 ≥ 0. The estimates and ranges of uncertainty for the parameters are shown in the next table. (a) Use the graphical method to solve this ...Consider the following problem. Maximize z = 20x1 + 30x2 + 25x3, Subject to and x1 ≥ 0, x2 ≥ 0, x3 ≥ 0, where b1, b2, and b3 are uncertain parameters that have mutually independent normal distributions. The mean and ...This case is a continuation of Case 4.3, which involved the Springfield School Board assigning students from six residential areas to the city’s three remaining middle schools. After solving a linear programming model for ...Use the dual simplex method manually to solve the following problem. Minimize Z = 5x1 + 2x2 + 4x3, Subject to and x1 ≥ 0, x2 ≥ 0, x3 ≥ 0.Post your question

0