Please analyze the attached Apex AutoGroup datasets to construct a high-end, consulting-style 'Global Manufacturing Strategic Matrix'. 1. Data Processing Logic: Join the tables properly. Group by 'Zone' (Row Index). Calculate Metrics: Capacity Utilization: Total Units / (Factory Capacity * 12). Revenue Contribution ($B): Sum of (Units * Price), formatted in Billions. Quality Index (%): (1 - (Defects / Units)). EV Transition Score: % of units that are EV. 2. Visual & Formatting Requirements (CRITICAL UPDATE): Theme: Use a 'Professional Blue' palette, but prioritize readability. Header: Dark Blue background (#1F4E78) with White Bold Text. Data Cells (Heatmap Fix): For 'Quality Index', apply a Soft Heatmap ranging from White to Light-Medium Blue (e.g., #DDEBF7 to #9BC2E6). Do NOT use dark blue backgrounds for data cells, as it obscures the black text. Alternatively, if a cell background is dark, force the font color to White. Data Bars: For 'Revenue Contribution', use a distinct, lighter blue data bar that allows the number to be seen clearly. Footer: The 'Global Total' row should have a Medium Blue background with White Text to distinguish it from the data. Borders: Use thin, light grey borders for the grid, and a thick bottom border for the header. Goal: The table must be legible and elegant. No text should be unreadable due to dark background colors.