Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer all ?'s using functions, thanks in advance! F57 fx F B C E D 1 Chapter 4: Applying Excel 2 3 Data 4
please answer all ?'s using functions, thanks in advance!
F57 fx F B C E D 1 Chapter 4: Applying Excel 2 3 Data 4 Beginning work in process inventory: 200 5 Units in process 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 production during the period 5,000 12 Costs added to production during the period: 13 Materials cost $368,600 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 formula into each of the cells marked with a ? below 21 22 Weighted Average method: 23 24 Equivalent Units of Production 25 Materials Conversion 26 Units transferred to the next department ? ? 27 Equivalent units in onding work in process inventory: 28 Materials ? 29 Conversion ? 30 Equivalent units of production ? ? 31 32 Costs per Equivalent Unit 33 Materials Conversion 34 Cost of beginning work in process inventory 7 ? 35 Costs added during the period ? ? 36 Total cost 2 ? 37 Equivalent units of production ? 2 38 Cost per equivalent unit ? 2 39 40 Costs of Ending Work In Process Inventory and the Units Transferred Out 41 42 Ending work in process inventory: Materials Conversion 43 Equivalent units ? 44 "? Cost per equivalent unit ? ? Chapter 4 Form Total F57 A 6 D E 2 2 Total ? B 30 Equivalent units of production 7 7 31 32 Costs per Equivalent Unit 33 Materials Conversion 2 2 34 Cost of beginning work in process inventory 35 Costs added during the period 2 ? 36 Total cost ? 37 Equivalent units of production 2 7 38 Cost per equivalent unit 2 39 40 Costs of Ending Work in Process Inventory and the Units Transferred Out Materials Conversion 42 Ending work in process inventory 43 Equivalent units ? 7 Cost per equivalent unit 7 ? 45 Cost of ending work in process inventory 2 ? 46 47 Units completed and transferred out: Units transferred to the next department 7 2 49 Cost per equivalent unit 2 ? 50 Cost of units transferred out 2 ? 51 52 Cost Reconciliation 53 Costs to be accounted for 54 Cost of beginning work in process inventory ? 55 Costs added to production during the period ? 56 Total cost to be accounted for ? 57 Costs accounted for as follows: 58 Cost of ending work in process inventory ? 59 Cost of units transferred out 7 60 Total cost accounted for ? 61 62 63 ? 65 66 67 68 69 70 31 32 73 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