Fit World began January with merchandise inventory of 90 crates of vitamins that cost a total of $ 5,850. During the month, Fit
World purchased and sold merchandise on account as follows:Jan 2 Purchases 130 crates @ 76 eachJan 5 Sale 140 crates @ 100 eachJan 16 Purchases 170 crates @ 86 eachJan 27 Sale 180 crates @ 104eachRequirement 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 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 of merchandise inventorypurchased, sold, and on hand at the end of the period. (Enter the oldest inventory layers first.)PurchasesCost of Goods SoldInventory on HandUnitTotalUnitTotalUnitTotalDateQuantityCostCostQuantityCostCostQuantityCostCostJan. 1251627TotalsGross profit is $_______ using the FIFO inventory costing method.Requirement 2. Prepare a perpetual inventory record, using the LIFO 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 ending merchandise inventory 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 inventorypurchased, sold, and on hand at the end of the period. (Enter the oldest inventory layers first.)PurchasesCost of Goods SoldInventory on HandUnitTotalUnitTotalUnitTotalDateQuantityCostCostQuantityCostCostQuantityCostCostJan. 1251627TotalsGross profit is $_______using the LIFO inventory costing method.Requirement 3. Prepare a perpetual inventory record, using theweighted-average inventory costing method, and determine thecompany's cost of goods sold, ending merchandise inventory, and gross profit.Begin by computing the cost of goods sold and cost of ending merchandise inventory using the weighted-average 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 inventorypurchased, sold, and on hand at the end of the period. (Round weighted average cost per unit to the nearest cent and all other amounts to the nearest dollar.)PurchasesCost of Goods SoldInventory on HandUnitTotalUnitTotalUnitTotalDateQuantityCostCostQuantityCostCostQuantityCostCostJan. 1251627TotalsGross profit is $_____using the weighted-average inventory costing method.Requirement 4. If the business wanted to pay the least amount of income taxes possible, which method would it choose?If the business wanted to pay the least amount of income taxespossible, they would choose (select correct answer; FIFO, LIFO or weighted-average).
1 answer:
Answer:
1. FIFO method
A. Cost of Goods sold is $24,330
B. Ending inventory is $6,020
C. Gross profit is $8,390
2. LIFO method
A. Cost of goods sold is $25,800
B. Ending inventory is $4,550
C. Gross profit is $6,920
3. WA method
A. Cost of goods sold is $24,655
B. Ending inventory is $5,695
C. Gross profit $8,065
4. If the business wanted to pay least taxes, they should use LIFO method of inventory costing
Explanation:
1. Using FIFO method of inventory costing, the cost of goods sold is computed as follows:
Jan 05 sale 140 crates
90 @ 65 = 5,850
50 @ 76 = 3,800
Total $9,650
Jan 27 sale 180 crates
80 @ 76 = 6,080
100 @ 86 = 8,600
Total $14,680
Therefore, $9,650 + $14,680 = $24,330
2. Inventory end using FIFO method
Beg 90 crates add total purchases of 300 crates total available crates is 390 less crates sold of 320 makes the inventory end reduce to 70 crates @ 86. Total amount of inventory at hand is 6,020.
3. Gross profit using FIFO method is computed as follows:
Total sales
Jan 05, 140 @ 100 = $14,000
Jan 27, 180 @ 104 = $18,720
Total amount of sales $32,720
Next, let’s deduct the computed cost of goods sold from total sales to arrive the gross profit. $32,720 - $24,330 = $8,390 (answer)
2. LIFO method (last purchases crates will be sold first)
Cost of goods sold:
Jan 05
130 @ 76 = 9,880
10 @ 65 = 650
total $10,530
Jan 27
170 @ 86 = 14,620
10 @ 65 = 650
total 15,270
total cost of goods sold $25,800
B. Ending inventory at hand using LIFO method
Beg inventory of 90 crates plus total purchases of 300 crates. Total available crates is 390 less total crates sold of 320 makes the ending inventory at hand reduce to 70 crates. Units per crates under this method is the oldest inventory per unit. This is because, under this method, all units sold are those purchased recently. So 70 crates x 65 = $4,550
C. Gross profit using LIFO
To compute the gross profit let’s deduct the cost of good sold computed above from the sales we already computed also.
Sales $32,720
less: COGS $25,800
Gross profit is $6,920
3. WEIGHTED AVERAGE method
Using this method, please refer to the attached file for more clear explanation.
4. If the business wants to pay least tax, they should choose the method that has the least per unit cost of ending inventory at hand. Due to least amount of inventory at hand the cost of goods sold is higher which leads to lesser gross profit reported which result to least amount of tax liability.
You might be interested in