I do not know If the answers in the yellow boxes are right and how to calculate the employ yellow boxes.

Step 2: Complete the below data table using the provided values and the measured Sewing times below TOTALS 1 - Note on P/T per unit All Value 20 S 15 50 Processes Added Only When calculating Process Time per unit, remember the following Lead time (sec) 75 120 60 120 60 147 240 Take the total process time P/T per unit (sec)" 0.6 7.5 3 5.9 2.4 - Convert that to a per unit measurement (divide by batch size) Percent complete and accurate 99.5% 99.0% 99.5% 96.0%% 99.5% - Divide the per unit measurement by the # of workers Yes No Yes No Yes 2 - Note (Value Added Activity) Data from sample of 5 workers Computations on Worker 3 - Notes on Average and Standard Deviation of Sewing times After you calculate the processes (but sewing covers Performance The random sampling data set of 5-workers, provides an opportunity to: before you calculate the Totals): Average Standard Calculate an average per worker (AVERAGE excel function) Sewing Deviation - Calculate a standard deviation per worker (STDEV excel function) Use the Yes / No dropdowns to state if you Worker # Sewing time (sec) Worker # Sewing - Afterwards, you can use this random data set to approximate the total process time believe the activity described in the process (sec) time (sec) time for Process 4 (average of ALL workers' sewing time in the data set) is a value added activity. That is, does that activity add value to the consumer? 140 141.9 9.3 - Calculate the two total columns. One is a 130 142.1 9.8 total of all processes, and the latter is a total 144 In d WN 143.4 9.3 of only what you have deemed to be value 130 58.6 9.7 146.3 145.8 14.7 added activities 153 152 144 150 143 156 133 125 142 148 148 143 143 145 142 149 142 MUMUUMUUAAAAAAAAAAWWWWWWWNNNNNNNNN 168 169 168 128 167To calculate the values in the yellow boxes, you'll need to follow the instructions provided In the table. Here's a breakdown of the calculations: Process Time per Unit (P/T per unit): 1. Calculate total process time: Add up the process times for each process. 2. Divide by batch size: Divide the total process time by the batch size. 3. Divide by number of workers: Divide the result from step 2 by the number of workers. 4. Multiply by percentage complete and accurate: Multiply the result from step 3 by the percentage complete and accurate. For Process 1. e Total process time = 60 + 120 + 60 + 147 + 240 = 627 seconds e P/T per unit = 627 seconds /100 units /5 workers / 95.5% = 1.31 seconds/unit Totals: o Total of all processes: Add up the P/T per unit for all processes. e Total of only value-added activities: Add up the P/T per unit for processes that are considered value-added. Average and Standard Deviation of Sewing Times: e Average sewing time: Use the AVERAGE function in Excel to calculate the average sewing time for each worker. o Standard deviation of sewing time: Use the STDEV function in Excel to calculate the standard deviation of sewing time for each worker. Note on P/T per unit: e When calculating P/T per unit, ensure you are using the correct units (e.g., seconds/unit). e If the process time is measured in minutes, convert it to seconds before dividing by the batch size. Once you have calculated these values, you can fill in the yellow boxes accordingly