Perpetual Inventory Using FIFO Beginning inventory, purchases,and sales data for Keurig coffee machines are as follows: June 1 Inventory 50 units at $10 Sale 20 units 14 Purchase 90 units at $11 19 Sale 60 units 25 Purchase 40 units at $13 30 Sale 50 units The business maintains a perpetual inventory system, costing by the first-in, first-out method. Using the chart below, determine the cost of ending inventory. Sales Date Purchases Inventory (Cost of goods) Unit Cost Total Unit Cost Total Unit Cost Total 1-Jun 6-Jun

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
icon
Concept explainers
Topic Video
Question
100%
AutoSave
Module 7 Excel Quiz
Excel
Search
Sebastian Beltran
回 X
Off
SB
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
A Share
Comments
Insert
Calibri
v 11
ab
Delete
Paste
BI U
A
$ v % 9
K0 .00
00 0
58 28
Conditional Format as
Cell
Sort & Find &
Ideas
Sensitivity
v
Format
Formatting v Table v Styles v
Filter
Select
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Ideas
Sensitivity
C23
fx
A
В
C
D
E F
H
J
K
L
M
N
Q
R
U
20
Sales
Date
Purchases
Inventory
21
(Cost of goods)
22
Unit
Cost
Total
Unit
Cost
Total
Unit
Cost
Total
23
24
1-Jun
25
26
27
6-Jun
28
29
30
14-Jun
31
32
33
19-Jun
34
35
36
25-Jun
37
38
39
30-Jun
40
41
Cost of ending inventory =
12
INCORRECT!
Sheet1
Ready
囲
100%
>
>
17
Transcribed Image Text:AutoSave Module 7 Excel Quiz Excel Search Sebastian Beltran 回 X Off SB File Home Insert Page Layout Formulas Data Review View Help A Share Comments Insert Calibri v 11 ab Delete Paste BI U A $ v % 9 K0 .00 00 0 58 28 Conditional Format as Cell Sort & Find & Ideas Sensitivity v Format Formatting v Table v Styles v Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity C23 fx A В C D E F H J K L M N Q R U 20 Sales Date Purchases Inventory 21 (Cost of goods) 22 Unit Cost Total Unit Cost Total Unit Cost Total 23 24 1-Jun 25 26 27 6-Jun 28 29 30 14-Jun 31 32 33 19-Jun 34 35 36 25-Jun 37 38 39 30-Jun 40 41 Cost of ending inventory = 12 INCORRECT! Sheet1 Ready 囲 100% > > 17
AutoSave
Module 7 Excel Quiz
Excel
Search
Sebastian Beltran
回 X
Off
SB
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
A Share
Comments
Insert
Calibri
v 11
ab
Delete
Paste
$ • % 9 58 28
Conditional Format as
Cell
Sort & Find &
Ideas
Sensitivity
BI U
A
K0 .00
00 0
v
Format
Formatting v Table v Styles v
Filter
Select
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Ideas
Sensitivity
C23
fx
A
В
C
D
E F
G
H
K
M
Q
R
U
7
Perpetual Inventory Using FIFO
8
Beginning inventory, purchases,and sales data for Keurig coffee machines are as follows:
9.
10
June
1
Inventory
50 units at $10
11
6.
Sale
20 units
12
14
Purchase
90 units at $11
13
19
Sale
60 units
14
25
Purchase
40 units at $13
15
30
Sale
50 units
16
17
The business maintains a perpetual inventory system, costing by the first-in, first-out method.
18
Using the chart below, determine the cost of ending inventory.
19
20
Sales
Date
Purchases
Inventory
21
(Cost of goods)
22
Unit
Cost
Total
Unit
Cost
Total
Unit
Cost
Total
23
24
1-Jun
25
26
27
6-Jun
28
Sheet1
Ready
囲
100%
>
P.
17
Transcribed Image Text:AutoSave Module 7 Excel Quiz Excel Search Sebastian Beltran 回 X Off SB File Home Insert Page Layout Formulas Data Review View Help A Share Comments Insert Calibri v 11 ab Delete Paste $ • % 9 58 28 Conditional Format as Cell Sort & Find & Ideas Sensitivity BI U A K0 .00 00 0 v Format Formatting v Table v Styles v Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity C23 fx A В C D E F G H K M Q R U 7 Perpetual Inventory Using FIFO 8 Beginning inventory, purchases,and sales data for Keurig coffee machines are as follows: 9. 10 June 1 Inventory 50 units at $10 11 6. Sale 20 units 12 14 Purchase 90 units at $11 13 19 Sale 60 units 14 25 Purchase 40 units at $13 15 30 Sale 50 units 16 17 The business maintains a perpetual inventory system, costing by the first-in, first-out method. 18 Using the chart below, determine the cost of ending inventory. 19 20 Sales Date Purchases Inventory 21 (Cost of goods) 22 Unit Cost Total Unit Cost Total Unit Cost Total 23 24 1-Jun 25 26 27 6-Jun 28 Sheet1 Ready 囲 100% > P. 17
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.