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 (in $) 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. Net Sales $4,560,000 Cost of Goods Sold Beginning Inventory $858,000 Ending Inventory $654,300 Average Inventory $ Inventory Published Turnover Rate 8.2 $ Target Average Inventory

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 (in $) 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. Net Sales $4,560,000 Cost of Goods Sold Beginning Inventory $858,000 Ending Inventory $654,300 Average Inventory $ Inventory Published Turnover Rate 8.2 $ Target Average Inventory

Financial Reporting, Financial Statement Analysis and Valuation

8th Edition

ISBN:9781285190907

Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Chapter10: Forecasting Financial Statement

Section: Chapter Questions

Problem 5QE: Use the following hypothetical data for Walgreens in Years 11 and 12 to project revenues, cost of...

See similar textbooks

Similar questions

Use the last-in, first-out (LIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for A75 Company, considering the following transactions.
Use the first-in, first-out (FIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for A75 Company, considering the following transactions.
Use the first-in, first-out method (FIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.
Use the following information relating to Shana Company to calculate the inventory turnover ratio and the number of days sales in inventory ratio.
Compute Westtown Companys (A) inventory turnover ratio and (B) number of days sales in inventory ratio, using the following information.
Use the following information relating to Singh Company to calculate the inventory turnover ratio and the number of days sales in inventory ratio.
When the double-extension approach to the dollar-value LIFO inventory cost flow method is used, the inventory layer added in the current year is multiplied by an index number. How would the following be used in the calculation of this index number?
Compare the calculations for gross margin for A76 Company, based on the results of the perpetual inventory calculations using FIFO, LIFO, and AVG.
Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for A76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for weighted average (AVG).
Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for A76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for last-in, first-out (LIFO).
Inventory Costing: Average Cost Refer to the information for Filimonov Inc. and assume that the company uses a perpetual inventory system. Required: Calculate the cost of goods sold and the cost of ending inventory using the average cost method. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest dollar.)
Beginning inventory, purchases, and sales for Meta-B1 are as follows: Assuming a perpetual inventory system and using the weighted average method, determine (a) the weighted average unit cost after the July 23 purchase, (b) the cost of the merchandise sold on July 26, and (c) the inventory on July 31.