Units Conversion Work in process, beginning Units completed during the months Work in process, ending 60,000 HINT: Formulas in RED will be in units Forumlas in BLUE will percentages Formulas in GREEN will be in dollars 40% 210,000 30,000 70% Costs to account for: To find started and completed: Total Completed units - beginning inventory Started during the month - ending inventory Beginning work in process 2$ 94,800 151,200 600,300 Materials added %24 Conversion costs incurred Total costs to be accounted for FORMULA 1 Cost assignment Direct Mat. % % Added Conversio During the Conversion Beginning Equiv. Units Inventory Direct Added During Direct Mat. Equiv. Units Whole Units the Month Month Materials Total 60,000 FORMULA 5 | FORMULA 8FORMULA 12 FORMULA 1 FORMULA 19 FORMULA 2: FORMULA 2 FORMULA 6 FORMULA SFORMULA 13 FORMULA 1 FORMULA 20 FORMULA 2: FORMULA 2 FORMULA 1FORMULA 14 FORMULA 1 FORMULA 21FORMULA 24 FORMULA 2 $0 $0 Beg. Work in process Started & Completed Ending Work in proces: Total $0 150,000 30,000 FORMULA 7 240,000 $0 $0 $0 $0

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
I uploaded a picture of the excel practice problem.
JX
FORMULA 5
A
F
H.
8.
K
M
Percent
9
Units
Conversion
10
Work in process, beginning
60,000
HINT:
Formulas in RED will be in units
Forumlas in BLUE will percentages
40%
11
Units completed during the months
Work in process, ending
210,000
30,000
12
70%
13
Formulas in GREEN will be in dollars
14
15
Costs to account for:
To find started and completed:
Completed units - beginning inventory
Started during the month - ending inventory
16
Total
17
Beginning work in process
24
94,800
18
Materials added
2$
151,200
600,300
19
Conversion costs incurred
2$
20
Total costs to be accounted for
FORMULA 1
21
22
23
Cost assignment
Direct Mat. %
% Added
Whole
Added During Direct Mat.
During the
Conversion Beginning
Direct
Conversio
Materials
Total
Equiv. Units
FORMULA 8FORMULA 12 FORMULA 1 FORMULA 19 FORMULA 2: FORMULA 2
FORMULA 9 FORMULA 13 FORMULA 1 FORMULA 20 FORMULA 2: FORMULA 2
FORMULA 1FORMULA 14 FORMULA 1 FORMULA 21FORMULA 24 FORMULA 2
24
Units
the Month
Month
Equiv. Units Inventory
$0
60,000
150,000
30,000
FORMULA 5
Beg. Work in process
Started & Completed
Ending Work in proces:
Total
25
$0
$0
$0
26
FORMULA 6
27
FORMULA 7
$0
$0
$0
28
240,000
29
Amount reported on the balance sheet as:
Finished goods inventory FORMULA 28
Work in Process invento FORMULA 29
Direct Mat.
Conversion
30
31
Cost per
FORMULA 11
FORMULA 18
32
equivalent
33
34
35
Sheet1
Sheet2
Sheet3
+
99+
O Type here to search
Transcribed Image Text:JX FORMULA 5 A F H. 8. K M Percent 9 Units Conversion 10 Work in process, beginning 60,000 HINT: Formulas in RED will be in units Forumlas in BLUE will percentages 40% 11 Units completed during the months Work in process, ending 210,000 30,000 12 70% 13 Formulas in GREEN will be in dollars 14 15 Costs to account for: To find started and completed: Completed units - beginning inventory Started during the month - ending inventory 16 Total 17 Beginning work in process 24 94,800 18 Materials added 2$ 151,200 600,300 19 Conversion costs incurred 2$ 20 Total costs to be accounted for FORMULA 1 21 22 23 Cost assignment Direct Mat. % % Added Whole Added During Direct Mat. During the Conversion Beginning Direct Conversio Materials Total Equiv. Units FORMULA 8FORMULA 12 FORMULA 1 FORMULA 19 FORMULA 2: FORMULA 2 FORMULA 9 FORMULA 13 FORMULA 1 FORMULA 20 FORMULA 2: FORMULA 2 FORMULA 1FORMULA 14 FORMULA 1 FORMULA 21FORMULA 24 FORMULA 2 24 Units the Month Month Equiv. Units Inventory $0 60,000 150,000 30,000 FORMULA 5 Beg. Work in process Started & Completed Ending Work in proces: Total 25 $0 $0 $0 26 FORMULA 6 27 FORMULA 7 $0 $0 $0 28 240,000 29 Amount reported on the balance sheet as: Finished goods inventory FORMULA 28 Work in Process invento FORMULA 29 Direct Mat. Conversion 30 31 Cost per FORMULA 11 FORMULA 18 32 equivalent 33 34 35 Sheet1 Sheet2 Sheet3 + 99+ O Type here to search
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education