Make a system for recording the cost of raw materials using the complete Perpetual and Periodic method.note: excel formulas for each work Known transactions at the company PT. Wahid for theDecember 2019 period as follows:1. Initial inventory 10,000kg @ IDR 10,0005. Purchase 5,000kg @ IDR 11,0006. Usage 9000kg10. Purchase 1000kg @IDR 12,00011. Usage 2000kg12. Usage 1000kg20. Purchase 5,000kg @ Rp 12,00025. Usage 500kgSpecial Remarks:• Materials used on December 6, 2019, came from initialinventory of 6,000kg and purchases on December 5, 2019of 3,000kg• Usage on December 11, 2019, comes from initial inventoryof 1000kg• Usage on December 12, 2019, came from the purchase ofraw materials on December 10, 2019 as much as 1000kg• Materials used on December 25, 2019, came frombeginning inventoryRequested:1. Make a system for recording the cost of raw materialsusing the complete Perpetual and Periodic method.

Name: Make a system for recording the cost of raw materials using the comple
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Make a system for recording the cost of raw materials using the complete Perpetual and Periodic method.note: excel formulas for each work Known transactions at the company PT. Wahid for theDecember 2019 period as follows:1. Initial inventory 10,000kg

Cost of Raw Material To calculate the cost of raw material first to add the beginning inventory plus…

Answered: Make a system for recording the cost of…

Business

Accounting

Make a system for recording the cost of raw materials using the complete Perpetual and Periodic method. note: excel formulas for each work

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Chapter8: Inventories: Special Valuation Issues

Section: Chapter Questions

Problem 3P: Inventory Write-Down The inventory records of Frost Company for the years 2019 and 2020 reveal the...

See similar textbooks

Similar questions

Inventory Write-Down The inventory records of Frost Company for the years 2019 and 2020 reveal the cost and market of the January 1, 2019, inventory to be 125,000. On December 31, 2019, the cost of inventory was 130,000, while the market value was only 128,000. The December 31, 2020, market value of inventory was 140,000, and the cost was only 135,000. Frost uses a perpetual inventory system. Required: 1. Assume the inventory that existed at the end of 2019 was sold in 2020. Prepare the journal entries at the end of 2019 and 2020 to record the lower of cost or net realizable value under the: a. allowance method b. direct method 2. Show the presentation of cost of goods sold and inventory of Frosts income statement and balance sheet for 2019 and 2020 under the: a. allowance method (assume the cost of goods sold prior to applying the lower of cost or net realizable value rule was 595,000 and 605,000 for 2019 and 2020, respectively) b. direct method
A. At the end of December 2020, the accounting records of XYZ firm present the following transactions for a particular merchandise that sold at €20 per unit: Transaction Units Amount Inventory, 1/12/2020 200 2,000 € Purchase, 10/12/2020 150 1,800 € Purchase, 15/12/2020 120 1,800 €Purchase, 23/12/2020 170 2,720 € Sale 180 Sale 120 In addition, the level of operating expenses in December is €1,500 and the tax rate is 20%. The firm has decided to distribute the after-tax profits to shareholders. 1. If XYZ firm uses a periodic inventory system, prepare a summarized income statement for December 2020 under each inventory cost flow assumption: (a) weighted average, (b) FIFO, (c) LIFO, and (d) specific identification. For specific identification, assume that the first sale was out of the beginning inventory and the second sale was out of the December 23 purchase. Exhibit inventory calculations in detail. 2. Which…
If the Cost of Sales for Company Z is $912,500 for the 2019 year, and the Days Inventory Held is 25. The value of the Inventory at the end of 2019 is: $ 62,500 $ 36,500 $ 3,042 $ 2,500
Crane Corporation sells item A as part of its product line. Information as to balances on hand, purchases, and sales of item A are given in the following table for the first six months of 2020. Date January 11 January 24 February 8 March 16 June 11 Quantities Purchased 1,300 630 Sold 330 605 Balance Unit Price of Purchase 430 1,730 1,400 795 1,425 $4.60 $4.80 $5.30 (a) Compute the ending inventory at June 30 under the perpetual LIFO inventory pricing method. Ending inventory $ Compute the cost of goods sold for the first 6 months under the periodic FIFO inventory pricing method. Cost of Goods Sold $
Jan Cahilig Traders started operating in 2020. For the year ended 2020, the sales, purchases, and closing inventory are P600,000, P300,000 and P20,000. What is the cot of goods sold for the year ended 2020?
Crane Corporation sells item A as part of its product line. Information as to balances on hand, purchases, and sales of item A are given in the following table for the first six months of 2025. Date January 11 January 24 February 8 March 16 June 11 (a) Purchased 1,320 Ending inventory Quantities 700 Sold 340 560 Balance 440 1.760 1,420 860 1,560 Unit Price of Purchase $4.70 $4.80 $5.20 Compute the ending inventory at June 30 under the perpetual LIFO inventory pricing method.
Smile JungkookCompany reported the following balances at the end of each year: 2020 2019 InventoryP2,600,000 P2,900,000 , Accounts Payable 750,000 500,000 The entity paid suppliers P4,900,000 during the year ended December 31, 2020.What should be the amount to be reported for cost of goods sold in 2020?
The following information was obtained from the accor February 2020, the end of the financial year: Opening inventory Closing inventory Purchases Import duties Carriage on sales The cost of sales for the year ended 29 February 2020 amounted to Select one: a. R1 030 000 b. R1 080 000 c. R1 115 000 d. R1 065 000
Jan Cahilig Traders started operating in 2020. For the year ended 2020, the sales, purchases, and closing inventory are P500,000, P300,000 and P40,000. What is the gross profit for the year ended 2020?
Assume that Distributor Company Inc. has the following inventory item on hand at December 31, 2018:Historical cost : $1,000Replacement cost: $900Estimated Selling price: $ 1,050Estimated costs to complete and sell: $100Required: Write down the journal entry at end of 20181) Follow IFRS2) Follow U.S GAAP
6. MNO Company is preparing the annual financial statements dated December 31, 2022. Information about inventory stocked for regular sale follows: Item A B C D Quantity on Hand 80 35 40 75 Unit Cost When Acquired €50 €20 €50 €40 Market Value at year end €30 €25 €80 €20 a) Compute the valuation for the December 31, 2022, inventory using the lower-of-cost-or-net realizable value basis and make necessary adjusting journal entries. b) Sold 15 units of A for €20 in cash, 3 units of B for €30 and 10 units of C for €75 cach in cash and written-off 5 units of D. Make necessary journal entries. 7. Improvements were made to the leased warehouse on June 01, 2021 at a cost of $ 22,000. The estimated life of the improvement is ten years. Lease contract terminates on December 31, 2025. Make necessary entries as of 31.12.2021 and 31.12.2022.
Grit Company had the following for 2019: Purchase P40,000 • Purchase returns and allowances P2,000 Freight In P3,000 Beginning Inventory - 5,000 Ending Inventory - P8,000 What was the cost of goods sold ?