Question
Exercise 1 FIFO Perpetual Lighting Designs by Laura has the following list of beginning inventory, purchases, and sales for the month of June: 1 st
Exercise 1 FIFO Perpetual
Lighting Designs by Laura has the following list of beginning inventory, purchases, and sales for the month of June:
1st Beginning Inventory 600 light bulbs at $0.20
4th Purchase 400 light bulbs at $0.30
10th Sale 750 light bulbs at $1.75
13th Purchase 300 light bulbs at $0.25
19th Sale 370 light bulbs at $2.00
23rd Purchase 300 light bulbs at $0.35
28th Sale 160 light bulbs at $1.80
Determine the cost of merchandise sold for each sale (10th, 19th, and 28th). Calculate the cost of ending inventory using the first-in, first-out method under a perpetual inventory system.
Exercise 2 LIFO Perpetual
Lighting Designs by Laura has the following list of beginning inventory, purchases, and sales for the month of June:
1st Beginning Inventory 600 light bulbs at $0.20
4th Purchase 400 light bulbs at $0.30
10th Sale 750 light bulbs at $1.75
13th Purchase 300 light bulbs at $0.25
19th Sale 370 light bulbs at $2.00
23rd Purchase 300 light bulbs at $0.35
28th Sale 160 light bulbs at $1.80
Determine the cost of merchandise sold for each sale (10th, 19th, and 28th). Calculate the cost of ending inventory using the last-in, first-out method under a perpetual inventory system.
Exercise 3 Periodic (FIFO, LIFO, Average)
Spring River sells bottled water using a periodic inventory system. The following is a list of beginning inventory and purchases for bottles used in manufacturing their spring water.
Beginning Inventory 10,000 bottles at $0.10
First Purchase 5,500 bottles at $0.16
Second Purchase 6,000 bottles at $0.12
Third Purchase 4,000 bottles at $0.18
At the end of the year, 4,500 bottles remained in ending inventory. What is cost of merchandise sold and ending inventory under the FIFO, LIFO and average cost methods? Present your answers in the following form (in an excel spreadsheet). Round to the nearest dollar.
Cost
Inventory Method Merchandise Inventory Merchandise Sold
a. FIFO $ $
b. LIFO
c. Weighted average cost
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started