QUESTION 9 HA 2 Question - Using the "Line Balancing" worksheet, choose the "% Load" value for Op. No. 6, "Inject foam into carton....." (calculated; changes from zero after you add Yellow Input Box values). Op. No. Operation Description 1 Assemble & staple carton top 2 Assemble & staple carton bottom 3 Add stryrofoam table supports to carton bottom 4 Place table in plastic bag 5 Center & place table in carton bottom; top down 6 Inject foam into carton, around table, up to top of carton 7 Add warranty sheet and sales brochures on top of foam 8 Add carton top 9 Shrink wrap carton assembly 10 Remove product carton from manufacturing line 19 Cycle Time Min. 0.280 0.200 0.100 0 310 0.220 0.500 0.050 0.100 0.630 0.250 Line Time 0.315 0.315 0.315 0.315 0315 0.630 0.315 0.315 0630 0315 No. of No. of Stations Avg. Cycle Stations (Rounded Up) Time 0.824 #DIV/01 0.588 #DIV/01 0.294 #DIV/01 0.912 #DIV/01 0847 #DIV/01 1.471 #DIV/01 0.147 #DIV/01 0 294 #DIV/01 1.853 #DIV/01 0735 #DIV/0! % Load #DIV/0! #DIV/0! #DIV/OI #DIV/0! #DIVIO #DIV/01 #DIV/OI #DIV/OI #DIV/0! #DIV/OI Pcs./Hr. Hrs./1000 190.48 5 25 190.48 25 190.48 5.25 5.25 0.48 5 25 95.24 10.50 190.48 5.25 190.48 5.25 95.24 10.50 190.48 525 O 63.49% O 69.84% O 79.37% O 100% QUESTION 10 HA 2 Question - Using the "Scrap" worksheet, choose the "Starting Qty Before - Scrap / Day" value for WT-TP, Part Name "Top" (calculated; changes from zero after you add Yellow Input Box values). Part No. Part Name Final Req'd Qty / Day Scrap % Calculated Scrap 0 Starting Qty Before Scrap / Day 0 WT1 Writing Table - Final Assembly 0 Operations Needed Assembling Ignore Painting Ignore Gluing Ignore Packaging Cutting + Planing Cutting + Planing Cutting + Planing Cutting + Planing Cutting + Planing Cutting + Planing Setup Scrap Amount Setup Scrap Amount WT-LG Leg WT-LR Long Rail WT-SR Short Rail WT-BR Bottom Rail WT-FR Foot Rail WT-TP Top 1000 Gorilla Glue (oz) 1001 White Paint (gal.) 0 0 0 0 0 0 0 0 0 0 A 0 2,000 50 2,000 50 0 54 O 535 O 1,035 0 2,200