
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Topic Video
Question
Excel formulas must be shown! Need help with formulas.

Transcribed Image Text:9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Work in process, beginning
Units completed during the months
Work in process, ending
24
25
26
Costs to account for:
27
28
29
Beginning work in process
Materials added
Conversion costs incurred
Total costs to be accounted for
30
Beg. Work in process
Started & Completed
Ending Work in process
Total
$
$
$
Whole Units
FORMULA 2
FORMULA 3
FORMULA 3
Units
60,000
210,000
30,000
Total
94,800
151,200
600,300
FORMULA 1
Direct Mat. %
Added During
the Month
FORMULA 5
FORMULA 6
FORMULA 7
Percent
Conversion
40%
70%
Direct Mat.
Equiv. Units
FORMULA 8
FORMULA 9
FORMULA 10
Direct Mat.
Conversion%
Added During
the Month
FORMULA 12
FORMULA 13
FORMULA 14
HINT:
Formulas in RED will be in units
Forumlas in BLUE will percentages
Formulas in GREEN will be in dollars
To find started and completed:
Completed units - beginning inventory
Started during the month - ending inventory
Cost assignment
Conversion Beginning
Equiv. Units
Inventory
FORMULA 15 FORMULA 19
FORMULA 16 FORMULA 20
FORMULA 17 FORMULA 21
$0
Conversion
Direct
Materials Conversion
FORMULA 22 FORMULA 25
FORMULA 23 FORMULA 26
FORMULA 24 FORMULA 27
$0
$0
Total
SO
SO
SO
$0
Amount reported on the balance sheet as:
E

Transcribed Image Text:D
1
2
23
24
25
26
Costs to account for:
27
28
29
Beginning work in process
Materials added
Conversion costs incurred
Total costs to be accounted for
30
31
32
33
34
35
36
Beg. Work in process
Started & Completed
Ending Work in process
Total
$
$
$
Whole Units
FORMULA 2
FORMULA 3
FORMULA 3
Total
94,800
151,200
600,300
FORMULA 1
Direct Mat. %
Added During
the Month
FORMULA 5
FORMULA 6
FORMULA 7
Cost per
equivalent unit
Direct Mat.
Equiv. Units
FORMULA 8
FORMULA 9
FORMULA 10
Direct Mat.
FORMULA 11
Conversion%
Added During
the Month
FORMULA 12
FORMULA 13
FORMULA 14
To find started and completed:
Completed units beginning inventory
Started during the month - ending inventory
Cost assignment
Conversion
FORMULA 25
Direct
Materials
FORMULA 22
FORMULA 23 FORMULA 26
FORMULA 24 FORMULA 27
$0
$0
Conversion
Equiv. Units
Beginning
Inventory
FORMULA 15 FORMULA 19
FORMULA 16 FORMULA 20
FORMULA 17 FORMULA 21
$0
Conversion
FORMULA 18
Total
SO
$0
SO
$0
Amount reported on the balance sheet as:
Finished goods inventory
FORMULA 28
FORMULA 29
Work in Process inventory
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 3 images

Knowledge Booster
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.Similar questions
- Hi can you show how to input in excel using the pmt formula thank you so mucharrow_forwardcan you please show me how to calculate this without using excel? Thanksarrow_forwardis there a way to do this question with formulas and a calculator instead of excel? if so please upload the solution this wayarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education