Purchase Solution

Periodic and perpetual inventory systems and inventory cost

Not what you're looking for?

Ask Custom Question

See attached file for proper format of the table.

P. 2 periodic inventory system and inventory costing methods

The inventory of Product PIT and data on purchases and sales for a two-month period follow. The company closes its books at the end of each month. It uses the periodic inventory system.

Apr. 1 Beginning inventory 50 units @ $204
10 Purchase 100 units @ $ 220
17 Sale 90 units
30 Ending inventory 60 units
May 2 Purchase 100 units @ $216
14 Purchase 50units @ $ 224
22 Purchase 60 units @ $ 234
30 Sale 200 units
31 Ending inventory 70 units

Required

1. Compute the cost of ending inventory of Product PIT on April 30 and May 31 using the average-cost method. In addition, determine cost of goods sold for April and May. Round unit costs to cents and totals to dollars.
2. Compute the cost of ending inventory on April 30 and May 31 using the FIFO method. In addition, determine cost of goods sold for April and May.
3. Compute the cost of ending inventory on April 30 and May 31 using the LIFO method. In addition, determine cost of goods sold for April and May.
4. Do the cash flows from operations for April and May differ depending on which inventory costing method is used- average-cost, FIFO, or LIFO? Explain

P.3 Perpetual inventory system and inventory costing methods

Use the data provided in p. 2, but assume that the company uses the perpetual inventory system. (Hint: in preparing the solutions required below, it is helpful to determine the balance of inventory after each transaction, as shown in the review problem in this chapter).

Required

1. Compute the cost of ending inventory and cost of goods sold for April and May using the average cost method. Round unit to cents and totals to dollars.
2. Compute the cost of ending inventory and cost of goods sold for April and May using the FIFO method.
3. Compute the cost of ending inventory and cost of goods sold for April and May using the LIFO method.
4. Assume that this company grows for many years in a long period of rising prices. How realistic do you think the balance sheet value for inventory would be and what effect would it have on the inventory turnover ratio?

Attachments
Purchase this Solution
Solution Summary

Your tutorial is in Excel (click in cells to see computations). You have a different sheet for perpetual and periodic but this data does not result in different amounts because the sales do not occur between purchase dates. Comments about inventory turnover and cash flow statement impact of the methods are provided.

Solution Preview

Your tutorial is in Excel (click in cells to see computations).

You have a ...

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

View More Free Quizzes
Related BrainMass Solutions

  • Periodic and Perpetual Inventory Systems

    What are the similarities and differences between periodic and perpetual inventory systems? 2. What types of companies use periodic inventory systems? 3. What types of companies use perpetual inventory systems? 4..

  • Main distinctions of perpetual and periodic inventory systems

    233571 Distinctions of Perpetual and Periodic Inventory Systems Question: What is the main distinction between perpetual and periodic inventory systems? Which type of system provides better internal control over inventory? Explain why.

  • What types of companies use periodic inventory?

    118310 What types of companies use periodic inventory? What types of companies use periodic inventory? What types of companies use perpetual inventory? What are the similarities and differences between periodic and perpetual inventory systems?

  • FIFO, LIFO calculations under periodic and perpetual method

    182754 FIFO and LIFO using periodic and perpetual systems. Cost-flow assumptions?FIFO and LIFO using periodic and perpetual systems.

  • Inventory methods and the effects to cost of goods sold

    What are the similarities and differences between periodic and perpetual inventory systems? How does each method affect the inventory and cost of sales calculations?

  • Periodic inventory systems

    25724 Periodic inventory systems are discussed. Subject: What is the difference between perpetual and periodic inventory system?

  • Inventory Systems and Calculating Revenues, Expenses, and In

    it uses (a) a periodic inventory system and (b) a perpetual inventory system.

  • Perpetual vs periodic inventory systems

    470460 Perpetual vs periodic inventory systems Why are perpetual inventory systems so much more popular today than back in the early 1960s and earlier?

  • FIFO and LIFO

    160020 Cost-Flow Assumptions - FIFO and LIFO Using Periodic and Perpetual Systems Cost-flow assumptions-FIFO and LIFO using periodic and perpetual systems.

  • Prepare journal entries

    190364 Prepare journal entries for the periodic and perpetual inventory method - CSI Systems Journalize the following merchandising transactions for CSI Systems assuming it uses (a) a periodic inventory system and (b) a perpetual inventory system.

View More Related Solutions