Question

5. Shown below is activity for one of the products of Denver Office Equipment: January 1...

5.

Shown below is activity for one of the products of Denver Office Equipment:

January 1 balance, 500 units @ $55  $27,500

Purchases:

    January 10: 500 units @ $60

    January 20: 1,000 units @ $63

Sales:

     January 12: 800 units

     January 28: 750 units

Required:Compute the January 31 ending inventory and cost of goods sold for January, assuming Denver uses average cost and a perpetual inventory system (fill in the blanks on the next page).


January 12 COGS:                        ______________

January 28 COGS:                        ______________

January 31stending inventory:     ______________

Circle the right answer below:

If Denver Office used a FIFO perpetual system instead of average cost, their ending inventory will be:

            

HIGHER                                                /                                   LOWER

than the one reported above.

Homework Answers

Answer #1

Required:Compute the January 31 ending inventory and cost of goods sold for January, assuming Denver uses average cost and a perpetual inventory system (fill in the blanks on the next page).

Date Unit purchase Unit Cost Purchase Cost Unit sold Unit cost Cost of goods sold Ending inventory Units Unit Cost Ending inventory
Jan 1 500 55 27500
Jan 10 500 60 30000 1000 57.50 57500
Jan 12 800 57.50 46000 200 57.50 11500
Jan 20 1000 63 63000 1200 62.083 74500
Jan 28 750 62.083 46562.50 450 62.083 27937.50

January 12 COGS: $46000

January 28 COGS: $46562.50

January 31st ending inventory: $27937.50

Ending inventory would be higher under FIFO perpetual method (450*63) = $28350

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
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance,...
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance, 500 units @ $55 per unit $27,500 Purchases: January 10: 500 units @ $60 per unit January 20: 1,000 units @ $63 per unit Sales: January 12: 800 units January 28: 750 units Required: Compute the January 31 ending inventory and cost of goods sold for January, assuming Denver uses average cost and a perpetual inventory system.
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance,...
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance, 670 units @ $60 $40,200 Purchases:       January 10: 670 units @ $54       January 20: 1,060 units @ $60 Sales:       January 12: 900 units       January 28: 800 units Required: Compute the January 31 ending inventory and cost of goods sold for January, assuming Denver uses LIFO and a perpetual inventory system.
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance,...
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance, 600 units @ $50 $30,000 Purchases:       January 10: 600 units @ $55       January 20: 1,200 units @ $58 Sales:       January 12: 900 units       January 28: 800 units Required: Compute the January 31 ending inventory and cost of goods sold for January, assuming Denver uses LIFO and a perpetual inventory system.
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance,...
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance, 690 units @ $60 $41,400 Purchases: January 10: 690 units @ $64 January 20: 1,220 units @ $66 Sales: January 12: 1,000 units January 28: 800 units Required: Compute the January 31 ending inventory and cost of goods sold for January, assuming Denver uses average cost and a periodic inventory system. (Do not round intermediate calculations. Round your final answers to nearest whole dollar...
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance,...
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance, 580 units @ $60 $34,800 Purchases: January 10: 580 units @ $65 January 20: 1,040 units @ $68 Sales: January 12: 900 units January 28: 780 units Required: Compute the January 31 ending inventory and cost of goods sold for January, assuming Denver uses FIFO and a periodic inventory system.
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance,...
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance, 590 units @ $50 $29,500 Purchases: January 10: 590 units @ $50 January 20: 1,020 units @ $60 Sales: January 12: 840 units January 28: 790 units Required: Compute the January 31 ending inventory and cost of goods sold for January, assuming Denver uses LIFO and a perpetual inventory system.
Shown below is activity for one of the products of Broken Bow Office Equipment: Units Cost/Unit...
Shown below is activity for one of the products of Broken Bow Office Equipment: Units Cost/Unit Total Cost January 1 balance 500 $55 $27,500 Purchases: 10-Jan 500 60 20-Jan 1,000 63 Sales: 12-Jan 800 28-Jan 750 Required: Compute the January 31 ending inventory and cost of goods sold for January, assuming Broken Bow uses the FIFO inventory method. Use the Excel file template provided.
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance,...
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance, 580 units @ $60 $34,800 Purchases: January 10: 580 units @ $65 January 20: 1,040 units @ $68 Sales: January 12: 900 units January 28: 780 units Required: Compute the January 31 ending inventory and cost of goods sold for January, assuming Denver uses average cost and a periodic inventory system. (Do not round intermediate calculations. Round your final answers to nearest whole dollar...
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance,...
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance, 520 units @ $50 $26,000 Purchases: January 10: 520 units @ $55 January 20: 1,040 units @ $59 Sales: January 12: 780 units January 28: 770 units Required: Compute the January 31 ending inventory and cost of goods sold for January, assuming Denver uses average cost and a periodic inventory system. (Do not round intermediate calculations. Round your final answers to nearest whole dollar...
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance,...
Shown below is activity for one of the products of Denver Office Equipment: January 1 balance, 520 units @ $50 $26,000 Purchases: January 10: 520 units @ $55 January 20: 1,040 units @ $59 Sales: January 12: 820 units January 28: 770 units Required: Compute the January 31 ending inventory and cost of goods sold for January, assuming Denver uses LIFO periodic inventory system.