Top-Rated Free Essay
Preview

Perpetual Inventory Record

Satisfactory Essays
441 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Perpetual Inventory Record
PA-5B
A 25th Century Electronic Center began December with 94 units of inventory that cost $72 each. During December, the store made the following purchases:
12/3: 20 @ 77
12/12: 52 @ 79
12/18: 79 @ 82
25th Century uses the periodic inventory system, and the physical count at December 31 indicates that 112 units of inventory are on hand.
Requirements:
1. Determine the ending inventory and cost-of-goods-sold amounts for the December financial statements under the average cost, FIFO, and LIFO methods. 2. Sales revenue for December totaled $23,000. Compute 25th Century’s gross profit for December under each method. 3. Which method will result in the lowest income taxes for 25th Century? Why? Which method will result in the highest net income for 25th Century? Why?
-------------------------------------------------

E-15
Measuring and journalizing inventory and cost of goods sold in a perpetual system—FIFO [20–25 min]
Putter’s Paradise carries an inventory of putters and other golf clubs. Putter’s Paradise uses the FIFO method and a perpetual inventory system. The sales price of each putter is $135. Company records indicate the following for a particular line of Putter’s Paradise putters: Date | Item | Quantity | Unit Cost | Sep 1 | Balance | 5 | $61 | 6 | Sale | 3 | | 8 | Purchase | 10 | 66 | 17 | Sale | 4 | | 30 | Sale | 2 | |

Requirements: 1. Prepare a perpetual inventory record for the putters. Then determine the amounts Putter’s Paradise should report for ending inventory and cost of goods sold using the FIFO method.
-------------------------------------------------
2. Journalize Putter’s Paradise inventory transactions using the FIFO method.

E-16
Measuring ending inventory and cost of goods sold in a perpetual system—LIFO [20–25 min]
Refer to the Putter’s Paradise inventory data in Exercise 15. Assume that Putter’s Paradise uses the perpetual LIFO cost method.
Requirements:
1. Prepare Putter’s Paradise perpetual inventory record for the putters on the LIFO basis. Then identify the cost of ending inventory and cost of goods sold for the month. 2. Journalize Putter’s Paradise inventory transactions using the perpetual LIFO method.
-------------------------------------------------

E-17
Measuring ending inventory and cost of goods sold in a perpetual system-average cost [20–25 min]
Refer to the Putter’s Paradise inventory data in Exercise 15. Assume that Putter’s Paradise uses the average-cost method.
Requirements:
1. Prepare Putter’s Paradise perpetual inventory record for the putters on the average-cost basis. Round average cost per unit to the nearest cent and all other amounts to the nearest dollar. Then identify the cost of ending inventory and cost of goods sold for the month. 2. Journalize Putter’s Paradise inventory transactions using the perpetual average cost method.
-------------------------------------------------

Repeat E-16 for a periodic inventory system

