Correct Answer:
Requirement a:
perpetual |
FIFO |
Cost of Goods Sold |
$ 136,838.00 |
Ending Inventory |
$ 35,916.00 |
Working:
Cost of Goods Available for sale |
||||
Units |
Cost per unit |
value |
||
Beginning Inventory |
01-Apr |
50 |
$ 212.00 |
$ 10,600.00 |
Beginning Inventory |
01-Apr |
102 |
$ 226.00 |
$ 23,052.00 |
Purchases |
10-Apr |
194 |
$ 273.00 |
$ 52,962.00 |
Purchases |
24-Apr |
295 |
$ 292.00 |
$ 86,140.00 |
Total |
641 |
$ 172,754.00 |
Perpetual FIFO |
||||||
A |
Total Units Available for sale |
641 |
$ 172,754.00 |
|||
Units Sold |
518 |
|||||
Ending Inventory Units |
123 |
|||||
Valuation |
||||||
Cost of Goods Sold |
50 |
$ 212.00 |
$ 10,600.00 |
|||
102 |
$ 226.00 |
$ 23,052.00 |
||||
194 |
$ 273.00 |
$ 52,962.00 |
||||
172 |
$ 292.00 |
$ 50,224.00 |
||||
$ - |
||||||
$ - |
||||||
B |
Cost of Goods Sold |
518 |
units |
$ 136,838.00 |
||
A-B |
Ending Inventory |
123 |
units |
$ 35,916.00 |
Requirement 2:
FIFO |
|
Gross profit |
$ 75,024.00 |
gross profit margin |
35.4% |
Working:
FIFO |
||
A |
Sales Revenue |
$ 211,862.00 |
B |
Cost of goods sold |
$ 136,838.00 |
C=A-B |
Gross profit |
$ 75,024.00 |
D =C/A *100 |
gross profit margin |
35.4% |
Sales Revenue = (75+238+205)*409 = $ 211,862.00
Requirement c:
The gross profit is higher than if the weighted average cost formula had been used in a perpetual inventory system because cost of goods sold is Lower under FIFO in a period of Rising prices than it would be using the average cost formula,
Under FIFO, ending inventory is $ 35,916.00, Cost of goods sold is $ 136,838.00, and the Gross profit is $ 75,024.00.
End of answer.
Please give a thumbs-up, it will be highly appreciated.
Thanks.
Show the work!Thank you Indigo Outdoor Stores Inc. uses a perpetual inventory system and has a...
Indigo Outdoor Stores Inc. uses a perpetual inventory system and has a beginning inventory, as at April 1, of 152 tents. This consists of 50 tents at a cost of $212 each and 102 tents at a cost of $226 each. During April, the company had the following purchases and sales of tents: Purchases Sales Date Units Unit Cost Units Unit Price Apr. 3 75 $409 10 194 ...
Bramble Outdoor Stores Inc. uses a perpetual inventory system and has a beginning inventory, as at April 1, of 148 tents. This consists of 51 tents at a cost of $206 each and 97 tents at a cost of $223 each. During April, the company had the following purchases and sales of tents: Sales Purchases Units Unit Cost Date Apr. 3 Units 75 Unit Price $414 202 $271 249 414 287 290 198 414 Determine the cost of goods sold...
Question 11 Grouper Outdoor Stores Inc. uses a perpetual inventory system and has a beginning inventory, as at April 1, of 149 tents. This consists of 51 tents at a cost of $210 each and 98 tents at a cost of $225 each. During April, the company had the following purchases and sales of tents: Purchases Units Unit Cost Date Apr. 3 10 Sales Units Unit Price 79 $420 205 $272 261 420 307 289 200 420 X Your answer...
Question 5 Swifty Limited uses a perpetual inventory system. The inventory records show the following data for its first month of operations: Date Explanation Units Unit Cost Total Cost Balance in Units Aug. 2 Purchases 249 $67 $16,683 249 3 Purchases 515 102 52,530 764 10 Sales (274) 490 15 Purchases 859 119 102,221 1,349 25 Sales (330) 1,019 (a) Your answer is correct. Calculate the cost of goods sold and ending inventory using the FIFO cost method. Cost of...
Wildhorse Co. began operations on July 1. It uses a perpetual inventory system. During July, the company had the following purchases and sales. Purchases Date Units Unit Cost Sales Units July 1 5 $166 July 6 3 July 11 6 $180 July 14 5 July 21 7 $191 July 27 5 Calculate the average cost per unit at July 1, 6, 11, 14, 21 & 27. (Round answers to 2 decimal places, e.g. $105.50.) Average cost for each unit July...
Case Defence sells smartphone cases and uses the perpetual inventory system. The following is information on the purchases and sales of "Defender Box” cases. On October 1, Case Defence had 33 units with a unit cost of $27. Sales Units Unit Price Purchases Units Unit Cost 23 28 - 33 Date Oct. 3 Oct. 6 Oct. 12 Oct. 19 Oct. 23 Oct. 30 Oct. 31 28 33 $63 $63 43 38 $63 28 Required: 1. Calculate the dollar value of...
Martinez Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month of June: Date Explanation Units Unit Cost Total Cost June 1 Beginning inventory 1,500 $6 $9,000.00 12 Purchases 2,480 7 17,360 15 Sale (2,610 ) 16 Purchases 4,560 8 36,480 23 Purchases 1,380 9 12,420 27 Sales (5,830 ) (a) Determine the cost of goods sold and the cost of the ending inventory using (1) FIFO and (2) Average cost. (Round average final answers...
Brief Exercise 6-5 Martinez Limited uses the average cost formula in a perpetual inventory system. Fill in the missing amounts for items [1] to [13] in the following perpetual inventory schedule. (Round per unit cost and total cost to 2 decimal places, e.g. 15.23.) Balance Cost of Goods Sold Purchases Total Cost Units Total Cost Total Units Cost Units Date $2,580 $172 15 April 1 [3] $ [4] $ 28 1] [2] $5,404 [8] $ 25 [5] [9] $ [71...
Bramble Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month of June: Explanation 1 Beginning inventory 2 Purchases 5 Sale 5 Purchases 3 Purchases 7 Sales Units Unit Cost Total Cost 1,510 $6 $9,060.00 2,520 7 17,640 (2,540) 4,320 8 34,560 1,490 13,410 (5,710) Na (a) Determine the cost of goods sold and the cost of the ending inventory using (1) FIFO and (2) Average cost. (Round average final answers to 2 decimal places,...
Novak Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month of June: Date Unit Cost $5 6 Total Cost $6,850.00 14,280 Explanation June 1 Beginning inventory 12 Purchases 15 Sale 16 Purchases 23 Purchases 27 Sales Units 1.370 2,380 (2,610) 4,480 1,600 (5,520) 31,360 12.800 8 (a) Determine the cost of goods sold and the cost of the ending inventory using (1) FIFO and (2) Average cost. (Round average final answers to 2 decimal...