Costco uses the weighted average inventory cost flow assumption for tracking its inventory. One of its products, bags of frozen berries, is exclusively sold to Smoothie stores across Vancouver. The following transactions took place in March 2023: Date March 1 March 7 March 10 March 14 Transaction Opening inventory Sale #1 Purchase #1 Sale #2 Units 550 300 200 125 Unit Selling Price/Unit Cost $4.50 $8 $3.75 $8.50 Note: See Excel for the table. You may complete the question on word or excel. What is the ending inventory balance in units, and the ending inventory cost (per unit and total) at the end of the month?

Costco uses the weighted average inventory cost flow assumption for tracking its inventory. One of its products, bags of frozen berries, is exclusively sold to Smoothie stores across Vancouver. The following transactions took place in March 2023: Date March 1 March 7 March 10 March 14 Transaction Opening inventory Sale #1 Purchase #1 Sale #2 Units 550 300 200 125 Unit Selling Price/Unit Cost $4.50 $8 $3.75 $8.50 Note: See Excel for the table. You may complete the question on word or excel. What is the ending inventory balance in units, and the ending inventory cost (per unit and total) at the end of the month?

Corporate Financial Accounting

14th Edition

ISBN:9781305653535

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter6: Inventories

Section: Chapter Questions

Problem 6.2BE: Perpetual inventory using FIFO Beginning inventory, purchases, and sales for Item Zeta9 are as...

See similar textbooks

Similar questions

