Using Excel to Cost Inventory Student Work Area PROBLEM In its first month of operations, McLanie Company made three purchases. 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. Cost per Unit $ 6.00 8.00 Compute the cost of the ending inventory under the average-cost method in a periodic inventory system. Units 300 11 400 12 500 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. Cost of ending inventory 17

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
Please see the picture below for question details. Need help with this. NOTE: PLEASE INCLUDE THE APPROPRIATE FORMULA AND CELL REFERENCING USED TO GET ANSWERS.
A
D
G
H.
K
N
1 Function: ROUND; Formula: Add, Multiply, Divide; Cell Referencing
2.
3 Using Excel to Cost Inventory
Student Work Area
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.
7
8
Cost per Unit
$ 6.00
Compute the cost of the ending inventory under the average-cost method in
a periodic inventory system.
9
Units
10
300
11
400
8.00
500
9.00
Weighted-average unit cost
12
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.
Cost of ending inventory
17
Transcribed Image Text:A D G H. K N 1 Function: ROUND; Formula: Add, Multiply, Divide; Cell Referencing 2. 3 Using Excel to Cost Inventory Student Work Area 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. 7 8 Cost per Unit $ 6.00 Compute the cost of the ending inventory under the average-cost method in a periodic inventory system. 9 Units 10 300 11 400 8.00 500 9.00 Weighted-average unit cost 12 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. Cost of ending inventory 17
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
Money Management and Achieving Financial Goals
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