The design for the new electric car has been approved by the board and production is underway, but the VP of Manufacturing is nervous about the rate of defective parts from suppliers. See Original List screenshot below. He has decided to use the Subtotal feature to generate a report that shows subtotals of defects by Subassembly Name, with a grand total at the end, such as the Desired Report below. His report, however, looks like the Report Generated, below. Which description would create this?

• Sort Original List by Subassembly Name, then Subtotal

• Use Conditional Format to prepare template, then Subtotal

• Subtotal, then Sort by Month and Subassembly Type

• Use @Risksort add-in to create report

C D H Original Live Defects Defects Month May Feb March Jan June March Jan 14 36 90 90 June 3 Subassembly Name 4 Master Cylinder 5 Master Cylinder 6 Wheel Hub 7 Master Cylinder 8 LED Assembly 9 LED Assembly 10 Airbag 11 Airbag 12 Cockpit Monitor 13 Airbag 14 Master Cyinder 15 Airbag 16 Airbag 17 Airbag 18 Cockpit Monitor 19 Locking System 20 Master Cylinder 21 Locking System 22 Locking System 23 LED Assembly 24 Locking System 25 Cockpit Monitor 26 Locking System 27 Airbag 28 Wheel Hub 29 30 31 April May June March June March Feb Feb June March Feb Feb June April lan March Jan :21SEXEH8252225 G Desired Report Subassembly Name Month Defects Airbag Jan 55 Nune 38 Airbag June 47 Alb March 34 AD March 61 Airbag March SB Airbag May 33 Airbag Total Cockpit Monitor April Cockpit Monitor April 76 Cockpl Monitor Feb 45 Cockpit Monitor Total 150 LED Assembly Feb 125 LED Assembly June LED Assembly March LED Assembly Total 235 Locking System Feb 23 Locking System Feb 40 Locking System lan 32 Locking System June 63 Locking System March 81 Locking System Total 239 Master Cylinder Feb 14 Master Cylinder Jan 45 Master Cylinder June 71 Master Cylinder June 5 Master Cylinder My 22 Master Cylinder Total 157 Wheel Hub an Wheel Hub March 90 Wheel Hub Total Grand Total 1240 23 82 110 55 38 93 29 29 1 Report Generated Subassembly Name Month Master Cyinder May Master Cylinder Feb Master Cylinder Total Wheel Hub March Wheel Hub Total Master Cylinder Jan Master Cylinder Total LED Assembly June LED Asembly March LED Assembly Total Airbu Airbag June Airbag Total Cockpit Monitor April Cockpit Monitor Total Airbag May Airbag Total Master Cylinder June Master Cylinder Total Airbag March Airbag June Airbag March Airbag Total Cockpit Monitor Feb Cockpit Monitor Tot Locking System Feb Locking System Total Master Cylinder June Master Cylinder Total Locking System March Locking System Feb Locking System Total LED Assembly Feb LED Assembly Total Locking System June Locking System Total Cockpit Monitor April Cockpit Monitor Total Locking System Jan Lacking System Total Airbag March Airbag Total Wheel Hub Jan Wheel Hub Total Grand Total 33 71 71 34 47 61 142 45 45 23 23 5 S 81 40 121 125 33 36 35 36 38 39 10 41 42 63 63 76 76 32 32 58 58 45 47 43 1240