Graphing assignment

Graphing Assignment # 5 Consider the data below from the Metronome Widget Company of Lake of the Woods, MN, on widget production from 2006-2016, for their second shift of workers. Since Metronome is a publicly traded company, the data was derived from the corporate web site of their accounting firm, Vrelland, Markoe and Robbins, LLC. (FYI - the site does not really exist) on June 6, 2018, from Page 29, Table 14C of their report: "Metronome Second Shift Data by Decades." a. In a clearly and accurately labeled line graph, which will be known as Graph 11, created using Excel, plot the total product (TP), marginal product (MP) and average product (AP) curves based on that data. (45 pts) b. 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) c. 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) d. Referencing all your constructed curves, identify where labor productivity has been maximized, and which curve most clearly illustrate(s) this. (3 pts) Number of Workers Per Shift Units of Output (in 100s) 18 2 39 3 64 4 86 101 111 7 116 8 116 9 106 Graphs for this assignment must be properly constructed and created using Excel. Prepare your assignment as a Word document with embedded Excel charts. Number each step of the assignment. The assignment may be submitted to Turnitin as a Word or . pdf document. Be sure to include your name at