The following is a list of inventory items for Ducard Company on April 30. Item Quantity Unit Cost When Acquired Net Realizable Value Shoes 12 $ 42.00 $ 64.00 Sunglasses 23 28.00 35.00 Umbrellas 15 18.00 12.00 T-Shirts 17 8.00 8.00 Hats 28 12.00 10.00 Sandals 9 15.00 19.00 Boots 14 48.00 35.00 Keychains 35 $ 3.00 $ 5.00 Required Determine the current value of the Inventory. Use the lower of Cost or Net Realizable Value (NRV) to determine the value of inventory. Create a journal entry to mark down the inventory.

The following is a list of inventory items for Ducard Company on April 30. Item Quantity Unit Cost When Acquired Net Realizable Value Shoes 12 $ 42.00 $ 64.00 Sunglasses 23 28.00 35.00 Umbrellas 15 18.00 12.00 T-Shirts 17 8.00 8.00 Hats 28 12.00 10.00 Sandals 9 15.00 19.00 Boots 14 48.00 35.00 Keychains 35 $ 3.00 $ 5.00 Required Determine the current value of the Inventory. Use the lower of Cost or Net Realizable Value (NRV) to determine the value of inventory. Create a journal entry to mark down the inventory.

Name: man.2 The following is a list of inventory items for Ducard Company on
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: man.2 The following is a list of inventory items for Ducard Company on April 30. ItemQuantity Unit Cost When Acquired Net Realizable Value Shoes 12 $ 42.00 $ 64.00Sunglasses 23 28.00 35.00 Umbrellas 15 18.00 12.00 T-Shirts 17 8.00 8.00 Hats28 12.00 1

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter16: Manufacturing Accounting (mfg)

Section: Chapter Questions

Problem 3R: The following data pertain to 2012 activities of Twisp Industries: Use your completed worksheet to...

See similar textbooks

Similar questions

Cost of goods sold and related items The following data were extracted from the accounting records of Harkins Company for the year ended April 30, 20Y8: Estimated returns of current year sales 11,600 Inventory, May 1, 20Y7 380,000 Inventory, April 30, 20Y8 415,000 Purchases 3,800,000 Purchases returns and allowances 150,000 Purchases discounts 80,000 Sales 5,850,000 Freight in 16,600 a. Prepare the Cost of goods sold section of the income statement for the year ended April 30, 20Y8, using the periodic inventory system. b. Determine the gross profit to be reported on the income statement for the year ended April 30, 20Y8. c. Would gross profit be different if the perpetual inventory system was used instead of the periodic inventory system?
Analyzing Inventory The recent financial statements of McLelland Clothing Inc. include the following data: Required: 1. Calculate McLellands gross profit ratio (rounded to two decimal places), inventory turnover ratio (rounded to three decimal places), and the average days to sell inventory (assume a 365-day year and round to two decimal places) using the FIFO inventory costing method. Be sure to explain what each ratio means. 2. Calculate McLellands gross profit ratio (rounded to two decimal places), inventory turnover ratio (rounded to three decimal places), and the average days to sell inventory (assume a 365-day year and round to two decimal places) using the LIFO inventory costing method. Be sure to explain what each ratio means. 3. CONCEPTUAL CONNECTION Which ratios-the ones computed using FIFO or LIFO inventory values-provide the better indicator of how successful McLelland was at managing and controlling its inventory?
Calculate the cost of goods sold dollar value for B74 Company for the sale on November 20, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average (AVG).
The following data pertain to 2012 activities of Twisp Industries: Use your completed worksheet to determine the firms cost of goods sold for 2012. Remember to change the year in row 24 and to enter new beginning inventory balances. Save the 2012 file as MFG3. Print the worksheet when done. If sales and other expenses were identical in 2011 and 2012, during which year did Twisp earn more income? Why?
On January 1, Pope Enterprises inventory was 625,000. Pope made 950,000 of net purchases during the year. On its year-end income statement, Pope reported cost of goods sold of 1,025,000. Calculate Popes December 31 ending inventory.
Inventory Costing Methods On June 1, Welding Products Company had a beginning inventory of 210 cases of welding rods that had been purchased for S88 per case. Welding Products purchased 1,150 cases at a cost of $95 per case on June 3. On June 19, the company purchased another 950 cases at a cost of $112 per case. Sales data for the welding rods are: Welding Products uses a perpetual inventory system, and the sales price of the welding rods was $130 per case. Required: 1. Compute the cost of ending inventory and cost of goods sold using the FIFO method. 2. Compute the cost of ending inventory and cost of goods sold using the LIFO method. 3. Compute the cost of ending inventory and cost of goods sold 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 Assume that operating expenses are $21,600 and Welding Products has a 30% tax rate. How much will the cash paid for income taxes differ among the three inventory methods? 5. CONCEPTUAL CONNECTION Compute Welding Products' gross profit ratio (rounded to two decimal places) and inventory turnover ratio (rounded to three decimal places) under each of the three inventory costing methods. How would the choice of inventory costing method affect these ratios?
Inventory Costing Methods Andersons Department Store has the following data for inventory, purchases, and sales of merchandise for December. Andersons uses a perpetual inventory system. All purchases and sales were for cash. Required: 1. Compute cost of goods sold and the cost of ending inventory using FIFO. 2. Compute cost of goods sold and the cost of ending inventory using LIFO. 3. Compute cost of goods sold and the cost of ending inventory using the average cost method. ( Note: Use four decimal places for per-unit calculations.) 4. Prepare the journal entries to record these transactions assuming Anderson chooses to use the FIFO method. 5. CONCEPTUAL CONNECTION Which method would result in the lowest amount paid for taxes?
Retail method; gross profit method Selected data on inventory, purchases, and sales for Celebrity Tan Co. and Ranchworks Co. are as follows: Instructions 1. Determine the estimated cost of the inventory of Celebrity Tan Co. on August 31 by the retail method, presenting details of the computations. 2. A. Estimate the cost of the inventory of Ranchworks Co. on November 30 by the gross profit method, presenting details of the computations. B. Assume that Ranchworks Co. took a physical inventory on November 30 and discovered that 369,750 of inventory was on hand. What was the estimated loss of inventory due to theft or damage during March through November?
Inventory by three cost flow methods Details regarding the inventory of appliances on January 1, 20Y7, purchases invoices during the year, and the inventory count on December 31. 2O’7. of Amsterdam Appliances are summarized as follows: Instructions Discuss which method (FIFO or LIFO) would be preferred for income tax purposes in periods of (a) rising prices and (b) declining prices.