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
1. Calculate the annual stock turnover rate based on the following monthly sales and inventory figures....
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....