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
  • Esquire Products Inc. expects the following monthly sales: January February March April May June $ 38,000...

    Esquire Products Inc. expects the following monthly sales: January February March April May June $ 38,000 July 29,000 August 22,000 September 24,000 October 18.ee November 16,eee December Total sales = $384,cee $ 32,000 36,000 39,000 44,000 52,00 34, eee Cash sales are 40 percent in a given month, with the remainder going into accounts receivable. All receivables are collected in the month following the sale. Esquire sells all of its goods for $2 each and produces them for $1 each....

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