Read the attached Case Study of the WYNDOR Glasss Co. Product Mix Problem and answer the following Questions:

Use the graphical method to solve the linear programming problem for Wyndor Co.

Draw the constraint boundary line for each functional constraint.

Find the feasible region after calculating the representing points for all constraints.

Calculate the profit for all constraints and identify the optimal solutions

Should they go ahead with launching these two new products?

If so, what should be the product mix?

1. Take a photo for your handwriting and submit it back.

2. Buil LP model using excell sheet

Background The Wyndor Glass Co. produces high-quality glass products, including windows and glass doors that feature handcrafting and the finest workmanship. Although the products are expensive, they fill a market niche by providing the highest quality available in the industry for the most discriminating buyers. The company has three plants that simultaneously produce the components of its products. Plant 1 produces aluminum frames and hardware. Plant 2 produces wood frames. Plant 3 produces the glass and assembles the windows and doors. Because of declining sales for certain products, top management has decided to revamp the company's product line. Unprofitable products are being discontinued, releasing production capacity to launch the two new products developed by Jim Baker's group if management approves their release. The 8-foot glass door requires some of the production capacity in Plants 1 and 3, but not Plant 2. The 4 -foot 6-foot double-hung window needs only Plants 2 and 3 , Management now needs to address two issues: 1. Should the company go ahead with launching these two new products? 2. If so, what should be the product mix-the number of units of each produced per weekfor the two new products? Wyndor Glass Co. Product-Mix Problem - Company: Wyndor Glass Company - Business: High quality glass products - Synopsis: - Three plants produce components of products: - Plant 1: Aluminum frames \& hardware - Plant 2: Wood frames - Plant 3: Glass production \& assembly - Two new products to be developed - 8-foot glass door with aluminum framing - 4-foot X 6 foot double-hung, wood-framed window - Decisions: - Should the company launch these two new products? - What should be the product mix (units produced per week of each)? - Objective: - Maximize profit. - Decision Variables: - Amount to produce of each product - Parameters: - Production capacity of each plant - Production capacity needed by each product at each plant - Profit from each product 1. Use the graphical method to solve the linear programming problem for Wyndor Co. 2. Draw the constraint boundary line for each functional constraint. 3. Find the feasible region after calculating the representing points for all constraints. 4. Calculate the profit for all constraints and identify the optimal solutions 5. Should they go ahead with launching these two new products? 6. If so, what should be the product mix