please assist.

B F G H Assignment Standard Material Unit it ft ft ft ft ft ft N/A ft ft ft N/A / N/A D E Beginning Inventory Ending Inventory 395.00 405.00 855.00 1,005.00 4,985.00 4,305.00 1,235.00 1,335.00 1,340.00 1,145.00 1,980.00 2,045.00 80.00 685.00 3.972.00 5.571.00 10,101.00 14,905.00 12,760.00 27,090.00 12.520.00 30,980.00 2,976.00 609.00 2,932.00 694.00 951.00 4,173.00 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 N/A SKU Primary Vendor 100525 Alpha 3 101652 Alpha 108900 Alpha 5 110852 Alpha 6 111568 Alpha 7 118741 Alpha 8 119561 Alpha 9 202456 American Products 10 555874 Giant Wholesale 11 555902 Giant Wholesale 12 555916 Giant Wholesale 13 825600 Technical Innovations 14 825605 Technical Innovations 15 825608 Technical Innovations 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 The beginning and ending inventory accounts for each product (units of output) are provided below: Beginning Inventory Count Ending Inventory Count Units Sold 5,040 4,040 18,220 X370A Z410B 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). B F G H Assignment Standard Material Unit it ft ft ft ft ft ft N/A ft ft ft N/A / N/A D E Beginning Inventory Ending Inventory 395.00 405.00 855.00 1,005.00 4,985.00 4,305.00 1,235.00 1,335.00 1,340.00 1,145.00 1,980.00 2,045.00 80.00 685.00 3.972.00 5.571.00 10,101.00 14,905.00 12,760.00 27,090.00 12.520.00 30,980.00 2,976.00 609.00 2,932.00 694.00 951.00 4,173.00 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 N/A SKU Primary Vendor 100525 Alpha 3 101652 Alpha 108900 Alpha 5 110852 Alpha 6 111568 Alpha 7 118741 Alpha 8 119561 Alpha 9 202456 American Products 10 555874 Giant Wholesale 11 555902 Giant Wholesale 12 555916 Giant Wholesale 13 825600 Technical Innovations 14 825605 Technical Innovations 15 825608 Technical Innovations 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 The beginning and ending inventory accounts for each product (units of output) are provided below: Beginning Inventory Count Ending Inventory Count Units Sold 5,040 4,040 18,220 X370A Z410B 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)