Athletic world began January with merchandise inventory of 70 crates of vitamins that cost a total of $4,550. During the month, Athletic World purchased and sold merchandise on account as follows.
Correct Answer:
Perpetual |
FIFO |
LIFO |
Weighted-Average |
Cost of goods sold |
$ 22,730.00 |
$ 23,630.00 |
$ 22,885.00 |
Ending inventory |
$ 4,150.00 |
$ 3,250.00 |
$ 3,995.00 |
Gross profit |
$ 10,310.00 |
$ 9,410.00 |
$ 10,155.00 |
Working:
FIFO |
LIFO |
Weighted-Average |
|
Sales revenue |
$ 33,040.00 |
$ 33,040.00 |
$ 33,040.00 |
Less: cost of goods sold |
$ 22,730.00 |
$ 23,630.00 |
$ 22,885.00 |
Gross profit |
$ 10,310.00 |
$ 9,410.00 |
$ 10,155.00 |
Perpetual FIFO |
|||||||||||
Date |
Goods Purchased |
Cost of Goods Sold |
Inventory Balance |
||||||||
# of Units |
Cost Per Unit |
Cost of Goods Available for sale |
# of Units Sold |
Cost per Unit |
Cost of Goods Sold |
# of Units |
Cost per Unit |
Inventory Balance |
|||
01-Jan |
70 |
$ 65.00 |
$ 4,550.00 |
||||||||
05-Jan |
130 |
$ 76.00 |
$ 9,880.00 |
130 |
$ 76.00 |
$ 9,880.00 |
|||||
70 |
$ 65.00 |
$ 4,550.00 |
|||||||||
13-Jan |
70 |
$ 65.00 |
$ 4,550.00 |
||||||||
70 |
$ 76.00 |
$ 5,320.00 |
60 |
$ 76.00 |
$ 4,560.00 |
||||||
18-Jan |
150 |
$ 83.00 |
$ 12,450.00 |
150 |
$ 83.00 |
$ 12,450.00 |
|||||
60 |
$ 76.00 |
$ 4,560.00 |
|||||||||
26-Jan |
60 |
$ 76.00 |
$ 4,560.00 |
||||||||
100 |
$ 83.00 |
$ 8,300.00 |
50 |
$ 83.00 |
$ 4,150.00 |
||||||
Cost of goods sold |
Ending Inventory |
||||||||||
Total |
300 |
$ 22,730.00 |
50 |
$ 4,150.00 |
|||||||
Perpetual LIFO |
|||||||||
Date |
Goods Purchased |
Cost of Goods Sold |
Inventory Balance |
||||||
# of Units |
Cost Per Unit |
Cost of Goods Available for sale |
# of Units Sold |
Cost per Unit |
Cost of Goods Sold |
# of Units |
Cost per Unit |
Inventory Balance |
|
01-Jan |
70 |
$ 65.00 |
$ 4,550.00 |
||||||
05-Jan |
130 |
$ 76.00 |
$ 9,880.00 |
130 |
$ 76.00 |
$ 9,880.00 |
|||
70 |
$ 65.00 |
$ 4,550.00 |
|||||||
13-Jan |
10 |
$ 65.00 |
$ 650.00 |
||||||
130 |
$ 76.00 |
$ 9,880.00 |
60 |
$ 65.00 |
$ 3,900.00 |
||||
18-Jan |
150 |
$ 83.00 |
$ 12,450.00 |
150 |
$ 83.00 |
$ 12,450.00 |
|||
60 |
$ 65.00 |
$ 3,900.00 |
|||||||
26-Jan |
10 |
$ 65.00 |
$ 650.00 |
||||||
150 |
$ 83.00 |
$ 12,450.00 |
50 |
$ 65.00 |
$ 3,250.00 |
||||
Cost of goods sold |
Ending Inventory |
||||||||
Total |
300 |
$ 23,630.00 |
50 |
$ 3,250.00 |
Perpetual Weighed-Average |
|||||||||||
Date |
Goods Purchased |
Cost of Goods Sold |
Inventory Balance |
||||||||
# of Units |
Cost Per Unit |
Cost of Goods Available for sale |
# of Units Sold |
Cost per Unit |
Cost of Goods Sold |
# of Units |
Cost per Unit |
Inventory Balance |
|||
01-Jan |
70 |
$ 65.00 |
$ 4,550.00 |
||||||||
05-Jan |
130 |
$ 76.00 |
$ 9,880.00 |
200 |
$ 72.15 |
$ 14,430.00 |
|||||
13-Jan |
140 |
$ 72.15 |
$ 10,101.00 |
||||||||
60 |
$ 72.15 |
$ 4,329.00 |
|||||||||
18-Jan |
150 |
$ 83.00 |
$ 12,450.00 |
210 |
$ 79.90 |
$ 16,779.00 |
|||||
26-Jan |
160 |
$ 79.90 |
$ 12,784.00 |
||||||||
50 |
$ 79.90 |
$ 3,995.00 |
|||||||||
Cost of goods sold |
Ending Inventory |
||||||||||
Total |
300 |
$ 22,885.00 |
50 |
$ 3,995.00 |
|||||||
End of answer.
Please give a thumbs-up, it will be highly appreciated.
Thanks.
Athletic world began January with merchandise inventory of 70 crates of vitamins that cost a total...
Athletic World began January with merchandise inventory of 72 crates of vitamins that cost a total of $3,600. During the month, Athletic World purchased and sold merchandise on account as follows: BE: (Click the icon to view the transactions.) Read the requirements. Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold and cost of...
Fit Gym began October with merchandise inventory of 78 crates of vitamins that cost a total of $4,290. During the month, Fit Gym purchased and sold merchandise on account as follows: EEB (Click the icon to view the transactions.) Read the requirements. Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold and cost of...
crates of vitamins that cost a total of $3,600. During the month, Athletic W i Data Table good the tra the qu Oct. 5 Purchase 13 Sale 18 Purchase 26 Sale 120 crates @ 130 crates @ 130 crates @ 140 crates @ $ $ $ $ 58 each 108 each 72 each 112 each stof Print | Done o the next question Activity Details Athletic World began October with merchandise inventory of 80 crates of vitamins that cost a...
Please show answers clearly. Fit Gym began July with merchandise inventory of 76 crates of vitamins that cost a total of $4,560. During the month, Fit Gym purchased and sold merchandise on account as follows: (Click the icon to view the transactions.) Read the requirements Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and delermine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold...
Athletic Word began May with merchandise inventory of 65 cretes or vitamins that cost total of $3.835 During the month, Athletic World purchased and sold merchandise on account as follows Click the icon to view the transactions.) Read the cours Total Requirement 1. Prepare a perpetual invertory record, using the FIFO inventory cesting method, and determine the company's cost of gouck cold, erding merchandise inventory, and grove proit. Begin by computing the cost of good cod and cost of encirg...
For planet began May with with merchandise inventory of 65 crates of of vitamins that cost a total of of $3,835. During the month, fit planet purchased and sold merchandise on account as follows: ms 50f 6 (3 complete) ▼ uring the month, Fit Planet purchased and sold merchandise on account as follows: determine the company's cost of goods sold, ending merchandise inventory, and gross profit. on ha Xhe olde Requirements ota Prepare a perpetual inventory record, using the FIFO...
ntory of 78 crates of vitamins that cost a total of $4,290. During the month, Exercise Planet purch Data Table x using the goods sold, end ending e all oft Enter th Oct. 5 Purchase 156 crates @ $ 64 each 100 each he transactions the quantity and 13 Sale 180 crates @ $ Costo 18 Purchase crates @ $ 75 each crates @ S 18 each o the next question Exercise Planet begon October with marchandise inventory of T...
Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross protit. Begin by computing the cost of goods sold and cost of ending merchandise inventory using the FIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost...
Steel Mill began August with 60 units of iron inventory that cost $ 25 each. During August the company completed the following inventory transactions: Units Unit Cost Unit Sales Price Aug. 3 Sale 45 $72 8 Purchase 65 $41 21 Sale 55 86 30 Purchase 20 56 Requirement 1. Prepare a perpetual inventory record for the merchandise inventory using the FIFO inventory costing method. Start by entering the beginning inventory balances. Enter the transactions in chronological order, calculating new inventory...
1. 2. Requirement 2. Determine the amount that would be reported in ending merchandise inventory on May 15 using the LIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter all amounts to the nearest cent, $X.XX. Enter...