Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

describe the procedures used to calculate the variance Product ISKU X370A X370A X370A X370A X370A Primary Vendor Standard Cost Standard Mate 100525 Alpha $ 1.25

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

describe the procedures used to calculate the variance

Product ISKU X370A X370A X370A X370A X370A Primary Vendor Standard Cost Standard Mate 100525 Alpha $ 1.25 ft 101652 Alpha $ 1.50 ft 108900 Alpha $ 1.75 ft 202456 American Products 10.75 N/A 555874 Giant Wholesale $ 0.05 ft 555902 Giant Wholesale $ 0.08 ft 825600 Technical Innovations $ 3.00 N/A 825605 Technical Innovations $ 3.00 N/A 825608 Technical Innovations $ 1.50 N/A 110852 Alpha $ 1.10 ft 111568 Alpha 1.40 ft 118741 Alpha $ 1.79 ft 119561 Alpha 1.79 ft 555916 Giant Wholesale 0.08 ft 0X370A 1 ZA10B 4 7410B 5 7410B SKU Primary Vendor Standard Material Unit Beginning Inventory Ending Inventory 2 100525 Alpha 395.00 405.00 3 101652 Alpha 855.00 1,005.00 4 108900 Alpha 4,985.00 4,305.00 5 110852 Alpha 1,235.00 1,335.00 111568 Alpha 1,340.00 1,145.00 7 118741 Alpha 1,980.00 2,045.00 119561 Alpha 80.00 685.00 9202456 American Products N/A 3,972.00 5,571.00 10 555874 Giant Wholesale 10,101.00 14,905.00 11 555902 Giant Wholesale 12,760.00 27,090.00 12 555916 Giant Wholesale 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 Hes 4 5 OM 7 OG 9 M 1 Purchase ord PO Date Purcha: - Vendor SKU 2. 5399 12/4/2020 Alex Technical Innovations 825608 3 5400 12/5/2020 Chris Alpha 100525 12/5/2020 Chris Alpha 101652 5400 1251/2020 Chris Alpha 108900 5400 12/5/2020 Chris Alpha 110852 12/5/2020 Chris Alpha 111568 5400 12/5/2020 Chris Alpha 118741 5400 12/5/2020 Chris Alpha 119561 12/9/2020 Alex Technical Innovations 825600 12/9/2020 Alex Technical Innovations 825605 5403 12/12/2020 Pat Giant Wholesale 555874 12/12/2020 Pat Giant Wholesale 555902 12/12/2020 Pat Giant Wholesale 555916 5404 12/12/2020 Pat American Products 202456 5405 12/28/2020 Chris Alpha 100525 5405 12/28/2020 Chris Alpha 101652 5405 12/28/2020 Chris Alpha 108900 5405 12/28/2020 Chris Alpha 119561 5406 1/3/2021 Alex Technical Innovations 825608 5408 1/5/2021 Pat Giant Wholesale 555874 22 5408 1/5/2021 Pat iant Wholesale 555902 1 Islan91 Dat Gint Alholarolo 3 6 99 555016 A B D 22 25 26 28 31 5408 1/5/2021 Pat 5408 1/5/2021 Pat 5409 1/11/2021 Alex 5409 1/11/2021 Alex 5410 1/14/2021 Chris 5410 1/14/2021 Chris 5410 1/14/2021 Chris 5410 1/14/2021 Chris 5410 1/14/2021 Chris 5411 1/15/2021 Pat 5413 1/27/2021 Alex 5413 1/28/2021 Alex 5413 1/28/2021 Alex 5414 1/30/2021 Chris 5414 1/30/2021 Chris 5414 1/30/2021 Chris 5414 1/30/2021 Chris 5414 1/30/2021 Chris 5415 1/31/2021 Chris 5415 1/31/2021 Chris 5416 2/6/2021 Chris 5416 2/6/2021 Chris 6091chric Product Standards Giant Wholesale 555902 20,000.00 Giant Wholesale 555916 37,500.00 Technical Innovations 825600 5,000.00 Technical Innovations 825605 5,000.00 Alpha 101652 200.00 Alpha 108900 1,000.00 Alpha 110852 200.00 Alpha 111568 500.00 Alpha 118741 2,000.00 American Products 202456 35,000.00 Technical Innovations 825600 5,000.00 Technical Innovations 825605 5,000.00 Technical Innovations 825608 16,000.00 Alpha 100525 500.00 Alpha 101652 1,000.00 Alpha 108900 1,000.00 Alpha 111568 500.00 Alpha 119561 1,000.00 Limited Stock 100525 2,000.00 Limited Stock 110852 4,000.00 Alpha 100525 500.00 Alpha 101652 500.00 Alah Inventory Information Purchasing Information 88 MA SA16 10o@nn Dan on 5416 101652 108900 5416 5 5416 118741 6 119561 202456 8 5418 555874 5418 555902 555916 100525 101652 5420 2/6/2021 Chris 2/6/2021 Chris 2/6/2021 Chris 2/6/2021 Chris 2/15/2021 Pat 2/19/2021 Pat 2/19/2021 Pat 2/19/2021 Pat 2/24/2021 Chris 2/24/2021 Chris 2/24/2021 Chris 2/24/2021 Chris 2/24/2021 Chris 2/24/2021 Chris 2/24/2021 Chris 3/1/2021 Alex 3/1/2021 Alex 3/13/2021 Chris 3/13/2021 Chris 3/13/2021 Chris 3/15/2021 Pat Alpha Alpha Alpha Alpha American Products Giant Wholesale Giant Wholesale Giant Wholesale Alpha Alpha Alpha Alpha Alpha Alpha Alpha Technical Innovations Technical Innovations Alpha Alpha Alpha American Products 108900 500.00 200.00 2,000.00 200.00 35,042,00 20,000.00 20,000.00 37,500.00 500.00 500.00 2,500.00 300.00 500.00 2,000.00 1,000.00 5,000.00 5,000.00 500.00 1,000.00 2,500.00 35,000.00 110852 5420 111568 56 5420 118741 5420 119561 825600 5421 5421 825605 100525 101652 5423 5423 108900 202456 5424 4 B D E ON 1 Invoic - Received - Vendor SKU Purchase ord Total Price Pa 2 1000587 12/8/2020 Technical Innovations 825608 5399 $ 3,132.50 Yes 3 10056 12/9/2020 Alpha 100525 5400 $ 645.00 Yes 4 10056 12/9/2020 Alpha 101652 5400 $ 1,500.00 Yes 5 10056 12/9/2020 Alpha 108900 5400 $ 8,350.00 Yes 6 10056 12/9/2020 Alpha 110852 5400 $ 1,725.00 Yes 10070 12/28/2020 Alpha 111568 5400 $ 2,980.00 Yes 8 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 384 12/17/2020 Giant Wholesale 555874 5403 $ 1,168.50 Yes 384 12/17/2020 Giant Wholesale 555902 5403 $ 675.00 Yes 384 12/17/2020 Giant Wholesale 555916 5403 $ 1,200.00 Yes 15 603 12/20/2020 American Products 202456 5404 $376,250.00 Yes 10078 1/3/2021 Alpha 100525 5405 $ 645.00 Yes 10078 1/3/2021 Alpha 101652 5405 S 300.00 Yes 10078 1/3/2021 Alpha 108900 5405 $ 175.00 Yes 10078 1/3/2021 Alpha 119561 5405 $ 180.00 Yes 20 1000613 1/7/2021 Technical Innovations 825608 5406 $ 8,950.00 Yes 405 1/7/2021 Giant Wholesale 555874 5408 S 900.00 Yes 408 1/7/2021 Giant Wholesale 555902 5408 $ 1,560.00 Yes 191 cinnt mibolorido SS5016 Inventory Information Purchasing Information Accounts Payable Summary 12 LIPS Am O@A V G 22 408 1/7/2021 Giant Wholesale 555902 408 1/7/2021 Giant Wholesale 555916 24 1000800 1/16/2021 Technical Innovations 825600 25 1000800 1/16/2021 Technical Innovations 825605 26 10125 1/18/2021 Alpha 101652 27 10125 1/18/2021 Alpha 108900 10125 1/18/2021 Alpha 110852 10140 2/4/2021 Alpha 111568 10125 1/18/2021 Alpha 118741 609 1/20/2021 American Products 202456 32 1001111 1/31/2021 Technical Innovations 825600 33 1001111 1/31/2021 Technical Innovations 825605 34 1001111 1/31/2021 Technical Innovations 825608 35 2/4/2021 Alpha 100525 10140 2/4/2021 Alpha 101652 10140 2/4/2021 Alpha 108900 10140 2/4/2021 Alpha 111568 10140 2/4/2021 Alpha 119561 40 9000456 2/20/2021 Limited Stock 100525 41 9000456 2/20/2021 Limited Stock 110852 10181 2/10/2021 Alpha 100525 10181 2/10/2021 Alpha 101652 10091 Alnba 5408 $ 1,560.00 Yes 5408 $ 2,996.25 Yes 5409 $ 15,000.00 Yes 5409 $ 15,000.00 Yes 5410 $ 300.00 Yes 5410 $ 1,750.00 Yes 5410 $ 230.00 Yes 5410 $ 715.00 Yes 5410 $ 3,600.00 Yes 5411 $ 376,250.00 Yes 5413 $ 15,650.00 Yes 5413 $ 15,650.00 Yes 5413 $ 25,440.00 Yes 5414 $ 645.00 Yes 5414 $ 1,650.00 Yes 5414 $ 1,750.00 Yes 5414 $ 715.00 Yes 5414 S 1,800.00 Yes 5415 $ 2,000.00 Yes 5415 $ 4,000.00 Yes 5416 S 645.00 Yes 5416 S 825.00 Yes 3 3 necon 9 on an Vine Inucnton of B 5 10181 2/10/2021 Alpha 101652 10181 2/10/2021 Alpha 108900 45 10181 2/10/2021 Alpha 118741 46 10181 2/10/2021 Alpha 119561 611 2/20/2021 American Products 202456 451 2/23/2021 Giant Wholesale 555874 49 451 2/23/2021 Giant Wholesale 555902 451 2/23/2021 Giant Wholesale 555916 10200 2/28/2021 Alpha 100525 10200 2/28/2021 Alpha 101652 10200 2/28/2021 Alpha 108900 54 10200 2/28/2021 Alpha 110852 10280 3/3/2021 Alpha 111568 56 10200 2/28/2021 Alpha 118741 10200 2/28/2021 Alpha 119561 58 1001258 3/4/2021 Technical Innovations 825600 59 1001258 3/4/2021 Technical Innovations 825605 10300 3/18/2021 Alpha 100525 10300 3/18/2021 Alpha 101652 62 10300 3/18/2021 Alpha 108900 618 3/20/2021 American Products 202456 5416 $ 825.00 Yes 5416 $ 350.00 Yes 5416 $ 3,780.00 Yes 5416 $ 360.00 Yes 5417 $ 376,250.00 No 5418 $ 900.00 Yes 5418 $ 1,560.00 Yes 5418 $ 2,996.25 Yes 5420 $ 645.00 Yes 5420 $ 825.00 Yes 5420 $ 4,300.00 Yes 5420 $ 345.00 Yes 5420 $ 715.00 Yes 5420 $ 3,780.00 Yes 5420 $ 1,800.00 Yes 5421 $ 15,650.00 No 5421 $ 15,650.00 No 5423 $ 645.00 No 5423 S 1,650.00 No 5423 S 4,300.00 No 5424 $. 376,250.00 No Product ISKU X370A X370A X370A X370A X370A Primary Vendor Standard Cost Standard Mate 100525 Alpha $ 1.25 ft 101652 Alpha $ 1.50 ft 108900 Alpha $ 1.75 ft 202456 American Products 10.75 N/A 555874 Giant Wholesale $ 0.05 ft 555902 Giant Wholesale $ 0.08 ft 825600 Technical Innovations $ 3.00 N/A 825605 Technical Innovations $ 3.00 N/A 825608 Technical Innovations $ 1.50 N/A 110852 Alpha $ 1.10 ft 111568 Alpha 1.40 ft 118741 Alpha $ 1.79 ft 119561 Alpha 1.79 ft 555916 Giant Wholesale 0.08 ft 0X370A 1 ZA10B 4 7410B 5 7410B SKU Primary Vendor Standard Material Unit Beginning Inventory Ending Inventory 2 100525 Alpha 395.00 405.00 3 101652 Alpha 855.00 1,005.00 4 108900 Alpha 4,985.00 4,305.00 5 110852 Alpha 1,235.00 1,335.00 111568 Alpha 1,340.00 1,145.00 7 118741 Alpha 1,980.00 2,045.00 119561 Alpha 80.00 685.00 9202456 American Products N/A 3,972.00 5,571.00 10 555874 Giant Wholesale 10,101.00 14,905.00 11 555902 Giant Wholesale 12,760.00 27,090.00 12 555916 Giant Wholesale 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 Hes 4 5 OM 7 OG 9 M 1 Purchase ord PO Date Purcha: - Vendor SKU 2. 5399 12/4/2020 Alex Technical Innovations 825608 3 5400 12/5/2020 Chris Alpha 100525 12/5/2020 Chris Alpha 101652 5400 1251/2020 Chris Alpha 108900 5400 12/5/2020 Chris Alpha 110852 12/5/2020 Chris Alpha 111568 5400 12/5/2020 Chris Alpha 118741 5400 12/5/2020 Chris Alpha 119561 12/9/2020 Alex Technical Innovations 825600 12/9/2020 Alex Technical Innovations 825605 5403 12/12/2020 Pat Giant Wholesale 555874 12/12/2020 Pat Giant Wholesale 555902 12/12/2020 Pat Giant Wholesale 555916 5404 12/12/2020 Pat American Products 202456 5405 12/28/2020 Chris Alpha 100525 5405 12/28/2020 Chris Alpha 101652 5405 12/28/2020 Chris Alpha 108900 5405 12/28/2020 Chris Alpha 119561 5406 1/3/2021 Alex Technical Innovations 825608 5408 1/5/2021 Pat Giant Wholesale 555874 22 5408 1/5/2021 Pat iant Wholesale 555902 1 Islan91 Dat Gint Alholarolo 3 6 99 555016 A B D 22 25 26 28 31 5408 1/5/2021 Pat 5408 1/5/2021 Pat 5409 1/11/2021 Alex 5409 1/11/2021 Alex 5410 1/14/2021 Chris 5410 1/14/2021 Chris 5410 1/14/2021 Chris 5410 1/14/2021 Chris 5410 1/14/2021 Chris 5411 1/15/2021 Pat 5413 1/27/2021 Alex 5413 1/28/2021 Alex 5413 1/28/2021 Alex 5414 1/30/2021 Chris 5414 1/30/2021 Chris 5414 1/30/2021 Chris 5414 1/30/2021 Chris 5414 1/30/2021 Chris 5415 1/31/2021 Chris 5415 1/31/2021 Chris 5416 2/6/2021 Chris 5416 2/6/2021 Chris 6091chric Product Standards Giant Wholesale 555902 20,000.00 Giant Wholesale 555916 37,500.00 Technical Innovations 825600 5,000.00 Technical Innovations 825605 5,000.00 Alpha 101652 200.00 Alpha 108900 1,000.00 Alpha 110852 200.00 Alpha 111568 500.00 Alpha 118741 2,000.00 American Products 202456 35,000.00 Technical Innovations 825600 5,000.00 Technical Innovations 825605 5,000.00 Technical Innovations 825608 16,000.00 Alpha 100525 500.00 Alpha 101652 1,000.00 Alpha 108900 1,000.00 Alpha 111568 500.00 Alpha 119561 1,000.00 Limited Stock 100525 2,000.00 Limited Stock 110852 4,000.00 Alpha 100525 500.00 Alpha 101652 500.00 Alah Inventory Information Purchasing Information 88 MA SA16 10o@nn Dan on 5416 101652 108900 5416 5 5416 118741 6 119561 202456 8 5418 555874 5418 555902 555916 100525 101652 5420 2/6/2021 Chris 2/6/2021 Chris 2/6/2021 Chris 2/6/2021 Chris 2/15/2021 Pat 2/19/2021 Pat 2/19/2021 Pat 2/19/2021 Pat 2/24/2021 Chris 2/24/2021 Chris 2/24/2021 Chris 2/24/2021 Chris 2/24/2021 Chris 2/24/2021 Chris 2/24/2021 Chris 3/1/2021 Alex 3/1/2021 Alex 3/13/2021 Chris 3/13/2021 Chris 3/13/2021 Chris 3/15/2021 Pat Alpha Alpha Alpha Alpha American Products Giant Wholesale Giant Wholesale Giant Wholesale Alpha Alpha Alpha Alpha Alpha Alpha Alpha Technical Innovations Technical Innovations Alpha Alpha Alpha American Products 108900 500.00 200.00 2,000.00 200.00 35,042,00 20,000.00 20,000.00 37,500.00 500.00 500.00 2,500.00 300.00 500.00 2,000.00 1,000.00 5,000.00 5,000.00 500.00 1,000.00 2,500.00 35,000.00 110852 5420 111568 56 5420 118741 5420 119561 825600 5421 5421 825605 100525 101652 5423 5423 108900 202456 5424 4 B D E ON 1 Invoic - Received - Vendor SKU Purchase ord Total Price Pa 2 1000587 12/8/2020 Technical Innovations 825608 5399 $ 3,132.50 Yes 3 10056 12/9/2020 Alpha 100525 5400 $ 645.00 Yes 4 10056 12/9/2020 Alpha 101652 5400 $ 1,500.00 Yes 5 10056 12/9/2020 Alpha 108900 5400 $ 8,350.00 Yes 6 10056 12/9/2020 Alpha 110852 5400 $ 1,725.00 Yes 10070 12/28/2020 Alpha 111568 5400 $ 2,980.00 Yes 8 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 384 12/17/2020 Giant Wholesale 555874 5403 $ 1,168.50 Yes 384 12/17/2020 Giant Wholesale 555902 5403 $ 675.00 Yes 384 12/17/2020 Giant Wholesale 555916 5403 $ 1,200.00 Yes 15 603 12/20/2020 American Products 202456 5404 $376,250.00 Yes 10078 1/3/2021 Alpha 100525 5405 $ 645.00 Yes 10078 1/3/2021 Alpha 101652 5405 S 300.00 Yes 10078 1/3/2021 Alpha 108900 5405 $ 175.00 Yes 10078 1/3/2021 Alpha 119561 5405 $ 180.00 Yes 20 1000613 1/7/2021 Technical Innovations 825608 5406 $ 8,950.00 Yes 405 1/7/2021 Giant Wholesale 555874 5408 S 900.00 Yes 408 1/7/2021 Giant Wholesale 555902 5408 $ 1,560.00 Yes 191 cinnt mibolorido SS5016 Inventory Information Purchasing Information Accounts Payable Summary 12 LIPS Am O@A V G 22 408 1/7/2021 Giant Wholesale 555902 408 1/7/2021 Giant Wholesale 555916 24 1000800 1/16/2021 Technical Innovations 825600 25 1000800 1/16/2021 Technical Innovations 825605 26 10125 1/18/2021 Alpha 101652 27 10125 1/18/2021 Alpha 108900 10125 1/18/2021 Alpha 110852 10140 2/4/2021 Alpha 111568 10125 1/18/2021 Alpha 118741 609 1/20/2021 American Products 202456 32 1001111 1/31/2021 Technical Innovations 825600 33 1001111 1/31/2021 Technical Innovations 825605 34 1001111 1/31/2021 Technical Innovations 825608 35 2/4/2021 Alpha 100525 10140 2/4/2021 Alpha 101652 10140 2/4/2021 Alpha 108900 10140 2/4/2021 Alpha 111568 10140 2/4/2021 Alpha 119561 40 9000456 2/20/2021 Limited Stock 100525 41 9000456 2/20/2021 Limited Stock 110852 10181 2/10/2021 Alpha 100525 10181 2/10/2021 Alpha 101652 10091 Alnba 5408 $ 1,560.00 Yes 5408 $ 2,996.25 Yes 5409 $ 15,000.00 Yes 5409 $ 15,000.00 Yes 5410 $ 300.00 Yes 5410 $ 1,750.00 Yes 5410 $ 230.00 Yes 5410 $ 715.00 Yes 5410 $ 3,600.00 Yes 5411 $ 376,250.00 Yes 5413 $ 15,650.00 Yes 5413 $ 15,650.00 Yes 5413 $ 25,440.00 Yes 5414 $ 645.00 Yes 5414 $ 1,650.00 Yes 5414 $ 1,750.00 Yes 5414 $ 715.00 Yes 5414 S 1,800.00 Yes 5415 $ 2,000.00 Yes 5415 $ 4,000.00 Yes 5416 S 645.00 Yes 5416 S 825.00 Yes 3 3 necon 9 on an Vine Inucnton of B 5 10181 2/10/2021 Alpha 101652 10181 2/10/2021 Alpha 108900 45 10181 2/10/2021 Alpha 118741 46 10181 2/10/2021 Alpha 119561 611 2/20/2021 American Products 202456 451 2/23/2021 Giant Wholesale 555874 49 451 2/23/2021 Giant Wholesale 555902 451 2/23/2021 Giant Wholesale 555916 10200 2/28/2021 Alpha 100525 10200 2/28/2021 Alpha 101652 10200 2/28/2021 Alpha 108900 54 10200 2/28/2021 Alpha 110852 10280 3/3/2021 Alpha 111568 56 10200 2/28/2021 Alpha 118741 10200 2/28/2021 Alpha 119561 58 1001258 3/4/2021 Technical Innovations 825600 59 1001258 3/4/2021 Technical Innovations 825605 10300 3/18/2021 Alpha 100525 10300 3/18/2021 Alpha 101652 62 10300 3/18/2021 Alpha 108900 618 3/20/2021 American Products 202456 5416 $ 825.00 Yes 5416 $ 350.00 Yes 5416 $ 3,780.00 Yes 5416 $ 360.00 Yes 5417 $ 376,250.00 No 5418 $ 900.00 Yes 5418 $ 1,560.00 Yes 5418 $ 2,996.25 Yes 5420 $ 645.00 Yes 5420 $ 825.00 Yes 5420 $ 4,300.00 Yes 5420 $ 345.00 Yes 5420 $ 715.00 Yes 5420 $ 3,780.00 Yes 5420 $ 1,800.00 Yes 5421 $ 15,650.00 No 5421 $ 15,650.00 No 5423 $ 645.00 No 5423 S 1,650.00 No 5423 S 4,300.00 No 5424 $. 376,250.00 No

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

Internal Auditing Assurance And Advisory Services

Authors: Kurt R. Reding, Paul J. Sobel, Urton L. Anderson, Michael J. Head, Sridhar Ramamoorti, Mark Salamasick, Cris Riddle

3rd Edition

0894137409, 978-0894137402

More Books

Students also viewed these Accounting questions