Question 1 options:

Use this Excel File to answer the question.

The Corning Corporation is now in the business of producing different types of fiber optics cables. It has to determine the production schedule for next month. Given the current conditions in the telecommunications market, it has decided to only produce A-type, H-type, X-type and Y-type cables. Each million A-type and H-type fiber respectively provides a profit of $350,000, $300,000, $420,000, and $380,000, uses up 12, 16, 9, and 15 ounces of premium glass, and 9, 6, 7, and 10 man-hours of labor. The total premium glass available is 2880 ounces per day, and the labor available is 1566 man-hours per day. Further, it is not possible to pull more than 200 million strands of optic-fiber glass in total per day. Suppose we plan to produce 40 million strands of each type of fiber. Which of the resources is used up?

Type:

• A for "Glass",
• B for "Labor,"
• C for "Both glasses and labor"
• D for "Neither glasses nor labor"

By optimizing the production plan, the profit generated is within the range:

Type:

• A for $60 - 64.9 million
• B for $65 - 69.9 million
• C for $70 - 74.9 million
• D for $75 - 79.9 million
• E for $80 - 84.9 million
• F for None of the above