Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started