THE QUESTION BELOW HAS A COUPLE OF PARTS THE ATTACHMENT IS THE EXCEL

Incorrect Question 7 0 / 1 pts Smyth Window has an order for 4 products (101, 202, 303, 404). The company can assemble any or all these window products in-house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in- house or to buy the products from partner. If Smyth assembles the products in-house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order. The goal for Smyth Window is to minimize the total cost of filling the order. Which of the following are true? There are four "Make" decision variables in this problem. There are eight decision variables in total. There are seven constraints in total in this problem. O All constraints are "greater-than-or-equal-to" constraints in this problem. Exactly two of these answers are correct. O Exactly three of these answers are correct. Incorrect Question 8 0/1 pts Smyth Window has an order for 4 products (101, 202, 303, 404). The company can assemble any or all these window products in-house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in- house or to buy the products from partner. If Smyth assembles the products in-house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order. The goal Smyth Window to minimize the total cost filling the In setting up the linear program for optimization, a formula that would work in cell F17, for the left-hand-side of the Assemble constraint is: =sumproduct(B4:E4,B17:E17) =sumproduct(B9:19,B17:E17) =sumproduct($B$8:$E$8,B4:E4) =B8*B17+C8*C17+D8%D17+E8*E17 Exactly two of these answers are correct. O None of these answers are correct. Incorrect Question 9 0 / 1 pts Smyth Window has an order for 4 products (101, 202, 303, 404). The company can assemble any or all these window products in-house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in- house or to buy the products from partner. If Smyth assembles the products in-house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order. The goal for Smyth Window is to minimize the total cost of filling the order. Which of the following are true of the optimal solution for Smyth Window? O Assemble all 101s in-house. O Outsource the assembly of all 202s. Split the 303s between in-house assembly and outsourced assembly. O Outsource the assembly of all the 404s. Exactly two of these answers are correct. O None of the other answers are correct. Incorrect Question 10 0/1 pts Smyth Window has an order for 4 products (101, 202, 303, 404). The company can assemble any or all these window products in-house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in- house or to buy the products from partner. If Smyth assembles the products in-house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order. The goal for Smyth Window is to minimize the total cost of filling the order. At the optimal solution for Smyth Window, within some range limit, each additional hour of picking time, Has no effect on the optimal solution. Increases the total cost by $5.00. Decreases the total cost by $14.40. Increases the total cost by $14.40. O Decreases the total cost by $120. O None of the other answers are correct. Incorrect Question 11 0 / 1 pts Smyth Window has an order for 4 products (101, 202, 303, 404). The company can assemble any or all these window products in-house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in- house or to buy the products from partner. If Smyth assembles the products in-house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order. The goal for Smyth Window is to minimize the total cost of filling the order. At the optimal solution, The quantity of Product 101 assembled by the outsourcing partner will remain the same unless the cost to outsource the product increases by $2.48 per unit.. The quantity of Product 101 assembled by the outsourcing partner will remain the same unless the cost to manufacture in-house drops by $2.48 per unit. 0 The quantity of Product 202 assembled by the outsourcing partner will likely increase if the cost to outsource increases by $10.80 per unit The quantity of Product 202 assembled by the outsourcing partner will likely decrease if the cost to outsource increases by $10.80 per unit O Exactly three of these answers are correct. All answers are correct. A B D E F G H 1 J K L M N P Smyth Window Product Costs 101 $51 $64 Assembly Costs Outsource Costs 202 $81 $99 303 $121 $135 404 $145 $172 Smyth Window Smyth Window has an order for 4 products (101, 202, 303, 404). The company can assemble any or all these window products in-house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in-house or to buy the products from partner. 101 202 303 404 Total Cost Assembled Quantity Outsource Quantity If Smyth assembles the products in-house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order. Required Amount 300 250 200 210 The goal for Smyth Window is to minimize the total cost of filling the order. 303 404 Hrs Used Pick Assemble Inspect Hours Required (per unit) 101 202 0.70 0.80 1.00 1.00 0.25 0.30 0.90 1.25 0.60 0.75 1.50 0.75 Hr Avail 220 350 100

Question

