Requirement 1
Average cost per unit = $4.80
Requirement 2
FIFO | LIFO | Weighted Average | |
Ending Inventory | $ 4,886 | $ 4,494 | $ 4,704 |
Cost of Goods Sold | $ 9,226 | $ 9,618 | $ 9,408 |
Requirement 3 and 4
Method that provide lowest GP = LIFO
Method that yeild lowest ending inventory = LIFO
Working
Units | Cost per unit | value | |
Beginning Balance | 140 | $ 4.50 | $ 630 |
Purchases | |||
1120 | $ 4.60 | $ 5,152 | |
560 | $ 4.90 | $ 2,744 | |
420 | $ 5.00 | $ 2,100 | |
700 | $ 4.98 | $ 3,486 | |
Total | 2940 | $ 14,112 |
.
Average Cost of Inventory | ||
Units | (A) | 2940 |
Total Cost | (B) | $ 14,112 |
Average Cost | (C=B/A) | $ 4.80 |
.
FIFO | ||||
Total Units Available for sale | 2940 | |||
Units Sold | 1960 | |||
Closing Stock in Units | 980 | |||
Valuation | ||||
Ending Inventory | 700 | @ | $ 4.98 | $ 3,486 |
280 | @ | $ 5.00 | $ 1,400 | |
Value Of Ending Inventory | $ 4,886 | |||
Cost of Goods sold | $ 9,226 | |||
LIFO | ||||
Total Units Available for sale | 2940 | |||
Units Sold | 1960 | |||
Closing Stock in Units | 980 | |||
Valuation | ||||
Ending Inventory | 140 | @ | $ 4.50 | $ 630 |
840 | @ | $ 4.60 | $ 3,864 | |
Value Of Ending Inventory | $ 4,494 | |||
Cost of Goods sold | $ 9,618 | |||
Weighted Average method | ||||
Total Units Available for sale | 2940 | |||
Units Sold | 1960 | |||
Closing Stock in Units | 980 | |||
Valuation | ||||
Ending Inventory | 980 | @ | $ 4.80 | $ 4,704 |
Value Of Ending Inventory | $ 4,704 | |||
Cost of Goods sold | (Total Purchase and opening stock Minus Closing Stock) | $ 9,408 |
Presented below is information related to Blowfish radios for the Splish Company for the month of...
Presented below is information related to Blowfish radios for the Oriole Company for the month of July. Units Sold Selling Price Total Total $ 780 6,400 600 $7.00 7.30 $4.200 4380 600 3.440 Date Transaction Units In Unit Cost July 1 Balance 200 $3.90 6 Purchase 1.600 4.00 7 Sale 10 Sale 12 Purchase 800 4.30 15 Sale 18 Purchase 22 Sale 25 Purchase 1.000 4.38 30 Sale Totals 4.200 400 7.40 2,960 800 2.640 800 7.40 5.920 4380 400...
Presented below is information related to Blowfish radios for the Sunland Company for the month of July. Units Sold Selling Price Total Total $ 507 4,160 390 390 $6.70 7.00 $2,613 2,730 2,236 Date Transaction Units In Unit Cost July 1 Balance 130 $3.90 6 Purchase 1,040 4.00 7 Sale 10 Sale 12 Purchase 520 4.30 15 Sale 18 Purchase 390 4.40 22 Sale 25 Purchase 650 4.38 30 Sale Totals 2,730 260 7.10 1,846 1,716 520 7.10 3,692 2,847...
Presented below is information related to Blowfish radios for the Nash Company for the month of July. Units Sold Selling Price Total Units In Unit Cost 120 $4.10 960 4.20 Total $ 492 4,032 $6.80 7.10 $2,448 2,556 480 4.502,160 Date Transaction July 1 Balance 6 Purchase 7 Sale 10 Sale 12 Purchase 15 Sale 18 Purchase 22 Sale 25 Purchase 30 Sale Totals 7.20 1.728 360 4.60 1,656 7.20 3,456 600 2,748 7.30 240 1,680 1,752 $11,940 2,520 $11,088...
Question 20 Presented below is information related to Blowfish radios for the Blossom Company for the month of July. Units Sold Selling Price Total Units In 130 1,040 Unit Cost $4.10 4.20 Total $ 533 4,368 390 390 $6.90 7.20 $2,691 2,808 Date July 1 6 7 10 12 15 18 22 25 30 520 4.50 2,340 Transaction Balance Purchase Sale Sale Purchase Sale Purchase Sale Purchase Sale Totals 260 7.30 1,898 390 4.60 1,794 520 7.30 3,796 650 4.58...
Exercise 8-13 Presented below is information related to Blowfish radios for the Waterway Company for the month of July. Units Sold Selling Price Total Unit Cost Total Date Transaction Units In $ 760 6,232 190 $4.00 July 1 Balance 6 urchase 1,520 4.10 570 $6.90 $3,933 4,104 7 Sale Sale Purchase 7.20 10 570 760 4.40 3,344 12 7.30 2,774 15 Sale 380 Purchase 4.50 18 570 2,565 5,548 22 Sale 760 7.30 4.48 25 Purchiase 950 4,256 Sale 380...
Presented below is information related to Blowfish radios for the Skysong Company for the month of July. Units Sold Selling Price Date July 1 6 7 10 Units In 160 1,280 Unit Cost $4.50 4.60 Total Total $ 720 5,888 6.80 7.10 $ 3,264 3,408 12 Transaction Balance Purchase Sale Sale Purchase Sale Purchase Sale Purchase Sale Totals 640 4.90 3,136 2,304 480 5.00 2,400 4,608 800 25 30 4.98 3,984 2,336 $15,920 3,360 $16,1282 ,240 Calculate average cost per...
Presented below is information related to BLANK radios for the BLANK Company for the month of July. Date Transaction Units In Unit Cost Total Units Sold Selling Price Total July 1 Balance 130 $3.90 $ 507 6 Purchase 1,040 4.00 4,160 7 Sale 390 $6.70 $ 2,613 10 Sale 390 7.00 2,730 12 Purchase 520 4.30 2,236 15 Sale 260 7.10 1,846 18 Purchase 390 4.40 1,716 22 Sale 520 7.10 3,692 25 Purchase 650 4.38 2,847 30 Sale 260 7.20...
E8.11 (LO3) (Compute FIFO and Average-Cost—Periodic) The following information is related to radios for the Couples Company for the month of July. Date Transaction Units In Units Cost Total Units Sold Selling Price Total July 1 Balance 100 $4.10 $ 410 6 Purchase 800 4.30 3,440 7 Sale 300 $7.00 $ 2,100 10 Sale 300 7.30 2,190 12 Purchase 400 4.51 1,804 15 Sale 200 7.40 1,480 18 Purchase 300 4.60 1,380 22 Sale 400 7.40 2,960 25 Purchase 500 ...
$4,10 6 100 800 E8.11 (103) (Compute FIFO and Average-Cost-Periodic) The following information is related to radios for the Couples Company for the month of July Units Units Selling Date Transaction Units In Cost Total Sold Price Total July 1 Balance $410 Purchase 4.30 3,440 Sale $7.00 $ 2.100 Sale 7.30 2.190 Purchase 1.804 15 Sale 7.40 1.480 Purchase 300 1,380 22 Sale 2.960 25 Purchase 500 4.58 2,290 30 Sale 200 7.50 1,500 Totals 2,100 $9,324 1.400 $10,230 4.51...
You are provided with the following information for Splish Brothers Inc. for the month ended June 30, 2020. Splish Brothers uses the periodic method for inventory.DateDescriptionQuantityUnit Cost or Selling PriceJune1Beginning inventory45$42June4Purchase13546June10Sale11573June11Sale return1373June18Purchase5448June18Purchase return948June25Sale6878June28Purchase2552(a1)Calculate weighted-average cost per unit. (Round answer to 2 decimal places, e.g. 5.25.)Weighted-average cost per unit$(a2)Calculate ending inventory, cost of goods sold, gross profit under each of the following methods. (1) LIFO. (2) FIFO. (3) Average-cost. (Round average-cost method answers to 2 decimal places, e.g. 1,250.25 and other answers to 0...