Purchase Solution

Cost of sales, Ending inventory under FIFO, LIFO

Not what you're looking for?

Ask Custom Question

1) Use the following information to calculate 1.) ending inventory 2.) Cost of Sales and 3.) gross margin under the inventory methods shown below. Assume that a periodic inventory system is employed and all sales are made at a price of $15/unit.

Date Description Quantity Per Unit Cost
11/1/2002 Beginning Inventory 70 $7.00
11/2/2002 Purchase 30 $8.00
11/11/2002 Purchase 40 $9.00
11/17/2002 Sales 25 n/a
11/22/2002 Purchase 15 $10.00
11/27/2002 Sales 40 na
11/30/2002 Purchase 10 $11.00

Sale
Date Description Quantity Sales price per unit Total revenue
11/17/2002 Sales 25 $15.00 $375.00
11/27/2002 Sales 40 $15.00 $600.00
65 $975.00

2) a.) STU Corporation purchased a piece of equipment on April 1, 2001 for 29,600. The equipment has an estimates life of five years or 27,000 units of production and an estimated residual value of 2,600. Compute depreciation for 2001, 2002 and 2003, using the methods indicated below. Assume that the company's fiscal year corresponds to the calendar year and that 4,700, 6050, and 4,350 units were produced in the respective years.
b.) Under the straight line method, assume that at the end of 2003 it was determined that the salvage value changed to 2,000.00 and that the estimated life changed to a total of seven years. What would the depreciation expense be for 2004?

Attachments
Purchase this Solution
Solution Summary

There are two problems
The solution to the first problem provides steps for the calculation of Cost of sales, Gross Margin and Ending inventory under FIFO, LIFO and Average Cost inventory methods.
The solution to the second problem calculates depreciation using straight line and double declining balance methods.
The solutions are provided in the attached excel file.

Solution Preview

The answer is in the excel file attached.
Use the following information to calculate 1.) ending inventory 2.) Cost of Sales and 3.) gross margin
under the inventory methods shown below. Assume that a periodic inventory system is employed
and all sales are made at a price of $15/unit.

Date Description Quantity Per Unit Cost
11/1/2002 Beginning Inventory 70 $7.00
11/2/2002 Purchase 30 $8.00
11/11/2002 Purchase 40 $9.00
11/17/2002 Sales 25 n/a
11/22/2002 Purchase 15 $10.00
11/27/2002 Sales 40 na
11/30/2002 Purchase 10 $11.00

Sale
Date Description Quantity Sales price per unit Total revenue
11/17/2002 Sales 25 $15.00 $375.00
11/27/2002 Sales 40 $15.00 $600.00
65 $975.00

Average Cost

Cost of Sales
Total cost
11/1/2002 Beginning Inventory 70 $7.00 $490.00

11/2/2002 Purchase 30 $8.00 $240.00
11/11/2002 Purchase 40 $9.00 $360.00
11/22/2002 Purchase 15 $10.00 $150.00
11/30/2002 Purchase 10 $11.00 $110.00
95 $860.00

Beginning inventory+ Purchase= 165 $1,350.00 Unit cost= 8.18

Unit cost Value of inventory
Ending Inventory =165-100 100 $8.18 $818.00

Gross Margin =Sales- (Beginning inventory+Purchases)+Ending ...

Purchase this Solution
Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

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.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

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.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

View More Free Quizzes
Related BrainMass Solutions

  • Perpetual & Periodic Inventory System

    The solution computes cost of goods sold under perpertual & periodic inventory system using FIFO, LIFO & Average Cost Method.

  • FIFO, LIFO calculations under periodic and perpetual method

    The ending inventory value is 50X28 + 50X25 = $2,650 The cost of goods sold is 20,050-2,650 = $17,400 The solution explains how to calculate the cost of goods sold, ending inventory under FIFO and LIFO using perpetual and periodic methods

  • FIFO, LIFO Average Cost

    Using the perpetual inventory system determine cost of goods sold under FIFO. 9. Using the perpetual inventory system determine ending inventory under LIFO. 10. Using the perpetual inventory system determine cost of goods sold under LIFO.

  • Cost of Goods Sold and Ending Inventory

    107746 Calculate Cost of Goods Sold (COGS) and Ending Inventory (EI) under FIFO, LIFO, and W/A (Periodic Inventory). 1. Calculate Cost of Goods Sold (COGS) and Ending Inventory (EI) under FIFO, LIFO, and W/A (Periodic Inventory).

  • LIFO, FIFO, Average cost; Perioidic and Perpetual Methods

    Sales for entire year $2,680 consisting of 180 units Required: The cost assigned to the 65 units in ending inventory under the periodic FIFO cost flow assumption is $___________.

  • Important information about Inventory valuation

    Total goods available for sale = 33,655 Ending inventory under FIFO = 4,715 (this remains the same under both periodic and perpetual) Cost of goods sold = 33,655-4,715 = $28,940 In an inflationary period, which inventory method-FIFO, LIFO, average

  • FIFO, LIFO, and Average-Cost Inventory Methods

    (b) Determine (1) the ending inventory, and (2) the cost of goods sold under each of the assumed cost flow methods (FIFO, LIFO, and average). Prove the accuracy of the cost of goods sold under the FIFO and LIFO methods.

  • FIFO and LIFO

    Calculate cost of goods sold and ending inventory under FIFO and LIFO. c. Explain why the FIFO results for cost of goods sold and ending inventory are the same in your answers to parts a and b, but the LIFO results are different. d.

  • FIFO and LIFO inventory systems

    Cost of the ending inventory = (1,000 units @ $24) = $24,000 This solution is comprised of a detailed explanation to answer what is the cost of the ending inventory for item 27 under FIFO and LIFO method.

  • Periodic inventory system.

    Instructions Determine ending inventory and cost of goods sold under (a) average cost, (b) FIFO, and (c) LIFO.

View More Related Solutions