Question: What is the TY cost and amount received for each line item highlighted in yellow (i.e cost for september for item 99114 - avocado for

What is the TY cost and amount received for each line item highlighted in yellow (i.e cost for september for item 99114 - avocado for vendor A -2863 from data set below?

Month Item Code Item Description Vendor Number Vendor Name TY Cost Received Amount
September 99114 Avocado 2863 Vendor A
September 99114 Avocado 4670 Vendor B
September 99114 Avocado 3102 Vendor C
October 99114 Avocado 2863 Vendor A
October 99114 Avocado 4670 Vendor B
October 99114 Avocado 3102 Vendor C
Vendor Number Item # CREA_DATE ITEM_DESC ITEM_SIZE_DESC ITEM_PACK_QTY Vendor Name Cost Received Units
2863 99114 9/5/2018 Avocado EA 40 Vendor A $ 18.00 931
2863 99114 9/6/2018 Avocado EA 40 Vendor A $ 35.00 818
2863 99114 9/7/2018 Avocado EA 40 Vendor A $ 32.00 1,051
4670 99114 9/9/2018 Avocado EA 40 Vendor B $ 23.00 731
3102 99114 9/10/2018 Avocado EA 40 Vendor C $ 15.00 1,775
4670 99114 9/14/2018 Avocado EA 40 Vendor B $ 26.00 1,042
3102 99114 9/15/2018 Avocado EA 40 Vendor C $ 19.00 1,166
3102 99114 9/18/2018 Avocado EA 40 Vendor C $ 40.00 1,461
2863 99114 9/19/2018 Avocado EA 40 Vendor A $ 31.00 627
2863 99114 9/20/2018 Avocado EA 40 Vendor A $ 19.00 737
4670 99114 9/20/2018 Avocado EA 40 Vendor B $ 30.00 853
4670 99114 9/20/2018 Avocado EA 40 Vendor B $ 31.00 1,879
3102 99114 9/21/2018 Avocado EA 40 Vendor C $ 34.00 970
3102 99114 9/22/2018 Avocado EA 40 Vendor C $ 26.00 1,791
2863 99114 9/22/2018 Avocado EA 40 Vendor A $ 27.00 1,438
4670 99114 9/23/2018 Avocado EA 40 Vendor B $ 30.00 936
2863 99114 9/24/2018 Avocado EA 40 Vendor A $ 30.00 1,386
4670 99114 9/24/2018 Avocado EA 40 Vendor B $ 30.00 726
4670 99114 9/24/2018 Avocado EA 40 Vendor B $ 30.00 520
2863 99114 10/5/2018 Avocado EA 40 Vendor A $ 31.00 1,265
2863 99114 10/6/2018 Avocado EA 40 Vendor A $ 39.00 1,790
2863 99114 10/7/2018 Avocado EA 40 Vendor A $ 39.00 1,416
4670 99114 10/9/2018 Avocado EA 40 Vendor B $ 32.00 1,204
3102 99114 10/10/2018 Avocado EA 40 Vendor C $ 32.00 740
4670 99114 10/14/2018 Avocado EA 40 Vendor B $ 20.00 1,820
3102 99114 10/15/2018 Avocado EA 40 Vendor C $ 31.00 640
3102 99114 10/18/2018 Avocado EA 40 Vendor C $ 28.00 1,596
2863 99114 10/19/2018 Avocado EA 40 Vendor A $ 32.00 1,559
2863 99114 10/20/2018 Avocado EA 40 Vendor A $ 39.00 1,572
4670 99114 10/20/2018 Avocado EA 40 Vendor B $ 20.00 686
4670 99114 10/20/2018 Avocado EA 40 Vendor B $ 16.00 1,812
3102 99114 10/21/2018 Avocado EA 40 Vendor C $ 21.00 1,256
3102 99114 10/22/2018 Avocado EA 40 Vendor C $ 39.00 532
2863 99114 10/22/2018 Avocado EA 40 Vendor A $ 35.00 1,633
4670 99114 10/23/2018 Avocado EA 40 Vendor B $ 35.00 1,170
2863 99114 10/24/2018 Avocado EA 40 Vendor A $ 17.00 1,359
4670 99114 10/24/2018 Avocado EA 40 Vendor B $ 29.00 975
4670 99114 10/24/2018 Avocado EA 40 Vendor B $ 26.00 1,133

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

What is the TY cost and amount received for each line item highlighted in yellow (i.e cost for september for item 99114 - avocado for vendor A -2863 from data set below using excel functions? Month...

Q:

There are three tabs included on the workbook: 1. Purchase Orders 2. LY Cost 3. Savings Purchase orders outlines the price we bought the item from and who we bought it from. There are two months of...

Q:

1. Purchase Orders 2. LY Cost 3. Savings Purchase orders outlines the price we bought the item from and who we bought it from. There are two months of data included across two different items.LY Cost...

Q:

Please help with this assignment. Ive attached the 2016 Apple 10k report and questions. thanks Category: Revenue and Net Income1. What was the corporation's net sales, cost of goods sold, and gross...

Q:

Need help with Accounting Discussion. The questions are attached along with the 10K Report to look for the answer in *Use the Coca Cola 10K Report to answer your questions along with any other...

Q:

Need help with Accounting Discussion. The questions are attached along with the 10K Report to look for the answer in *Use the Coca Cola 10K Report to answer your questions along with any other...

Q:

please give solution to this whole question 14 chapter 6. coarse instruction 161 Why 1. Usip 14 TMC ABC Coily for the VEI. MES fondu Ye Master Production Schedule 1 2 3 We Number 4 5 6 Product 10 25...

Q:

Spend analysis Stock-keeping unit (SKU) 10 Three-way match Utilization ty Images; @ monsity/ Getty Images Vendor master health care? iency? CHAPTER 17 applied, and what are the steps to fol-...

Q:

I need assistance with some SAP Classic Rockers Case Student Exercises (Setup, MM, PP, SD, FI/CO). let me know if interested. Chapter 1: Setup Exercises EXERCISE 1:SETUP PARAMETER ID This exercise...

Q:

Please Help! Begin by reading the Email from Darlene. 1,637 Then go to A-0 The Planning Audit Program. Note the highlighted rows #4 a and b and 8. These are the three workpapers you need to complete....

Q:

What are the stages involved in buying behavior? How can they be enhanced?

Q:

A manufacturer of cereal is considering three alternative box colors-red, yellow, and blue. To check whether such a consideration has any effect on sales, 16 stores of approximately equal size are...

Q:

On 1 July 2022 Law Engineering purchased a machine on credit for $120,000.00. It had an expected useful life of 4 years and an expected residual value of $15,000.00 Required (a) using the Straight...

Q:

Required information [The following information applies to the questions displayed below]. The bookkeeper at Jefferson Company has not reconciled the bank statement with the Cash account, saying. "I...