Using Excel to Cost Inventory Student Work Area PROBLEM In its first month of operations, McLanie Company made three purchases. 6 Information concerning these purchases and units on hand are: Required: Provide input into cells shaded in yellow in this template.Use only mathematical formulas with cell references to compute the unit cost and the cost of ending inventory. 8. Units Cost per Unit $ 6.00 Compute the cost of the ending inventory under the average-cost method in a periodic inventory system. 10 300 11 400 8.00 12 500 Answer Field 41.7% of your score. Formula: Add, Multiply, Divide; Input a mathematical formula us from the respective amounts int 9.00 Weighted-average unit cost 13 14 Units on hand at period end 200 Round unit cost to 3 decimals using the ROUND function 15 16 Purchases of merchandise were made in the sequence listed above. 17 Cost of ending inventory 18 19
Using Excel to Cost Inventory Student Work Area PROBLEM In its first month of operations, McLanie Company made three purchases. 6 Information concerning these purchases and units on hand are: Required: Provide input into cells shaded in yellow in this template.Use only mathematical formulas with cell references to compute the unit cost and the cost of ending inventory. 8. Units Cost per Unit $ 6.00 Compute the cost of the ending inventory under the average-cost method in a periodic inventory system. 10 300 11 400 8.00 12 500 Answer Field 41.7% of your score. Formula: Add, Multiply, Divide; Input a mathematical formula us from the respective amounts int 9.00 Weighted-average unit cost 13 14 Units on hand at period end 200 Round unit cost to 3 decimals using the ROUND function 15 16 Purchases of merchandise were made in the sequence listed above. 17 Cost of ending inventory 18 19
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please see the pictures below for question details. Need help with this. Note that the pictures are the same, it is just showing what each part is asking for.
Transcribed Image Text:fx Function: ROUND; Formula: Add, Multiply, Divide; Cell Referencing
B.
G
H
1 Funcion: ROUND; Formula: Add, Multiply, Divide; Cell Referencing
M
2.
Using Excel to Cost Inventory
Student Work Area
4.
PROBLEM
5 In its first month of operations, McLanie Company made three purchases.
6 Information concerning these purchases and units on hand are:
Required: Provide input into cells shaded in yellow in this template.Use only
mathematical formulas with cell references to compute the unit cost and the
cost of ending inventory.
8.
6.
Units
Cost per Unit
$ 6.00
Compute the cost of the ending inventory under the average-cost method in
a periodic inventory system.
10
300
11
400
8.00
12
500
9.00
Answer Field
T 41.7% of your score.
Formula: Add, Multiply, Divide; Cell reference.
Input a mathematical formula using cell-referencing
from the respective amounts in the Problem Area.
Weighted-average unit cost
13
14
Units on hand at period end
200
Round unit cost to 3 decimals using the
ROUND function
15
16 Purchases of merchandise were made in the sequence listed above.
17
Cost of ending inventory
18
19
20
21
22
23
24
25
26
Transcribed Image Text:A1
fx Function: ROUND; Formula: Add, Multiply, Divide; Cell Referencing
M
C D
E F
G
B
H
1 Funcion: ROUND; Formula: Add, Multiply, Divide; Cell Referencing
Student Work Area
3 Using Excel to Cost Inventory
Required: Provide input into cells shaded in yellow in this template.Use only
mathematical formulas with cell references to compute the unit cost and the
4
PROBLEM
5 In its first month of operations, McLanie Company made three purchases.
6 Information concerning these purchases and units on hand are:
cost of ending inventory.
7
Compute the cost of the ending inventory under the average-cost method in
a periodic inventory system.
Units
Cost per Unit
300
$ 6.00
10
11
400
8.00
500
9.00
Weighted-average unit cost
12
13
Round unit cost to 3 decimals using the
ROUND function
Units on hand at period end
200
14
15
Answer Field
SE 16.6% of your score.
Formula: Multiply; Cell reference:
Input a mathematical formula using cell-referencing
to the respective amount in the Problem Area and
from your calculated unit cost.
16 Purchases of merchandise were made in the sequence listed above.
Cost of ending inventory
17
18
19
20
21
22
23
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 now
This is a popular solution!
Step by step
Solved in 2 steps with 2 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.Recommended textbooks for you
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,
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