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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.