Question

In: Accounting

Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales...

Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions

Date Activities Units Acquired at Cost Units Sold at Retail
Jan. 1 Beginning inventory 660 units @ $35 per unit
Feb. 10 Purchase 330 units @ $32 per unit
Mar. 13 Purchase 110 units @ $20 per unit
Mar. 15 Sales 760 units @ $75 per unit
Aug. 21 Purchase 180 units @ $40 per unit
Sept. 5 Purchase 570 units @ $36 per unit
Sept. 10 Sales 750 units @ $75 per unit
Totals 1,850 units 1,510 units

    
Required:
1.
Compute cost of goods available for sale and the number of units available for sale.

2. Compute the number of units in ending inventory.

3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, units sold consist of 660 units from beginning inventory, 230 from the February 10 purchase, 110 from the March 13 purchase, 130 from the August 21 purchase, and 380 from the September 5 purchase. (Round your average cost per unit to 2 decimal places.)

Compute the cost assigned to ending inventory using FIFO. (Round your average cost per unit to 2 decimal places.)

Perpetual FIFO:
Goods Purchased Cost of Goods Sold Inventory Balance
Date # of units Cost per unit # of units sold Cost per unit Cost of Goods Sold # of units Cost per unit Inventory Balance
Jan 1 660 @ $35.00 = $23,100.00
Feb 10
Mar 13
Mar 15
Aug 21
Sept 5
Sept 10
Totals $0.00 $0.00

4. Compute gross profit earned by the company for each of the four costing methods. (Round your average cost per unit to 2 decimal places.)

FIFO LIFO Weighted Average Specific Identification
Sales
Less: Cost of goods sold
Gross profit $0 $0 $0 $0

This is repeated for Perpetual LIFO, Weighted Average, and Specific ID as well.

Solutions

Expert Solution

Due to restriction could not uploas full Answer.Up;oading images for remaining parts
Perpetual FIFO:
Goods Purchased Cost of Goods Sold Inventory Balance
Date # of units Cost per unit # of units sold Cost per unit Cost of Goods Sold # of units Cost per unit Inventory Balance
1-Jan 660 @ $35.00 = $23,100.00
10-Feb 660 @ $35.00 = $23,100.00
330 $32 330 @ $32.00 = $10,560.00
13-Mar 660 @ $35.00 = $23,100.00
330 @ $32.00 = $10,560.00
110 $20 110 @ $20 $2,200.00
15-Mar 760 660 $35 $23,100.00 0 @ $35.00 = $0.00
100 $32.00 $3,200.00 230 @ $32.00 = $7,360.00
110 @ $20 $2,200.00
21-Aug
230 @ $32.00 = $7,360.00
110 @ $20 $2,200.00
180 $40 180 @ $40.00 = $7,200.00
5-Sep
230 @ $32.00 = $7,360.00
110 @ $20 $2,200.00
180 @ $40.00 = $7,200.00
570 $36 570 @ $36.00 = $20,520.00
10-Sep 750 230 $32 $7,360
110 $20 $2,200
180 $40 $7,200
230 $36 $8,280 340 @ $36.00 = $12,240.00
Totals 1190 1510 $51,340.00 340 @ $36.00 = $12,240.00
Perpetual LIFO:
Goods Purchased Cost of Goods Sold Inventory Balance
Date # of units Cost per unit # of units sold Cost per unit Cost of Goods Sold # of units Cost per unit Inventory Balance
1-Jan 660 @ $35.00 = $23,100.00
10-Feb 660 @ $35.00 = $23,100.00
330 $32 330 @ $32.00 = $10,560.00
13-Mar 660 @ $35.00 = $23,100.00
330 @ $32.00 = $10,560.00
110 $20 110 @ $20 $2,200.00
15-Mar 760 110 $20 $2,200.00
330 $32.00 $10,560.00
320 $35 $11,200.00 340 @ $35.00 = $11,900.00
21-Aug
340 @ $35.00 = $11,900.00
180 $40 180 @ $40.00 = $7,200.00
5-Sep
340 @ $35.00 = $11,900.00
180 @ $40.00 = $7,200.00
570 $36 570 @ $36.00 = $20,520.00
10-Sep 750 570 $36 $20,520
180 $40 $7,200
340 @ $35.00 = $11,900.00
Totals 1190 1510 $51,680.00 340 @ $35.00 = $11,900.00
GROSS PROFIT EARNED
Sales Revenue=760*75+750*75=1510*75= $        113,250
FIFO LIFO Weighted Average Specific Identification
Sales $113,250 $113,250 $113,250 $113,250
Less: Cost of goods sold $51,340.00 $51,680.00 $51,476.00 $51,540.00
Gross profit $61,910 $61,570 $61,774 $61,710


