Only answer the weighted average. Please use excel and take a screenshot of it with formula. Inventory Costing Methods(ADOPTED) The following information was made available fora particular product sold by Blue Company:April 2 Purchase 700 units @ Php 158April 6 SaleApril 12 Purchase 800 units @ Php 164April 18 SaleApril 24 Purchase 500 units @ Php 170600 units @ Php 200700 units @ Php 220There was no inventory of this particular product at the start ofApril.REQUIRED:A. Assume that Blue uses the periodic inventory system,compute the ending inventory, cost of goods sold, and grossprofit for this product if the inventory costing method usedis:1. FIFO2. LIFO3. Weighted averageB. Assume that Blue uses the perpetual inventory system,compute the ending inventory, cost of goods sold, and grossprofit for this product if the inventory costing method usedis:4. FIFO5. LIFO6. Moving average

In weighted Average method, the unit cost is taken as cost mutiplied with respective quantities…

Inventory Costing Methods (ADOPTED) The following information was made available for a particular product sold by Blue Company: April 2 Purchase 700 units @ Php 158 April 6 Sale April 12 Purchase 800 units @ Php 164 April 18 Sale April 24 Purchase 500 units @ Php 170 600 units @ Php 200 700 units @ Php 220 There was no inventory of this particular product at the start of April.

Inventory Costing Methods (ADOPTED) The following information was made available for a particular product sold by Blue Company: April 2 Purchase 700 units @ Php 158 April 6 Sale April 12 Purchase 800 units @ Php 164 April 18 Sale April 24 Purchase 500 units @ Php 170 600 units @ Php 200 700 units @ Php 220 There was no inventory of this particular product at the start of April.

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 50E: Inventory Costing Methods Crandall Distributors uses a perpetual inventory system and has the...

See similar textbooks

Similar questions

Inventory Costing Methods Crandall Distributors uses a perpetual inventory system and has the following data available for inventory, purchases, and sales for a recent year. Required: 1. Compute the cost of ending inventory and the cost of goods sold using the specific identification method. Assume the ending inventory is made up of 40 units from beginning inventory, 30 units from Purchase 1, 80 units from Purchase 2, and 40 units from Purchase 3. 2. Compute the cost of ending inventory and cost of goods sold using the FIFO inventory costing method. 3. Compute the cost of ending inventory and cost of goods sold using the LIFO inventory costing method. 4. Compute the cost of ending inventory and cost of goods sold using the average cost inventory costing method. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest dollar.) 5. CONCEPTUAL CONNECTION Compare the ending inventory and cost of goods sold computed under all four methods. What can you conclude about the effects of the inventory costing methods on the balance sheet and the income statement?
Alternative Inventory Methods Nevens Company uses a periodic inventory system. During November, the following transactions occurred: Required: 1. Compute the cost of goods sold for November and the inventory at the end of November for each of the following cost flow assumptions: a. FIFO b. LIFO c. Average cost 2. Next Level What can you conclude about the effects of the inventory cost flow assumptions on the financial statements?
Refer to the information for Morgan Inc. above. If Morgan uses a perpetual inventory system, what is the cost of ending inventory under FIFO at April 30? a. $32,500 b. $38,400 c. $63,600 d. $69,500
Alternative Inventory Methods Park Companys perpetual inventory records indicate the following transactions in the month of June: Required: 1. Compute the cost of goods sold for June and the inventory at the end of June using each of the following cost flow assumptions: a. FIFO b. LIFO c. Average cost (Round unit costs to 3 decimal places and other amounts to the nearest dollar.) 2. Next Level Why are the cost of goods sold and ending inventory amounts different for each of the three methods? What do these amounts tell us about the purchase price of inventory during the year? 3. Next Level Which method produces the most realistic amount for net income? For inventory? Explain your answer. 4. Next Level If Park uses IFRS, which of the previous alternatives would be acceptable and why?
Inventory Write-Down Stiles Corporation uses the FIFO cost flow assumption and is in the process of applying the LCNRV rule for each of two products in its ending inventory. A profit margin of 30% on the selling price is considered normal for each product. Specific data for each product are as follows:
Inventory Write-Down Byron Company has five products in its inventory and uses the FIFO cost flow assumption. Specific data for each product are as follows: Required: 1. What is the correct inventory value, assuming the LCNRV rule is applied to each item of inventory? 2. What is the correct inventory value, assuming the LCNRV rule is applied to the total of inventory? 3. Next Level Comment on any differences that result from applying the LCNRV rule to individual items compared to the total of inventory.
Inventory Costing: Average Cost Refer to the information for Filimonov Inc. and assume that the company uses a perpetual inventory system. Required: Calculate the cost of goods sold and the cost of ending inventory using the average cost method. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest dollar.)
Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for B76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for last-in, first-out (LIFO).
Uncle Butchs Hunting Supply Shop reports the following information related to inventory: Calculate Uncle Butchs ending inventory using the retail inventory method under the FIFO cost flow assumption. Round the cost-to-retail ratio to 3 decimal places.
PERPETUAL: LIFO AND MOVING-AVERAGE Kelley Company began business on January 1, 20-1. Purchases and sales during the month of January follow. REQUIRED Calculate the total amount to be assigned to cost of goods sold for January and the ending inventory on January 31, under each of the following methods: 1. Perpetual LIFO inventory method. 2. Perpetual moving-average inventory method.
Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for B76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for first-in, first-out (FIFO).
( Appendix 6B) Inventory Costing Methods: Periodic Inventory Systems. Refer to the information for Tyler Company in Brief Exercise 6-35 and assume that the company uses the periodic inventory system. Required: Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest whole dollar.)