Assuming that all net sales figures are at retail and all cost of goods sold figures are at cost, calculate the average inventory (in $) and inventory turnover for the following. If the actual turnover is less than the published rate, calculate the target average inventory necessary to come up to industry standards. If the actual turnover is greater than the published rate, enter "above" for target average inventory. Round inventories to the nearest dollar and inventory turnovers to the nearest tenth

Assuming that all net sales figures are at retail and all cost of goods sold figures are at cost, calculate the average inventory (in $) and inventory turnover for the following. If the actual turnover is less than the published rate, calculate the target average inventory necessary to come up to industry standards. If the actual turnover is greater than the published rate, enter "above" for target average inventory. Round inventories to the nearest dollar and inventory turnovers to the nearest tenth

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Define days' sales in inventory (what do the results mean). Provide an example.
PART 1: Raw Materials Inventory Turnover A. How is this ratio calculated? What does the ratio show? Using the data below (Sunn Corporation) , calculate and discuss the implications of Sunn's RM Inventory Turnover. Days' Sales in Raw Materials Inventory B. How is this ratio calculated? What does the ratio show? Using the data below (Sunn Corporation) calculate and discuss the implications of Sunn's Days' Sales in RM Inventory
Perpetual inventory using LIFO The following units of a particular item were available for sale during the calendar year: Jan. 1 Inventory 3,900 units at $41 Apr. 19 Sale 2,600 units June 30 Purchase 4,900 units at $46 Sept. 2 Sale 5,600 units Nov. 15 Purchase 2,000 units at $48 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet The firm maintains a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale, assuming the last-in, first-out method. Present the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two or more different costs, enter the units with the LOWER unit cost first in the Inventory Unit Cost column. Round your answers for quantity values to the nearest whole number, for unit cost values to the nearest cent, and for total cost values to the…
Based on the data below, how would the merchandise inventory appear on the balance sheet, assuming that the lower of cost or market is used and the cost is determined by the FIFO method? Total cost: $74, 300 Total market: $72,900 Lower of cost or market: $70, 400 The merchandise inventory would appear in the current assets section, as follows: Merchandise inventory - at lower of cost (FIFO) or market is
How would you interpret an inventory turnover ratio of 12.4?
Pina Furniture Ltd. uses a perpetual inventory system and has a beginning inventory, as at June 1, of 490 bookcases at a cost of $132 each. During June, the company had the following purchases and sales of bookcases: Date June (a) 6 10 14 16 26 Purchases Units Unit cost 1,160 $134 1,780 970 135 136 Sales Units Unit price 950 1,660 $201 206
Refer to the data in attached image. 1.Using the perpetual inventory system, compute the cost of ending inventory, cost of goods sold, and gross margin. Use the average-cost, FIFO, and LIFO inventory costing methods. (Round unit costs to the nearest cent.) 2.Explain the reasons for the differences in gross mar-gin produced by the three methods.
Dengar
Cruz Company uses LIFO for inventory costing and reports the following financial data. It also recomputed inventory and cost of goods sold using FIFO for comparison purposes. Year 2 $ 320 900 390 855 LIFO inventory LIFO cost of goods sold FIFO inventory FIFO cost of goods sold Current assets (using LIFO) Current assets (using FIFO) Current liabilities 1. Compute its current ratio, inventory turnover, and days' sales in inventory for Year 2 using (a) LIFO numbers and (b) FIFO numbers. Current ratio Inventory turnover Days' sales in inventory Year 1 $ 270 840 380 450 180 Current ratio Inventory turnover Days' sales in inventory (a) Compute its current ratio, inventory turnover, and days' sales in inventory for Year 2 using LIFO numbers. Numerator / Denominator 295 840 350 375 160 Numerator / Denominator (b) Compute its current ratio, inventory turnover, and days' sales in inventory for Year 2 using FIFO numbers. Ratio 0 0 0 Ratio 0 0 0
Cruz Company uses LIFO for inventory costing and reports the following financial data. It also recomputed inventory and cost of sold using FIFO for comparison purposes. LIFO inventory LIFO cost of goods sold FIFO inventory FIFO cost of goods sold Current assets (using LIFO) Current assets (using FIFO) Current liabilities 1. Compute its current ratio, inventory turnover, and days' sales in inventory for Year 2 using (a) LIFO numbers and (b) FIFO number Current ratio Inventory turnover Days' sales in inventory Answer is not complete. (a) Compute its current ratio, inventory turnover, and days' sales in inventory for Year 2 using LIFO numbers. Current ratio Inventory turnover Days' sales in inventory Current ratio Inventory turnover Days' sales in inventory $ $ $ $ Year 2 $ 290 870 360 825 350 420 170 Numerator 1 Denominator 350.0 / $ $ 870.0 111.0 X $ $ $ Numerator 1 350.0 / (a) Compute its current ratio, inventory turnover, and days' sales in inventory for Year 2 using LIFO numbers.…
Define average days in inventory.
Byron Company has five products in its inventory and uses the FIFO cost flow assumption. Specific data for each product are as follows: 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 coinpared to the total of inventory.