( Appendix 6B) Refer to the information for Morgan Inc. above. If Morgan uses a periodic inventory system, what is the cost of goods sold under FIFO at April 30? a. $32,800 b. $38,400 c. $63,600 d. $69,200
( Appendix 6B) Inventory Costing Methods Jet Black Products uses a periodic inventory system. For 2018 and 2019, Jet Black has the following data: All purchases and sales are for cash. Required: 1. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using FIFO. 2. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using LIFO. 3. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using the average cost method. ( Note: Use four decimal places for per unit calculations and round all other numbers to the nearest dollar.) 4. CONCEPTUAL CONNECTION Which method would result in the lowest amount paid for taxes? 5. CONCEPTUAL CONNECTION Which method produces the most realistic amount for income? For inventory? Explain your answer. 6. CONCEPTUAL CONNECTION What is the effect of purchases made later in the year on the gross margin when LIFO is employed? When FIFO is employed? Be sure to explain why any differences occur. 7. CONCEPTUAL CONNECTION If you worked Problem 6-68A, compare your answers. What are the differences? Be sure to explain why any differences occurred.
Continuing Company AnalysisAmazon: Inventory turnover and number of days sales in inventory Amazon.com, Inc. is one of the largest Internet retailers in the world. Target Corporation is one of the largest value-priced general merchandisers operating in the United States. Target sells through nearly 1,800 brick-and-mortar stores and through the Internet. Amazon and Target compete for customers across a wide variety of products, including media, general merchandise, apparel, and consumer electronics. Cost of goods sold and inventory information from a recent annual report are provided for both companies as follows (in millions): Amazon Target Cost of goods sold 62,752 51,160 Inventories: Beginning of year 7,411 7,903 End of year 8,299 8,766 A. Compute the inventory turnover for both companies. (Round all calculations to one decimal place.) B. Compute the number of days sales in inventory for both companies. (Use 365 days and round all calculations to one decimal place.) C. Which company has the better inventory efficiency? D. What might explain the difference in inventory efficiency between the two companies?
( Appendix 6B) Refer to the information for Morgan Inc. above. If Morgan uses a periodic inventory system, what is the cost of ending inventory under LIFO at April 30? a. $32,800 b. $38,400 c. $63,600 d. $69,200
( Appendix 6B) Inventory Costing Methods Grencia Company uses a periodic inventory system. For 2018 and 2019, Grencia has the following data (assume all purchases and sales are for cash): Required: 1. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using FIFO. 2. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using LIFO. 3. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using the average cost method. ( Note: Use four decimal places for per unit calculations and round all other numbers to the nearest dollar.) 4. CONCEPTUAL CONNECTION Which method would result in the lowest amount paid for taxes? 5. CONCEPTUAL CONNECTION Which method produces the most realistic amount for income? For inventory? Explain your answer. 6. CONCEPTUAL CONNECTION What is the effect of purchases made later in the year on the gross margin when LIFO is employed? When FIFO is employed? Be sure to explain why any differences occur. 7. CONCEPTUAL CONNECTION If you worked Problem 6-68B, compare your answers. What are the differences? Be sure to explain why any differences occurred.
Palisade Creek Co. is a merchandising business that uses the perpetual inventory system. The account balances for Palisade Creek Co. as of May 1, 2016 (unless otherwise indicated), are as follows: During May, the last month of the fiscal year, the following transactions were completed: May 1. Paid rent for May, 5,000. 3. Purchased merchandise on account from Martin Co., terms 2/10, n/30, FOB shipping point, 36,000. 4. Paid freight on purchase of May 3, 600. 6. Sold merchandise on account to Korman Co., terms 2/10, n/30, FOB shipping point, 68,500. The cost of the merchandise sold was 41,000. 7. Received 22,300 cash from Halstad Co. on account. 10. Sold merchandise for cash, 54,000. The cost of the merchandise sold was 32,000. 13. Paid for merchandise purchased on May 3. 15. Paid advertising expense for last half of May, 11,000. 16. Received cash from sale of May 6. 19. Purchased merchandise for cash, 18,700. 19. Paid 33,450 to Buttons Co. on account. 20. Paid Korman Co. a cash refund of 13,230 for returned merchandise from sale of May 6. The invoice amount of the returned merchandise was 13,500 and the cost of the returned merchandise was 8,000. Record the following transactions on Page 21 of the journal: 20. Sold merchandise on account to Crescent Co., terms 1/10, n/30, FOB shipping point, 110,000. The cost of the merchandise sold was 70,000. 21. For the convenience of Crescent Co., paid freight on sale of May 20, 2,300. 21. Received 42,900 cash from Gee Co. on account. May 21. Purchased merchandise on account from Osterman Co., terms 1/10, n/30, FOB destination, 88,000. 24. Returned of damaged merchandise purchased on May 21, receiving a credit memo from the seller for 5,000. 26. Refunded cash on sales made for cash, 7,500. The cost of the merchandise returned was 4,800. 28. Paid sales salaries of 56,000 and office salaries of 29, 000. 29. Purchased store supplies for cash, 2,400. 30. Sold merchandise on account to Turner Co., terms 2/10, n/30, FOB shipping point, 78,750. The cost of the merchandise sold was 47,000. 30. Received cash from sale of May 20 plus freight paid on May 21. 31. Paid for purchase of May 21, less return of May 24. Instructions 1. Enter the balances of each of the accounts in the appropriate balance column of a four-column account. Write Balance in the item section, and place a check mark () in the Posting Reference column. Journalize the transactions for July, starting on Page 20 of the journal. 2. Post the journal to the general ledger, extending the month-end balances to the appropriate balance columns after all posting is completed. In this problem, you are not required to update or post to the accounts receivable and accounts payable subsidiary ledgers. 3. Prepare an unadjusted trial balance. 4. At the end of May, the following adjustment data were assembled. Analyze and use these data to complete (5) and (6). f. The adjustment for customer returns and allowances is 60,000 for sales and 35,000 for cost of merchandise sold. 5. (Optional) Enter the unadjusted trial balance on a IO-column end-of-period spreadsheet (work sheet), and complete the spreadsheet. 6. Journalize and post the adjusting entries. Record the adjusting entries on Page 22 of the journal. 7. Prepare an adjusted trial balance. 8. Prepare an income statement, a statement of owners equity, and a balance sheet. 9. Prepare and post the closing entries. Record the closing entries on Page 23 of the journal. Indicate closed accounts by inserting a line in both the Balance columns opposite the closing entry. Insert the new balance in the owners capital account. 10. Prepare a post-closing trial balance.
( Appendix 6B) Inventory Costing Methods: Periodic Average Cost Refer to the information for Filimonov Inc. (p. 337) and assume that the company uses a periodic 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.)
Perpetual inventory using FIFO Beginning inventory, purchases, and sales for Item Zeta9 are as follows: Oct. 1 Inventory 175 units at 30 7 Sale 155 units 15 Purchase 200 units at 33 24 Sale 140 units Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method, determine (A) the cost of goods sold on October 24 and (B) the inventory on October 31.
SERIES B PROBLEM PERPETUAL: LIFO AND MOVING-AVERAGE Vozniak 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.
( Appendix 6B) Inventory Costing Methods: Periodic Inventory System The inventory accounting records for Lee Enterprises contained the following data: Required: 1. Calculate the cost of ending inventory and the cost of goods sold 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 dollar.) 2. CONCEPTUAL CONNECTION Compare the ending inventory and cost of goods sold computed under all three methods. What can you conclude about the effects of the inventory costing methods on the balance sheet and the income statement?
Perpetual inventory using LIFO Beginning inventory, purchases, and sales for Item 88-HX are as follows: July 1 Inventory 90 units at 54 8 Sale 75 units 15 Purchase 125 units at 60 27 Sale 80 units Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (A) the cost of goods sold on July 27 and (B) the inventory on July 31.
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.