Check your worksheet by changing the beginning work in

Reference no: EM13566865

Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2,500 units, and the units in ending work in process inventory to 200 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 $152.50 and the cost per equivalent unit for conversion should be $145.50. If you do not get these answers, find the errors in your worksheet and correct them.

Chapter 4: Applying Excel

Data
Work in process, beginning:
Units in process	200
Completion with respect to materials	55%
Completion with respect to conversion	30%
Costs in the beginning inventory:
Materials cost	$9,600
Conversion cost	$5,575
Units started into production during the period	5,000
Costs added to production during the period:
Materials cost	$368,600
Conversion cost	$350,900
Work in process, ending:
Units in process	400
Completion with respect to materials	40%
Completion with respect to conversion	25%

Enter a formula into each of the cells marked with a ? below

Weighted Average method:

Equivalent Units of Production
	Materials	Conversion
Units transferred to the next department	?	?
Ending work in process:
Materials	?
Conversion		?
Equivalent units of production	?	?

Costs per Equivalent Unit
	Materials	Conversion
Cost of beginning work in process inventory	?	?
Costs added during the period	?	?
Total cost	?	?
Equivalent units of production	?	?
Cost per equivalent unit	?	?

Costs of Ending Work in Process Inventory and the Units Transferred Out
	Materials	Conversion	Total
Ending work in process inventory:
Equivalent units of production	?	?
Cost per equivalent unit	?	?
Cost of ending work in process inventory	?	?	?

Units completed and transferred out:
Units transferred to the next department	?	?
Cost per equivalent unit	?	?
Cost of units transferred out	?	?	?

Cost Reconciliation
Costs to be accounted for:
Cost of beginning work in process inventory	?
Costs added to production during the period	?
Total cost to be accounted for	?
Costs accounted for as follows:
Cost of ending work in process inventory	?
Cost of units transferred out	?
Total cost accounted for	?

Reference no: EM13566865

Questions Cloud

Analyze and evaluate the ergonomics and human factors : analyze and evaluate the ergonomics and human factors design principles with regards to aircraft and then creatively

Given the information for schism inc in problems 11 and 12 : given the information for schism inc. in problems 11 and 12 suppose you also know that the firms net capital spending

Cockpit decision you have been tasked with developing a : cockpit decisionyou have been tasked with developing a basic cockpit design for a new aircraft light corporate or

Office world inc has cash and carry customers and credit : office world inc. has cash and carry customers and credit customers. office world estimates that 25 of monthly sales

Check your worksheet by changing the beginning work in : check your worksheet by changing the beginning work in process inventory to 100 units the units started into production

A 50 stock dividend before the dividend 69 million common : identify the effects-both the direction and the dollar amount-of these assumed transactions on the total shareholders

What is the yield to maturity of a corporate bond with 10 : what is the yield to maturity of a corporate bond with 10 years to maturity a coupon rate of 6 per year a 1000 par

Last year chuck company issued a 10-year 12 semiannual : last year chuck company issued a 10-year 12 semiannual coupon bond at its par value of 1000. currently the bond can be

June 30th sold a computer that was purchased on january 1 : a compute the revised annual depreciation on each asset in 2014b prepare the entries to record depreciation on the

User Account

All Pages