Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A D E G H K M N P Q R S U V W X Z AA Al - Invoid Received Vendor SKU *

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
A D E G H K M N P Q R S U V W X Z AA Al - Invoid Received Vendor SKU * Purchase ord Total Price > Pay 1000587 12/8/2020 Technical Innovations 825608 5399 $ 3,132.50 Yes 10056 12/9/2020 Alpha 100525 5400 $ 645.00 Yes 10056 12/9/2020 Alpha 101652 5400 $ 1,500.00 Yes 10056 12/9/2020 Alpha 108900 5400 $ 8,350.00 Yes 10056 12/9/2020 Alpha 110852 5400 $ 1,725.00 Yes 10070 12/28/2020 Alpha 111568 5400 $ 2,980.00 Yes 10056 12/9/2020 Alpha 118741 5400 $ 3,500.00 Yes 10056 12/9/2020 Alpha 119561 5400 $ 180.00 Yes 10 1000598 12/14/2020 Technical Innovations 825600 5401 $ 15,000.00 Yes 11 1000598 12/14/2020 Technical Innovations 825605 5401 $ 15,000.00 Yes 12 384 12/17/2020 Giant Wholesale 555874 5403 $ 1,168.50 Yes 13 384 12/17/2020 Giant Wholesale 555902 5403 $ 675.00 Yes 384 12/17/2020 Giant Wholesale 555916 5403 $ 1,200.00 Yes 603 12/20/2020 American Products 202456 5404 $ 376,250.00 Yes 16 10078 1/3/2021 Alpha 100525 645.00 Yes 17 10078 1/3/2021 Alpha 101652 5405 300.00 Yes 18 10078 1/3/2021 Alpha 108900 5405 175.00 Yes 19 10078 1/3/2021 Alpha 119561 5405 180.00 Yes 0 1000613 1/7/2021 Technical Innovations 825608 5406 $ 8,950.00 Yes 21 105 1/7/2021 Giant Wholesale 555874 5408 $ 900.00 Yes 22 108 1/7/2021 Giant Wholesale 555902 5408 $ 1,560.00 Yes 23 408 1/7/2021 Giant Wholesale 555916 5408 $ 2,996.25 Yes 1000800 1/16/2021 Technical Innovations 825600 5409 $ 15,000.00 Yes 25 1000800 1/16/2021 Technical Innovations 825605 5409 $ 15,000.00 Yes 26 10125 1/18/2021 Alpha 101652 5410 $ 300.00 Yes 27 10125 1/18/2021 Alpha 108900 5410 $ 1,750.00 Yes 28 10125 1/18/2021 Alpha 110852 5410 $ 230.00 Yes 29 10140 2/4/2021 Alpha 111568 5410 $ 715.00 Yes 30 10125 1/18/2021 Alpha 118741 5410 $ 3,600.00 Yes 31 609 1/20/2021 American Products 202456 5411 $ 376,250.00 Yes 32 1001111 1/31/2021 Technical Innovations 825600 5413 $ 15,650.00 Yes 33 1001111 1/31/2021 Technical Innovations 825605 5413 15,650.00 Yes 34 1001111 1/31/2021 Technical Innovations 825608 5413 $ 25,440.00 Yes 10140 2/4/2021 Alpha 100525 5414 $ 645.00 Yes35 10140 2/4/2021 Alpha 100525 5414 $ 645.00 Yes 36 10140 2/4/2021 Alpha 101652 5414 $ 1,650.00 Yes 37 10140 2/4/2021 Alpha 108900 5414 $ 1,750.00 Yes 38 10140 2/4/2021 Alpha 111568 5414 $ 715.00 Yes 39 10140 2/4/2021 Alpha 119561 5414 $ 1,800.00 Yes 9000456 2/20/2021 Limited Stock 100525 5415 $ 2,000.00 Yes 9000456 2/20/2021 Limited Stock 110852 5415 $ 4,000.00 Yes 10181 2/10/2021 Alpha 100525 5416 $ 645.00 Yes 43 10181 2/10/2021 Alpha 101652 5416 $ 825.00 Yes 44 10181 2/10/2021 Alpha 108900 5416 $ 350.00 Yes 45 10181 2/10/2021 Alpha 118741 5416 $ 3,780.00 Yes 46 10181 2/10/2021 Alpha 119561 5416 $ 360.00 Yes 47 611 2/20/2021 American Products 202456 5417 $ 376,250.00 No 48 451 2/23/2021 Giant Wholesale 555874 5418 $ 900.00 Yes 49 451 2/23/2021 Giant Wholesale 555902 5418 $ 1,560.00 Yes 50 451 2/23/2021 Giant Wholesale 555916 5418 $ 2,996.25 Yes 10200 2/28/2021 Alpha 100525 5420 $ 645.00 Yes 52 10200 2/28/2021 Alpha 101652 5420 $ 825.00 Yes 53 10200 2/28/2021 Alpha 108900 5420 S 4,300.00 Yes 54 10200 2/28/2021 Alpha 110852 5420 $ 345.00 Yes 55 10280 3/3/2021 Alpha 111568 5420 $ 715.00 Yes 56 10200 2/28/2021 Alpha 118741 5420 $ 3,780.00 Yes 57 10200 2/28/2021 Alpha 119561 5420 $ 1,800.00 Yes 58 1001258 3/4/2021 Technical Innovations 825600 5421 $ 15,650.00 No 59 1001258 3/4/2021 Technical Innovations 825605 5421 $ 15,650.00 No 60 10300 3/18/2021 Alpha 100525 5423 $ 645.00 No 61 10300 3/18/2021 Alpha 101652 5423 $ 1,650.00 No 62 10300 3/18/2021 Alpha 108900 5423 $ 4,300.00 No 63 618 3/20/2021 American Products 202456 5424 $ 376,250.00 No 64 65 Product Standards Inventory Information Purchasing Information Accounts Payable Summary +A B C D E F G H I J K L M N P Q R S T U V W X Y 1 SKU Primary Vendor Standard Material Unit Beginning Inventory Ending Inventory 2 100525 Alpha ft 395.00 405.00 3 101652 Alpha ft 855.00 1,005.00 4 108900 Alpha ft 4,985.00 4,305.00 5 110852 Alpha ft 1,235.00 1,335.00 6 111568 Alpha ft 1,340.00 1,145.00 118741 Alpha Ift 1,980.00 2,045.00 8 119561 Alpha ft 80.00 685.00 9 202456 American Products N/A 3,972.00 5,571.00 10 555874 Giant Wholesale ft 10,101.00 14,905.00 11 555902 Giant Wholesale ft 12,760.00 27,090.00 12 555916 Giant Wholesale ft 12,520.00 30,980.00 13 825600 Technical Innovations N/A 2,976.00 609.00 14 825605 Technical Innovations N/A 2,932.00 694.00 15 825608 Technical Innovations N/A 951.00 4,173.00 16 17 18 19 20 21 22 23 24 Product Standards Inventory Information Purchasing Information Accounts Payable Summary +A1 X V Product B C E G H K M N O P Q R S T U Product SKU Primary Vendor Standard Cost Standard Material Unit Standard Material per Unit of Product Terms X370A 100525 Alpha 1.25 ft 0.2 Net 30 3 X370A 101652 Alpha 1.50 ft 0.2 Net 30 4 X370A 108900 Alpha 1.75 ft 0.5 Net 30 5 X370A 202456 American Products in in in in in in in 10.75 N/A 6 Net 60 6 X370A 555874 Giant Wholesale 0.05 ft 2 Net 30 7 X370A 555902 Giant Wholesale 0.08 ft 2 Net 30 8 X370A 825600 Technical Innovations 3.00 N/A 1 Net 30 9 X370A 825605 Technical Innovations 3.00 N/A 1 Net 30 10 X370A 825608 Technical Innovations 1.50 N/A 1 Net 30 11 24108 110852 Alpha 1.10 ft 0.2 Net 30 12 2410B 111568 Alpha 1.40 ft 0.2 Net 30 13 Z410B 118741 Alpha 1.79 ft 0.4 Net 30 14 Z4108 119561 Alpha 1.79 ft 0.1 Net 30 15 2410B 555916 Giant Wholesale 0.08 ft 4 Net 30 16 17 18 19 20 32 33 34 35 36 Product Standards Inventory Information Purchasing Information Accounts Payable Summary +X Y K M N P Q R S T U V W Z AA B C D E F G H 1 Purchase ord PO Date |Purchas Vendor SKU Quantity 5399 12/4/2020 Alex Technical Innovations 825608 1,750.00 5400 12/5/2020 Chris Alpha 100525 500.00 UI A W N 5400 12/5/2020 Chris Alpha 101652 1,000.00 5400 12/5/2020 Chris Alpha 108900 5,000.00 5400 12/5/2020 Chris Alpha 110852 1,500.00 5400 12/5/2020 Chris Alpha 111568 2,000.00 5400 12/5/2020 Chris Alpha 118741 2,000.00 5400 12/5/2020 Chris Alpha 119561 100.00 5401 12/9/2020 Alex Technical Innovations 825600 5,000.00 11 5401 12/9/2020 Alex Technical Innovations 825605 5,000.00 12 12/12/2020 Pat Giant Wholesale 555874 15,000.00 13 12/12/2020 Pat Giant Wholesale 655902 15,000.00 14 12/12/2020 Pat Giant Wholesale 55916 15,000.00 15 12/12/2020 Pat American Products 202456 35,000.00 16 5405 12/28/2020 Chris Alpha 100525 500.00 17 5405 12/28/2020 Chris Alpha 101652 200.00 18 12/28/2020 Chris Alpha 108900 100.00 19 5405 12/28/2020 Chris Alpha 119561 100.00 20 5406 1/3/2021 Alex Technical Innovations 825608 5,000.00 21 5408 1/5/2021 Pat Giant Wholesale 555874 20,000.00 22 5408 1/5/2021 Pat Giant Wholesale 555902 20,000.00 23 5408 1/5/2021 Pat Giant Wholesale 555916 37,500.00 24 5409 1/11/2021 Alex Technical Innovations 825600 5,000.00 25 5409 1/11/2021 Alex Technical Innovations 825605 5,000.00 26 5410 1/14/2021 Chris Alpha 101652 200.00 27 5410 1/14/2021 Chris Alpha 108900 1,000.00 28 5410 1/14/2021 Chris Alpha 110852 200.00 29 5410 1/14/2021 Chris Alpha 111568 500.00 30 5410 1/14/2021 Chris Alpha 118741 2,000.0030 5410 1/14/2021 Chris Alpha 118741 2,000.00 31 5411 1/15/2021 Pat American Products 202456 35,000.00 1/28/2021 Alex Technical Innovations 825600 5,000.00 32 5413 33 5413 1/28/2021 Alex Technical Innovations 825605 5,000.00 34 5413 1/28/2021 Alex Technical Innovations 825608 16,000.00 1/30/2021 Chris Alpha 500.00 35 5414 100525 36 5414 1/30/2021 Chris Alpha 101652 1,000.00 37 5414 1/30/2021 Chris Alpha 108900 1,000.00 111568 500.00 38 5414 1/30/2021 Chris Alpha 1,000.00 39 5414 1/30/2021 Chris Alpha 119561 5415 1/31/2021 Chris Limited Stock 100525 2,000.00 40 41 5415 1/31/2021 Chris Limited Stock 110852 4,000.00 42 5416 2/6/2021 Chris Alpha 100525 500.00 5416 2/6/2021 Chris Alpha 101652 500.00 43 200.00 44 5416 2/6/2021 Chris Alpha 108900 5416 2/6/2021 Chris Alpha 118741 2,000.00 45 5416 2/6/2021 Chris Alpha 200.00 46 119561 5417 2/15/2021 Pat American Products 202456 35,000.00 47 20,000.00 48 5418 2/19/2021 Pat Giant Wholesale 555874 5418 2/19/2021 Pat Giant Wholesale 655902 20,000.00 49 50 5418 2/19/2021 Pat Giant Wholesa 555916 37,500.00 2/24/2021 Chris 100525 500.00 51 5420 Alpha 500.00 52 5420 2/24/2021 Chris Alpha 101652 53 5420 2/24/2021 Chris Alpha 108900 2,500.00 2/24/2021 Chris Alpha 110852 300.00 54 5420 55 5420 2/24/2021 Chris Alpha 111568 500.00 2,000.00 56 5420 2/24/2021 Chris Alpha 118741 57 5420 2/24/2021 Chris Alpha 119561 1,000.00 58 5421 3/1/2021 Alex Technical Innovations 825600 5,000.00 59 5421 3/1/2021 Alex Technical Innovations 825605 5,000.00 100525 500.00 60 5423 3/13/2021 Chris Alpha 101652 1,000.00 61 5423 3/13/2021 Alpha 5423 3/13/2021 Chris Alpha 108900 2,500.00 62 63 5424 3/15/2021 Pat American Products 202456 35,000.00 64 65 Inventory Information Purchasing Information Accounts Payable Summary + Product Standards

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

Study Guide And Working Papers For Advanced Accounting

Authors: Joe Ben Hoyle, Thomas F. Schaefer, Timothy S. Doupnik, Sharon O'reilly

10th Edition

0077268040, 9780077268046

More Books

Students also viewed these Accounting questions