Insert a code module and write a sub (subroutine) named part3 that will perform the operations to meet the following problem definition. Your program must meet all the specifications described below to receive full credit. A 1 Inventory Analysis 2 Company Name Beginning Inventory Value Year End Inventory Value Annual Cost of Goods Sold Days to Turnover Inventory Inventory Turnover Ratio Use the interface provided to you on the worksheet named Part 3 (pictured left). You will write 2 subs: one (sub part3a) to perform the operations needed to analyze a company's inventory turnover and another (sub part3b) to clear the inputs (and outputs) in column C. Each button will have a macro assigned to it to perform the functionality specified by the button's label. Analysis Date: 11 12 Run Analysis In the first subroutine (part3a), create a solution that takes the input from Excel (C3, C4, and C5) and writes the code to calculate the "Days to Turnover Inventory" and "Inventory Turnover Ratio" and output the data to the Excel worksheet (cells C6 and C7). It will also output the Analysis Date to C9. 13 14 15 Clear Data 16 17 The formulas needed for the subroutine include: Days to Turnover Inventory = Year End Inventory Value and dividing it by the Annual Cost of Goods Sold times 365. Inventory Turnover Ratio = is calculated by dividing 365 by the Days to Turnover Inventory. Analysis Date = current date (The current date can be assigned to a cell using the VBA keyword DATE - which returns the computer's system date.) The second subroutine (part3b), triggered by the user clicking on the "Clear Data" button, should clear the contents of C2:C9. Your output should be formatted to look similar to the screen shot below: A 1 Inventory Analysis Notice the centering of the data in Column C. Also notice that the data "fits" and the numeric formatting applied to cells C3 through C5 displays the values as currency with no decimal places. 2 Company Name ABC Center $42,127 Beginning Inventory Value Year End Inventory Value $5,920 Annual Cost of Goods Sold $31,250 Use the test data I have provided in the adjacent screen shot to test your code. Days to Turnover Inventory 69 Inventory Turnover Ratio 5 Here is an additional set of test values: Analysis Date: 06/08/2022 $50,000 $25,000 Beginning Inventory Value Year End Inventory Value Annual Cost of Goods Sold Days to Turnover Inventory Inventory Turnover Ratio $75,000 122 3 3 4 5 6 7 8 9 10 3 4 5 6 7 8 9 10 11 12 Run Analysis 13 14 15 Clear Data 16 NOTE. Bam Galle DO NOT dinantly Insert a code module and write a sub (subroutine) named part3 that will perform the operations to meet the following problem definition. Your program must meet all the specifications described below to receive full credit. A 1 Inventory Analysis 2 Company Name Beginning Inventory Value Year End Inventory Value Annual Cost of Goods Sold Days to Turnover Inventory Inventory Turnover Ratio Use the interface provided to you on the worksheet named Part 3 (pictured left). You will write 2 subs: one (sub part3a) to perform the operations needed to analyze a company's inventory turnover and another (sub part3b) to clear the inputs (and outputs) in column C. Each button will have a macro assigned to it to perform the functionality specified by the button's label. Analysis Date: 11 12 Run Analysis In the first subroutine (part3a), create a solution that takes the input from Excel (C3, C4, and C5) and writes the code to calculate the "Days to Turnover Inventory" and "Inventory Turnover Ratio" and output the data to the Excel worksheet (cells C6 and C7). It will also output the Analysis Date to C9. 13 14 15 Clear Data 16 17 The formulas needed for the subroutine include: Days to Turnover Inventory = Year End Inventory Value and dividing it by the Annual Cost of Goods Sold times 365. Inventory Turnover Ratio = is calculated by dividing 365 by the Days to Turnover Inventory. Analysis Date = current date (The current date can be assigned to a cell using the VBA keyword DATE - which returns the computer's system date.) The second subroutine (part3b), triggered by the user clicking on the "Clear Data" button, should clear the contents of C2:C9. Your output should be formatted to look similar to the screen shot below: A 1 Inventory Analysis Notice the centering of the data in Column C. Also notice that the data "fits" and the numeric formatting applied to cells C3 through C5 displays the values as currency with no decimal places. 2 Company Name ABC Center $42,127 Beginning Inventory Value Year End Inventory Value $5,920 Annual Cost of Goods Sold $31,250 Use the test data I have provided in the adjacent screen shot to test your code. Days to Turnover Inventory 69 Inventory Turnover Ratio 5 Here is an additional set of test values: Analysis Date: 06/08/2022 $50,000 $25,000 Beginning Inventory Value Year End Inventory Value Annual Cost of Goods Sold Days to Turnover Inventory Inventory Turnover Ratio $75,000 122 3 3 4 5 6 7 8 9 10 3 4 5 6 7 8 9 10 11 12 Run Analysis 13 14 15 Clear Data 16 NOTE. Bam Galle DO NOT dinantly