Answer Happy

I need major help entering the answers in excel formula onexcel.
d 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: Work in process, beginning Units completed during the months Work in process, ending Costs to account for: Beginning work in process Materials added Conversion costs incurred Check figure: $ $ $ Amount reported on the balance sheet as Finished goods inventory $ 760,200 Units 60,000 210,000 30,000 Total 94,800 151,200 600,300 Percent Conversion 40% 70% Focus
A B Data Section: C Ready Work in process, beginning Units completed during the months Work in process, ending Beg. Work in process Started & Completed Ending Work in process Total Jx Costs to account for: Beginning work in process Materials added Conversion costs incurred Total costs to be accounted for Sheet1 D Whole Units FORMULA 2 FORMULA 3 FORMULA 3 Sheet2 $ $ $ E Units 60,000 210,000 30,000 Total 94,800 151,200 600,300 FORMULA 1 Direct Mat. % Added During the Month FORMULA 5 FORMULA 6 FORMULA 7 Cost per equivalent unit Sheet3 F Percent Conversion 40% 70% + Direct Mat. Equiv. Units % Added During the FORMULA 8 Month FORMULA 12 FORMULA 13 FORMULA 10 FORMULA 14 FORMULA 9 Direct Mat FORMULA 11 G H HINT: Formulas in RED will be in units Forumlas in BLUE will percentages Formulas in GREEN will be in dollars K To find started and completed: Completed units - beginning inventory Started during the month-ending Inventory Cost assignment Conversion Beginning Direct Equiv. Units Inventory Materials Conversion FORMULA 15 FORMULA 19 FORMULA 22 FORMULA 2! FORMULA 16 FORMULA 20 FORMULA 23 FORMULA 21 FORMULA 17 FORMULA 21 FORMULA 24 FORMULA 21 $0 $0 $0 Conversion FORMULA 18 L Total $0 $0 $0 $0 Amount reported on the balance sheet as: Finished goods inventory FORMULA 28 Work In Process inventory FORMULA 29 M