Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

______ ______ Inventory Turnover and Days' Sales in Inventory The Western Company installed a new inventory management system at the beginning of 2018. Shown below

image text in transcribed______

image text in transcribed

______

image text in transcribed

image text in transcribed

Inventory Turnover and Days' Sales in Inventory The Western Company installed a new inventory management system at the beginning of 2018. Shown below are data from the company's accounting records as reported out by the new system: Sales Revenue Cost of Goods Sold Beginning Inventory Ending Inventory 2018 2019 $11,000,000 $14,000,000 5,000,000 6,000,000 620,000 630,000 630,000 750,000 Calculate the company's (a) inventory turnover and (b) days' sales in inventory for 2018 and 2019. Round your answer to two decimal points, when needed. 2018 2019 Inventory turnover 0 0 Days' sales in inventory Lower-of-Cost-or-Net Realizable Value Method The following data are taken from the Daisy Corporation's inventory accounts: Item Code Product 1 Net Unit Realizable Quantity Cost Value ZKE 100 $22 $18 3003136 ZKF Product 2 MNJ 400 250 22 19 3137 MNS Calculate the value of the company's ending inventory using the lower-of-cost-or-net realizable method applied to each item of inventory. Applying the lower-of-cost-or-net realizable value method to each item of the inventory results in an ending inventory amount of $ $ 6,820 Inventory Costing Methods-Perpetual Method The Glenn Sales Corporation uses the perpetual inventory system. On January 1, 2018, Glenn had 2,600 units of product B with a unit cost of $40 per unit. A summary of purchases and sales during 2018 follows: Unit Units Units Cost Purchased Sold Jan. 3 1,600 Mar. 8 $44 3,000 June 13 2,000 Sept.19 46 800 Nov.23 50 1,200 Dec.28 1,800 Required a. Assume that Glenn uses the first-in, first-out method. Compute the cost of goods sold for 2018 and the ending inventory balance at December 31, 2018, for product B. b. Assume that Glenn uses the last-in, first-out method. Compute the cost of goods sold for 2018 and the ending inventory balance at December 31, 2018, for product B. c. Assume that Glenn uses the weighted-average cost method. Compute the cost of goods sold for 2018 and the ending inventory balance at December 31, 2018, for product B. Do not round until your final answers. Round to the nearest dollar. a. First In, First Out Ending Inventory $ 105,600 Cost of goods Sold $ 227,200 b. Last-In, First-Out Ending Inventory $ Cost of Goods Sold $ 0x c. Weighted Average Inventory Turnover and Days' Sales in Inventory The Southern Corporation installed a new inventory management system at the beginning of 2018. Shown below are data from the company's accounting records as reported by the new system: Sales Revenue Cost of goods sold Beginning inventory Ending inventory 2018 2019 $19,000,000 $20,000,000 8,600,000 9,200,000 2,500,000 2,530,000 2,530,000 2,600,000 Calculate the company's (a) inventory turnover and (b) days' sales in inventory for 2018 and 2019. Round your answers to two decimal points. HINT: Use your rounded answers for inventory turnover to calculate days' sales in inventory. 2018 2019 Inventory turnover Days' sales in inventory Inventory Turnover and Days' Sales in Inventory The Western Company installed a new inventory management system at the beginning of 2018. Shown below are data from the company's accounting records as reported out by the new system: Sales Revenue Cost of Goods Sold Beginning Inventory Ending Inventory 2018 2019 $11,000,000 $14,000,000 5,000,000 6,000,000 620,000 630,000 630,000 750,000 Calculate the company's (a) inventory turnover and (b) days' sales in inventory for 2018 and 2019. Round your answer to two decimal points, when needed. 2018 2019 Inventory turnover 0 0 Days' sales in inventory Lower-of-Cost-or-Net Realizable Value Method The following data are taken from the Daisy Corporation's inventory accounts: Item Code Product 1 Net Unit Realizable Quantity Cost Value ZKE 100 $22 $18 3003136 ZKF Product 2 MNJ 400 250 22 19 3137 MNS Calculate the value of the company's ending inventory using the lower-of-cost-or-net realizable method applied to each item of inventory. Applying the lower-of-cost-or-net realizable value method to each item of the inventory results in an ending inventory amount of $ $ 6,820 Inventory Costing Methods-Perpetual Method The Glenn Sales Corporation uses the perpetual inventory system. On January 1, 2018, Glenn had 2,600 units of product B with a unit cost of $40 per unit. A summary of purchases and sales during 2018 follows: Unit Units Units Cost Purchased Sold Jan. 3 1,600 Mar. 8 $44 3,000 June 13 2,000 Sept.19 46 800 Nov.23 50 1,200 Dec.28 1,800 Required a. Assume that Glenn uses the first-in, first-out method. Compute the cost of goods sold for 2018 and the ending inventory balance at December 31, 2018, for product B. b. Assume that Glenn uses the last-in, first-out method. Compute the cost of goods sold for 2018 and the ending inventory balance at December 31, 2018, for product B. c. Assume that Glenn uses the weighted-average cost method. Compute the cost of goods sold for 2018 and the ending inventory balance at December 31, 2018, for product B. Do not round until your final answers. Round to the nearest dollar. a. First In, First Out Ending Inventory $ 105,600 Cost of goods Sold $ 227,200 b. Last-In, First-Out Ending Inventory $ Cost of Goods Sold $ 0x c. Weighted Average Inventory Turnover and Days' Sales in Inventory The Southern Corporation installed a new inventory management system at the beginning of 2018. Shown below are data from the company's accounting records as reported by the new system: Sales Revenue Cost of goods sold Beginning inventory Ending inventory 2018 2019 $19,000,000 $20,000,000 8,600,000 9,200,000 2,500,000 2,530,000 2,530,000 2,600,000 Calculate the company's (a) inventory turnover and (b) days' sales in inventory for 2018 and 2019. Round your answers to two decimal points. HINT: Use your rounded answers for inventory turnover to calculate days' sales in inventory. 2018 2019 Inventory turnover Days' sales in inventory

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Research Methods And Audit In General Practice

Authors: David Armstrong, John Grace

1st Edition

0192624547, 978-0192624543

More Books

Students also viewed these Accounting questions

Question

What are the challenges associated with tunneling in urban areas?

Answered: 1 week ago

Question

What are the main differences between rigid and flexible pavements?

Answered: 1 week ago

Question

What is the purpose of a retaining wall, and how is it designed?

Answered: 1 week ago

Question

How do you determine the load-bearing capacity of a soil?

Answered: 1 week ago

Question

what is Edward Lemieux effect / Anomeric effect ?

Answered: 1 week ago