1 H K Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in numbers format will receive a 0. 4 PROCESS/HOWSE 6 7 8 Data Section: Work in process, beginning Units completed during the months Work in process, ending Units 50,000 210,000 30.000 Percent Conversion 40% 70% HINT: Formulas in RED will be in units Forumas In BLUE will percentages Formulas in GREEN will be in dollars Costs to account for: 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 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 5 5 5 Total 94.800 151,200 600,300 FORMULA 24 25 20 22 24 20 30 31 32 35 Cost assignment Direct Mat. % Conversion Added During Direct Mat. Added During Conversion Beginning Direct Whole Units the Month Equiv. Units the Month Equiv. Units Inventory Materials Conversion Total Beg. Work in process FORMULA2 FORMULAS FORMULAS FORMULA 12 FORMULA 15 FORMULA 1 FORMULA 22 FORMULA 25 50 Started & Completed FORMULAS FORMULA FORMULA FORMULA 1 FORMULA 16 FORMULA 20 FORMULA 23 FORMULA 28 Ending Work in process FORMULA FORMULAT FORMULA 10 FORMULA 14 FORMULA 17 FORMULA 1 FORMULA A FORMULA $0 Total 30 30 $0 $0 Direct Mat Conversion Amount reported on the balance sheet as Cost per FORMULA 11 FORMULA Finished goods inventory YORMULA 23 equivalent unit Work in Process inventory FORMULA Sheet She 1 Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in 2 3 4 PROCESS/HOWSE 5 6 7 Data Section: 8 9 Percent Conversion 40% Work in process, beginning Units completed during the months Work in process, ending Units 60,000 210,000 30,000 10 11 12 13 14 15 16 HINT: Formulas in RED will Forumlas in BLUE will Formulas in GREEN W 70% Costs to account for: To find started and com Completed units - Started during them 17 18 19 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 Beg. Work in process Started & Completed Ending Work in process Total Direct Mat. % Added During Whole Units the Month FORMULA 2 FORMULA 5 FORMULA 3 FORMULA 6 FORMULA 3 FORMULAZ Conversion % Direct Mat. Added During Conversion Beginning Equiv. Units the Month Equiv. Units Inventory FORMULAB FORMULA 12 FORMULA 15 FORMULA 19 FORMULA 9 FORMULA 13 FORMULA 16 FORMULA 20 FORMULA 10 FORMULA 14 FORMULA 17 FORMULA 21 $0 24 25 26 27 28 29 30 31 32 33 34 Direct Mat. Conversion Cost per FORMULA 11 FORMULA 18 equivalent unit Sheet1 Sheet2 Sheet3 Rat 4 must be used. Please be sure to submit your file as an Excel file. Any submissions in numbers format will receive a 0. Percent Conversion 40% months Units 60,000 210,000 30,000 70% HINT: Formulas in RED will be in units Forumlas in BLUE will percentages Formulas in GREEN will be in dollars Total To find started and completed: Completed units - beginning inventory Started during the month - ending inventory $ $ $ 94,800 151,200 600,300 FORMULA 1 d for Direct Mat. % Added During Whole Units the Month FORMULA 2 FORMULA 5 FORMULA 3 FORMULA 6 FORMULA 3 FORMULAZ Cost assignment Conversion% Direct Mat. Added During Conversion Beginning Direct Equiv. Units the Month Equiv. Units Inventory Materials Conversion FORMULA 8 FORMULA 12 FORMULA 15 FORMULA 19 FORMULA 22 FORMULA 25 FORMULAS FORMULA 13 FORMULA 16 FORMULA 20 FORMULA 23 FORMULA 26 FORMULA 10 FORMULA 14 FORMULA 17 FORMULA 21 FORMULA 24 FORMULA 27 $0 $0 $0 Total $0 $0 $0 $0 Direct Mat. Cost per Conversion FORMULA 18 FORMULA 11 Amount reported on the balance sheet as: Finished goods inventory FORMULA 28 Work in Process Inventory FORMULA 29 equivalent unit