THE QUESTION BELOW HAS A COUPLE OF PARTS THE ATTACHMENT IS THE EXCEL

image text in transcribed

Incorrect Question 7 0 / 1 pts Smyth Window has an order for 4 products (101, 202, 303, 404). The company can assemble any or all these window products in-house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in- house or to buy the products from partner. If Smyth assembles the products in-house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order. The goal for Smyth Window is to minimize the total cost of filling the order. Which of the following are true? There are four "Make" decision variables in this problem. There are eight decision variables in total. There are seven constraints in total in this problem. O All constraints are "greater-than-or-equal-to" constraints in this problem. Exactly two of these answers are correct. O Exactly three of these answers are correct. Incorrect Question 8 0/1 pts Smyth Window has an order for 4 products (101, 202, 303, 404). The company can assemble any or all these window products in-house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in- house or to buy the products from partner. If Smyth assembles the products in-house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order. The goal Smyth Window to minimize the total cost filling the In setting up the linear program for optimization, a formula that would work in cell F17, for the left-hand-side of the Assemble constraint is: =sumproduct(B4:E4,B17:E17) =sumproduct(B9:19,B17:E17) =sumproduct($B$8:$E$8,B4:E4) =B8*B17+C8*C17+D8%D17+E8*E17 Exactly two of these answers are correct. O None of these answers are correct. Incorrect Question 9 0 / 1 pts Smyth Window has an order for 4 products (101, 202, 303, 404). The company can assemble any or all these window products in-house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in- house or to buy the products from partner. If Smyth assembles the products in-house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order. The goal for Smyth Window is to minimize the total cost of filling the order. Which of the following are true of the optimal solution for Smyth Window? O Assemble all 101s in-house. O Outsource the assembly of all 202s. Split the 303s between in-house assembly and outsourced assembly. O Outsource the assembly of all the 404s. Exactly two of these answers are correct. O None of the other answers are correct. Incorrect Question 10 0/1 pts Smyth Window has an order for 4 products (101, 202, 303, 404). The company can assemble any or all these window products in-house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in- house or to buy the products from partner. If Smyth assembles the products in-house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order. The goal for Smyth Window is to minimize the total cost of filling the order. At the optimal solution for Smyth Window, within some range limit, each additional hour of picking time, Has no effect on the optimal solution. Increases the total cost by $5.00. Decreases the total cost by $14.40. Increases the total cost by $14.40. O Decreases the total cost by $120. O None of the other answers are correct. Incorrect Question 11 0 / 1 pts Smyth Window has an order for 4 products (101, 202, 303, 404). The company can assemble any or all these window products in-house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in- house or to buy the products from partner. If Smyth assembles the products in-house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order. The goal for Smyth Window is to minimize the total cost of filling the order. At the optimal solution, The quantity of Product 101 assembled by the outsourcing partner will remain the same unless the cost to outsource the product increases by $2.48 per unit.. The quantity of Product 101 assembled by the outsourcing partner will remain the same unless the cost to manufacture in-house drops by $2.48 per unit. 0 The quantity of Product 202 assembled by the outsourcing partner will likely increase if the cost to outsource increases by $10.80 per unit The quantity of Product 202 assembled by the outsourcing partner will likely decrease if the cost to outsource increases by $10.80 per unit O Exactly three of these answers are correct. All answers are correct. A B D E F G H 1 J K L M N P Smyth Window Product Costs 101 $51 $64 Assembly Costs Outsource Costs 202 $81 $99 303 $121 $135 404 $145 $172 Smyth Window Smyth Window has an order for 4 products (101, 202, 303, 404). The company can assemble any or all these window products in-house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in-house or to buy the products from partner. 101 202 303 404 Total Cost Assembled Quantity Outsource Quantity If Smyth assembles the products in-house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order. Required Amount 300 250 200 210 The goal for Smyth Window is to minimize the total cost of filling the order. 303 404 Hrs Used Pick Assemble Inspect Hours Required (per unit) 101 202 0.70 0.80 1.00 1.00 0.25 0.30 0.90 1.25 0.60 0.75 1.50 0.75 Hr Avail 220 350 100