Question: Using the above worksheet that shows the required time for each product (SKU) on each resource (machine), as well as demand and margin/unit for each

-
Using the above worksheet that shows the required time for each product (SKU) on each "resource" (machine), as well as demand and margin/unit for each product (SKU). Determine the system constraint
a. Edging Machine
b. Drill
c. Staining
d. Overhead Sander
e. Lathe
The constraint is the letter: ______
SKU Demand Profit Margin -66 82 $ 29.02 t-835 175 $ 18.75 u-487 8-408 86 190 $ 19.67 $ 20.24 P-102 u-794 s-997 r-920 166 128 131 143 $ 16.81 $33.17 $ 13.66 $ 26.70 e-299 h-47 0-524 n-461 100 179 177 55 $31.51 $ 23.71 $25.52 $ 29.75 t-835 0-524 Resource Saw Drill Lathe Overhead Sander Veneer Press Edging Machine Lacquer Staining Quality Control Shipping Prep Capacity 2160 2112 2208 1920 2208 2016 2160 2136 2088 2352 -66 0.27 1.00 1.58 0.89 0.33 1.52 1.24 0.00 0.00 1.03 0.14 0.69 1.82 1.49 1.86 1.29 1.16 0.64 1.51 0.29 Time required for each SKU on each resource, in minutes per unit of production u-487 8-408 P-102 u-794 5-997 r-920 e-299 h-47 1.04 1.90 0.57 0.35 0.02 0.30 1.06 1.82 0.00 1.36 1.40 1.81 0.00 0.00 0.43 1.62 1.55 1.47 0.69 1.72 1.35 0.92 1.16 1.27 1.14 1.01 1.05 0.96 1.63 0.87 1.86 1.22 0.70 1.83 0.25 0.48 0.56 0.55 0.29 0.28 1.45 1.50 1.53 0.87 1.32 0.85 0.89 1.41 1.64 1.38 1.46 1.39 0.45 0.19 0.15 1.40 0.61 0.41 0.15 0.60 0.00 0.53 0.25 0.20 1.64 1.22 1.21 1.09 0.00 2.05 1.41 1.34 0.27 0.73 0.20 1.94 1.94 0.15 1.41 1.39 0.93 0.89 1.59 0.90 1.90 1.25 1.98 0.12 2.01 1.35 n-461 0.12 1.93 1.20 0.62 1.53 0.83 3.30 0.00 1.19 1.58Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
