Question

In: Accounting

Using the Data below a) Prepare FIFO, LIFO, average valueto ending inventory. b) Prepare all entries...

Using the Data below a) Prepare FIFO, LIFO, average valueto ending inventory. b) Prepare all entries for either FIFO or LIFO – including closing entries Use periodic inventory March 1 – Had 2,200 liters at $.63 each March 3 – Purchased 2,550 liters at .70 each March 5 SOLD 2,400 at $1.10 March 11 Purchased 4,100 liters at .74 each March 20 Purchased 2,600 liters at .80 each March 30 Sold 5,500 liters for $1.25

Solutions

Expert Solution

Stock statement onFIFO basis
Purchase Cost of Goods Sold Ending Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
01-Mar         2,200 $0.63 $1,386.00
03-Mar 2550 $0.70 $1,785.00         2,200 $0.63 $1,386.00
2550 $0.70 $1,785.00
05-Mar 2200 0.63 1386
          200 $0.70 140 2350 0.7 1645
11-Mar        4,100 $0.74 $3,034.00 2350 0.7 1645
        4,100 $0.74 $3,034.00
20-Mar 2600 0.8 2080 2350 0.7 1645
        4,100 $0.74 $3,034.00
2600 0.8 2080
30-Mar 2350 0.7 1645            950 $0.74 703
3150 0.74 2331 2600 0.8 2080
       9,250 $6,899.00       7,900 $5,502.00         3,550 $2,783.00
Stock statement on LIFO basis
Purchase Cost of Goods Sold Ending Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
01-Mar         2,200 $0.63 $1,386.00
03-Mar 2550 $0.70 $1,785.00         2,200 $0.63 $1,386.00
2550 $0.70 $1,785.00
05-Mar 2400 0.7 1680         2,200 $0.63 $1,386.00
150 0.7 105
11-Mar        4,100 $0.74 $3,034.00         2,200 $0.63 $1,386.00
150 0.7 105
        4,100 $0.74 $3,034.00
20-Mar 2600 0.8 2080         2,200 $0.63 $1,386.00
150 0.7 105
4100 0.74 3034
2600 0.8 2080
30-Mar 2600 0.8 2080         2,200 $0.63 $1,386.00
2900 0.7 2030 150 0.7 105
1200 0.74 888
       9,250 $6,899.00       7,900 $5,790.00         3,550 $2,379.00
Stock statement on Average basis
Purchase Cost of Goods Sold Ending Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
01-Mar         2,200 $0.63 $1,386.00
03-Mar 2550 $0.70 $1,785.00         4,750 $0.67 $3,171.00
05-Mar 2400 $0.67 $1,602.19         2,350 $0.67 $1,568.81
11-Mar        4,100 $0.74 $3,034.00         6,450 $0.71 $4,602.81
20-Mar 2600 0.8 2080         9,050 $0.74 $6,682.81
30-Mar 5500 $0.74 4061.377         3,550 $0.74 $2,621.43
       9,250 $6,899.00       7,900 $5,663.57         3,550 $0.74 $2,621.43
Journal Entry ( On FIFO Basis)
Date Account Tittle & Explanation Debit Credit
03-Mar Inventory $1,785
Account Payable/Cash $1,785
To Record Purchase of 2550 Litre
05-Mar Account Recievable/Cash $2,640
Sales $2,640
To Record Sales of 2400 Litre @$1.10
05-Mar Cost of Goods Sold $1,526
Inventory $1,526
To Record Cost of Goods Sold
11-Mar Inventory $3,034
Account Payable/Cash $3,034
To Record Purchase of 4100 Litre
20-Mar Inventory $2,080
Account Payable/Cash $2,080
To Record Purchase of 2600 Litre
05-Mar Account Recievable/Cash $6,875
Sales $6,875
To Record Sales of 5500 Litre @$1.25
30-Mar Cost of Goods Sold $3,976
Inventory $3,976
To Record Cost of Goods Sold

Related Solutions

Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods.
Inventory Costing Methods: Periodic Inventory Systems. (Appendix 6B)Tyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory20 units @ $510Purchase30 units @ $820Sales40 units @ $1525Purchase25 units at $10Assume that the company uses the periodic inventory system.Required:Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods. (Note: Use four decimal places for per-unit calculations and...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that Madden Company reports the following initial balance and subsequent purchase of inventory. Inventory balance at beginning of year 1,820 units @ $150 each $273,000 Inventory purchased during the year 2,380 units @ $180 each 428,400 Cost of goods available for sale during the year 4,200 units $701,400 Assume that 2,800 units are sold during the year. Compute the cost of goods sold for the...
E5.7 Calculate inventory and cost of sales using FIFO, LIFO and average cost.
E5.7 Calculate inventory and cost of sales using FIFO, LIFO and average cost. Fenning Pty Ltd reports the following for the month of June: Required a. Calculate cost of the ending inventory and the cost of sales under (1) FIFO, (2) LIFO and (3) average cost b. Which costing method gives the highest ending inventory and the highest cost of sales? Why? c. How do the average cost values for ending inventory and cost of sales compare with ending inventory and cost of sales for FIFO and...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 36 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 43 $ 7.10 $ 305.30 April 1 38 6.35 241.30 June 1 53 6.10 323.30 September 1 48 6.60 316.80 Total 182 $ 1,186.70 Cost of...
Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted...
Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods. Description # of units Cost per unit Beginning inventory: 20 20 Jan.15 Purchase: 22 27 Jan. 20 Sale 10 blank Jan.25 Purchase 18 25 Jan.28 Sale   15 blank
How can i calculate Cost of goods sold and ending inventory using FIFO, LIFO and the...
How can i calculate Cost of goods sold and ending inventory using FIFO, LIFO and the periodic system given the information below? On December 1, 2017, Ivanhoe Company had the account balances shown below. Debits Credits Cash $5,180 Accumulated Depreciation—Equipment $1,460 Accounts Receivable 4,230 Accounts Payable 2,710 Inventory (2,900 x $0.60) 1,740 Common Stock 10,200 Equipment 21,400 Retained Earnings 18,180 $32,550 $32,550 The following transactions occurred during December. Dec. 3 Purchased 3,900 units of inventory on account at a cost...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 38 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 54 $ 7.50 $ 405.00 April 1 49 6.75 330.75 June 1 64 6.50 416.00 September 1 59 7.00 413.00 Total 226 $ 1,564.75. FIFO $...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 33 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 41 $ 7.80 $ 319.80 April 1 36 7.05 253.80 June 1 51 6.80 346.80 September 1 46 7.30 335.80 Total 174 $ 1,256.20 Cost of...
Using Weighted Average, FIFO and LIFO inventory cost flow methods calculate inventory. Be sure to show...
Using Weighted Average, FIFO and LIFO inventory cost flow methods calculate inventory. Be sure to show all work!!! Beginning Inventory 600 units @$6 February purchase 400 units @$7 April Purchase 700 units @$8 June purchase 300 units @$9 sold 500 units Weighted Average FIFO LIFO
Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods.
Penn Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1:Required Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT