January 2018
Intermediate to advanced
480 pages
236h 9m
English
The data from the table are as follows. Cost of Goods Sold = $10,000,000. Weeks of Operation = 52. Raw materials.
Item Number | Average Level | Unit Value | Total Value |
1 | 1,400 | $50 | $70,000 |
2 | 1,000 | $32 | $32,000 |
3 | 400 | $60 | $24,000 |
4 | 2,400 | $10 | $24,000 |
5 | 800 | $15 | $12,000 |
Work in process.
Item Number | Average Level | Unit Value | Total Value |
6 | 320 | $700 | $224,000 |
7 | 160 | $900 | $144,000 |
8 | 280 | $750 | $210,000 |
9 | 240 | $850 | $192,000 |
10 | 400 | $1,000 | $400,00 |
Finished goods.
Item Number | Average Level | Unit Value | Total Value |
11 | 60 | $2,000.00 | $120,000 |
12 | 40 | $3,500.00 | $140,000 |
13 | 50 | $2,800.00 | $140,000 |
14 | 20 | $5,000.00 | $100,000 |
15 | 40 | $4,200.00 | $168,000 |
Total = $2,000,000. Average Weekly Sales at Cost = $192,308. Weeks of Supply = 10.4. Inventory Turnover = 5.0.