Question

Compute the inventory turnover ratio and average selling period from the following data of a trading...

Compute the inventory turnover ratio and average selling period from the following data of a trading company: Sales: $75,000 Gross profit: $35,000 Opening inventory: $9,000 Closing inventory: $7,000

Homework Answers

Answer #1
Inventory Turnover
Choose Numerator: / Choose Denominator: = Inventory Turnover
Cost of goods sold / Average inventory = Inventory Turnover
$40,000 / $8,000 = 5.0 times
average selling period
Choose Numerator: / Choose Denominator: x Days = average selling period
Merchandise inventory / Cost of goods sold x 365 = Days’ Sales in Inventory
                         7,000 / $40,000 x 365 = 63.875 days

Average Inventory = (Beg. Inventory + ending Inventory)/2

Cost of goods sold = Sales - Gross Profit

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Calculating the Average Inventory, the Inventory Turnover Ratio, and the Inventory Turnover in Days Last year,...
Calculating the Average Inventory, the Inventory Turnover Ratio, and the Inventory Turnover in Days Last year, Nikkola Company had net sales of $2,299,500,000 and cost of goods sold of $1,755,000,000. Nikkola had the following balances: January 1 December 31 Accounts receivable $142,650,000 $172,350,000 Inventory     54,374,200     62,625,800 Required: Note: Round answers to one decimal place. Assume 365 days per year. 1. Calculate the average inventory. $ 2. Calculate the inventory turnover ratio. times 3. Calculate the inventory turnover in days. days...
use the following ratio data to coplete old mill's income statement. 1. Inventory turnover was 3.70...
use the following ratio data to coplete old mill's income statement. 1. Inventory turnover was 3.70 (beginning merchandise inventory was $810; ending merchandise inventory was $770). 2. profit margin ratio is 14% Old Mills Income Statement Year Ended December 31, 2018 Net sales revenue $6,900, cost of goods sold_________, selling and administrative expensed 1,710, interest expense____________, other expenses 120, income before income taxes 1,150, income tax expense_____________, net income_____________.
Accounts Receivable and Inventory Turnover The following data (in millions) were adapted from recent financial statements...
Accounts Receivable and Inventory Turnover The following data (in millions) were adapted from recent financial statements of Apple Inc (AAPL). Year 2 Year 1 Sales $233,715 $182,795 Cost of goods sold 140,089 112,258 Operating income 71,230 52,503 Average accounts receivable 33,713 27,816 Average inventory 2,230 1,938 1. Compute the accounts receivable turnover for Years 1 and 2. Round to one decimal place. Accounts Receivable Turnover Year 2 Year 1 2. Compute the number of days' sales in receivables for Years...
eBook Show Me How Calculator Print Item Calculating the Average Inventory, the Inventory Turnover Ratio, and...
eBook Show Me How Calculator Print Item Calculating the Average Inventory, the Inventory Turnover Ratio, and the Inventory Turnover in Days Last year, Dogwood Company had net sales of $9,375,000 and cost of goods sold of $4,760,000. Dogwood had the following balances: January 1 December 31 Accounts receivable $725,000 $775,000 Inventory 450,000 425,000 Required: Note: Round answers to one decimal place. Assume 365 days per year. 1. Calculate the average inventory. $ 2. Calculate the inventory turnover ratio. times 3....
1 Last year a company reported sales of $ 10 million and an inventory turnover ratio...
1 Last year a company reported sales of $ 10 million and an inventory turnover ratio of 5. It is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 8 while maintaining the same level of sales, how much cash will be freed up? 2 A company has days sales outstanding of 18 days. It averages $ 6,500 in credit sales every day....
Q8. (Trading account, average cost) Clyde Wishbone breeds and sells sheep. During the 2017/18 year records...
Q8. (Trading account, average cost) Clyde Wishbone breeds and sells sheep. During the 2017/18 year records disclosed the following: Quantity Value ($) Sheep on Hand – 30 June 2017 8,200 47,900 Purchases 500 9,200 Natural Increase 2,900 Sales 4,300 92,400 Rations 100 Deaths 300 Clyde chooses to use the prescribed value for natural increase and average cost for rations and closing stock. Required: Prepare the average cost calculations and the trading account for the 2017/18 tax year. Average Cost Calculations...
Exercise 6-49 (Algorithmic) Analyzing Inventory Examining the recent financial statements of McLelland Clothing, Inc., you note...
Exercise 6-49 (Algorithmic) Analyzing Inventory Examining the recent financial statements of McLelland Clothing, Inc., you note the following: Sales $754,693 Cost of goods sold 506,700 Average inventory 76,900 Required: Calculate McLelland's gross profit ratio, inventory turnover ratio, and assuming a 365-day year, the average days to sell inventory. (Use two decimal places for gross profit ratio and average days to sell inventory, three decimal places for inventory turnover ratio.) Gross profit ratio   % Inventory turnover ratio Average days to sell...
Exercise 9-11 Accounts receivable turnover, inventory turnover, and net margin LO 9-2, 9-4 Selected data from...
Exercise 9-11 Accounts receivable turnover, inventory turnover, and net margin LO 9-2, 9-4 Selected data from Stuart Company follow: Balance Sheets As of December 31 2018 2017 Accounts receivable $ 396,000 $ 380,000 Allowance for doubtful accounts (19,800 ) (15,200 ) Net accounts receivable $ 376,200 $ 364,800 Inventories, lower of cost or market $ 476,500 $ 435,000 Income Statement For the Years Ended December 31 2018 2017 Net credit sales $ 2,017,000 $ 1,757,000 Net cash sales 419,000 308,000...
Inventory Ratio Calculations McMahan, LTD. provided the following data for 2008 and 2009: Inventory December 31,...
Inventory Ratio Calculations McMahan, LTD. provided the following data for 2008 and 2009: Inventory December 31, 2007 $178,000 December 31, 2008 185,000 December 31, 2009 193,000 Cost of goods sold 2008 $545,000 2009 587,000 Gross margin 2008 $254,000 2009 283,000 Do not round until your final answers. Round all calculations to two decimal places. (a) Calculate the inventory turnover ratio for 2008 and 2009. 2008 Answer times 2009Answer times (b) Calculate the gross margin return on inventory investment for 2008...
Answer ALL the questions. Show your calculations. The following data is taken from the financial statements...
Answer ALL the questions. Show your calculations. The following data is taken from the financial statements of company Fairuz Sdn Bhd. Based on the data below, calculate the following. Show all your calculations: Sales 640,000 Cost of Goods Sold 380,000 Cash 30,000 Marketable Securities 40,000 Account Receivable 70,000 Inventory 150,000 Net Fixed Assets 300,000 Current Liabilities 120,000 Operating Expenses 25,000 Interest     6,000 Notes Payable 70,000 Equities : Ordinary Shares Preference Shares Retained Earnings 150,000 100,000 20,000 Tax      40%...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT