Question

These are the inventory transactions for a start up business. red Date Type Purchase Sale Purchase Sale Units 100 40 25 70 Unit Cost 50 0 01/07/17 15/07/17 31/07/17 15/08/17 60 Do not use punctuation in numerical answers. Calculate Cost of Goods Sold using periodic FIFO: Calculate Closing inventory using periodic average cost us page Ne
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Purchase and Sale data bifurcated:

Data: Purchases data: Units Cost 100 25 125 Amount 50 5,000 01/07/2017 Purchase 31/07/2017 Purchase 60 1,500 Total $6,500 Sales data: Units 15/07/2017 Sales 15/08/2017 Sales Total 40 70 110

Cost of goods sold under Periodic FIFO:

Calculation of Cost of Goods Sold using periodic FIFC Under the FIFO Method, we sale the oldest inventory we have in stock. it in periodic inventory system, cost of goods sold is assigned at the end of the period. So, in this case, there was a total sale of 110 units, in which we will assign cost to the sales unit, to calculate cost of goods sold as below: Cost 40 60 10 Units 01/07/2017 Purchase 01/07/2017 Purchase 31/07/2017 Purchase Total cost of goods sold Amount 50 $ 2,000 50 3,000 60 600 110 $ 5,600 Total cost of goods sold under periodic FIFO 5,600

Calculation of closing inventory using periodic average cost:

Computation of closing inventory using periodic average cost: Explanation of periodic average cost - in average cost, the cost of goods sold and ending inventory is determined by applying the average price of all the total goods in stock. It is calculated when the period is over and accordingly applied to the units sold. Average cost Total purchase cost/units sold Average cost 6,500/125 $52 Closing inventory Purchases -Units sold 125-110 15 units Closing inventory value Closing inventory* average cost 15 units $ 52 $780 Closing inventory under periodic average cost $ 780

Add a comment
Know the answer?
Add Answer to:
These are the inventory transactions for a start up business. red Date Type Purchase Sale Purchase...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  •                                Inventory   Date       Activity       Units &nbsp

                                   Inventory   Date       Activity       Units        Unit Cost       Balance                                      1-Mar       Beginning Balance       250       $14        $3,500                                       3-Mar       Sale       (200)               - - 0                                       10-Mar       Purchase       200       15       ...

  • Knowledge Check 01 The inventory transactions of VTS Corporation are shown below. Date Transaction Number of...

    Knowledge Check 01 The inventory transactions of VTS Corporation are shown below. Date Transaction Number of Units Unit Cost/Price Jan. 1 Beginning inventory 500 $ 10 Feb. 25 Sale 300 20 May 21 Purchase 400 12 Jul. 15 Purchase 500 15 Dec. 10 Sale 800 20 All purchase/sale transactions are made on credit. The company uses the FIFO method and the perpetual inventory system to record transactions. The entry to record the transaction on December 10 will involve a debit...

  • 1) The below Inventory and sales transactions took place during the month of March 2014. Purchase 110@ $4.25 3/01...

    1) The below Inventory and sales transactions took place during the month of March 2014. Purchase 110@ $4.25 3/01 3/02 3/07 Purchase 220 @ $5.20 Sold 200 @ $20.00 3/15 Purchased 320@ 3.25 3/20 Sold 325 $20.00 Wgt Avg Fifo Ending inventory (show calculations) Cost of Goods Sold (show calculations) 2) Put the above results in the below table assuming expenses are $3,500 and tax rate is 30 percent Net Income Wgt Avg Fifo Ufo Sales COGS GROSS PROFIT EXPENSES...

  • Anderson Company uses the periodic inventory method and recorded the following purchase sale of inventory during...

    Anderson Company uses the periodic inventory method and recorded the following purchase sale of inventory during the month of September Purchases Sales Date Units Unit Cost Units Unit Price Sept1120 51.00 Sept 10150 $2.00 Sept 15 10 $3.00 Sept 17 30 $5.00 Sept 20 195 54.00 Sept 26 180 $8.00 Sept 28 210 $500 Instruction Under the periodic inventory system complete the following table Round following formats: 55,400, or $540. ans Cost of Ending Inventory Cost of Good Sold Gross...

  • 20-21. During 2018, Liberty Company has the following inventory transactions. Date Transaction Units Total Cost $4,400...

    20-21. During 2018, Liberty Company has the following inventory transactions. Date Transaction Units Total Cost $4,400 8,200 7,560 Cost Beginning inventory Jan. 1 11 $400 Jan. 8 Purchase 20 410 Jan. 15 Purchase 18 420 Jan. 19 Sales 44 Required: Using FIFO with a periodic inventory system, calculate cost of goods sold, ending inventory

  • INVENTORY ITEM 621AB UNITS DATE COST Beginning Inventory $6 $7 Jan 1 120 Purchase 200 Jan...

    INVENTORY ITEM 621AB UNITS DATE COST Beginning Inventory $6 $7 Jan 1 120 Purchase 200 Jan 7 Sale Jan 10 250 Purchase $8 Jan 15 300 Jan 17 Purchase $9 200 Sale 325 Jan 20 Sale Jan 25 100 Jan 28 Purchase $10 175 Smith Corporation uses a perpetual inventory system. Determine the costs assigned to Cost of Goods Sold and Ending Inventory using both FIFO and LIFO methods. DATE ITEM RED16 UNITS COST Beginning Inventory $10 Jan 1 100...

  • The following transactions occurred for the month of May. Date 1-May Beginning Balance 2-May Purchase 3-May...

    The following transactions occurred for the month of May. Date 1-May Beginning Balance 2-May Purchase 3-May Purchase 10-May Sale 15-May Purchase 17-May Sale 30-May Sale Units Cost Total Sales Price 75 10 $750 60 11 $660 80 16 $1,280 125 $40 45 19 $855 60 $40 $40 $40 40 Calculate the cost of Goods Sold, Ending inventory, and Gross Profit for the month under FIFO. End of the month totals Cost of Goods Sold $ [ Ending Inventory $[ Gross...

  • April 3 Inventory 11 Purchase 14 Sale 21 Purchase 25 Sale 21 units @ $14 15...

    April 3 Inventory 11 Purchase 14 Sale 21 Purchase 25 Sale 21 units @ $14 15 units @ $14 26 units 13 units @ $22 13 units Complete the inventory cost card assuming the business maintains a perpetual determine the cost of goods sold and ending inventory using FIFO.

  • 5. Complete the FIFO Inventory Calculation Date Unit Cost Sales Price $8 Item Beginning Inventory Purchase...

    5. Complete the FIFO Inventory Calculation Date Unit Cost Sales Price $8 Item Beginning Inventory Purchase Sale Purchase Sale 1 10 15 21 30 Quantity 50 units 60 units 70 units 110 units 120 units $11 $12 FIFO Calculation Purchases COGS Inventory on Hand Total Cost Date Quantity Unit Cost Total Cost Quantity | Unit Cost Quantity Unit Cost Total Cost 6. Using the information from #5 above, complete the Income Statement Income Statement Month Ended July 31, 2012 FIFO...

  • Beginning inventory, purchases, and sales data for widgets are as follo Apr. 3 $30 $27 Inventory Purchase Sale Purc...

    Beginning inventory, purchases, and sales data for widgets are as follo Apr. 3 $30 $27 Inventory Purchase Sale Purchase Sale 15 units @ 12 units @ 18 units 7 units 10 units $25 25 Complete the subsidiary Inventory ledger assuming the business maintains a perpetual inventory system and calculate the cost of merchandise sold and ending Inventory using FIFO. Cost of Merchandise Sold Purchases Inventory

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT