Compute the cost of the ending inventory under the a. FIFO method FIFO Units Unit Cost Total Cost 200 $ 6.00 $ 1,200 Compute the cost of the ending inventory under the b. LIFO method LIFO Units 200 Unit Cost Total Cost $9.00 $1,800

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
tel)
RE 17
Gen
File
Paste
N20
22
23
24
25
26
27
28
29
30
31
32
33
mm m
34
35
9.2.
36
mm
Home
37
38
X Cut
LB Copy
Format Painter
Clipboard
M
Insert
:
N
Purchase $
1
2
3
Page Layout
Liberation Sans
BIU
с
A
B
1 Formula: Multiply; Cell Referencing
2
3 Using Excel to Determine Ending Inventory
PROBLEM
Units on hand
66°F
Rain off and on
Units
300
4
5 In its first month of operations, McLanie Company made
6 three purchases of merchandise in the following sequence:
7
8
Formulas
400
500
Enter Answer
Ready Accessibility: Investigate
h
Font
+
D
9
10
11
12
13 McLanie uses a periodic inventory system. It also provided
14 the following information:
15
16
17
18
19
20
21
12
at
at
at
bal
Data
A A
E
200
Review
Unit Cost
$ 6.00
$ 8.00
$ 9.00
= = =
===
F
View
G
Help
Wrap Text
33Merge & Center
Alignment
H
Tell me what you want to do
FIFO
J
LIFO
Custom
$ - % -
-0
KI
Units
200
Number
M
N
N
Compute the cost of the ending inventory under the
a. FIFO method
Conditional Format as
Formatting
Table
Student Work Area
Required: Provide input into cells shaded in yellow in this
template. Use a cell references and mathematical
formulas for calculations.
Unit Cost Total Cost
$ 6.00 $ 1,200
Compute the cost of the ending inventory under the
b. LIFO method
Chapter6Excel Quest
Units Unit Cost Total Cost
200 $9.00 $ 1,800
0
M
HO LD
P
M
DELI
Transcribed Image Text:tel) RE 17 Gen File Paste N20 22 23 24 25 26 27 28 29 30 31 32 33 mm m 34 35 9.2. 36 mm Home 37 38 X Cut LB Copy Format Painter Clipboard M Insert : N Purchase $ 1 2 3 Page Layout Liberation Sans BIU с A B 1 Formula: Multiply; Cell Referencing 2 3 Using Excel to Determine Ending Inventory PROBLEM Units on hand 66°F Rain off and on Units 300 4 5 In its first month of operations, McLanie Company made 6 three purchases of merchandise in the following sequence: 7 8 Formulas 400 500 Enter Answer Ready Accessibility: Investigate h Font + D 9 10 11 12 13 McLanie uses a periodic inventory system. It also provided 14 the following information: 15 16 17 18 19 20 21 12 at at at bal Data A A E 200 Review Unit Cost $ 6.00 $ 8.00 $ 9.00 = = = === F View G Help Wrap Text 33Merge & Center Alignment H Tell me what you want to do FIFO J LIFO Custom $ - % - -0 KI Units 200 Number M N N Compute the cost of the ending inventory under the a. FIFO method Conditional Format as Formatting Table Student Work Area Required: Provide input into cells shaded in yellow in this template. Use a cell references and mathematical formulas for calculations. Unit Cost Total Cost $ 6.00 $ 1,200 Compute the cost of the ending inventory under the b. LIFO method Chapter6Excel Quest Units Unit Cost Total Cost 200 $9.00 $ 1,800 0 M HO LD P M DELI
Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Cost allocation
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
  • SEE MORE QUESTIONS
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