Question

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

Homework Answers

Answer #1

ACCRODING TO FIFO METHOD UNITS IS (2200+2550+4100+2600-2400-5500)=3550 UNITS IS INVENTORY

WHICH VALUE IS( 2600*..8) +(950*.74)=$ 2783

ACCRODING TO LIFO METHOD UNITS IS 2600+950= 3550 BUT THESE UNITS IS SAVED FROM FIRST AND SECOND LOTS SO VALUE IS (2200*.63)+(150*.7)+(1200*.74)=$2379

ACCRODING TO AVERAGE METHOD UNITS IS 3550 BUT THESE UNITS ALSO SAVED FROM THE LAST TWO LOTS BUT THE VALUE IS

2200 UNITS 1386

2550 UNITS 1785

TOTAL UNITS 4750 IS 3171

SOLD 2400 UNITS AVERAGE BASIS IS 3171*2400/4750= 1602

THEN 2350 UNITS IS BALANCE IS 1569

PURCHASED 4100 UNITS IS 3034

PURCHASE 2600 UNITS IS 2080

TOTAL UNITS IS 9050 IS (1569+3034+2080) = 6683

SOLD 5500 UNITS IS = 6683*5500/9050= 4061

SO THE CLOSING INVENTORY 3550 UNITS IS 6683-4061= $ 2622

ENTRIES ( FIFO METHOD)

MAR.1

OPENING ENTRY FOR STOCK - NO ENTRY PASSED

MAR .3

DR. GOODS $ 1785

CR. CASH $ 1785

MAR.5 DR CASH $2640

CR GOODS$ 1526

CR PROFIT ON GOODS $ 1114

MAR.11 DR GOODS $ 3034

CR. CASH $ 3034

MAR 20 DR GOODS $ 2080

CR CASH $ 2080

MAR 30 DR CASH $6875

CR GOODS $ 3976

PROFIT ON GOODS $ 2899

CLOSING ENTRY WILL NOT BE PASSED

ACCRODIN TO LIFO METHOD

MAR .1 NO ENTRY

MAR .3 DR GOODS $ 1785

CR. CASH $ 1785

MAR .5 DR CASH $ 2640

CR GOODS $ $ 1680

CR PROFIT ON GOODS $ 960

MAR .11 DR GOODS $ 3034

CR CASH $ 3034

MAR .20 DR GOODS $ 2080

CR CASH $ 2080

MAR .30 DR CASH $ 6875

CR GOODS $4226

CR PROFIT ON GOODS $ 2649

CLOSING ENTRY WILL NOT BE PASSED

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Using a FIFO then LIFO perpetual cost flow, calculate (a) the value of the ending inventory...
Using a FIFO then LIFO perpetual cost flow, calculate (a) the value of the ending inventory and (b) the cost of merchandise sold for the month of November of Beamer Company using the data below. (USE provided worksheet) Nov. 1 Purchased 240 units $78 each 4 Sold 180 units 11 Purchased 280 units $80 each 12 Sold 220 units 22 Sold 90 units 23 Purchased 320 units                  $86 each
Determine Colour ending inventory and cost of goods sold under the LIFO perpetual basis. Begin by...
Determine Colour ending inventory and cost of goods sold under the LIFO perpetual basis. Begin by preparing Colour perpetual inventory record under the​ last-in, first-out​ (LIFO) method for the year Transaction Units Sales in Units Unit Cost Total Cost Beginning inventory 1/1 5,500 $51 $280,500 Purchases March 30 4,500 67 301,500 July 15 850 70 59,500 September 1 6,600 Total available for sale 10,850 $641,500 Units sold September 1 (6,600) Ending inventory 4,250 LIFO: Cost of Cost of Units Unit...
M7-7 Calculating Cost of Goods Available for Sale, Cost of Goods Sold, and Ending Inventory under...
M7-7 Calculating Cost of Goods Available for Sale, Cost of Goods Sold, and Ending Inventory under FIFO, LIFO, and Weighted Average Cost (Periodic Inventory) [LO 7-3] Aircard Corporation tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period as if it uses a periodic inventory system. The following are the transactions for the month of July. Units Unit Cost July 1 Beginning Inventory 2,500 $ 50...
Income tax effect of shifting from FIFO to LIFO The following information pertains to the inventory...
Income tax effect of shifting from FIFO to LIFO The following information pertains to the inventory of Parvin Company during Year 2: Jan. 1 Beginning Inventory 500 units @ $ 34 Apr. 1 Purchased 2,200 units @ $ 39 Oct. 1 Purchased 700 units @ $ 42 During Year 2, Parvin sold 3,100 units of inventory at $85 per unit and incurred $42,500 of operating expenses. Parvin currently uses the FIFO method but is considering a change to LIFO. All...
1 part A eriodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of...
1 part A eriodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 6 units at $44 $264 Aug. 7 Purchase 19 units at $46 874 Dec. 11 Purchase 13 units at $47 611 38 units $1,749 There are 16 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a)...
You are provided with the following information for Splish Brothers Inc. Splish Brothers Inc. uses the...
You are provided with the following information for Splish Brothers Inc. Splish Brothers Inc. uses the periodic system of accounting for its inventory transactions. March 1 Beginning inventory 1,935 liters at a cost of 58¢ per liter. March 3 Purchased 2,475 liters at a cost of 63¢ per liter. March 5 Sold 2,330 liters for $1.05 per liter. March 10 Purchased 3,945 liters at a cost of 70¢ per liter. March 20 Purchased 2,490 liters at a cost of 78¢...
4) Samuel’s Manufacturing (SM) began October with merchandise inventory of 70 chairs that cost a total...
4) Samuel’s Manufacturing (SM) began October with merchandise inventory of 70 chairs that cost a total of $49,000. During the month, SM purchased and sold merchandise on account as follows:   Oct 7 Purchase 30 chairs @ $750 each        14 Sale 30 chairs @ 1,200 each        18 Purchase 50 chairs @ $775 each        27 Sale 40 chairs @ $1,200 each Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods...
Error Analysis 1. All sales and purchases were made on credit. In the space provided in...
Error Analysis 1. All sales and purchases were made on credit. In the space provided in the table, indicate the effect of each error on the elements presented. Use the following symbols to answer this part: ↑ for when overestimated ↓ for when underestimated NE for when there is no effect Event Accounts Receivable Inventory Accounts Payable Sales Cost of goods sold Purchased goods, which are in transit, were noted as a purchase, but were excluded from the final inventory....
Desmond Consolidated Inc is a leading manufacturer of steel products.  The following inventory data relates to the...
Desmond Consolidated Inc is a leading manufacturer of steel products.  The following inventory data relates to the firms production during the first quarter of 2020: Date of Purchase Tons of Raw Steel Purchased Purchase Price per Ton Total Cost Jan 1 500 $38 $19,000 Jan 15 700 35 24,500 Feb 7 200 33   6,600 Feb 21 450 30 13,500 March 15 350 43 15,050 2200 $78,650 At the end of the first quarter of 2020. Desmond’s internal auditors determined that 1,700...
4) Samuel’s Manufacturing (SM) began October with merchandise inventory of 70 chairs that cost a total...
4) Samuel’s Manufacturing (SM) began October with merchandise inventory of 70 chairs that cost a total of $49,000. During the month, SM purchased and sold merchandise on account as follows:   Oct 7 Purchase 30 chairs @ $750 each        14 Sale 30 chairs @ 1,200 each        18 Purchase 50 chairs @ $775 each        27 Sale 40 chairs @ $1,200 each Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods...