Number $ %) 2 Wrap Text aste BIU A Merge Center Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? 21 x fx D E B F H M N 0 P SKU Demand Proft Martin Resource 0 1 2 13 1-66 487 8-408 p-102 -997 1.920 82 e-299 175 86 1:47 0-524 0-461 190 166 128 131 143 100 179 $ 29.02 $ 18.75 $ 19.67 $20.24 $ 16.81 $33.17 $13.66 $ 25.705 31.51 $ 23.71 $25.52 $29.75 177 55 Time required for each SKU on each resowe, in minutes per unit of production Capacity 1-66 1-835 487 8408 p-102 -794 5-997 1.920 299 2160 027 0.14 1.04 0-524 1461 190 0.57 0.35 0.02 0.30 1560 1.05 182 0.94 0.00 0.64 0.61 0.12 0.41 0.15 0.60 0.00 0.53 2160 0.25 0.20 0.11 0.00 0.00 1.51 1.22 1.21 1.99 0.00 2.05 1.41 134 2040 2.02 1.19 1.16 138 1.46 1.39 0.45 0.19 2208 0.33 1.16 0.15 1.40 1.97 3.30 0.70 0.56 0.55 0.29 0.28 1968 152 1.92 1.53 0.29 145 1.20 1.53 017 0.65 0.89 0.23 2112 1.01 0.89 0.83 0.69 0.21 1.95 0.96 0.63 027 1.86 0.62 2336 1.00 0.69 0.72 0.00 1.36 1.40 0.00 0.00 0.43 2304 1.58 0.87 1.93 1.82 0.69 1.72 1.35 0.92 1.27 2352 1.63 1.20 103 0.29 0.27 0.73 0:20 1N 1.94 0.15 141 1.39 1.36 15 Drill Lathe Overhead Sander Veneer Press Edging Machine Lacquer Staining Quality Control Shipping Prep 25 45 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 37 38 40 DATA + MacBook Pro esc FT F3 54 a # $ 1 2 3 4 5 6 7 QUESTION 1 An Excel worksheet is provided that shows the required time for each product (SKU) on each resource machines, as well as demand and margin/unit for each product (SKU). Determine the system constraint, the resource that has demand, in terms of aggregate workload, that is greater than the capacity for that resource) DATA O a. Quality Control b. Lathe O c. Overhead Sander d. Lacquer OD QUESTION 2 A business manufactures four products (A, B, C, D), each requiring a number of input materials for production. Information on each of the products, including selling price and profit margin per unit, demand per week, and the number of each input required to produce one unit of product is provided below 175 Product Products Product ProductD Selling Price $ 125 $ 135 $ 150 $ - Variable Cost 5 60 $ 655 90$ 95 Profit Margin/Units 655 70 S 60 $ Demand 60 70 25 45 1 Number of input materials required for each unit of production Total Total Input Material Product Products Product Product Required Available Cross-beams 1 2 2 270 400 Butterfly clamps 16 20 24 28 4.220 12.000 Stabilizing brackets 9 10 12 15 2.215 1.495 Articulating hinges 2 6 6 6. 1,200 It has been found that the business does not have enough stabilizing brackets to meet the ful demand for all four products, and must thus find the product mix that madmizes profit. Please find the optimal product mix. How many units of Product will the optimal product mix include? Save and Submit to save and submit. Click Save All Answers to see all answers. Save MACBOOK Pro