IE7-1 Reporting Inventory at a Lower of Cost or Net Realizable Value The following is a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
IE7-1 Reporting Inventory at a Lower of Cost or Net Realizable Value The following is a list of inventory items for Ducard Company on April 30, 20XX. Unit Cost Net Realizable Item Shoes Sunglasses Umbrellas T-Shirts Hats Sandals Boots Keychains Required Quantity When Acquired 12 $ 42.00 Value $ 64.00 23 28.00 35.00 15 18.00 12.00 17 8.00 8.00 28 12.00 10.00 15.00 19.00 14 48.00 35.00 35 $ 3.00 $ 5.00 1. Determine the current value of the Inventory. 2. Use the lower of Cost or Net Realizable Value to determine the how much inventory should be. 3. Create a journal entry to mark down the inventory. Hint: Use the IF() function for the Lower of Cost or NRV. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. A1 A Calibri (Body) 11 A A BI U ab X fx Accessibility tab summary: The financial information B C D E For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. 1 The following is a list of inventory items for Ducard Company on April 30, 20XX. Example: =B3+C3 Item Quantity Unit Cost When Acquired Net Realizable Value OK Shoes 12.00 $ 42.00 $ 64.00 Sunglasses Umbrellas T-Shirts 23.00 28.00 35.00 15.00 18.00 12.00 17.00 8.00 8.00 Hats 28.00 12.00 10.00 10 Sandals 9.00 15.00 19.00 11 Boots 14.00 48.00 35.00 35.00 $ 3.00 $ 5.00 12 Keychains 14 Required 1. Determine the current value of the Inventory. 26 27 234567892223172 22222222222223 29 30 17 Item Quantity Unit Cost When Acquired Total Cost 18 Shoes 19 Sunglasses 20 Umbrellas 21 T-Shirts 22 Hats 23 Sandals 24 Boots 25 Keychains Total 28 2. Use the lower of Cost or Net Realizable Value to determine the how much inventory should be. Hint: Use the IF() function for the Lower of Cost or NRV. = Graded Worksheet + IE7-1 Reporting Inventory at a Lower of Cost or Net Realizable Value The following is a list of inventory items for Ducard Company on April 30, 20XX. Unit Cost Net Realizable Item Shoes Sunglasses Umbrellas T-Shirts Hats Sandals Boots Keychains Required Quantity When Acquired 12 $ 42.00 Value $ 64.00 23 28.00 35.00 15 18.00 12.00 17 8.00 8.00 28 12.00 10.00 15.00 19.00 14 48.00 35.00 35 $ 3.00 $ 5.00 1. Determine the current value of the Inventory. 2. Use the lower of Cost or Net Realizable Value to determine the how much inventory should be. 3. Create a journal entry to mark down the inventory. Hint: Use the IF() function for the Lower of Cost or NRV. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. A1 A Calibri (Body) 11 A A BI U ab X fx Accessibility tab summary: The financial information B C D E For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. 1 The following is a list of inventory items for Ducard Company on April 30, 20XX. Example: =B3+C3 Item Quantity Unit Cost When Acquired Net Realizable Value OK Shoes 12.00 $ 42.00 $ 64.00 Sunglasses Umbrellas T-Shirts 23.00 28.00 35.00 15.00 18.00 12.00 17.00 8.00 8.00 Hats 28.00 12.00 10.00 10 Sandals 9.00 15.00 19.00 11 Boots 14.00 48.00 35.00 35.00 $ 3.00 $ 5.00 12 Keychains 14 Required 1. Determine the current value of the Inventory. 26 27 234567892223172 22222222222223 29 30 17 Item Quantity Unit Cost When Acquired Total Cost 18 Shoes 19 Sunglasses 20 Umbrellas 21 T-Shirts 22 Hats 23 Sandals 24 Boots 25 Keychains Total 28 2. Use the lower of Cost or Net Realizable Value to determine the how much inventory should be. Hint: Use the IF() function for the Lower of Cost or NRV. = Graded Worksheet +
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
You are currently a managing partner at Innovative Marketing Solutions (IMS) a social media marketing start-up. The firm occupies a modern office space at the London Roundhouse (a hub for tech...
-
Describe a venture bankruptcy. Also, indicate the difference between a voluntary bankruptcy petition and an involuntary bankruptcy petition.
-
Define the term agreed-upon procedures engagement and describe typical procedures performed and reporting on such an engagement. The practitioner should not perform agreed-upon procedures that are...
-
In what two ways can the breakeven point be stated?
-
Suppose that the total benefit and total cost from a continuous activity are, respectively, given by the following equations: B (Q) = 100 + 36Q 4Q2 and C (Q) = 80 + 12Q. [MB (Q) = 36 8Q and MC (Q)...
-
9. The average amount earned by each employee is $66,500. Based on this amount what would be total assessable earnings when they payroll administrator calculates it for Workers' Compensation? Provide...
-
Loan Amount Type Region $ 33,000.00 Consumer 1 $ 30,500.00 Commercial 1 $ 84,500.00 Commercial 2 $ 110,500.00 Commercial 3 $ 21,500.00 Commercial 3 $ 59,500.00 Commercial 4 $ 48,500.00 Real Estate 1...
-
discuss the ethical and legal challenges surrounding employee data privacy in the context of sophisticated Human Resources Information Systems (HRIS) ?
-
Assume an and bn are alternating series. 00 an n = 5 (a) If lan = 11, what can we say about n = 5 The series converges. (b) If bn = 8, what can we say about bnl ? n = 1 Impossible to tell 00 Submit...
-
What are the potential ramifications of adopting advanced analytics and AI-driven decision-making in talent acquisition and workforce planning ?
-
Select one kind of challenge that Human Resource Management faces today and address how to handle this challenge.
-
Fred currently earns $10,100 per month. Fred has been offered the chance to transfer for three to five years to an overseas affiliate. His employer is willing to pay Fred $13,100 per month if he...
-
6. (20 pts) Pure copper is poured into a sand mold. The metal level in the pouring basin is 250 mm above the metal level in the mold, and the runner is circular with a 10-mm diameter. What are the...
-
Which of the companies has the lowest accounts receivable turnover in the year 20X2? a. Company A. b. Company B. c. Company C. d. CompanyD. 20X1 20X2 Credit Sales Average Receivables Balance $1.0...
-
The weekly payroll for employees of Ryan Company, who work a five-day week, amounts to \(\$ 20,000\). All employees are paid up-to-date at the close of business each Friday. If December 31 falls on...
-
At year-end the adjusting entry to reduce the Unexpired Insurance account by the amount of insurance premium applicable to the current period was accidentally omitted. Which items in the income...
-
Do all transactions involving revenue or expenses require adjusting entries at the end of the accounting period? If not, what is the distinguishing characteristic of those transactions that do...
Study smarter with the SolutionInn App