90.2K

Verified Solution

Question

Accounting

image

G A H Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or work area as indicated. a. Calculate the lower of cost and net realizable value for each inventory category within Tech-T's inventory. B D E 3 BE6.10 Using Excel to Value Inventory at the Lower-of- 4 Cost or Net Realizable Value 5 PROBLEM 6 The following information on cost and net realizable value of 7 Tech-T Ltd.'s various inventory categories was gathered at 8 December 31, 2021: 9 10 Inventory Categories Cost NRV 11 Desktops $3,47,000 $3,26,000 12 Tablets and readers 1,68,700 2.24,000 13 Laptops 2.21,020 2,85,000 14 Accessories and parts 97,400 94,300 15 16 LCNRV Inventory Categories Desktops Tablets and readers Laptop 17 Accessories and parts 18 19 20 Total LCNRV b. Prepare the entry needed to adjust Tech-T's inventory value to the lower of cost or net realizable value at December 31, 2021. 21 22 23 24 25 Debit Credit 26 27 28

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students