Sweet Pote products began chocolate brownies in thoe processes -mixine baking and packeing Due to the incroaing populaity of the brownies, the company has multiple deoatments runining the tame processes each. under different producton wupevison. There are thron mixing, fout baking and one packacing process departments. For the fast several monthe, the production cost reorts have indieated fome ovemuns in the cotts peneratind by the mixing depatments. The production cost reports whect combined activity of all three mising departments and upper management is unable to detomine if the costs ovemans are due to one dopatment in particular or all the mixing deoxtments. Data containing. unit materiais and copvesion couts incured by each of the throe mizing: dopatments for the month of March are provided here. Hett hel 7 There are two parts to this problem. Use Excel to perfom the following: a. Create a 2-D line chart for the material variance data. Include a desciptive chart title, axes labels, and a legend in the chart. b. Do you believe Lamy is on tahet to recelve a favorable performance: evaluation? Explain. Evaluate any trends you see. Sweet Pote products began chocolate brownies in thoe processes -mixine baking and packeing Due to the incroaing populaity of the brownies, the company has multiple deoatments runining the tame processes each. under different producton wupevison. There are thron mixing, fout baking and one packacing process departments. For the fast several monthe, the production cost reorts have indieated fome ovemuns in the cotts peneratind by the mixing depatments. The production cost reports whect combined activity of all three mising departments and upper management is unable to detomine if the costs ovemans are due to one dopatment in particular or all the mixing deoxtments. Data containing. unit materiais and copvesion couts incured by each of the throe mizing: dopatments for the month of March are provided here. Hett hel 7 There are two parts to this problem. Use Excel to perfom the following: a. Create a 2-D line chart for the material variance data. Include a desciptive chart title, axes labels, and a legend in the chart. b. Do you believe Lamy is on tahet to recelve a favorable performance: evaluation? Explain. Evaluate any trends you see