please assist with question 1.(a)

QUESTION 1 The Whitt Window Company is a company with only three employees which makes two different kinds of hand-crafted windows: a wood-framed and an aluminium-framed window. They earn $60 profit for each wood-framed window and S30 profit for each aluminium-framed window. Doug makes the wood frames, and can make 6 per day. Linda makes the aluminium frames, and can make 4 per day. Bob forms and cuts the glass, and can make 48 square feet of glass per day. Each wood-framed window uses 6 square feet of glass and each aluminium-framed window uses 8 square feet of glass The company wishes to determine how many windows of each type to produce per day to maximize total profit (a) Construct and fill in a table like Table 3. 1 (Hillier Lieberman) for this problem, identifying both the activities and the resources, (b) Formulate a linear programming model for this problem (c) Use the Graphical Method to solve this problem (d) Verify your solution by solving the problem using Excel Solver (e) A new competitor in town has started making wood-framed windows as well. This may force the company to lower the price they charge and so lower the profit made for each wood- framed window. How would the optimal solution change cilat all of the profit per wood- framed window decreases from $60 to $40? From $60 to $207 (1) Doug is considering lowering his working hours, which would decrease the number of wood frames he makes per day. How would the optimal solution change if he makes only 5 wood frames per day 35 3.1 PROTOTYPE EXAMPLE TABLE 3.1 Data for the Wyndor Glass Co. problem Production Time per Batch, Hours Product Production Time Available per Week, Hours N 1 Plant 1 0 3 NNO 4 12 18 2 3 $5,000 $3,000 Profit per batch and the marketing division, along with a pricing decision from the marketing division, the accounting department developed estimates for the third category. Table 3.1 summarizes the data gathered. The OR