DA10 Data analytics can be used to analyze variances. Toddle Enterprises produces solid wood furniture and distributes it directly to major retali stores. Larry Berry was hired as the peoduction rupervisor for the children's wooden rocking chair production department to improve a poorfy run operation. The chairs are constructed of 15 linear feet of 5/8 by 4 -inch pine lumber, 36 one-half inch wood screws, and two 20 -inch rubber rocker rails. The materials are ordered by the purchasing department thiroush approved suppliers. The supervisor that preceded Larry appeared to have little contral of the cost and usage of materials, and continually had cost overruns. Lamy has completed his six months of operations and wants to be sure he is on target for a 10% bonus that may accompany his performance evaluation if variances are under control. The budgeted costs for the six-months period for each of the three materials are presented here. Weekly materials price and quantity wariances for the three materials for the six months during which Larry has been employed by foddle Enterprises are provided here. Positive amounts indicate favorable variances and negative amounts indicate unfavorable variances. Instructions There are two parts to this problem. Use Excel to perform the following: a. Create a 2-D line chart for the material variance data. Include a descriptive chart title, anes labels, and a legend in the chart. b. Do you believe Larry is on target to receive a favorable performance evaluation? Explain. Evaluate any trends you see. Student Work Area a. Material variances chart b. Response to part b DA10 Data analytics can be used to analyze variances. Toddle Enterprises produces solid wood furniture and distributes it directly to major retali stores. Larry Berry was hired as the peoduction rupervisor for the children's wooden rocking chair production department to improve a poorfy run operation. The chairs are constructed of 15 linear feet of 5/8 by 4 -inch pine lumber, 36 one-half inch wood screws, and two 20 -inch rubber rocker rails. The materials are ordered by the purchasing department thiroush approved suppliers. The supervisor that preceded Larry appeared to have little contral of the cost and usage of materials, and continually had cost overruns. Lamy has completed his six months of operations and wants to be sure he is on target for a 10% bonus that may accompany his performance evaluation if variances are under control. The budgeted costs for the six-months period for each of the three materials are presented here. Weekly materials price and quantity wariances for the three materials for the six months during which Larry has been employed by foddle Enterprises are provided here. Positive amounts indicate favorable variances and negative amounts indicate unfavorable variances. Instructions There are two parts to this problem. Use Excel to perform the following: a. Create a 2-D line chart for the material variance data. Include a descriptive chart title, anes labels, and a legend in the chart. b. Do you believe Larry is on target to receive a favorable performance evaluation? Explain. Evaluate any trends you see. Student Work Area a. Material variances chart b. Response to part b