Question

Use the 'Solver' add in on excel to formulate the constraints

The Clarke Special Parts Company manufactures three products: A, B, and C. Three manufacturing centers are necessary for the production process. Product A only passes through Centers 1 and 2; Products B and C must pass through all three manufacturing centers. The time required in each center to produce one unit of each of the three products is noted as follows:

				X1	X2	X3	Z
			Profit
			Constraints
			Center 1
			Center 2
			Center 3

So a unit of Product A takes three hours at Center 1, two hours at Center 2, and zero hours at Center 3. Each center is on a 40-hour week. The time available for production must be decreased by the necessary cleanup time. Center 1 requires four hours of cleanup, Center 2 requires seven hours, and Center 3 requires five hours. It is estimated that the profit contribution is $60 per unit of Product A, $40 per unit of Product B, and $30 per unit of Product C. How many units of each of these special parts should the company produce to obtain the maximum profit?

Product:     Center 1        Center 2     Center 3

A                3 hrs             2hrs            0 hrs

B                 1                 2                2

C                  2                 1              3

Formulation, by steps:

1. Determine the type of problem—The problem only mentions profit, so it has to be a maximization problem.

2. Define the decision variables—The profit coefficients are attached to Products A, B, and C and have a weekly stated time horizon, so

X1 = number of units of Product A to produce per week

X2 = number of units of Product B to produce per week

X3 = number of units of Product C to produce per week

3. Formulate the objective function:

Maximize: Z = 60X1 + 40X2 + 30X3

4. Formulate the constraints—This problem illustrates that some arithmetic may be needed to derive model parameters. In this case, the right-hand-side b values need to be adjusted for the cleanup time. In a week, each department starts with 40 hours for production purposes. They then have to be decreased for the cleanup time, as stated in the problem sentences, “The time available for production must be decreased by the necessary cleanup time. Center 1 requires four hours of cleanup, Center 2 requires seven hours, and Center 3 requires five hours.” So, for Center 1 we have 36 hours (40 − 4), for Center 2 we have 33 hours (40 − 7), and so on to formulate the right-hand-side values in each constraint. This problem also illustrates the use of the left-hand-side strategy for formulating constraints. Note how the tabled values are the technology coefficients listed by columns in the constraints that follow:
Image

5. Interpret the results

Answer 1

solution:-

1 The Clarke Special Parts Company mamfachures three products: A, B, and C. Three manufacturing centers are necessary for the production process. 2 Product A only passes through Centers 1 and 2 Products B and C must pass through all three manufacturing centers. The time required in each center 3 to produce one unit of each of the three products is noted as follows: 4 So a unit of Product A takes three hours at Center 1, two hours at Center 2, and zero hours at Center 3. Each center is on a 40-hour weck. 5 The time available for production must be decreased by the necessary cleanup time. Center 1 requires four hours of cleanup, Center 2 requires seven hours 6 and Center 3 requires five hours. It is estimated that the profit contribution is S60 per unit of Product A. S40 per unit of Product B 7 and S30 per unit of Product C. How many units of each of these special parts should the company produce to obtain the maximum proft Product Center 1 Center 2 Center3 0 hrs 12 13 Formulation, by steps: 14 () Deternine the type of problem-The problen only mentions profit, so it has to be a maximization problem. 15 (2 Define the decision variables-The profit coefficients are attached to Products A, B, and C and have a weekly stated time horizon, so X1-mumber of units of Product A to produce per week X2umber of units of Product B to produce per week X3-number of units of Product C to produce per wee!k 16 Formulate the objective fimction Maximize: Z = 60X1 40X2 3023 214) Formulate the constraints This problem illustrates that some arithmetic may be needed to derive model parameters. In this case, the right-hand-side b vaues need to be adjusted for the cleanup time. In a week, each department starts with 40 hours for production purposes. They then have to be decreased for the cleanup time, as stated in the problem sentences, "The time available for production must be decreased by the necessary cleanup time. Cente1 requires four hours of cleamup, Center 2 requires seven hours, and Center 3 requires five hours." So, for Center 1 we have 36 hours (40-4), for Center 2 we have 33 hours (407) and so on to formulate the right-hand-side values n each constraint. This problem also thustrates the use of the left-hand-side strategy for formulating constramts. Note how the tabled vahues are the technology coefficients listed by cohmns in the constraints that follow 24 25 XI 1Max Profit Capacity Profit 32 Constraints Center 1 Center 22 Center 3 0 35 36