Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am unsure how to insert the data within the following excel sheet A 1 Chapter 4: Applying Excel 3 Data Beginning work in process
I am unsure how to insert the data within the following excel sheet
A 1 Chapter 4: Applying Excel 3 Data Beginning work in process inventory Units in process 200 G Completion with respect to materials 55% Completion with respect to conversion 30% Costs in the beginning work in process inventory 9 Materials cost $9.500 10 Conversion cost 55,575 11 Units started into production during the period 5,000 12 Costs added to production during the period: 13 Materials cost $368 800 14 Conversion cost $350 900 15 Ending work in process inventory 16 Units in process 400 17 Completion with respect to materials 40% 18 Completion with respect to conversion 25% 19 20 Enter a fomula into each of the cells marted with a ? below 21 22 Weighted Average method: 23 24 Equivalent Units of Production 25 Materials Conversion 26 Units transferred to the next department ? 2 27 Equivalent units in ending work in process inventory 20 Mataas 2 29 Conversion 30 Equivalent units of production 7 2 11 12 Costs per Equivalent Unit Materials Conversion 14 Cout of beginning work in process inventory 7 2 15 Costs added during the period ? Total cost ? 2 13 Equivalent units of production 2 1 Cost per equivalent unit 7 7 10 Costs of Ending Work in Process Inventory and the Unite Transferred Out 41 Materials 42 Ending work in process inventory Conversion Total Equivalent units 2 2 Cost per equivalent unit 7. 45 Cost of ending work in process inventory 2 ? ? 47 Units completed and transfered out Un transfered to the next department 4 Cost per equivalent unit 2 2 2 2 50 Cost of units transferred out ? ? 53 Cost Reconciliation 51 Costs to be accounted for Cost of beginning work in process inventory 55 costs added to production during the period 17 56 Total cost to be accounted for 57 Costs accounted for as follows 5 Cost of ending work in process inventory Cost of units transformed out 2 60 Total cost accounted for 7 2 64 53 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started