Download the Applying Excel form and enter formulas in all cells that contain question marks.
For example, in cell B34 enter the formula "= B9".
After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text.
Check your worksheet by changing the beginning work in process inventory to 300 units, the units started into production during the period to 18,200 units, and the units in ending work in process inventory to 500 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $20.78 and the cost per equivalent unit for conversion should be $19.67. If you do not get these answers, find the errors in your worksheet and correct them. I need help with the formulas more than anything.
Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click "Save." You will use this worksheet to answer the questions in Part 2.
Beginning Work in process | ||||||
Units | 200 | |||||
Completion Materials | 55% | |||||
Completion Conversion | 30% | |||||
Costs in beginning work in process | ||||||
Material Cost | $ 9,600 | |||||
Conversion Cost | $ 5,575 | |||||
Units started | 5000 | |||||
Costs added | ||||||
Material Cost | $ 368,600 | |||||
Conversion Cost | $ 350,900 | |||||
Ending Work in process | ||||||
Units | 400 | |||||
Completion Materials | 40% | |||||
Completion Conversion | 25% | |||||
Material | Conversion | |||||
Units transferred | 4800 | 4800 | =B5+B11-B16 | =B26 | ||
Equivalent units in ending WIP | ||||||
Materials | 160 | =B16*B17 | ||||
Conversion | 100 | =B16*B18 | ||||
Equivalent units of production | 4960 | 4900 | =SUM(B26:B29) | =SUM(C26:C29) | ||
Material | Conversion | |||||
Cost of beginning work in process | $ 9,600 | $ 5,575 | =B9 | =B10 | ||
Cost added during the production | $ 368,600 | $ 350,900 | =B13 | =B14 | ||
Total Cost | $ 378,200 | $ 356,475 | =SUM(B34:B35) | =SUM(C34:C35) | ||
Equivalent units of production | 4960 | 4900 | =B30 | =C30 | ||
Cost per Equivalent unit | $ 76.25 | $ 72.75 | =B36/B37 | =C36/C37 | ||
Material | Conversion | Total | ||||
Ending Work in process inventory | ||||||
Equivalent units | 160 | 100 | =B28 | =C29 | ||
Cost per Equivalent unit | $ 76.25 | $ 72.75 | =B38 | =C38 | ||
Cost of Ending Work in process inventory | $ 12,200 | $ 7,275 | $ 19,475 | =+B43*B44 | =+C43*C44 | |
Units completed and transferred out | ||||||
Units transferred | 4800 | 4800 | =B26 | =C26 | ||
Cost per Equivalent unit | $ 76.25 | $ 72.75 | =B38 | =C38 | ||
Cost of Units transferred | $ 366,000 | $ 349,200 | $ 715,200 | =B48*B49 | =C48*C49 | |
Costs to be accounted for | ||||||
Cost of beginning work in process | $ 15,175 | =B9+B10 | ||||
Cost added during production | $ 719,500 | =B13+B14 | ||||
Total Costs to be accounted for | $ 734,675 | =SUM(B54:B55) | ||||
Costs accounted for as follows | ||||||
Cost of Ending work in process | $ 19,475 | =D45 | ||||
Cost of Units transferred | $ 715,200 | =D50 | ||||
Total Costs accounted for | $ 734,675 | =SUM(B58:B59) |
Beginning Work in process | ||||||
Units | 300 | |||||
Completion Materials | 55% | |||||
Completion Conversion | 30% | |||||
Costs in beginning work in process | ||||||
Material Cost | $ 9,600 | |||||
Conversion Cost | $ 5,575 | |||||
Units started | 18200 | |||||
Costs added | ||||||
Material Cost | $ 368,600 | |||||
Conversion Cost | $ 350,900 | |||||
Ending Work in process | ||||||
Units | 500 | |||||
Completion Materials | 40% | |||||
Completion Conversion | 25% | |||||
Material | Conversion | |||||
Units transferred | 18000 | 18000 | =B5+B11-B16 | =B26 | ||
Equivalent units in ending WIP | ||||||
Materials | 200 | =B16*B17 | ||||
Conversion | 125 | =B16*B18 | ||||
Equivalent units of production | 18200 | 18125 | =SUM(B26:B29) | =SUM(C26:C29) | ||
Material | Conversion | |||||
Cost of beginning work in process | $ 9,600 | $ 5,575 | =B9 | =B10 | ||
Cost added during the production | $ 368,600 | $ 350,900 | =B13 | =B14 | ||
Total Cost | $ 378,200 | $ 356,475 | =SUM(B34:B35) | =SUM(C34:C35) | ||
Equivalent units of production | 18200 | 18125 | =B30 | =C30 | ||
Cost per Equivalent unit | $ 20.78 | $ 19.67 | =B36/B37 | =C36/C37 |
Download the Applying Excel form and enter formulas in all cells that contain question marks. For...
Chapter 4: Applying Excel Data Beginning work in process inventory: Units in process 200 Completion with respect to materials 100% Completion with respect to conversion 40% Costs in the beginning work in process inventory: Materials cost $2,000 Conversion cost $800 Units started into production during the period 1,800 Costs added to production during the period: Materials cost $18,400 Conversion cost $38,765 Ending work in process inventory: Units in process 100 Completion with respect to materials 100% Completion with respect to...
very confused :-) 1 Required information The Chapter 5 Form worksheet is to be used to create your own worksheet version of Exhibit 5-5 and Exhibit 5-8 in the text. pped Book Print erences Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B34 enter the formula "B9". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the...
please answer in yellow box and enter Excel formulas. 1. Compute the equivalent units of production using the weighted-average method 2. Compute the cost per equivalent unit using the weighted average method. 3. Assign costs to units using the weighted average method 4. Prepare a cost reconciliation report 5. FILE Process Costing using the Weighted-Average Method - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW HOME INSERT Sign In -11AA2 Paste B I U A Alignment Number Conditional Format as Cell...
You need to show the Excel formulas. This is the most important thing! Thank you Salish Craft Beers provides the following information for the Malting Department for the month of August 2018: Units Costs Beginning Work-in-Process Inventory Started in Production in August Total to Account For Completed and Transferred to Packaging Department during August 26,000 26,000 21,000 54,000 * 54,000 ? Ending Work-in-Process Inventory, 30% complete for direct materials and 60% complete for conversion costs. Total Accounted For 5,000 26,000...
Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B26 enter the formula “= B4*B8”. Note that the worksheet contains a section at the bottom titled “Determine the Product Margin Under a Traditional Cost System” that is not in the Review Problem. In this section, it is assumed that the traditional costing system allocates manufacturing overhead on the basis of the number of units produced. When completed, that part of...
5 GRADED 0 Saved Requirement 2: Change all of the numbers in the data area of your worksheet so that it looks like this: 1 Chapter 5: Applying Excel eBook Print 5 eferences 300 65 $ 3 Data 4 Beginning work in process inventory: Units in process Completion with respect to materials Completion with respect to conversion Costs in the beginning work in process inventory: Materials cost Conversion cost 11 Units started into production during the period 12 Costs added...
Download the Applying Excel form and enter formulas in all cells that contain question markS. For example, in cell C18 enter the formulaB6". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts in both the traditional and contribution format income statements match the numbers in Exhibit 1-7 Check your worksheet by changing the variable selling cost in the Data area to $900, keeping all of the other data the same as in...
Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B13 enter the formula "= B5". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the fixed expenses to $270,000. If your worksheet is operating properly, the degree of operating leverage should be 10. If you do not get this answer, find...
Requirement 2: Change all of the numbers in the data area of your worksheet so that it looks like this: B U 2 العا 4 es 300 35 % 50 % А 1 Chapter 5: Applying Excel 2 Data 4 Beginning work in process inventory: 5 Units in process 6 Completion with respect to materials 7 Completion with respect to conversion 8 Costs in the beginning work in process inventory: 9 Materials cost 10 Conversion cost 11 Units started into...
Paste В І ov Merge & Center $ % 98 -28 Conditional Format Cell Formatting as Table Styles Insert Delete Format C1 . B C 1 Chapter 4: Applying Excel Name: 2 3 Data 4 Beginning work in process inventory: 5 Units in process 200 6 Completion with respect to materials 55% 7 Completion with respect to conversion 30% 8 Costs in the beginning work in process inventory: 9 Materials cost $9,600 10 Conversion cost $5,575 11 Units started into...