Entity A, a trading entity, buys and sells Product Z. Movements in the inventory of Product Z during the period are as follows: Date Transaction Units Unit Cost Total Cost Feb 1 Beginning Inv 100 15 1,500 7 Purchase 300 18 5,400 12 Sale 320 21 Purchase 200 21 4,200 How much is the ending inventory under the Weighted Average cost formula? (The average is calculated on a periodic basis.)

Entity A, a trading entity, buys and sells Product Z. Movements in the inventory of Product Z during the period are as follows: Date Transaction Units Unit Cost Total Cost Feb 1 Beginning Inv 100 15 1,500 7 Purchase 300 18 5,400 12 Sale 320 21 Purchase 200 21 4,200 How much is the ending inventory under the Weighted Average cost formula? (The average is calculated on a periodic basis.)

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter6: Cost Of Goods Sold And Inventory

Section: Chapter Questions

Problem 24CE: Inventory Costing: Average Cost Refer to the information for Filimonov Inc. and assume that the...

See similar textbooks

Related questions

Q: Date January 1 Beginning inventory January 10 Sales Purchase January 20 Sales January 25 January 30…

A: The specific identification method: It is one of the methods of inventory valuation, specifically…

Q: Please explain how to calculate the FIFO and LIFO for the below problem and to prepare the income…

A: First-in-First-Out (FIFO): In First-in-First-Out method, the costs of the initially purchased items…

Q: Particulars Beginning inventory Date Units Unit Cost/Price January 1 50 Tk. 10 March 1 Purchase 30…

A: DATE PARTICULARS UNITS Unit cost per price Total cost Jan 1 Beginning inventory 50 10 500 March…

Q: Which of the following measures the length of time it takes to acquire, sell, and replace inventory?…

A: Numbers of days to sell inventory: This ratio is determined as the number of days a particular…

Q: Instructions 1. Determine the cost of the inventory on December 31 by the first-in, first-out…

A: Dymac Appliances Cost of inventory - FIFO method Model Qty Unit Cost Total Cost A10 4 $ 76 $…

Q: Requirements: Complete the Ending Inventory and Cost of Goods Sold schedules for each inventory…

A: Cost of goods Sold The cost of the inventory that a business sells within a given time period is…

Q: Nittany Company uses a periodic inventory system. At the end of the annual accounting period,…

A: It is the stock held for sale to customers. The inventory comprises of raw materials, work in…

Q: Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for A76 Company,…

A: Last -In-Last -Out method is one of the inventory valuation method where materials received last are…

Q: A company reports inventory using the lower of cost and net realizable value. Below is information…

A: a. Inventory Cost NRV Cost per unit Quantity Ending inventory A 37 39 37 13 $481 B 44 41 41…

Q: PROBLEM 11: The following information has been extracted from the records of CCC Company about one…

A: Note - the closing inventory and cost of sales under the LIFO periodic method is being computed in…

Q: 1. Compute cost of goods available for sale and the number of units available for sale.

A: The cost which has been incurred on goods that are available for sale is known as cost of goods…

Q: Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and…

A: Under FIFO method the oldest products in inventory have been sold first. Under LIFO method the…

Q: Weighted average cost method with perpetual inventory The beginning inventory at Midnight Supplies…

A: According to the weighted average perpetual inventory system, the purchases and sales are dealt with…

Q: You are provided with the following information for Guillaume Inc. for the month ended June 30,…

A: Under FIFO METHOD:: BBeginning inventory::40*P40 =P1600 June 4:Purchases::135*P44 =P5940 June 18…

Question

Entity A, a trading entity, buys and sells Product Z. Movements in the inventory of Product Z
during the period are as follows:
Date
Transaction
Units
Unit Cost
Total Cost
Feb 1
Beginning Inv
100
15
1,500
7
Purchase
300
18
5,400
12
Sale
320
21
Purchase
200
21
4,200
How much is the ending inventory under the Weighted Average cost formula? (The average is
calculated on a periodic basis.)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2: Working for Weighted Average method

VIEW

Step 3: Answer - Ending Inventory

VIEW

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Compare the calculations for gross margin for B76 Company, based on the results of the perpetual inventory calculations using FIFO, LIFO, and AVG.
Use the weighted-average (AVG) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for A75 Company, considering the following transactions.
Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for A76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for weighted average (AVG).
Use the last-in, first-out method (LIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.
Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for A76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for first-in, first-out (FIFO).
During a period of rising prices, which U.S. GAAP inventory method reports the most current inventory costs on the income statement and on the balance sheet? a. Income Statement Balance Sheet LIFO LIFO b. FIFO FIFO c. FIFO LIFO d. LIFO FIFO
Which of the following inventory cost flow assumptions produces the same ending inventory values under both the periodic and perpetual system? a. FIFO b. LIFO c. Average d. Dollar-value LIFO
What is the right answer in the options?
On the basis of the following data: Product InventoryQuantity Cost perUnit Market Value per Unit(Net Realizable Value) Model A 42 $74 $90 Model B 45 181 202 Model C 29 166 171 Model D 12 130 112 Model E 24 159 158 Determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 9. Inventory at the Lower of Cost or Market Product Total Cost Total Market Lower of Total Cost or Total Market A $ $ $ B C D E Total $ $ $
Suppose the following:Beginning Inventory = 11257Ending Inventory= 12407Beginning Receivables = 6167Ending Receivables = 6879Beginning Payables = 8498Ending Payables = 8829Credit Sales = 93480Cost of Goods Sold = 72325Calculate the following (round final answers to 2 decimal places):Operating Cycle = daysCash Cycle = days
Assume that a firm separately determined inventory under FIFO and LIFO and then compared the results. a. In each space that follows, place the correct sign [less than (), or equal (=)] for each comparison, assuming periods of rising prices. 1. FIFO inventory LIFO inventory 2. FIFO cost of merchandise sold LIFO cost of merchandise sold 3. FIFO net income LIFO net income 4. FIFO income taxes LIFO income taxes b. Why would management prefer to use LIFO over FIFO in periods of rising prices?
Lower-of-Cost-or-Market InventoryOn the basis of the following data, determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 9. ProductInventoryQuantityUnitCost PriceUnitMarket Value per Unit(Net Realizable Value)Model A300$140$125Model B50090112Model C1506059Model D800120115Model E400140145 Inventory at the Lower of Cost or MarketProductTotal CostTotal MarketLower of Total Cost or Total MarketA$$$B C D E Total$$$