1. An Excel worksheet is provided 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 (i.e., the resource that has demand, in terms of aggregate workload, that is greater than the capacity for that resource.)

   DATA

   	a.	Staining
   	b.	Edging Machine
   	c.	Drill
   	d.	Lathe
   	e.	Overhead Sander

u-487 u-794 SKU Demand Profit Margin -66 82 $ 29.02 t-835 175 86 $ 19.67 g-408 190 $ 20.24 p-102 166 $ 16.81 128 $ 33.17 S-997 r-920 131 143 $ 13.66 $ 26.70 e-299 100 $ 31.51 h-47 179 $ 23.71 0-524 177 $ 25.52 n-461 55 $ 29.75 $ 18.75 Resource t-835 0-524 n-461 0.12 0.14 Capacity 2160 2112 2208 1920 1.93 Saw Drill Lathe Overhead Sander Veneer Press Edging Machine Lacquer Staining Quality Control Shipping Prep j-66 0.27 1.00 1.58 0.89 0.33 1.52 1.24 0.00 0.00 Time required for each SKU on each resource, in minutes per unit of production u-487 g-408 p-102 u-794 S-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.69 1.82 1.49 1.86 1.29 1.16 0.64 2208 2016 2160 2136 2088 2352 0.93 0.89 1.59 0.90 1.90 1.25 1.98 0.12 2.01 1.35 1.20 0.62 1.53 0.83 3.30 0.00 1.19 1.51 1.03 0.29 1.58