For the pivot created in exercise 3, given the weekly factory capacity of each vendor, determine which vendors have exceeded their weekly capacity.

please explain the steps to use in excel

H B E D Exercise 4 For the pivot created in Exercise 3 given the weekly factory capacity of each vendor, determine which vendor(s) have exceeded their weekly capacity. 2 3 4 Vendor Vendor 1 Vendor 112 Vendor #3 Vendor Vendor 5 Weekly Factory Capacity 3 260 10 7 30 7 9 10 11 B C D E F Exercise 3 Using a pivot table, summarize the Containers shipping from each vendor by ship week. Provide a chart showing their weekly volume. Containers 1 2 1 2 1 1 2 1 Vendor Name Vendor #1 Vendor #1 Vendor #1 Vendor #1 Vendor #1 Vendor #1 Vendor #1 Vendor #1 Vendor #1 Vendor #1 Vendor #1 Vendor #1 Vendor 1 Vendor #1 Vendor 1 Vendor #2 Vendor #2 Vendor #2 Vendor 12 Mandarin Origin Port Destination DC Shanghai 5149 Shanghai 5149 Shanghai 5150 Shanghai 5150 Shanghai 5151 Shanghai 5151 Shanghai 5362 Shanghai 5363 Shanghai 5565 Shanghai 5645 Shanghai 5650 Shanghai 5852 Shanghai 5920 Shanghai 5920 Shanghal 5965 Shenzhen 5149 Shenzhen 5149 Shenzhen 5150 Shenzhen 5150 chanthan Ship Week 202023 202028 202023 202026 202024 202028 202027 202025 202028 202024 202025 202028 202024 202028 202028 202023 202027 202023 202027 snonno DC Arrival Week 202030 202034 202030 202033 202030 202034 202034 202030 202034 202028 202030 202033 202030 202034 202034 202030 202033 202030 202034 1 1 1 2 1 1 2 1 41 2 66