You May Also Find These Documents Helpful

  • Powerful Essays

    Hrm 531 Week 3 Quiz

    • 4852 Words
    • 20 Pages

    87. On April 1, Robert LLC purchased two units of inventory, A and B. The cost of unit A was $650, and the…

    • 4852 Words
    • 20 Pages
    Powerful Essays
  • Satisfactory Essays

    Xacc/280 Week 3 Quiz

    • 826 Words
    • 4 Pages

    An end of the month (1/31/14) inventory showed that 160 units were on hand. If the company uses FIFO, what is the value of the ending inventory?…

    • 826 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Problem 5-9

    • 3989 Words
    • 16 Pages

    method of accounting for inventory than it would have paid if it had used the LIFO method?…

    • 3989 Words
    • 16 Pages
    Good Essays
  • Satisfactory Essays

    Acct 505 Project A

    • 281 Words
    • 2 Pages

    Total cash collections ... $436,000 $695,000 $865,000 $1,996,000 c. Merchandise purchases budget: Budgeted unit sales ..... 65,000 Add desired ending inventory (40% of the next month’s unit sales)................. 40,000 Total needs.................. 105,000 Less beginning inventory .................. 26,000 Required purchases...... 79,000 Cost of purchases at $4 per unit ................ $316,000 100,000 50,000 215,000 20,000 120,000 12,000 62,000 12,000 227,000 40,000 80,000 20,000 42,000 26,000 201,000 $320,000 $168,000 $ 804,000 d. Budgeted cash disbursements for merchandise purchases: Accounts payable .......... $100,000 April purchases ............. 158,000 May purchases .............. June purchases .............…

    • 281 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Week 8 Acc 290

    • 582 Words
    • 3 Pages

    Solution: The lower value for each inventory type is: cameras $12,500, camcorders $9,000, and DVDs $12,200.…

    • 582 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Is Case Study

    • 394 Words
    • 2 Pages

    iii. Totals formulas/functions for average inventory, annual gross profit, cost of goods sold and annual sales (4 points)…

    • 394 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    The inventory has a financial importance as it is purchased and recorded at its historical cost or original cost. With respect to a perpetual inventory system, inventory accounts are continually controlled as goods are purchased and placed directly into the inventory account and then later taken out when sold. Therefore the inventory is properly recognized within the period it is sold. Furthermore valuing the inventory with FIFO correctly reports the ending inventory at its market value. When ending inventory is reported at market value, before making proper year adjustments unexpected changes occur in the ordinary course of business causing the market to be lower then the cost basis of the inventory. This departure from the cost basis of pricing the inventory requires the utility of inventory is no longer as great as its original cost. The ASC allows assets to be valued with Lower of Cost or Market when evidence is proving the future utility of the inventory drops below its historical cost.…

    • 1307 Words
    • 6 Pages
    Good Essays
  • Powerful Essays

    WEEK 3 ASSIGNMENT

    • 787 Words
    • 4 Pages

    2. Inventory valuation methods: basic computations. The January beginning inven¬tory of the Gilette Company consisted of 300 units costing $40 each. During the first quarter, the company purchased two batches of goods: 700 Units at $44 on February 21 and 800 units at $50 on March 28. Sales during the first quarter were 1,400 units at $75 per unit. The White Company uses a periodic inventory system. Using the White Company data, fill in the following chart to compare the results obtained under the FIFO, LIFO, and weighted-average inventory methods.…

    • 787 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    The principal role of inventory management systems is to ensure that stores are adequately stocked. Companies use various methods to track and report inventory. Retail companies are perhaps the best entities to examine when attempting to understand inventory management systems. The type of inventory a company has determines the method they use. Retail companies use the retail inventory method as a base system. Last-in-First-Out (LIFO) and First-in-First-Out (FIFO) are the two systems that appear to be used more frequently. Other systems used are the Just in Time or JIT method and the Average Cost method. The following paragraphs will describe different companies and the type or types of inventory systems they use. Also the advantages and disadvantages of their systems are discussed.…

    • 1893 Words
    • 8 Pages
    Good Essays
  • Good Essays

    Periodic inventory only sales recorded when inventory is sold. CMS is determined at the end of the accounting period…

    • 717 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    "The perpetual inventory system is best suited for the sort of enterprises that usually keep a high inventory and have a high turnover. It is also well suited for the type of industries where there isn't much processing to do, so the inventory exists at only one level (for sale) rather than at three levels (raw materials, work in progress and for sale). It is well suited for the fact that inventory checking is an important part of the operations of this industry." (Kulkarni, 2010) A perpetual inventory system, also known as a continuous inventory system is when the inventory availability and quantity are updated continuously. Each transaction that is made is instantaneously reported into the inventory account records. With the perpetual inventory system the inventory has a up to date balance all year long. Because inventory is being updated continuously and the balance is up to date, there is no need for the business to perform an end of year inventory check. Under the perpetual system, all records should be correct unless there was theft at the business that would make the inventory count off. "Furthermore, the perpetual inventory system is further aided by the presence of RFID checkers. These RFID checkers make the inventory calculation and recording purchases and sales easier and eliminate the need for manual checking at regular intervals. Of course, one cannot avoid situations where there may be a theft or unaccounted spoilage or a system failure which may send the thing into a disarray and manual backup may be called for." (Kulkarni, 2010)…

    • 283 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Gul Ahmed

    • 1226 Words
    • 5 Pages

    For the following transactions are related to Parashanlal Merchandizing Company. Income Tax is 10%; operating expenses are Rps 10,000. Compute Net Income, and calculate the value of inventory remaining at the end of the month using the following methods:…

    • 1226 Words
    • 5 Pages
    Good Essays
  • Better Essays

    Double Entry

    • 1599 Words
    • 7 Pages

    At the end of the year, the cost of all the items sold is deducted from sales to give the gross profit. The cost of items unsold appears in the Statement of financial position inventory account. There are different ways of recording the purchase of goods for resale to arrive at this final position. This section shows how we deal with such purchases in this tutorial.…

    • 1599 Words
    • 7 Pages
    Better Essays
  • Satisfactory Essays

    Inventory System

    • 348 Words
    • 2 Pages

    * The scope of an inventory system considers which needs the inventory system addresses. These include valuing the inventory, measuring the change in inventory and planning for future inventory levels. The value of the inventory at the end of each period provides a basis for financial reporting on the balance sheet. Measuring the change in inventory allows the company to determine the cost of inventory sold during the period. The inventory level and changes allow the company to plan for future inventory needs.…

    • 348 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Chapter 6 Exercises

    • 2396 Words
    • 10 Pages

    PE 6–2B Cost of merchandise sold: Merchandise inventory, April 1 $ 128,120 Purchases $983,400 Less: Purchases returns and allowances $ 10,250 Purchases discounts 8,000 18,250 Net purchases $965,150 Add transportation in 5,680 Cost of merchandise purchased 970,830 Merchandise available for sale $ 1,098,950 Less merchandise inventory, April 30 140,500 Cost of merchandise sold $ 958,450 PE 6–3A a. Accounts Receivable 12,250 Sales 12,250 Cost of Merchandise Sold 7,400 Merchandise Inventory 7,400 b. Cash 12,005 Sales Discounts 245 Accounts Receivable 12,250 PE 6–3B a. Accounts Receivable 22,500 Sales 22,500 Cost of Merchandise Sold 14,150 Merchandise Inventory 14,150 b. Cash 22,275 Sales Discounts 225 Accounts Receivable 22,500 PE 6–4A a. $5,880. Purchase of $7,500 less the return of $1,500 less the discount of $120 [($7,500 – $1,500) × 2%)]. b. Merchandise Inventory PE 6–4B a. $11,385.…

    • 2396 Words
    • 10 Pages
    Good Essays