Periodic inventory by three methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 2,400 units at $4 Feb. 17 Purchase 3,000 units at $5 Jul. 21 Purchase 3,300 units at $6 Nov. 23 Purchase 1,300 units at $7 There are 1,900 units of the item in the physical inventory at December 31. The periodic inventory system is used. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the inventory cost by the first-in, first-out method. b. Determine the inventory cost by the last-in, first-out method. c. Determine the inventory cost by the weighted average cost method. Round your answer to the nearest dollar.

Chemistry
10th Edition
ISBN:9781305957404
Author:Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Chapter1: Chemical Foundations
Section: Chapter Questions
Problem 1RQ: Define and explain the differences between the following terms. a. law and theory b. theory and...
icon
Related questions
Question
Periodic inventory by three methods
The units of an item available for sale during the year were as follows:
Jan. 1
Inventory 2,400 units at $4
Feb. 17
Purchase 3,000 units at $5
Jul. 21
Purchase 3,300 units at $6
Nov. 23 Purchase 1,300 units at $7
There are 1,900 units of the item in the physical inventory at December 31. The periodic inventory system is used. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input
your answers in the questions below.
Open spreadsheet
a. Determine the inventory cost by the first-in, first-out method.
b. Determine the inventory cost by the last-in, first-out method.
c. Determine the inventory cost by the weighted average cost method. Round your answer to the nearest dollar.
Transcribed Image Text:Periodic inventory by three methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 2,400 units at $4 Feb. 17 Purchase 3,000 units at $5 Jul. 21 Purchase 3,300 units at $6 Nov. 23 Purchase 1,300 units at $7 There are 1,900 units of the item in the physical inventory at December 31. The periodic inventory system is used. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the inventory cost by the first-in, first-out method. b. Determine the inventory cost by the last-in, first-out method. c. Determine the inventory cost by the weighted average cost method. Round your answer to the nearest dollar.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
Chemistry
Chemistry
Chemistry
ISBN:
9781305957404
Author:
Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:
Cengage Learning
Chemistry
Chemistry
Chemistry
ISBN:
9781259911156
Author:
Raymond Chang Dr., Jason Overby Professor
Publisher:
McGraw-Hill Education
Principles of Instrumental Analysis
Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning
Organic Chemistry
Organic Chemistry
Chemistry
ISBN:
9780078021558
Author:
Janice Gorzynski Smith Dr.
Publisher:
McGraw-Hill Education
Chemistry: Principles and Reactions
Chemistry: Principles and Reactions
Chemistry
ISBN:
9781305079373
Author:
William L. Masterton, Cecile N. Hurley
Publisher:
Cengage Learning
Elementary Principles of Chemical Processes, Bind…
Elementary Principles of Chemical Processes, Bind…
Chemistry
ISBN:
9781118431221
Author:
Richard M. Felder, Ronald W. Rousseau, Lisa G. Bullard
Publisher:
WILEY