Use the following tables from Brices PT Cruisers expenditure system to address the situations below:

P6 (a) Assume Brices PT Cruisers Inc. is concerned that its new temporary Purchase Department Manager, Sly Hawkeye, is allowing payments to be made to unauthorized vendors. Develop an Excel formula to identify any payments made to unauthorized vendors. (6 points):

P6 (b) Assume Brices PT Cruisers Inc. wants to separate the employee first name into a separate column in the Current Employee table. Develop an Excel Formula to place first name in Column E. (6 points)

C D Emplo Term date A B 1 Current employees 2 EmpNo Name 31 Brice Burns 4 2 Grace Garcia 5 3 Lou Larson 6 4 Cyndie Cortez 7 5 Jordan Jones 8 16 Heath Hook bburns ggarcia llarson ccortez ijones hhook 7/6/2020 3/30/2020 B E F 1 Payment Transactions 2 Disbursementum 3 3356700 4 3356701 5 3356702 6 3356703 7 3356704 8 3356705 9 3356706 10 3356707 11 3356708 12 3356709 13 3356710 14 3356711 15 3356712 16 3356713 17 3356714 18 3356715 19 3356715 20 3356716 21 3356717 22 3356718 23 3356719 24 3356720 25 3356721 Vendorno 3246 3247 3246 3246 3248 3247 3245 3248 3245 3246 3245 3245 3247 3245 3248 3247 3247 3248 3248 3246 3245 3248 3246 InvoiceDate 1/4/2020 S 1/8/2020 $ 1/11/2020 S 1/15/2020 $ 1/18/2020 $ 1/19/2020 S 1/22/2020 $ 1/24/2020 S 1/26/2020 $ 1/27/2020 $ 1/28/2020 S 2/1/2020 S 2/2/2020 $ 2/5/2020 $ 2/9/2020 S 2/11/2020 $ /11/2020 $ Styles Pane /13/2020 $ 2/17/2020 S 2/20/2020 $ 2/24/2020 $ 2/26/2020 S 2/28/2020 S PaymentAmount Employeeld 350,000.00 bburns 350,000.00 sgarcia 150,000.00 sgarcia 200,000.00 ccortez 350,000.00 llarson 150,000.00 hhook 350,000.00 sgarcia 300,000.00 bburns 200,000.00 jones 200,000.00 hhook 200,000.00 bburns 300,000.00 bburns 150,000.00 lijones 350,000.00 sgarcia 200,000.00 bburns 100,000.00 bburns 100,000.00 bburns 150,000.00 sgarcia 100,000.00 ccortez 150,000.00 bburns 100,000.00 Marson 250,000.00 hhook 350,000.00 hook PaymentDate 1/7/2020 1/9/2020 1/13/2020 1/16/2020 1/19/2020 1/22/2020 1/24/2020 1/26/2020 1/28/2020 1/28/2020 1/29/2020 2/3/2020 2/3/2020 2/6/2020 2/10/2020 2/12/2020 2/12/2020 2/16/2020 2/20/2020 2/22/2020 2/25/2020 2/28/2020 3/1/2020 C A B 1 Current vendors 2 Vendor No Name Styles Pane 3 3245 Reliable Paint Suppliers Inc. 4 3246 Mighty Auto Parts Co. 5 3247 Dependable Paint Suppliers 6 3248 Slow Hawk Supply Inc. Date approved 1/2/2016 1/15/2019 7/5/2019 8/30/2020