Question

1 Approved Answer

Posted on Jul 09, 2024

10. The design for the new electric car has been approved by the board and production is underway, but the VP of Manufacturing is nervous

10. 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? Desport Org Subare Mate Matinde M Month Defecte F M Wom AN AJO AJO AM AN AG ****** Mayen UDA Mar M M 5 es Art 11 A 1 Cocktai 11 14 de 15 A Who More Made M M Madrid Whe M Wheel M Master der LEDA LIDA M LIDAY A Art Abu CoM AH COM M 82 130 35 May 232323282522343-3365223: Corte 11 Long 20 Mand TE :::::8 ::::::: Feb Corp. Men A C v Mau fa Coco Mart UDA LID UID LDA Login fe LOW Latin Lactang La M Logo Matem M MA MC MC M M Cadre 1 LDA gy Copt go Master 63 18 3 CM Coco Mart La Lane 45 es 20 Master M 40 ten unanswered question: 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? Desde Detect 22 14 Women NO AB Month Defecte 55 Oy When Mon Master in Mwinder Who M Mind #LIDA LED M 30 45 21 8 55 30 29 47 11 61 SH 33 326 20 Sub Mon Minder May Matinde Master der Total M Wheel Mat Master inderd LIDA June D A LIDAH ************ A M 32 Cacat Mon 1 Mind 25 A 71 une More 45 150 125 21 98 19 25 31 235 MW 61 45 23 5 1 40 125 63 M AD M M M NOT Coco Mon Art Coche Mentor Coco Monte F Casper Monitorul LEDA Feb LED LED Ambly March LED AS Lock Locom Feb Lacing System am Locham M Lacientem Marine Mind Main Marcin une Marcin Me Master der to To COM Corp At Note Malwinder Master Cylinder Ab A Art 1 Cact Me 19 Logo 20 Max Cinder 21 22 Long 21 LIDAS 34 Long 25 CM Lading 27 Arte 20 Wh M 45 12 Mans 71 71 14 47 61 Mech A Feb March 2 56 43 81 211 14 45 73 5 22 15 40 90 45 20 20 31 13 Copa Mo Copa Morte Liga Lorem Marcin Master Cylinder Long Long tem to LEDAL M March f Wheel Hud Grand To 1240 125 Orion Desired Report at Grad NEN Defects 22 14 36 90 90 45 45 23 #2 NON 5 My Month MW Feb March lan June March lan June Art My lung March June Much Feb Feb Subassembly Name Master Cylinder 5 Master Cylinder Wheb 7 Master Cylinder LED Assembly LED A 10 Airbag 11 Alba 12 Cockpit Monitor 13 Ab 16 Master Cylinder 15 ta 16 Arta 17 A 15 Cockpit Mon 19 Locking System 20 Master Cylinder 21 Lacking System 22 Lacking System 23 LD Assembly 24 Locking System 25 Cockpit Monitor 36 Locking System 27 Art 28 Wheb 25 30 11 110 Defects 22 14 90 45 23 87 55 38 25 33 71 34 47 61 45 23 5 81 40 125 61 76 32 SB 43 Subsembly None Month Defects AION 55 NON lune 30 Nune 47 March 34 NON March 60 March 58 AN 3) Ab Tord 126 Cockpit Monitor Apr Cockpk Monitor Apr 26 Cockpk Monitor Feb 45 Cockpit Monitor Tot 150 LED Assembly 125 LED bly Pune 23 LID Assembly March 87 LED Asembly Total 235 Locking Stem Feb 22 Locking System Feb 40 Locking System 32 Locking System Aine 63 Locking March 81 Locking System Total Master Cylinder 14 Master Cylinder 45 Master Cylinder une 71 Master Cylinder Pune 5 Master 22 Master Cylinder Total 157 Wheel Hub 43 Wheel Hub March 95 Wheel Hub Tot Grand Total 1260 Art Subassembly Name Month Master Cylinder May Master Cylinder Feb Master Cylinder Total Whab Manch Wheel Hub Total Master Cylinder Master Cyinder Total LED Assembly June LED Amb March LED Asembly Tot Ab lan Art June Airbag Total Cockpit Monitor Art Cockpit Monitor Total May tag Total Master Cylinder June Master Cyinder Total Ab Much Airbag June Airba March Arb Total Cockpit Monitor Cockpit Monitor Tote Locking System Lacking System Tot Malter Cylinder Master Cyinder Total Locking System March Lacking System Lacking System To LED Amb Feb LID Assembly Lacking System Pune Lacking System Total Cockpit Monitor All Cac Monate Lacking System Lacking System Tot AB March 55 38 93 29 29 33 33 71 71 34 More F Agri lun March 61 163 45 45 May 23 5 3 35 40 12: 125 135 33 1 76 16 12 S 31 Apel Lacking Sytem Tot Corisi Maata Cockpit Monroe Lacting System Lacking System To Art Ab Total What Wheel Hub Tot Grand Total 76 76 32 12 so so March 45 4 120 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 10. 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? Desport Org Subare Mate Matinde M Month Defecte F M Wom AN AJO AJO AM AN AG ****** Mayen UDA Mar M M 5 es Art 11 A 1 Cocktai 11 14 de 15 A Who More Made M M Madrid Whe M Wheel M Master der LEDA LIDA M LIDAY A Art Abu CoM AH COM M 82 130 35 May 232323282522343-3365223: Corte 11 Long 20 Mand TE :::::8 ::::::: Feb Corp. Men A C v Mau fa Coco Mart UDA LID UID LDA Login fe LOW Latin Lactang La M Logo Matem M MA MC MC M M Cadre 1 LDA gy Copt go Master 63 18 3 CM Coco Mart La Lane 45 es 20 Master M 40 ten unanswered question: 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? Desde Detect 22 14 Women NO AB Month Defecte 55 Oy When Mon Master in Mwinder Who M Mind #LIDA LED M 30 45 21 8 55 30 29 47 11 61 SH 33 326 20 Sub Mon Minder May Matinde Master der Total M Wheel Mat Master inderd LIDA June D A LIDAH ************ A M 32 Cacat Mon 1 Mind 25 A 71 une More 45 150 125 21 98 19 25 31 235 MW 61 45 23 5 1 40 125 63 M AD M M M NOT Coco Mon Art Coche Mentor Coco Monte F Casper Monitorul LEDA Feb LED LED Ambly March LED AS Lock Locom Feb Lacing System am Locham M Lacientem Marine Mind Main Marcin une Marcin Me Master der to To COM Corp At Note Malwinder Master Cylinder Ab A Art 1 Cact Me 19 Logo 20 Max Cinder 21 22 Long 21 LIDAS 34 Long 25 CM Lading 27 Arte 20 Wh M 45 12 Mans 71 71 14 47 61 Mech A Feb March 2 56 43 81 211 14 45 73 5 22 15 40 90 45 20 20 31 13 Copa Mo Copa Morte Liga Lorem Marcin Master Cylinder Long Long tem to LEDAL M March f Wheel Hud Grand To 1240 125 Orion Desired Report at Grad NEN Defects 22 14 36 90 90 45 45 23 #2 NON 5 My Month MW Feb March lan June March lan June Art My lung March June Much Feb Feb Subassembly Name Master Cylinder 5 Master Cylinder Wheb 7 Master Cylinder LED Assembly LED A 10 Airbag 11 Alba 12 Cockpit Monitor 13 Ab 16 Master Cylinder 15 ta 16 Arta 17 A 15 Cockpit Mon 19 Locking System 20 Master Cylinder 21 Lacking System 22 Lacking System 23 LD Assembly 24 Locking System 25 Cockpit Monitor 36 Locking System 27 Art 28 Wheb 25 30 11 110 Defects 22 14 90 45 23 87 55 38 25 33 71 34 47 61 45 23 5 81 40 125 61 76 32 SB 43 Subsembly None Month Defects AION 55 NON lune 30 Nune 47 March 34 NON March 60 March 58 AN 3) Ab Tord 126 Cockpit Monitor Apr Cockpk Monitor Apr 26 Cockpk Monitor Feb 45 Cockpit Monitor Tot 150 LED Assembly 125 LED bly Pune 23 LID Assembly March 87 LED Asembly Total 235 Locking Stem Feb 22 Locking System Feb 40 Locking System 32 Locking System Aine 63 Locking March 81 Locking System Total Master Cylinder 14 Master Cylinder 45 Master Cylinder une 71 Master Cylinder Pune 5 Master 22 Master Cylinder Total 157 Wheel Hub 43 Wheel Hub March 95 Wheel Hub Tot Grand Total 1260 Art Subassembly Name Month Master Cylinder May Master Cylinder Feb Master Cylinder Total Whab Manch Wheel Hub Total Master Cylinder Master Cyinder Total LED Assembly June LED Amb March LED Asembly Tot Ab lan Art June Airbag Total Cockpit Monitor Art Cockpit Monitor Total May tag Total Master Cylinder June Master Cyinder Total Ab Much Airbag June Airba March Arb Total Cockpit Monitor Cockpit Monitor Tote Locking System Lacking System Tot Malter Cylinder Master Cyinder Total Locking System March Lacking System Lacking System To LED Amb Feb LID Assembly Lacking System Pune Lacking System Total Cockpit Monitor All Cac Monate Lacking System Lacking System Tot AB March 55 38 93 29 29 33 33 71 71 34 More F Agri lun March 61 163 45 45 May 23 5 3 35 40 12: 125 135 33 1 76 16 12 S 31 Apel Lacking Sytem Tot Corisi Maata Cockpit Monroe Lacting System Lacking System To Art Ab Total What Wheel Hub Tot Grand Total 76 76 32 12 so so March 45 4 120 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