i need major help entering the answers in excel formula into excel! updated with numbers on side of excel.
AutoSave OFF ES MOD 3 - Saved to my Ma Home Insert Draw Page Layout Formulas Data Review View Tell me Arial v 10 - A ' V ab Wrap Text General LA v Paste ov V a. Av FEE Merge & Center $ % ) od Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates M5 x fx A B D E F G H I K L 5 Formula Bar Data Section: 8 Percent Conversion 40% Units 60,000 210,000 30,000 Work in process, beginning Units completed during the months Work in process, ending 70% HINT: Formulas in RED will be in units Forumlas in BLUE will percentages Formulas in GREEN will be in dollars 9 10 11 12 13 14 15 16 17 18 19 Costs to account for: To find started and completed: Completed units beginning inventory Started during the month - ending inventory Beginning work in process Materials added Conversion costs incurred Total costs to be accounted for $ $ $ $ Total 94,800 151,200 600,300 FORMULA 1 20 21 22 23 Cost assignment % Added Direct Mat. % Added During Whole Units the Month Beg. Work in process FORMULA 2 FORMULA Started & Completed FORMULA 3 FORMULA 6 Ending Work in process FORMULA 3 FORMULA 7 7 Total . Direct Mat During the Conversion Beginning Direct Equiv. Units Month Equiv. Units Inventory Materials Conversion FORMULA 8 FORMULA 12 FORMULA 15 FORMULA 19 FORMULA 22 FORMULA 2! FORMULA 9 FORMULA 13 FORMULA 16 FORMULA 20 FORMULA 23 FORMULA 2 FORMULA 10 FORMULA 14 FORMULA 17 FORMULA 21 FORMULA 24 FORMULA 27 $0 $0 $0 Total $0 SO 50 so Direct Mat Cost per FORMULA 11 equivalent unit Conversion FORMULA 18 Amount reported on the balance sheet as: Finished goods Inventory FORMULA 28 Work in Process Inventory FORMULA 29 24 25 26 27 26 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Sheet1 Sheet2 Sheet3 + MacBook Air Jx A B D E F G H 1 K L M Data Section: Percent Conversion 40% Units 60,000 210,000 30,000 Work in process, beginning Units completed during the months Work in process, anding 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 Beginning work in process Materials added Conversion costs incurred Total costs to be accounted for Total $ 94,800 $ 151,200 $ 600,300 FORMULA 1 Direct Mat. % Added During Whole Units the Month Beg. Work in process FORMULA2 FORMULA 5 Started & Completed FORMULA 3 FORMULA 6 Ending Work in process FORMULA 3 FORMULA 7 Total Cost assignment % Added Direct Mat During the Conversion Beginning Direct Equiv. Units Month Equiv. Units Inventory Materials Conversion FORMULAS FORMULA 12 FORMULA 15 FORMULA 19 FORMULA 22 FORMULA 2! FORMULA 9 FORMULA 13 FORMULA 16 FORMULA 20 FORMULA 23 FORMULA 2 FORMULA 10 FORMULA 14 FORMULA 17 FORMULA 21 FORMULA 24 FORMULA 21 $0 $0 $0 Total $0 so $0 $0 Direct Mat Cost per FORMULA 11 equivalent unit Conversion FORMULA 18 Amount reported on the balance sheet as: Finished goods Inventory FORMULA 28 Work In Process Inventory FORMULA 29 Sheet1 Sheet2 Sheet3 + Ready 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% Work in process, beginning Units completed during the months Work in process, ending Units 60,000 210,000 30,000 70% Costs to account for: Total Beginning work in process Materials added Conversion costs incurred $ $ $ 94,800 151,200 600,300 Check figure: Amount reported on the balance sheet as Finished goods inventory $ 760,200 FOC
