The supervisor of a manufacturing plant is trying to determine how many of two parts, Part X and Part Y, are to be produced per day. Each part must be processed in three sections of the plant. The time required for the production along with the profit contribution for each part are given in the following table.

Time required (Minutes/Unit)
	Section 1	Section 2	Section 3	Profit/Unit
Part X	50	30	18	$2
Part Y	80	45	22	$3
Available time (minutes)	3,600	2,500	1,200

No more than 60 units of Part X and up to 70 units of Part Y can be produced per day. The company already has orders for 30 units of Part Y that must be satisfied.

The answer report of the optimization problem (profit maximization) from the Excel Solver is:

What will be the new optimal profit if 180 fewer minutes are made available to Section 2?

	A.	150
	B.	138
	C.	126
	D.	The optimization problem needs to be re-solved to get the new optimal profit.
	E.	180

Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Solver Options Objective Cell (Max) Variable Cells