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

  1. 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.58

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!