ACT 126 G> Assignments > Chapter 18 Homework-Assignment #2 2019 Summer Session 2 Chapter 18 Homework - Assignment #2 Submit Assignment Home Announcements Submitting a file upload Due Saturday by 11:59pm Points 20 Available until Jul 6 at 11:59pm Modules Grades If you haven't read the Chapter 18 Information page, please do that now. For this assignment, complete a cost of production report using both the weighted average and FIFO methods using the information in Problem 18-2B in the book (page 878). I have created a template for you to use: Chapter 18-Process Costing Templates.xlsx. Please be sure to complete both tabs in this spreadsheet. The first tab is for the weighted People Chat average method and the second tab is for the FIFO method. Please do not change the format of anything in this spreadsheet. Submit it through this link by the due date. If you have questions about it, please email me before the due date, as it is difficult to answer your questions the night it is due. I will grade it within 24 hours of your submission so you can identify any problem areas before you take the exam. 6 Chapter 18-Process Costing Templates (6) Protected View) Excel (Unlicensed Product) Sign in File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do iPROTECTED VIEW Be careful-files feom the Internet can contain vinuses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing A E G H 1 Weighted Average Method 3 Step 1-Calculate the physical units to account for. Units in beginning WIP Inventory Units started 5 Beginning WIP 7 Units Started Total units tD account for 10 11 Step 2-Calculate the physical units accounted for 12 Units transferred out+ Units in ending WIP Inventory 13 14 15 Beginning WIP 16 Started and Completed 17 Ending WIP Total units accounted for 18 19 20 21 Step 3- Calculate the equivalent units of production 22 23 Total Direct Material Conversion 24 Beginning WIP 25 Started and Completed 26 Ending WIP Weighted Average FIFO Ready Type here to search 100% e 1:59 PM da 7/5/2019 E Chapter 18-Process Costing Templates () Protected View) Excel (Unlicensed Product) Sion in Tell me what you want to do File Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you nend to edt, it's sales to stay in Protected View Enable Editing CR G E 22 23 Total Direct Material Conversion Beginning WIP 25 Started and Completed 26 Ending WIP 24 27 Total EUP 28 29 30 Step 4-Calculate the total cost to account for 31 Cost in beginning WIP Inventory 4 Cost of current period 32 Total Materiol Costs: Total Conversion Costs 33 34 Beginning Inventory DM cost DM issued during June 37 Total Material Costs: Beginning inventory conversion cost Direct labor incurred during lune 35 36 Overhead applied during June 38 Total Conversion Costs: 39 Totol Cost 40 41 Material+Conversion 42 43 44 Step 5- Calculate the cost per equivalent unit of production. 47 Total material costs Total converson costs Weighted Average FIFO Ready Excel (Unlicensed Product) Sign in Chapter 18-Process Costing Templates (6) [Protected View] Tell me what you want to do Review View Help Formulas Data Insert Page Layout File Home Enable Editing Be carefu-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View PROTECTED VIEW fr C8 G H E F C A Total Cost 40 Material +Conversion 41 42 43 44 Step 5-Calculate the cost per equivalent unit of production. 45 46 Total converson costs 47 Total material costs EUP EUP 48 Conversion cost/EUP Material cost/EUP 49 50 Total Cost/EUP 51 52 53 54 Step 6-Assign the costs to inventory accounts 55 Transferred out (to FG Inventory or to the next department) AND Ending WIP Inventory 56 57 58 Cost of units in FG: W of units in FG 59 Total cost per EUP 60 61 Cost of units in FG 62 Cost of units in WIP 63 Total cost 64 Weighted Average FIFO Ready 4 e Type here to search Chapter 18 Process Costing Templates (6) IProtected View] Excel (Unlicensed Product) Sign in File Home Insert Page Layout Formulas Q Tell me what you want to do Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses, Unless vou need to edit, it's safer to stay in Protected View Enable Editing C8 E D G 40 Total Cost 41 Material+ Conversion 42 43 44 Step 5-Calculate the cost per equivalent unit of production. 45 46 Total material costs 47 Total converson costs 48 EUP EUP Material cost/EUP 49 Conversion cost/EUP 50 Total Cost/EUp 51 52 53 54 Step 6-Assign the costs to inventory accounts 55 Transferred out (to FG Inventory or to the next department) AND Ending WIP Inventory 56 57 58 Cost of units in FG: # of units in FG Total cost per EUP 6C Cost of units in FG 61 62 Cost of units in WIP 63 Total cost Weighted Average FFO Ready Tune here to cearch ACT 126 G> Assignments > Chapter 18 Homework-Assignment #2 2019 Summer Session 2 Chapter 18 Homework - Assignment #2 Submit Assignment Home Announcements Submitting a file upload Due Saturday by 11:59pm Points 20 Available until Jul 6 at 11:59pm Modules Grades If you haven't read the Chapter 18 Information page, please do that now. For this assignment, complete a cost of production report using both the weighted average and FIFO methods using the information in Problem 18-2B in the book (page 878). I have created a template for you to use: Chapter 18-Process Costing Templates.xlsx. Please be sure to complete both tabs in this spreadsheet. The first tab is for the weighted People Chat average method and the second tab is for the FIFO method. Please do not change the format of anything in this spreadsheet. Submit it through this link by the due date. If you have questions about it, please email me before the due date, as it is difficult to answer your questions the night it is due. I will grade it within 24 hours of your submission so you can identify any problem areas before you take the exam. 6 Chapter 18-Process Costing Templates (6) Protected View) Excel (Unlicensed Product) Sign in File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do iPROTECTED VIEW Be careful-files feom the Internet can contain vinuses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing A E G H 1 Weighted Average Method 3 Step 1-Calculate the physical units to account for. Units in beginning WIP Inventory Units started 5 Beginning WIP 7 Units Started Total units tD account for 10 11 Step 2-Calculate the physical units accounted for 12 Units transferred out+ Units in ending WIP Inventory 13 14 15 Beginning WIP 16 Started and Completed 17 Ending WIP Total units accounted for 18 19 20 21 Step 3- Calculate the equivalent units of production 22 23 Total Direct Material Conversion 24 Beginning WIP 25 Started and Completed 26 Ending WIP Weighted Average FIFO Ready Type here to search 100% e 1:59 PM da 7/5/2019 E Chapter 18-Process Costing Templates () Protected View) Excel (Unlicensed Product) Sion in Tell me what you want to do File Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you nend to edt, it's sales to stay in Protected View Enable Editing CR G E 22 23 Total Direct Material Conversion Beginning WIP 25 Started and Completed 26 Ending WIP 24 27 Total EUP 28 29 30 Step 4-Calculate the total cost to account for 31 Cost in beginning WIP Inventory 4 Cost of current period 32 Total Materiol Costs: Total Conversion Costs 33 34 Beginning Inventory DM cost DM issued during June 37 Total Material Costs: Beginning inventory conversion cost Direct labor incurred during lune 35 36 Overhead applied during June 38 Total Conversion Costs: 39 Totol Cost 40 41 Material+Conversion 42 43 44 Step 5- Calculate the cost per equivalent unit of production. 47 Total material costs Total converson costs Weighted Average FIFO Ready Excel (Unlicensed Product) Sign in Chapter 18-Process Costing Templates (6) [Protected View] Tell me what you want to do Review View Help Formulas Data Insert Page Layout File Home Enable Editing Be carefu-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View PROTECTED VIEW fr C8 G H E F C A Total Cost 40 Material +Conversion 41 42 43 44 Step 5-Calculate the cost per equivalent unit of production. 45 46 Total converson costs 47 Total material costs EUP EUP 48 Conversion cost/EUP Material cost/EUP 49 50 Total Cost/EUP 51 52 53 54 Step 6-Assign the costs to inventory accounts 55 Transferred out (to FG Inventory or to the next department) AND Ending WIP Inventory 56 57 58 Cost of units in FG: W of units in FG 59 Total cost per EUP 60 61 Cost of units in FG 62 Cost of units in WIP 63 Total cost 64 Weighted Average FIFO Ready 4 e Type here to search Chapter 18 Process Costing Templates (6) IProtected View] Excel (Unlicensed Product) Sign in File Home Insert Page Layout Formulas Q Tell me what you want to do Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses, Unless vou need to edit, it's safer to stay in Protected View Enable Editing C8 E D G 40 Total Cost 41 Material+ Conversion 42 43 44 Step 5-Calculate the cost per equivalent unit of production. 45 46 Total material costs 47 Total converson costs 48 EUP EUP Material cost/EUP 49 Conversion cost/EUP 50 Total Cost/EUp 51 52 53 54 Step 6-Assign the costs to inventory accounts 55 Transferred out (to FG Inventory or to the next department) AND Ending WIP Inventory 56 57 58 Cost of units in FG: # of units in FG Total cost per EUP 6C Cost of units in FG 61 62 Cost of units in WIP 63 Total cost Weighted Average FFO Ready Tune here to cearch