Dynamic Industrial is a relatively young company, with an unsophisticated accounting system. Dynamic Industrial manufactures two products, X370A, and Z410B. Each of the products has multiple components and materials (identified by SKU number), but assembly is relatively quick leaving no work in process inventory at the end of the period. Invoices are only approved for payment if the full quantity of the SKU has been received.

Using the information provided, calculate the Materials Price Variance and Materials Efficiency Variance for each component/material for 2021.

The beginning and ending inventory accounts for each product (units of output) for 2021 are provided below:

Beginning Inventory Count Ending Inventory Count Units Sold

X370A 5,040 4,040 18,220

Z410B 3,130 2,005 17,000

AutoSave OFF *Dynamic Industrial Data Q ~ Search Sheet Q v Share Comments Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 11 2 Wrap Text v General IX V V 2NAY - O. BI U V V DAY EE Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Ideas Paste Formatting as Table Styles X v Filter Select Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. P28 + X V fx W C D E F G H 1 J K L M N P Q R S T U V 18 384 12/17/17 Giant Wholesale 555916 5403 $ 1,200.00 Yes 19 603 12/20/17 American Products 202456 $404 $ 376,250.00 Yes 20 1007 1/3/18 Alpha 100525 $405 $ 645.00 Yes 21 10078 1/3/18 Alpha 101652 5405 $ 300.00 Yes 22 10078 1/3/18 Alpha 10890 5405 $ 175.00 Yes 23 10078 1/3/18 Alpha 119561 5405 $ 180.00 Yes 24 1000613 1/7/18 Technical Innovations 82560 $406 $ 8,950.00 Yes 25 CX890 2/1/18 Charleston 30008 $407 $ 598.80 Yes 26 CX890 2/1/18 Charleston 30008 5407 $ 4,125.00 Yes 2/1/18 Charleston 300091 5407 $ 779.00 Yes 2/23/18 Giant Wholesale 555874 5418 5 900.00 Yes 27 CX890 28 40 1/7/18 Giant Wholesale 555874 5408 $ 900.00 Yes 451 2/23/18 Giant Wholesale 555902 5418 $ 1,560.00 Yes 29 408 1/7/18 Giant Wholesale 555907 5408 $ 1,560.00 Yes 451 2/23/18 Giant Wholesale $55916 5418 $ 2,996.25 Yes 30 408 1/7/18 Giant Wholesale 555916 $408 $ 2,996.25 Yes x90z 3/2/18 Charleston 300087 5419 $ 4,125.00 No 31 1000800 1/16/18 Technical Innovations 825600 $409 $ 15,000.00 Yes CX902 3/2/18 Charleston 300091 5419 $ 779.00 No 32 1000800 1/16/18 Technical Innovations 825605 5409 $ 15,000.00 Yes 10200 2/28/18 Alpha 100525 5420 $ 645.00 Yes 1/18/18 Alpha 101652 5410 $ 10200 101652 825.00 Yes 10125 300.00 Yes 2/28/18 Alpha NEW 10125 1/18/18 Alpha 10890 5410 $ 1,750.00 Yes 10200 2/28/18 Alpha 108900 $ 4,300.00 Yes 10125 1/18/18 Alpha 110852 $410 $ 230.00 Yes 10200 2/28/18 Alpha 110852 5420 $ 345.00 Yes 36 10140 2/4/18 Alpha 111568 5410 $ 715.00 Yes 10280 3/3/18 Alphi 111568 5420 $ 715.00 Yes 37 10125 1/18/18 Alpha 118741 5410 $ 3,600.00 Yes 10200 2/28/18 Alpha 118741 5420 $ 3,780.00 Yes 38 609 1/20/18 American Products 202456 5411 $ 376,250.00 Yes 10200 2/28/18 Alpha 119561 5420 $ 1,800.00 Yes 39 CX899 2/18/18 Charleston 30008 5412 $ 598.80 No 1001258 3/4/18 Technical Innovations 825600 5421 $ 15,650.00 No 30009 5412 $ ON DO'000'0T 1001258 3/4/18 Technical Innovations 82560 5421 $ 15,650.00 No 40 CX899 2/18/18 Charleston 1/31/18 Technical Innovations 825600 $413 $ 15,650.00 Yes 10300 3/18/18 Alpha 100525 5423 $ 645.00 No 41 1001111 1/31/18 Technical Innovations 82560! 5413 $ 15,650.00 Yes 10300 3/18/18 Alpha 101652 5423 $ 1,650.00 No 42 1001111 5423 $ 4,300.00 No 43 1001111 1/31/18 Technical Innovations 825608 5413 $ 25,440.00 Yes 10300 3/18/18 Alpha 10890 10140 2/4/18 Alpha 10052 5414 $ 645.00 Yes 618 3/20/18 American Products 202456 5424 $ 376,250.00 No 45 10140 2/4/18 Alpha 101652 5414 $ 1,650.00 Yes 46 10140 2/4/18 Alpha 108900 5414 $ 1,750.00 Yes 47 10140 2/4/18 Alpha 111568 5414 $ 715.00 Yes 48 10140 2/4/18 Alpha 11956 5414 $ 1,800.00 Yes 49 9000456 2/20/18 Limited Stock 10052 5415 $ 2,000.00 Yes 50 9000456 2/20/18 Limited Stock 110852 5415 $ 4,000.00 Yes 51 10181 2/10/18 Alpha 100525 5416 $ 645.00 Yes 52 10181 2/10/18 Alpha 101652 5416 $ 825.00 Yes 53 10181 2/10/18 Alpha 10890 5416 $ 350.00 Yes 54 10181 2/10/18 Alpha 118741 5416 $ 3,780.00 Yes 55 10181 2/10/18 Alpha 119561 5416 $ 360.00 Yes 56 611 2/20/18 American Products 202456 5417 $ 376,250.00 No 57 58 FO Product Standards Inventory Information Purchasing Information Accounts Payable Summary + + 100%Box 7:51 PM Fri Nov 25 . . . .1 34% K Dynamic Industrial Data Home Insert Draw Formulas Data Review View Q Calibri (Body) 11 B I U S A General =v =P D V fx B D F G H K M SKU Primary Vendor Standard Material Unit Beginning Inventory Ending Inventory 405.00 IN 100525 Alpha 395.00 101652 Al ft 855.00 1,005.00 108900 Alpha ft 4,985.00 4,305.00 110852 Alpha ft 1,235.00 1,335.00 111568 Alpha ft 1,340.00 1,145.00 118741 Alpha ft 1,980.00 2,045.00 119561 Alpha ft 80.00 685.00 202456 American Products N/A 3,972.00 5,571.00 10 300080 Charleston lbs 10,250.00 16,870.00 11 300082 Charleston lbs 54,530.00 68,010.00 12 300091 Charleston Ibs 10,500.00 9,494.00 13 300095 Charleston lbs 60,302.00 77,356.00 555874 Giant Wholesale ft 10,101.00 14,905.00 15 555902 Giant Wholesale ft 12,760.00 27,090.00 16 555916 Giant Wholesale ft 12,520.00 30,980.00 17 825600 Technical Innovations N/A 2,976.00 609.00 18 825605 Technical Innovations N/A 2,932.00 694.00 19 825608 Technical Innovations N/A 951.00 4,173.00 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Product Standards Inventory Information Purchasing Information Accounts Payable S... +\fQ ~ Search Sheet Q v AutoSave OFF *Dynamic Industrial Data Share Comments Home Insert Draw Page Layout Formulas Data Review View 2" AP- O. Calibri (Body) 11 2 Wrap Text v General $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Ideas Paste BIU V V CAV E E Merge & Center v Formatting as Table Styles X v Filter Select Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. 048 + XV fx S T U V W B C D E G H 1 K L M N P Q R 5405 12/28/17 Chris Alpha 108900 100.0 5405 12/28/17 Chris Alpha 119561 100.00 5406 1/3/18 Alex Technical Innovations 825608 5,000.00 5407 1/5/18 Pat Charlestor 300080 12,000.00 5407 1/5/18 Pat Charleston 300082 55,000.00 5407 1/5/18 Pat Charleston 300091 10,000.00 5408 Giant Wholesale 555874 20,000.00 2/24/18 Chris Alpha 101652 500.00 1/5/18 Pat 5420 2/24/18 Chris Alpha 108900 2,500.00 5408 1/5/18 Pat Giant Wholesale 555902 20,000.00 5408 1/5/18 Pat Giant Wholesale 555916 37,500.00 5420 2/24/18 Chris Alpha 110852 300.00 Technical Innovations 111568 500.00 5409 1/11/18 Alex 825600 5,000.00 420 2/24/18 Chris Alpha 18741 2,000.00 5409 1/11/18 Ale Technical Innovations 825605 5,000.0 5420 2/24/18 Chris Alpha 5410 1/14/18 Chris Alpha 101652 200.00 5420 2/24/18 Chris Alpha 119561 1,000.00 $410 1/14/18 Chris Alpha 108900 1,000.00 5421 3/1/18 Alex Technical It 825600 5,000.00 1/14/18 Chris Alpha 110852 200.00 5421 3/1/18 Alex Technical It 825605 5,000.00 5410 5410 1/14/18 Chris Alpha 111568 500.00 5423 3/13/18 Chris Alpha 100525 500.00 Alpha 118741 00'000'7 5423 3/13/18 Chris Alpha 101652 1,000.00 5410 1/14/18 Chris Alpha 108900 2,500.00 5411 1/15/18 Pat American Products 202456 35,000.00 5423 3/13/18 Chris $412 1/26/18 Pat Charlestor 300080 12,000.00 5424 3/15/18 Pat American P 202456 #HWWWWWW $412 1/26/18 Pat Charleston 300095 100,000.00 5413 1/28/18 Alex Technical Innovations 825600 5,000.00 5413 1/28/18 Alex Technical Innovations 825605 5,000.00 5413 1/28/18 Alex Technical Innovations 825608 16,000.00 $414 1/30/18 Chris Alpha 100525 500.00 5414 1/30/18 Chris Alpha 101652 1,000.00 5414 1/30/18 Chris Alpha 108900 1,000.00 5414 1/30/18 Chris Alpha 111568 500.0 48 5414 1/30/18 Chris Alpha 119561 1,000.00 49 5415 1/31/18 Chris Limited Stock 100525 2,000.00 $41 1/31/18 Chris Limited Stock 110852 4,000.00 5416 2/6/18 Chris Alpha 100525 500.00 5416 2/6/18 Chris Alpha 101652 500.0 5416 2/6/18 Chris Alpha 108900 200.00 $416 2/6/18 Chris Alpha 118741 2,000.00 5416 2/6/18 Chris Alpha 119561 200.00 5417 2/15/18 Pat American Products 202456 35,000.00 5418 2/19/18 Pat Giant Wholesale 555874 20,000.00 5418 2/19/18 Pat Giant Wholesale 555902 20,000.00 418 2/19/18 Pat Giant Wholesale 555916 37,500.00 5419 2/19/18 Pat Charleston 300082 55,000.00 5419 2/19/18 Pat Charleston 300091 10,000.00 5420 2/24/18 Chris Alpha 100525 500.00 Product Standards Inventory Information Purchasing Information Accounts Payable Summary + - + 100%