Long description
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.
Get Operations Management: Processes and Supply Chains, 12th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