Related Solutions

Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 600 units @ $40 per unit Feb. 10 Purchase 400 units @ $37 per unit Mar. 13 Purchase 190 units @ $15 per unit Mar. 15 Sales 805 units @ $70 per unit Aug. 21 Purchase 190 units @ $45 per unit Sept. 5 Purchase 550 units @ $43...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions. (For specific identification, units sold consist of 600 units from beginning inventory, 300 from the February 10 purchase, 200 from the March 13 purchase, 50 from the August 21 purchase, and 250 from the September 5 purchase.) Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 600 units @ $45.00 per unit Feb. 10 Purchase 400 units @...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 540 units @ $40 per unit Feb. 10 Purchase 320 units @ $36 per unit Mar. 13 Purchase 100 units @ $24 per unit Mar. 15 Sales 650 units @ $85 per unit Aug. 21 Purchase 120 units @ $45 per unit Sept. 5 Purchase 520 units @ $41...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 600 units @ $40 per unit Feb. 10 Purchase 360 units @ $37 per unit Mar. 13 Purchase 150 units @ $25 per unit Mar. 15 Sales 765 units @ $80 per unit Aug. 21 Purchase 200 units @ $45 per unit Sept. 5 Purchase 580 units @ $42...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 540 units @ $40 per unit Feb. 10 Purchase 320 units @ $36 per unit Mar. 13 Purchase 100 units @ $24 per unit Mar. 15 Sales 650 units @ $85 per unit Aug. 21 Purchase 120 units @ $45 per unit Sept. 5 Purchase 520 units @ $41...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 600 units @ $60 per unit Feb. 10 Purchase 480 units @ $57 per unit Mar. 13 Purchase 120 units @ $42 per unit Mar. 15 Sales 785 units @ $80 per unit Aug. 21 Purchase 180 units @ $65 per unit Sept. 5 Purchase 470 units @ $63...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 600 units @ $40 per unit Feb. 10 Purchase 360 units @ $37 per unit Mar. 13 Purchase 150 units @ $25 per unit Mar. 15 Sales 765 units @ $80 per unit Aug. 21 Purchase 200 units @ $45 per unit Sept. 5 Purchase 580 units @ $42...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 600 units @ $60 per unit Feb. 10 Purchase 480 units @ $57 per unit Mar. 13 Purchase 120 units @ $42 per unit Mar. 15 Sales 785 units @ $80 per unit Aug. 21 Purchase 180 units @ $65 per unit Sept. 5 Purchase 470 units @ $63...
Montoure Company uses a periodic inventory system. It entered into the following calendar-year purchases and sales...
Montoure Company uses a periodic inventory system. It entered into the following calendar-year purchases and sales transactions.    Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 700 units @ $40.00 per unit Feb. 10 Purchase 450 units @ $37.00 per unit Mar. 13 Purchase 250 units @ $22.00 per unit Mar. 15 Sales 850 units @ $70.00 per unit Aug. 21 Purchase 200 units @ $45.00 per unit Sept. 5 Purchase 600 units @...
Montoure Company uses a periodic inventory system. It entered into the following calendar-year purchases and sales...
Montoure Company uses a periodic inventory system. It entered into the following calendar-year purchases and sales transactions. Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 790 units @ $85.00 per unit Feb. 10 Purchase 495 units @ $82.00 per unit Mar. 13 Purchase 295 units @ $67.00 per unit Mar. 15 Sales 895 units @ $115.00 per unit Aug. 21 Purchase 290 units @ $90.00 per unit Sept. 5 Purchase 690 units @ $86.00...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT