Military Surplus began July 2018 with 90 stoves that cost $20 each. During the month, the company made the following purchases at cost:
The company sold 338 stoves and on July 31, the ending inventory consisted of 62 stoves The sales price of each stove was $ 45
1. Determine the cost of goods sold and ending inventory amounts for July under the average-cost, FIFO, and LIFO costing methods. Round the average cost per unit to two decimal places, and round all other amounts to the nearest dollar.
2. Explain why cost of goods sold is highest under LIFO. Be specific.
3. Prepare the Military Surplus income statement for July. Report gross profit. Operating expenses totaled $ 4500. The company uses average costing for inventory. The income tax rate is 32%.
1.
Average Cost Method
Units | Unit Cost | Total Cost | |
Beginning Inventory | 90 | $ 20.00 | $ 1,800.00 |
Purchases | |||
July 6 | 120 | $ 25.00 | $ 3,000.00 |
July 18 | 130 | $ 30.00 | $ 3,900.00 |
July 26 | 60 | $ 35.00 | $ 2,100.00 |
400 | $ 27.00 | $ 10,800.00 |
Average Cost = Total Inventory Cost / Total Units
= $10800 / 400 = $27 per unit
Cost of Goods Sold = 338 x $27 = $9126
Ending Inventory = 62 x $27 = $1674
FIFO Method
Under FIFO method, inventory purchased first is sold first,
therefore ending Inventory Consists of Purchases made at last
Ending inventory
60 units from July 26 Purchase i.e. 60 x $35 = $2100
Balance 2 units from July 18 Purchase i.e. 2 x $30 = $60
Total Ending Inventory = $2160
Cost of Goods Sold = Total Inventory Cost - Ending
Inventory
= $10800 - $2160 = $8640
LIFO Method
Under LIFO method, inventory purchased last is sold first,
therefore ending Inventory Consists of Purchases made at
earliest
Ending Inventory
62 units from Beginning Balance i.e. 62 x $20 = $1240
Cost of Goods Sold = $10800 - $1240 = $9560
2.
Cost of Goods Sold under LIFO is highest because sales is made from
purchases made at last which is compartively at higher cost than
the purchases made earlier.
3. Average Cost
Income Statement | |
Sales Revenue | $ 15,210 |
Cost of Goods Sold | $ 9,126 |
Gross Profit | $ 6,084 |
Operating Expenses | $ 4,500 |
Operating Income | $ 1,584 |
Income Tax @32% | $ 507 |
Net Income | $ 1,077 |
Military Surplus began July 2018 with 90 stoves that cost $20 each. During the month, the...
Navy Seals Surplus began March 2018 with 80 stoves that cost $10 each. During the month, the company made the following purchases at cost: (Click the icon to view the purchases.) The company sold 240 stoves, and at March 31, the ending inventory consisted of 60 stoves. The sales price of each stove was $49. Read the requirements. Requirement 1. Determine the cost of goods sold and ending inventory amounts for March under the average-cost, FIFO, and LIFO costing methods....
please help with the requirements on this problem P6-71B (similar to) Air Force Surplus began July 2018 with 100 stoves that cost S15 each. During the month, the company made the following purchases at cost: E: (Click the icon to view the purchases.) The company sold 336 stoves, and at July 31, the ending inventory consisted of 64 stoves. The sales price of each stove was $45. Read the requirements Requirement 1. Determine the cost of goods sold and ending...
please assist with solving requirements for this problem This problem was posted in past but answer was incorrect Thank you! Air Force Surplus began July 2018 with 100 stoves that cost $15 each. During the month, the company made the following purchases at cost: (Click the icon to view the purchases.) The company sold 336 stoves, and at July 31, the ending inventory consisted of 64 stoves. The sales price of each stove was $45. Read the requirements. Requirement 1....
ds) SWAT Surplus begea h, the company made the fol. 02 3. What is the cost of the P6-71B. (Learning Objective 2: Compare inventory by three methods) su March 2018 with 100 tents that cost $10 each. During the month, the com lowing purchases at cost: Mar 6 18 26 110 tents @ $20 = $2,200 120 tents @ $25 = 3,000 40 tents @ $30 = 1,200 The company sold 318 tents, and at March 31, the ending inventory...
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...
Assume that a company started July with 60 units of merchandise inventory that cost S68 each. During Jly, the company made the following purchases: (Click the icon to view the purchases.) The company uses a periodic inventory system. Assume that a physical inventory count on July 31 indicates that 90 units are on hand. (For weighted-average calculations, round per unit costs to the nearest cent and all other amounts to the nearest dollar.) Data Table (A) Calculate the cost of...
Lyon Center began operations on July 1. It uses a perpetual inventory system. During July, the company had the following purchases and sales. Purchases Date Sales Units Units 7 Unit Cost $62 July 1 July 6 July 11 3 $66 July 14 July 21 July 27 Calculate average cost for each unit. (For calcula rs purpose round unit costs to 2 decimal places, eg. 15.25.) July 1 $ July 6 $ Determine the ending inventory under a perpetual inventory system...
Right Now Electronic Center began Dec with 90 units of merchandise inventory that cost $74 each. During Dec, the store made the following purchases: Dec 3: 20 units @ $76 each Dec 12: 30 units @ $78 each Dec 18: 60 units @ $94 each Right Now uses the periodic inventory system, and the physical count at Dec 31 indicates that 80 units of inventory are on hand. 1a. Determine the ending merchandise inventory and cost of goods sold amounts...
Novak Corp, 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 10 $129 July 6 July 11 14 $145 July 14 July 21 16 July 27 Calculate the average cost per unit at July 1, 6, 11, 14, 21 & 27. (Round answers to 3 decimal places, es $105.251.) Average cost for each unit 1$ July July 6 $...
Up-to-Date Election Center began December with 90 units of merchandise inventory that cost $80 each During Decemberthere made the wing purchases RB Click the con low the purchases Uplo Dates the periodic inventory system and the physical count at December indicates that units of merchandise for en hand Read the requirements Requirement. Deforme the ending merchandise ventory and cost of goods amounts for the December financial statements using the FIFO, UFO, and weighted average verlorycoing methods O Weighted average Ending...