Consider the data below from the Walsh Widget Company of Cape Cod, Mass. on widget production from 2012-2018, for their third shift of workers. Since Walsh is a publicly traded company, the data was derived from the corporate web site of their accounting firm, Rafferty, Risi, and Bettke, LLC. (FYI the site does not really exist) on July 14, 2019, from Pages 27-31, Table 7B of their report: Walsh Widgets and the Third Shift of Workers.

1. In a clearly and accurately labeled line graph, which will be known as Graph 8, created using Excel, plot the total product (TP), marginal product (MP) and average product (AP) curves based on that data. (45 pts).

2.Referencing only your TP and MP curves, identify where the law of diminishing returns has set in and state how we would recognize it on each of the curves you have constructed. (6 pts)

3.Referencing only your TP and MP curves, identify where negative returns have set and how we would recognize that on each of the curves you have constructed. (6 pts)

4.Referencing all your constructed curves, identify where labor productivity has been maximized, on each curve and which curve most clearly illustrate(s) this. (3 pts)

\begin{tabular}{|l|l|} \hline Number of Workers Per 3rd Shift (dozens of workers) & Units of Output (in 100s) \\ \hline 0 & 0 \\ \hline 1 & 15 \\ \hline 2 & 35 \\ \hline 3 & 68 \\ \hline 4 & 99 \\ \hline 5 & 120 \\ \hline 6 & 131 \\ \hline 7 & 133 \\ \hline 8 & 133 \\ \hline 9 & 121 \\ \hline \end{tabular}