Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Dyslexia A Practitioners Handbook

Authors: Gavin Reid

5th Edition

1118980107, 9781118980101

More Books

Students also viewed these Accounting questions

Question

Explain global human resource management.

Answered: 1 week ago

Question

Describe the grievance procedure in a union environment.

Answered: 1 week ago

Question

Discuss whistleblower protection under OSHA.

Answered: 1 week ago