no specific order but these are additional info

Assignment 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 logged and approved for payment if the full quantity of the SKU has been received 1) Using the information provided, calculate the Materials Price and Materials Quantity variance for each component/material for 2021. The beginning and ending inventory accounts for each product (units of output) are provided below: Beginning Inventory Count Ending Inventory Count Units Sold X370A 5,040 4,040 18,220 2410B 3,130 2,005 17,000 The company uses FIFO to value all inventory 2) Describe the procedures used to calculate the variances (not to exceed three pages). Include all steps required, along with any required notes for clarification. (Assume this will be used by someone who knows excel but not management accounting). Requirements This is a group assignment. Each group needs to submit your assignment electronically to me via iCollege by 11:59 pm on Friday, 04/23/2021. Each group needs to submit: your variance analysis for Question #1 in an Excel file, and (ii) your answer to Question #2 in a Word file. Invoice Received Vendor 100057 12/20 Technical Innovations 100% 12/9/20 Alpha 10056 12920 Alplu 10056 12/9/20 Alpha 10056 12/9/20 Alpha 10070 12/28/20 Alpha 10056 12/920 Alpha 10056 12/9/20 Alpha 100059 12/14/20 Technical Innovations 1000598 12/14/20 Technical Innovations 384 12/17/20 Giant Wholesale 384 12/17/20 Giant Wholesale 384 12/17/20 Giant Wholesale 603 12/20/20 American Products 10078 1/321 Alpha 10078 1/3 21 Alpha 10078 1/321 Alpha 10078 1/321 Alplus 1000613 ) 1/7/21 Technical Innovations 405 1/721 Giant Wholesale BIN 1/7/21 Giant Wholesale OR 1/721 unt Wholesale 1000000 1/16/21 Technical Innovations 10000 1/1621 Technical Innovations 10125 1/18/21 Alpha 10125 1/1N21 Alpha 10125 1/18/21 Alpha 10140 2421 Alpha 10125 1/1821 Alpha 609 1/20/21 American Products 1001111 1/31/21 Technical Innovations 1001111 1/31/21 Technical Innowions 1001111 1/31/21 Technical Innovations 10140 2421 Alphus 10140 2/4/21 Alpha 10140 2421 Alpha 10140 2/4/21 Alpha 10140 2421 Alpha 9000456 2/20/21 Limited Stock 9000456 2/2021 Limited Stock 101N 2/1021 Alpha 10181 2/1021 Alpha 1018 3/1021 Alpha 1018 2/1021 Alpha 10181 2/1021 Alpha 611 2/2021 American Products 451 2/2121 Giant Wholesale 451 2/2321 Gant Wholesale 451 22121 Giant Wholesale 10.000 2/2021 Alpha 101200 2/20/21 Alpha 10200 2/2621 Alpha 10300 2/28/21 Alpha 1020 3/321 Alpha 10200 2/28/21 Alpha 10200 2/28/21 Alpha 1001258 34/21 Technical Innovations 1001258 3:421 Technical Innovations 10300 3/1821 Alpha 10300 3/10/21 Alpha 10300 3/18/21 Alpha 61% 32021 American Products SKU Purchase order Total Price Paid 80560 3.335 Yes 100525 SO 645 Yes 101652 1.500 Yes 10900 500 150 Yes 110852 5200 1.725 Yes 111568 5400 2.950 Yes 118741 $400 3.500 Yes 119561 Se IN Yox 25600 S01 15.000 Yes $25608 S01 15.000 Yes S55874 503 LORS Yes 555902 580 675 Yes 555916 200 Yes 202456 5804 376,250 Yes 100525 645 Yes 101652 505 300 Yes 10900 175 Yes 119561 Se 10 Yes 356 SA R90 Yes 555874 5 900 Yes 555902 50 1.560 Yes 555916 2.925 Yes 825600 5000 15.000 Yes 825605 SA 15.000 Yes 101652 5410 100 Yes 10900 5410 1.150 Yes 110 5410 230 Yes 111568 5410 T15 Yes 118741 500 3. Yes 200456 5411 376250 Yes 825600 5403 15.650 Yes 35605 5413 15.6.50 Yes 2560 5413 15.440 Yes 100525 5414 645 Yes 101652 5414 So Yes TON900 5414 1.750 Yes 111568 5414 T15 Yes 119561 5414 1.00 Yes 100525 5415 2.000 Yes 110852 5415 4,000 Yes 100525 5416 645 Ve 101652 125 Yes TO900 350 Yes 118741 5416 3.780 Yes 119561 $416 360 Yes 203456 5612 376,150 No 555874 5418 900 Yes 555902 5418 1560 Yes 555916 2.996.25 Yes 100525 5430 645 Yes 101652 5430 35 Yes TON900 5430 400 Yes 110NS2 5430 345 Yes 111568 SE30 T15 Yes 118741 5630 3.10 Yes 119561 5420 100 Yew 25600 5421 15.450 No 325605 5421 15.650 No 100525 5423 645 No 101652 5423 SO No JON900 5423 400 No 203456 376150 No 2560 100 101653 108900 1102 111568 118741 119561 1.750 500 1.000 5.000 1.500 5399 5400 5400 5400 5400 5400 5400 5400 5401 5401 5403 5403 5403 5404 5405 $405 5405 5405 5406 540N 5408 540N 5409 5409 5410 5410 100 5.000 5.000 15.000 15.000 15.000 35.000 555874 55590 559916 203456 100585 101653 10 119561 200 100 5.000 555874 555902 559916 25600 39.500 5.000 5.000 200 1.000 200 5410 101652 108900 1102 11156 11741 2000 35.000 2560 12/4/20 Alex 12/5/20 Chris 12/5/20 Chris 12/3/20 Chris 12/5/20 Chris 12/5/20 Chris 12/5/20 Chris 12/3/20 Chris 12/9/20 Alex 12/9/20 Alex 12/12/20 PM 12/12/20 PM 12/12/20 Pa 12/12/20 Pat 12/28/20 Chris 12/28/20 Chris 12/28/20 Chris 12/28/20 Chris 1/321 Alex 11521 Par 1521 Par 1:521 Par 1/11/21 Alex 1/11/21 Alex 1/14/21 Chris 1/14/21 Chris 1/14/21 Chris 1/14/21 Chris 1/14/21 Chris 1/15/21 Pat 1/28/21 Alex 1/28.21 Alex 1/28/21 Alex 1/30/21 Chris 1/3021 Chris 1/3021 Chris 1/30/21 Chris 1/3621 Chris 1/3121 Chris 1/31/21 Chris 21621 Chris 2621 Chris 2/621 Chris 2/6/21 Chris 2/621 Chris 2/15/21 Pat 2/1921 PM 2/1921 Pa 2/19/21 Pas 2/24/21 Chris 2/24/21 Chris 2/24/21 Chris 2/24/21 Chris 2/24/21 Chris 2/24/21 Chris 2/24/21 Chris 3/1/21 Alex 3/1/21 Alex 3/13/21 Chris 3/1321 Chris 3/13/21 Chris 3/1521 Par 5410 5410 $411 5413 5413 5413 5414 5414 5414 5414 5414 5415 5415 5416 5416 5416 5416 5416 5417 5418 5418 5418 5420 5420 5420 5420 Technical Innovatie Alpha Alpha Alpha Alpha Alpha Alpha Alpha Technical Innovations Technical Innovation Giant Wholesale Giant Wholesale Giant Wholesale American Products Alpha Alpha Alpha Alpha Technical Innovations Giant Wholesale Giant Wholesale Giant Wholesale Technical Innovations Technical Innovations | Alpha Alpha Alpha Alpha Alpha American Products Technical Innovations Technical Innovations Technical Inno Alpha Alpha Alpha Alpha Alpha Limited Stock Limited Snack Alpha Alpha Alpha Alpha Alpha American Products Giant Wholesale Giant Wholesale Giant Wholesale Alpha Alpha Alpha Alpha Alpha Alphu Alpha Technical Innovations Technical Innovations Alpha Alpha | Alpha American Products S000 16.000 500 1.000 1.000 500 3560 100525 101652 108900 11156 119561 100525 11052 100525 101652 10900 116741 119561 2.000 1000 500 Soo 95.000 20.000 37.500 500 500 300 soo 5420 555874 555902 555016 100535 101652 10900 110652 111568 118741 119961 2600 25605 100535 101652 108900 203456 5420 5420 5421 5421 5423 5423 5423 5424 1.000 5.000 5.000 500 1.000 2.500 35.000 Product Standards Inventory Information Purchasing Information Accounts Payable SKU Quantity 1.750 SOO Purchase order PO Date Purchasing. Vendor 5199 12/4/20 Alex Technical Innovations 5400 12/5/20 Chris Alpha 5.400 12/5/20 Chris Alpha 5.400 12/5/20 Chris Alpha 5.400 12/5/20 Chris Alpha 5.100 12/5/20 Chris Alpha 5000 12/5/20 Chris Alpha 5.400 12/5/20 Chris Alpha 5401 129/20 Alex Technical Innovations S.401 12/9/20 Alex Technical Innovations 5403 12/12/20 Pat Giant Wholesale 5.403 12/12/20 Par Giant Wholesale 5401 12/12/20 Pa Giant Wholesale 5.404 12/12/20 PM American Products 5405 12/28/20 Chris Alpha 5405 12/28/20 Chris Alpha 5405 12/28/20 Chris Alpha S-LOS 12/28/20 Chris Alpha 5406 1/3/21 Alex Technical Innovations 5411 1SP Get Wholesale 825608 100525 101652 108900 110852 111568 118741 119561 825600 825605 555874 333902 555916 202456 100525 101652 108900 119561 25 5587 1.000 5,000 1.500 2,000 2,000 100 5,000 5.000 15.000 15.000 15,000 35,000 500 200 100 100 5.000 MANI Product Standards Inventory Information Purchasing Information Accounts Payable Summa SKU Standard Cont Standard Material per Unt of Product Product X370A X370A X370A X370A X370A X370 X370 X3704 X370A 24107 ZA101 Z4I0B 2410 2410B I'rimary Vendor 100$25 Alpha 101652 Alpha 108900 Alpha 202456 American Products 555874 Guant Wholesale 555902 Giant Wholesale N25600 Technical Innovations X2S60 Technical Innovations 825608 Technical Innovations 110852 Alpha 111568 Alpha 118741 Alpha 119561 Alpha 555916 Giant Wholesale Standard Material Unit 1.25 15 175 10.75 N/A 0.05 008 NA NA 1.5 NA Terms 0.2 Net 30 02 Net 10 05 Nut 30 6 Neto 2 Net 10 2 Netto 1 Netto Net 10 I Neto 0.2 Net 30 02 Net 30 04 Net 30 01 Net 10 4 Net 140 1.79 1.79 0.08 Product Standards Inventory Information Purchasing Info Ending Inventory 405 1,005 4,305 1.335 1,145 2,045 SKU Primary Vendor 100525 Alpha 101652 Alpha 108900 Alpha 110852 Alpha 111568 Alpha 118741 Alpha 119561 Alpha 202456 American Products 555874 Giant Wholesale 555902 Giant Wholesale 555916 Giant Wholesale 825600 Technical Innovations 825605 Technical Innovations 825608 Technical Innovations Standard Material Unit ft ft ft ft ft ft ft N/A ft ft ft N/A N/A N/A Beginning Inventory 395 855 4,985 1.235 1,340 1.980 80 3,972 10.101 12,760 12,520 2.976 2,932 951 685 5,571 14,905 27,090 30,980 609 694 4.173