Use the information in the Answer Report to answer the following questions:

A. What are the optimal solution and total profit?

Round your answer to a whole number

The optimal number of type 1 pipe is :=Answer

The optimal number of type 2 pipe is:=Answer

The optimal profit is:=Answer

B. Would any of the following resource (s) be used up if the company produces at the optimal amounts?

Enter 1 for YES, this resource would be used up; Enter 0 for NO, it would not.

Extrusion hours: :=Answer (enter 0 or 1)

Packaging hours::=Answer (enter 0 or 1)

Additive mix (lbs)::=Answer (enter 0 or 1)

C. For the resource that would NOT be used up, what would be the amount of leftover if the optimal solutions are implemented?

Extrusion hours: the amount of leftover :=Answer (enter 0 if the resource would be used up and there would be no leftover)

Packaging hours: the amount of leftover :=Answer (enter 0 if the resource would be used up and there would be no leftover)

Additive mix (lbs): the amount of leftover :=Answer (enter 0 if the resource would be used up and there would be no leftover)

Louis Payton Company produces two basic types of plastic pipe. Three resources are crucial to the production: extrusion hours, packaging hours, and a special additive to the plastic raw material. The following data represent next week's situation. Resource Resource Resource Resource availability requirements per unit requirements per unit of type 1 of type 2 ot Extrusion hrs 6 hrs 48 hrs 2 hrs 2 hrs 18 hrs Packaging Additive mix 2 lbs 1 lb 16 lbs The profit per unit is $40 for type 1 and $30 for type 2. The company wants to determine how much of each type of pipe should be produced to maximize the total profits. Below is Answer Report obtained from Excel Solver. (Max) Cell Name Original Value Final Value $D$5 Profit 100 340 Variable Cells Cell Name Original Value Final Value Integer Contin 1 7 $B$5 $C$5 Number of type 1 pipe Number of type 2 pipe 2 2 Contin Constraints Cell Name Cell Value Status Slack 16 0 $D$10 $D$8 $D$9 Additive mix (lbs) LHS Extrusion hours LHS Formula $D$10