solve ending work in process
20162_ACG2071_ProcessWorksheet Q Search Sheet Home Data Review View *+ Share A Insert Page Layout Formulas Arial 10 - A- A- BIVA E General 2 ' rap Text A Wrap Text Merge & Center Insert Delete Format Paste $ % ) Conditional Format Formatting as Table Cell Styles Sort & Filter Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. 020 x fx Data Section: Percent Conversion 40% Units 60.000 210,000 30 000 Work in process, beginning Units completed during the months Work in process, ending 210.00 70% 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 15 Beginning work in process Materials added Conversion costs incurred Total costs to be accounted for Total 94.800 151,200 600 300 846,300 $ Direct Mat. % Added During the Month Cost assignment Conversion% Direct Mat. Added During Conversion Beginning Direct Equiv. Units the Month Equiv. Units Inventory Materials Conversion 36,000 94,800 0 1 04,400 150.000 100% 150,000 0 126,000 435,000 FORMULA 10 70% FORMULA 17 FORMULA 21 FORMULA 24 FORMULA 27 150,000 186,000 FORMULA 22 FORMULA 25 $539,400 Whole Units 60,000 150,000 Beg. Work in process Started & Completed Ending Work in process Total Total S199,200 $561,000 100% 100% 210,000 $760,200 Direct Mat. Cost per Lequivalent unit FORMULA 11 Conversion FORMULA 18 Amount reported on the balance sheet as: Finished goods Inventory FORMULA 28 Work in Process inventory FORMULA 29 Sheet1 Sheet2 Sheet3 + Enter 5 E Zoorn level. Click to open the Zoom dialog box. - 100% 20162_ACG2071_ProcessWorksheet Q Search Sheet Home Data Review View *+ Share A Insert Page Layout Formulas Arial 10 - A- A- BIVA E General 2 ' rap Text A Wrap Text Merge & Center Insert Delete Format Paste $ % ) Conditional Format Formatting as Table Cell Styles Sort & Filter Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. 020 x fx Data Section: Percent Conversion 40% Units 60.000 210,000 30 000 Work in process, beginning Units completed during the months Work in process, ending 210.00 70% 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 15 Beginning work in process Materials added Conversion costs incurred Total costs to be accounted for Total 94.800 151,200 600 300 846,300 $ Direct Mat. % Added During the Month Cost assignment Conversion% Direct Mat. Added During Conversion Beginning Direct Equiv. Units the Month Equiv. Units Inventory Materials Conversion 36,000 94,800 0 1 04,400 150.000 100% 150,000 0 126,000 435,000 FORMULA 10 70% FORMULA 17 FORMULA 21 FORMULA 24 FORMULA 27 150,000 186,000 FORMULA 22 FORMULA 25 $539,400 Whole Units 60,000 150,000 Beg. Work in process Started & Completed Ending Work in process Total Total S199,200 $561,000 100% 100% 210,000 $760,200 Direct Mat. Cost per Lequivalent unit FORMULA 11 Conversion FORMULA 18 Amount reported on the balance sheet as: Finished goods Inventory FORMULA 28 Work in Process inventory FORMULA 29 Sheet1 Sheet2 Sheet3 + Enter 5 E Zoorn level. Click to open the Zoom dialog box. - 100%
