jagomart
digital resources
picture1_Vanderbeck 16e C06 Student


 203x       Filetype XLS       File size 0.21 MB       Source: cdn.prexams.com


File: Vanderbeck 16e C06 Student
sheet 1 e62 name section use paste specialformulas when copying between cells when totals subtotals and final amounts are correct the cell will change to green exercise 62 a equivalent ...

icon picture XLS Filetype Excel XLS | Posted on 17 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: E6-2

Name:



Section:












Use Paste Special/Formulas when copying between cells When totals, subtotals, and final amounts are correct the cell will change to green.










Exercise 6-2















a.




Equivalent Units






Material Labor & Overhead

Units completed







Units, ending process:








All material







25% labor and overhead






Equivalent units
























b.


Material Labor Overhead Total

Work in process, beg.







Current costs







Total costs





*

Equivalent units







Unit costs
























c. Completed and transferred















d. Ending work in process:








Materials







Labor







Overhead







Total





e. Total costs accounted for





*











* rounding difference















Sheet 2: E6-5
Name:


Section:










Use Paste Special/Formulas when copying between cells When totals, subtotals, and final amounts are correct the cell will change to green.









Exercise 6-5














CASE 1




Units transferred


Units in process, end of period


Units in process, beginning of period



Units started in process


Units transferred


Units in process, end of period



Equivalent units - materials


Units transferred


Units in process, end of period,


completed



Equivalent units - labor and factory overhead











Materials Labor



Total costs for the period






÷ Equivalent units






Unit cost for period



























CASE 2









Materials Labor



Total cost






÷ Unit cost






Equivalent units







Equivalent units - materials


Units transferred



Equivalent units in process, end of period, all materials


Equivalent units - labor and factory overhead


Units transferred



Equivalent units in process, end of period


completed









Units transferred


Units in process, end of period



Units started in process


























CASE 3




Equivalent units - labor and factory overhead


x Labor and factory overhead unit cost for period


Total cost


Less labor and factory overhead costs in process, beginning of period


Labor and factory overhead current month


Equivalent units - labor and factory overhead


Less equivalent units in process, end of period



completed


Units transferred


Units in process, end of period


Less:
Units started in process






Less units transferred





Units in process, beginning of period


Units transferred


Units in process, end of period


Equivalent units - materials


x Materials unit cost for period


Total cost for materials


Less materials cost in process, beginning of period



Materials cost current month











Sheet 3: E6-6
Name:

Section:







Use Paste Special/Formulas when copying between cells When totals and subtotals are correct the cell will change to green.






Exercise 6-6











Materials Labor Overhead Total
Beginning work in process



Cost for November



Total



Equivalent units



Average unit cost




( a ) ( b ) ( c ) ( d )






The words contained in this file might help you see if this file matches what you are looking for:

...Sheet e name section use paste specialformulas when copying between cells totals subtotals and final amounts are correct the cell will change to green exercise a equivalent units material labor amp overhead completed ending process all b total work in beg current costs unit c transferred d materials accounted for rounding difference case end of period beginning started factory divide cost x less month november average...

no reviews yet
Please Login to review.