(a1) Calculate average-cost per unit. (Round answer to 2 decimal places, e.e. 2.76.)
(a2) Determine ending inventory under (1) specific identification, (2) FIFO, (3) LIFO, and (4) average-cost. (Round answer to 0 decimal places, e.g. 2,760.)
(b1) Calculate price index. (Round answer to 4 decimal places, e.g. 2.7600.)
(b2) Determine ending inventory using dollar-value LIFO. Assume that the December 2, 2020, purchase cost is the current cost of inventory.(Hint: The beginning inventory is the base layer priced at $25 per unit.) (Round answer to 0 decimal places, e.g. 2,760.)
Homework Answers
(a1)
| Date | Particulars | No. of units | Cost per unit | Amount |
| 20-07-20 | purchases | 50 | $ 31.00 | $ 1,550.00 |
| 02-12-20 | purchases | 195 | $ 37.00 | $ 7,215.00 |
| 245 | $ 35.78 | $ 8,765.00 | ||
| average cost per unit | $ 35.78 |
(a2)
(1) SPECIFIC IDENTIFICATION/(2) FIFO
| FIFO | Cost of goods available for sale | Cost of goods sold | Ending inventory | |||||||
| DATE | No. of units | Cost per unit | Cost of goods available for sale | No. of units | Cost per unit | Cost of goods sold | No. of units in ending inventory | Cost per unit | Ending inventory | |
| 01-01-20 | Opening Stock | 195 | $ 24.0 | $ 4,680 | ||||||
| 15-03-20 | Purchases | 395 | $ 29.0 | $ 11,455 | ||||||
| 10-04-20 | Sales | 195 | $ 24.00 | $ 4,680 | ||||||
| 100 | $ 29.00 | $ 2,900 | ||||||||
| 295 | $ 29.00 | $ 8,555 | ||||||||
| 20-07-20 | Purchases | 395 | $ 31.0 | $ 12,245 | ||||||
| 20-08-20 | Sales | 295 | $ 29.00 | $ 8,555 | ||||||
| 100 | $ 31.00 | $ 3,100 | ||||||||
| 295 | $ 31.00 | $ 9,145 | ||||||||
| 04-09-20 | Purchases | 295 | $ 34.0 | $ 10,030 | ||||||
| 18-11-20 | Sales | 245 | $ 31.00 | $ 7,595 | ||||||
| 50 | $ 31.00 | $ 1,550 | ||||||||
| 295 | $ 34.00 | $ 10,030 | ||||||||
| 02-12-20 | Purchases | 195 | $ 37.0 | $ 7,215 | ||||||
| 12-12-20 | Sales | 50 | $ 31.00 | $ 1,550 | ||||||
| 245 | $ 34.00 | $ 8,330 | ||||||||
| 50 | $ 34.0 | $ 1,700 | ||||||||
| 195 | $ 37.0 | $ 7,215 | ||||||||
| Total | 245 | $ 8,915 | ||||||||
(3) LIFO
| LIFO | Cost of goods available for sale | Cost of goods sold | Ending inventory | |||||||
| DATE | No. of units | Cost per unit | Cost of goods available for sale | No. of units | Cost per unit | Cost of goods sold | No. of units in ending inventory | Cost per unit | Ending inventory | |
| 01-01-20 | Opening Stock | 195 | $ 24.0 | $ 4,680 | ||||||
| 15-03-20 | Purchases | 395 | $ 29.0 | $ 11,455 | ||||||
| 10-04-20 | Sales | 295 | $ 29.00 | $ 8,555 | ||||||
| 195 | $ 24.00 | $ 4,680 | ||||||||
| 100 | $ 29.00 | $ 2,900 | ||||||||
| 20-07-20 | Purchases | 395 | $ 31.0 | $ 12,245 | ||||||
| 20-08-20 | Sales | 395 | $ 31.00 | $ 12,245 | ||||||
| 195 | $ 24.00 | $ 4,680 | ||||||||
| 100 | $ 29.00 | $ 2,900 | ||||||||
| 04-09-20 | Purchases | 295 | $ 34.0 | $ 10,030 | ||||||
| 18-11-20 | Sales | 245 | $ 34.00 | $ 8,330 | ||||||
| 195 | $ 24.00 | $ 4,680 | ||||||||
| 100 | $ 29.00 | $ 2,900 | ||||||||
| 50 | $ 34.00 | $ 1,700 | ||||||||
| 02-12-20 | Purchases | 195 | $ 37.0 | $ 7,215 | ||||||
| 12-12-20 | Sales | 195 | $ 37.00 | $ 7,215 | ||||||
| 50 | $ 34.00 | $ 1,700 | ||||||||
| 50 | $ 29.00 | $ 1,450 | ||||||||
| 195 | $ 24.00 | $ 4,680 | ||||||||
| 50 | $ 29.00 | $ 1,450 | ||||||||
| Total | 245 | 6130 | ||||||||
(4) WEIGHTED AVERAGE
Date Particulars No. of units Cost per unit Amount
| Opening Stock | 195 | $ 24.00 | $ 4,680.00 | |
| Mar-15 | Add: purchases | 395 | $ 29.00 | $ 11,455.00 |
| 590 | $ 27.35 | $ 16,135.00 | ||
| Apr-10 | Less: Sales | -295 | $ 27.35 | $ (8,067.50) |
| Jul-20 | Add: purchases | 395 | $ 31.00 | $ 12,245.00 |
| 690 | $ 29.44 | $ 20,312.50 | ||
| Aug-20 | Less: Sales | -395 | $ 29.44 | $ (11,628.17) |
| Sep-04 | Add: purchases | 295 | $ 34.00 | $ 10,030.00 |
| 590 | $ 31.72 | $ 18,714.33 | ||
| Nov-18 | Less: Sales | -245 | $ 31.72 | $ (7,771.20) |
| Dec-02 | Add: purchases | 195 | $ 37.00 | $ 7,215.00 |
| 540 | $ 33.63 | $ 18,158.13 | ||
| Dec-12 | Less: Sales | -295 | $ 33.63 | $ (9,919.72) |
| CLOSING BALANCE | 245 | $ 33.63 | $ 8,238.41 | |
| average cost per unit | $ 33.63 | |||
Add Answer to:
(a1) Calculate average-cost per unit. (Round answer to 2 decimal places, e.e. 2.76.) (a2) Determine ending inventory un...
Skysong Corporation began operations on December 1, 2019. The only inventory transaction in 2019 was the...
Skysong Corporation began operations on December 1, 2019. The only inventory transaction in 2019 was the purchase of inventory on December 10, 2019, at a cost of $22 per unit. None of this inventory was sold in 2019. Relevant information is as follows. 135 Ending inventory units December 31, 2019 December 31, 2020, by purchase date December 2, 2020 July 20, 2020 135 50 185 During the year 2020, the following purchases and sales were made. Purchases March 15 335...
Blue Corporation began operations on December 1, 2019. The only inventory transaction in 2019 was the...
Blue Corporation began operations on December 1, 2019. The only inventory transaction in 2019 was the purchase of inventory on December 10, 2019, at a cost of $25 per unit. None of this inventory was sold in 2019. Relevant information is as follows. Ending inventory units December 31, 2019 122 December 31, 2020, by purchase date December 2, 2020 122 July 20, 2020 50 172 During the year 2020, the following purchases and sales were made. Purchases Sales March 15...
Calculate cost per unit. (Round answer to 2 decimal places, e.g. 5.25.) Weighted-average cost per unit $ enter the weighted-average cost per unit in dollars rounded to 2 decimal places
You have the following information for Lily Inc. for the month ended June 30, 2022. Lily uses a periodic inventory system.DateDescriptionQuantityUnit Cost or Selling PriceJune1Beginning inventory40$ 60June4Purchase13563June10Sale11090June11Sale return1590June18Purchase5566June18Purchase return1066June25Sale6596June28Purchase3570Calculate cost per unit. (Round answer to 2 decimal places, e.g. 5.25.)Weighted-average cost per unit$ enter the weighted-average cost per unit in dollars rounded to 2 decimal places
Information about Vinzant Company’s inventory of one item follows. Compute the cost of the ending inventory...
Information about Vinzant Company’s inventory of one item
follows.
Compute the cost of the ending inventory under the
average cost method.
Compute the cost of the ending inventory under the FIFO
method.
Compute the cost of the ending inventory under the LIFO
method.
Number of Unit Units Cost 135 $ 270 Explanation Beginning inventory, January 1 Purchases: April August October Ending inventory, December 31 175 195 145 135 275 280 282 Complete this question by entering your answers in the...
E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost...
E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost $5 1,830 Inventory, December 31, prior year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current year 6,130 4,130 2,810 2 Required: Compute ending...
Calculate average cost for each unit (Round answers to 3 decimal places, e.g 5.125) Jan 1 $ Jan 2 $ Jan 6 $ Jan 9 $ Jan...
Calculate average cost for each
unit (Round answers to 3 decimal places, e.g 5.125)
Jan 1 $
Jan 2 $
Jan 6 $
Jan 9 $
Jan 10 $
Jan 23 $
Jan 30 $
For each of the following cost flow assumptions, calculate (i)
cost of goods sold, (ii) ending inventory, and (iii) gross profit.
(Round answers to 0 decimal places, e.g.
125.)
(1)
LIFO.
(2)
FIFO.
(3)
Moving-average.
Problem 6-08A a1-a2 Wildhorse Co. is a retailer operating in...
E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost...
E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Unit Units Cost Inventory, December 31, prior 1,980 $8 year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current 6,090 4,150 7 2,840 year Required: Compute ending...
Exercise 8-12 Carol Garcia Company was formed on December 1, 2019. The following information is available from Garcia's...
Exercise 8-12 Carol Garcia Company was formed on December 1, 2019. The following information is available from Garcia's inventory records for Product BAP Units Unit Cost January 1, 2020 (beginning inventory) 1,320 7 Purchases: January 5, 2020 January 25, 2020 February 16, 2020 2,640 8 2,860 9 1,760 10 March 26, 2020 1,320 11 A physical inventory on March 31, 2020, shows 3,520 units on hand. Prepare schedule to compute the ending inventory at March 31, 2020, under FIFO inventory...
E7-5 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost...
E7-5 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost $5 1,930 Inventory, December 31, prior year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current year 7 5,080 2,830 4,040 Required: Compute ending...
Date Explanation Units Unit Cost Total Cost June 1 Inventory 123 $ 615 Purchases 2,106 Purchases...
Date Explanation Units Unit Cost Total Cost June 1 Inventory 123 $ 615 Purchases 2,106 Purchases 1,358 Inventory Calculate weighted average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted average unit cost $ e Textbook and Media Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round answers to 0 decimal places, e.g. 125.) FIFO LIFO Average-cost The cost of the ending inventory The cost of goods sold
Skysong Corporation began operations on December 1, 2019. The only inventory transaction in 2019 was the purchase of inventory on December 10, 2019, at a cost of $22 per unit. None of this inventory was sold in 2019. Relevant information is as follows. 135 Ending inventory units December 31, 2019 December 31, 2020, by purchase date December 2, 2020 July 20, 2020 135 50 185 During the year 2020, the following purchases and sales were made. Purchases March 15 335...
Information about Vinzant Company’s inventory of one item
follows.
Compute the cost of the ending inventory under the
average cost method.
Compute the cost of the ending inventory under the FIFO
method.
Compute the cost of the ending inventory under the LIFO
method.
Number of Unit Units Cost 135 $ 270 Explanation Beginning inventory, January 1 Purchases: April August October Ending inventory, December 31 175 195 145 135 275 280 282 Complete this question by entering your answers in the...
E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost $5 1,830 Inventory, December 31, prior year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current year 6,130 4,130 2,810 2 Required: Compute ending...
Calculate average cost for each
unit (Round answers to 3 decimal places, e.g 5.125)
Jan 1 $
Jan 2 $
Jan 6 $
Jan 9 $
Jan 10 $
Jan 23 $
Jan 30 $
For each of the following cost flow assumptions, calculate (i)
cost of goods sold, (ii) ending inventory, and (iii) gross profit.
(Round answers to 0 decimal places, e.g.
125.)
(1)
LIFO.
(2)
FIFO.
(3)
Moving-average.
Problem 6-08A a1-a2 Wildhorse Co. is a retailer operating in...
E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Unit Units Cost Inventory, December 31, prior 1,980 $8 year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current 6,090 4,150 7 2,840 year Required: Compute ending...
Exercise 8-12 Carol Garcia Company was formed on December 1, 2019. The following information is available from Garcia's inventory records for Product BAP Units Unit Cost January 1, 2020 (beginning inventory) 1,320 7 Purchases: January 5, 2020 January 25, 2020 February 16, 2020 2,640 8 2,860 9 1,760 10 March 26, 2020 1,320 11 A physical inventory on March 31, 2020, shows 3,520 units on hand. Prepare schedule to compute the ending inventory at March 31, 2020, under FIFO inventory...
E7-5 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost $5 1,930 Inventory, December 31, prior year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current year 7 5,080 2,830 4,040 Required: Compute ending...
Date Explanation Units Unit Cost Total Cost June 1 Inventory 123 $ 615 Purchases 2,106 Purchases 1,358 Inventory Calculate weighted average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted average unit cost $ e Textbook and Media Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round answers to 0 decimal places, e.g. 125.) FIFO LIFO Average-cost The cost of the ending inventory The cost of goods sold
Most questions answered within 3 hours.
-
Hydrobromic acid
dissolves solid iron according to the followiaung reaction:
Fe(s)+2HBr(aq)→
FeBr2(aq)+ H2(g)
Part A. What...
asked 1 hour ago -
Verify the following vector identity in SPHERICAL
COORDINATES.
div(curl(A)) = 0
asked 3 hours ago -
The work function (Φ) for a metal is 7.50×10-19 J.
What is the longest wavelength (nm)...
asked 3 hours ago -
1. Would the following procedural changes cause the
calculated mass percent Ni2+ ion in Ni(NH3)nCl2 to...
asked 5 hours ago -
1. Why does the voltage of the capacitor vary with frequency?
where does this missing voltage...
asked 6 hours ago -
p p please write each step out clearly
3. A manager of a company is considering...
asked 5 hours ago -
On October 1, Ebony Ernst organized Ernst Consulting; on October
3, the owner contributed $83,540 in...
asked 6 hours ago -
A.)As an electron moves through a region of space, its speed
decreases from 9.60 × 106...
asked 6 hours ago -
In java with the netbeans program do:
Through object programming
Create a class "ContadorP", which is...
asked 6 hours ago -
Pattern Corporation acquired all of Science
Company's outstanding stock on January 1, 2016 for $600,000 cash....
asked 6 hours ago -
Here are all accounts Tyler Co. maintains.
Tax expenses $4,750
Common stocks $48,840
SG&A expenses $2,500...
asked 7 hours ago -
Lis
out the types and equation of wind profile and the respective
variables in the fds...
asked 7 hours ago