I need major help entering in the answers by using excel formulas

02 fx 1 M NO A B D E F G H 1 Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in number format will receive a 0 4 PROCESS/HOWSE Data Section B Work in process, beginning Units completed during the months Work in process, ending Percent Conversion 40% Units 80,000 210,000 30,000 10 11 12 13 14 15 16 70% HINT: Formulas in RED will be in units Forumlas in BLUE will percentages Formulas in GREEN will be in dollars Costs to account for To find started and completed: Completed units beginning Inventory Started during the month - ending inventory 13 18 19 20 21 22 23 Beginning work in process Materials added Conversion costs incurred Total costs to be accounted for Total $ 94,800 5 151.200 5 600,300 FORMULA 1 Direct Mat% Added During Whole Units the Month Beg. Work in process FORMULA2 FORMULA 5 Started & Completed FORMULAI FORMULA Ending Work in process FORMULA FORMULA Total Contassignment % Added Direct Mat During the Conversion Beginning Direct Equiv. Units Month Equiv. Units Inventory Materials Conversion FORMULA E FORMULA 12 FORMULA 15 FORMULA 19 FORMULA 22 FORMULA 2! FORMULAS FORMULA 13 FORMULA 16 FORMULA 20 FORMULA 23 FORMULA 21 FORMULA 10 FORMULA 14 FORMULA 17 FORMULA 1 FORMULA 24 FORMULA 23 $0 $0 $0 24 25 26 27 28 20 30 31 32 33 44 35 Total 50 SO $0 50 Cost per coulvalent unit Direct Mat FORMULA 11 Conversion FORMULA 10 Amount reported on the balance sheet as: Finished goods inventory FORMULA 28 Work in Process Inventory FORMULA 29 Sheet1 Sheet2 Sheet3 + improvements, choose Check for Updates. Module 3 Excel Spreadsheet Instructions In the Module 1 MFG spreadsheet, you used formulas to complete the Excel. By using these formulas instead of directly inputting the answers, you are creating a spreadsheet where the inputs can be changed and your outputs will be automatically updated. In this module, we are going to explore this concept further. Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update. For this assignment, please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Data set #1 Inputs: Percent Conversion 40% Units 60,000 210,000 30,000 Work in process, beginning Units completed during the months Work in process, ending 70% Costs to account for: Total 94,800 151,200 600,300 Beginning work in process $ Materials added $ Conversion costs incurred $ Check figure: Amount reported on the balance sheet as Finished goods inventory $ 760,200 Focu Data set #2 Inputs: Percent Conversion 40% Units 20,000 215,000 25,000 Work in process, beginning Units completed during the months Work in process, ending 55% Costs to account for: Total 60,000 151.200 550,200 Beginning work in process $ Materials added $ Conversion costs incurred $ Check figure: Amount reported on the balance sheet as Finished goods inventory $ 709,948 Data set #3 Inputs: Percent Conversion 45% Units 5,000 97,000 7,500 Work in process, beginning Units completed during the months Work in process, ending 20% Costs to account for: Beginning work in process Materials added Conversion costs incurred Total costs to be accounted for $ $ $ Total 21,800 124.000 350.000 495,800 5 Check figure: Amount reported on the balance sheet as Finished goods inventory 480,999