Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 using excel functions?

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cornerstones of Managerial Accounting

Authors: Mowen, Hansen, Heitger

3rd Edition

324660138, 978-0324660135

More Books

Students also viewed these Accounting questions