Question


1. Calculate the annual stock turnover rate based on the following monthly sales and inventory figures. Calculate the stock-s
INVENTORY LEVELS Month Month Retail Stock Retail Stock Sales Sales Stock-Sales Ratio Stock-Sales Ratio 10 11 12 $0.00 EOM Inv
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Inventory Levels :-

Months Sales (A) Retail Stock (B) Stock-Sales Ratio (B/A)
1 $10000 $30000 3
2 $11000 $32000 2.91
3 $13000 $36000 2.77
4 $16000 $37000 2.31
5 $19000 $34000 1.79
6 $9000 $22000 2.44
7 $11000 $32000 2.91
8 $13000 $31000 2.38
9 $16000 $37000 2.31
10 $19000 $31000 1.63
11 $21000 $29000 1.38
12 $25000 $34000 1.36
EOM $19500
Totals $183000 $404500
Average Inventory $24750
Stock Turnover Rate 7.39 times

Average Inventory = (Beginning Stock + Ending Stock)/2

= ($30000 + $19500)/2

= $49500/2

= $24750

Stock Turnover Rate = Total Sales / Average Inventory

= $183000 / $24750

= 7.39 times

Add a comment
Know the answer?
Add Answer to:
1. Calculate the annual stock turnover rate based on the following monthly sales and inventory figures....
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • BusinessCourse Inventory Turnover The following financial data is from Brenner Instruments' financial statements (thousands of dollars,...

    BusinessCourse Inventory Turnover The following financial data is from Brenner Instruments' financial statements (thousands of dollars, except earnings per share.) 2019 Sales revenue $210,000 Cost of goods sold 125,000 Net income 8,300 Dividends 2,600 Earnings per share 4.15 Support BusinessCourse (usanus of DOllars) Dec. 31, 2019 Dec. 31, 2018 Assets Cash $18,300 $18,000 Accounts receivable (net) 41,000 46,000 39,500 Inventory 43,700 Total current assets 103,800 102,700 Plant assets (net) 52,600 50,500 Other assets 15,600 13,800 $172,000 $167,000 Total assets Liabilities...

  • Required: 1. Calculate the following six (6) ratios: Current Ratio, Quick Ratio, Receivables Turnover Ratio, Inventory...

    Required: 1. Calculate the following six (6) ratios: Current Ratio, Quick Ratio, Receivables Turnover Ratio, Inventory Turnover Ratio, Profit Margin Ratio and Debt to Assets Ratio. Be sure to show the actual calculation as well as your final answer You are only required to calculate the ratios for 2017, however, for two of the ratios (Receivables Turnover Ratio and Inventory Turnover Ratio), you will need data from 2016 for the formula When calculating the Quick Ratio, please note that Short-Term...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT