13.pdf - Requirement (1) Units Beginning inventory...

This preview shows page 1 - 2 out of 2 pages.

The preview shows page 1 - 2 out of 2 pages.
Requirement (1)UnitsUnit costAmountBeginning inventory10050.00$ 5,000Purchases:Mar-0540055.00$ 22,000Mar-1812060.00$ 7,200Mar-2520062.00$ 12,400Goods available for sale82046,600Requirement (2)UnitsBeginning inventory100Purchases:Mar-05400Mar-18120Mar-25200Goods available for sale820Sales(580)Units in ending inventory240Requirement (3)Perpetual FIFODateUnitsUnit CostUnits Unit CostCost of Goods SoldUnitsUnit CostInventory BalanceMar-0110050.00$ 5,000.00$ Mar-05400.0055.00$ 10050.00$ 5,000.00$ 40055.00$ 22,000.00$ 50027,000.00$ Mar-0910050.00$ 5,000.00$ 32055.00$ 17,600.00$ 8055.00$ 4,400.00$ 22,600.00$ 804,400.00$ Mar-18120.0060.00$ -50.00$ -$ 8055.00$ 4,400.00$ 12060.00$ 7,200.00$ 20011,600.00$ Mar-25200.0062.00$ -50.00$ -$ 8055.00$ 4,400.00$ 12060.00$ 7,200.00$ 20062.00$ 12,400.00$ 40024,000.00$ Mar-29--50.00$ -8055.00$ 4,400.00$ -55.00$ -8060.00$ 4,800.00$ 4060.00$ 2,400.00$ 20062.00$ 12,400.00$ 9,200.00$ -$ Totals58031,800.00$ 24014,800.00$ Weighted Average PerpetualDateUnitsUnit CostUnits Unit CostCost of Goods SoldUnitsUnit CostInventory BalanceMar-0110050.00$ 5,000$ Mar-0540055.00$ 10050.00$ 5,000$ 40055.00$ 22,000$ Average50054.00$ 27,000$ Mar-0942054.00$ 22,680$ 8054.00$ 4,320$ Average80544,320Mar-1812060.00$ 8054.00$ 4,320$ 12060.00$ 7,200$ Average20057.60$ 11,520$ Mar-2520062.00$ 20057.60$ 11,520$ 20062.00$ 12,400$ 40059.80$ 23,920$ Mar-2916059.80$ 9,568$ 24059.80$ 14,352$ Totals58032,248$ 24014,352Goods PurchasedCost of Goods SoldInventory BalanceGoods PurchasedCost of Goods SoldInventory Balance
Perpetual LIFODateUnitsUnit CostUnits Unit CostCost of Goods SoldUnitsUnit CostInventory BalanceMar-0110050.00$ 5,000.00$ Mar-0540055.00$ 10050.00$ 5,000.00$ 40055.00$ 22,000.00$ 50027,000.00$ Mar-092050.00$ 1,000.00$ 8050.00$ 4,000.00$ 40055.00$ 22,000.00$ -55.00$ -$ 23,000.00$ 804,000.00$ Mar-1812060.00$ 8050.00$ 4,000.00$ -55.00$ -$ 12060.00$ 7,200.00$ 200
End of preview. Want to read all 2 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
juda smith
Tags
Finance, Goods Sold, unit cost

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture