HELP PLEASE.. I just want to make sure I'm correct for B, C, D
Graphing Assign ment# 5 check blackboard forthedue date - THIS IS COPYRIGHTED MATERIAL THIS IS COPYRIGHTED MATERIAL 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 oftheir accounting firm, Rafferty, Risi, and Bettke, LLC. [FYI the site does not really exist} on July 14, 2019, from Pages 27-31, Table 70 of their report: \"Walsh Widgets and the Third Shift of Workers.\" THIS IS COPYRIGHTED MATERIAL THIS IS COPYRIGHTED MATERIAL a. 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]. This is COPYRIGHTED MATERIAL Referencing only your TP and M P 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. [5 pts] 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}. This is COPYRIGHTED MATERIAL Referencing all your constructed curves, identify where labor productivity has been maximized, on each curve and which curve most clearly illustratels] this. [3 pts}. THIS IS COPYRIGHTED MATERIAL Number of Workers Per 3rd Units of Output {in 1005} Shift [dozens of workers} 1 15 2 35 3 63 4 99 5 120 5 131 7 133 3 133 9 121 THIS IS COPYRIGHTED MATERIAL Graphs for this assignment must be properly constructed and created using Excei. Prepare your assignment as a Word document with embedded Excei charts. Number each step of the assignment. The assignment may he submitted to Tarnitin as a Word or .pdf document. Be sure to inciade your name at the top of the assignment before submitting. This graphing assignment is worth 60 points. THIS IS COPYRIGHTED MATERIAL JP AutoSave off Book1 - Excel Search (Alt+0) Jasmine Perdomo File Home Insert Page Layout Formulas Data Review View Help Chart Design Format abc pelling Thesaurus Workbook Check Smart Translate New Delete Previous Next Show Notes Protect Protect Allow Edit Unshare Hide Statistics Accessibility ~ Lookup Comment Comment Comment Comments Sheet Workbook Ranges Workbook Ink Proofing Accessibility Insights Language Comments Notes Protect Ink Chart 1 X V A B D E F G H K L M N O P Number d Unit of Ou Marginal P Average Product Format Ch 0 0 Chart Options 1 15 15 15 2 35 17.5 20 3 68 22.6 33 Widget Production (2012-2018) 4 99 24.7 31 150 Fill 5 120 24 21 130 131 21.8 11 Y No fill 133 19 2 Solid fill Workers Per 3rd Shift (In Dozens) 133 19 IN 121 13.4 -12 O Gradient fill 8 6 68 8 8 8 5 Picture or te Pattern fill O Automatic 8 10 Unit of Output (in 100s) Color Unit of Output (in 100s) Marginal Product Average Product Border No line
