Compute the labor, material, and multifactor productivity measures for each of the day shown in the Excel worksheet (Question 1) for production of steel rods. The selling price for the rods is currently $5.56/ft. Assume 8-hour days and an hourly wage of $20. Overhead is 0.7 times daily labor cost. Material cost is $9 per pound. There is also a capital investment cost of $225 per day. Create a separate monthly line chart for each of the labor productivity, material productivity, and multifactor productivity values and discuss what do the resulting productivity figures suggest. You may want to include some information as graphs such as the overall trend, the worst performing month, the best performing month, etc. Put your comments in a text box. Think it as a report that you prepare for your manager. Compute the labor, material, and multifactor productivity measures for each of the day shown in the Excel worksheet (Question 1) for production of steel rods. The selling price for the rods is currently $5.56/ft. Assume 8-hour days and an hourly wage of $20. Overhead is 0.7 times daily labor cost. Material cost is $9 per pound. There is also a capital investment cost of $225 per day. Create a separate monthly line chart for each of the labor productivity, material productivity, and multifactor productivity values and discuss what do the resulting productivity figures suggest. You may want to include some information as graphs such as the overall trend, the worst performing month, the best performing month, etc. Put your comments in a text box. Think it as a report that you prepare for your manager