engineers is conducting a study of workers at a manufactur- ving workers at random times am is able to use sta- estimate the percent of time the different activities, 12. A team of industrial engineers is cond productivity study of workers ing plant. By observing workers throughout the day, the team is able to tistical tools to estimate the percent workers spend performing different activ The categories "Direct Work,"Indirect we "Travel," "Breaks," and "Other" compriset workers' activities. A table displays the team results in terms of the percent of time workers were observed doing each activity for one week (Refer to worksheet "5.12") a. Create a separate pie chart for each day of the week that depicts the percent of time workers spent doing each activity. b. Also, create a pie chart of the overall percent of time spent doing each activity for the entire week. c. On each chart, display data labels of the per- centages represented by each section of the pie. d. On which day was "Travel" the highest? e. On Thursday, in which category was the most time spent? f. When did "Direct Work time exceed "Indi- rect Work" time? Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 12 A AW = = = = Paste BI U Av G18 X fx A B C D E Other 2 Monday 3 Tuesday 4 Wednesday 5 Thursday Friday Direct Work Indirect World 0.35 0.25 0.42 0.23 0.40 0.17 0.32 0.15 0.27 0.13 Travel 0.10 0.15 0.20 0.14 0.21 Breaks 0.20 0.15 0.21 0.27 0.31 0.10 0.05 0.02 0.12 0.08