Jerry Jackson is getting ready for the holiday season. Jerry is the purchasing manager for a large online toy store, Elves R Us. Due to supply chain issues and price increases, Jerry is concerned about placing too many toy orders with any one supplier. He is also concerned about supplies of the toy, "Avastar" which recently became very popular with 8 to 12 year old children and is expected to be the most requested toy for this holiday season. The suppliers used by Elves R Us are: Lyra, Goodwin's, Jackson, Simple Goods and Woodson. No other vendors are approved by Elves R Us. Jerry has run a report detailing all purchase orders placed in 2022, specifically for the holiday season. This data is included in the "Toy Data" tab. You need to analyze this data and see if Jerry's concerns are warranted.

1. Run a pivot table for Jerry detailing total purchases made by supplier by product.