Question

In: Operations Management

Given the following inventory information… Item number Unit cost Annual usage in units Current inventory in...

Given the following inventory information…

Item number

Unit cost

Annual usage in units

Current inventory in units

B8867

10

100

4500

J1252

5.25

6500

120

K9667

1.22

4000

1000

L2425

12.5

54

254

M4554

5.25

6500

120

T6334

70

500

800

W9856

.75

800

20000

X2215

1.5

8000

2000

Y3214

70

1000

500

Y6339

4

3500

125

which of the following items is not classified as C items by annual dollar usage?

Which is not classified as C items by current inventory value (dollars)?

Which of the following items is an overstocking item?

Which of the following items is an understocking item?

Solutions

Expert Solution


Related Solutions

An annual demand for an item is 500 units, ordering cost is 8 $, inventory carrying...
An annual demand for an item is 500 units, ordering cost is 8 $, inventory carrying interest is 20% of the purchase price per year. Purchase prices are as follows as proposed by the vendor/supplier; where the value of unit cost=10 without any discount? Discount 0% 000≤Q<300    Discount 2% 300≤Q<450 Discount 3% 450≤Q
An annual demand for an item is 500 units, ordering cost is 8 $, inventory carrying...
An annual demand for an item is 500 units, ordering cost is 8 $, inventory carrying interest is 20% of the purchase price per year. Purchase prices are as follows as proposed by the vendor/supplier; where the value of unit cost=10 without any discount? Discount 0% 000≤Q<300    Discount 2% 300≤Q<450 Discount 3% 450≤Q a) for inventory model with no discount====================================================================== a1) The economic order quantity = [EOQ] units a2) The total ordering costs = [TOC] $ a3) The total...
Perform ABC analysis for the following products: Item Volume (units/ year) Cost ($/unit) Annual $ Volume...
Perform ABC analysis for the following products: Item Volume (units/ year) Cost ($/unit) Annual $ Volume A 700 1 700 B 70 15 1050 C 965 4 3860 D 514 5 2570 E 20 15 300 F 770 32 24640 G 608 29 17632 H 513 2 1026 I 578 10 5780 J 199 2 398 57956 please, try to explain how can get the answer without used excel
Inventory records for a company revealed the following: Date Transaction Number of Units Unit Cost Apr....
Inventory records for a company revealed the following: Date Transaction Number of Units Unit Cost Apr. 1 Beginning inventory 500 $2.40 Apr. 20 Purchase 400 $2.50 The company sold 700 units of inventory during the month. Cost of goods sold assuming FIFO would be: a. $1,690 b. $1,720. c. $1,700. d. $1,730. e. $1,710. If management can estimate the amount of loss that will occur due to litigation against the company, and the likelihood of the loss is reasonably possible,...
The Wright Company recorded the following inventory information during the month of October: UNITS UNIT COST...
The Wright Company recorded the following inventory information during the month of October: UNITS UNIT COST TOTAL COST UNITS ON HAND Balance on October 1 2,000 $1.00 $2,000 2,000 Purchased on October 8 1,200 $3.00 $3,600 3,200 Sold on October 20 1,500 1,700 Purchased on October 22 2,000 $4.00 $8,000 3,700 Sold on October 28 2,200 1,500 Purchase on October 29 1,000 $5.00 $5,000 2,500 Part B: Using the partially computed tables on the next three pages, compute the cost...
Consider the following information on an inventory management system:             Item Cost:                 &nbsp
Consider the following information on an inventory management system:             Item Cost:                                $10             Order Cost:                              $250             Annual Holding Cost:              33% of item cost             Annual Demand:                     25,750             Average Demand:                   515 per week             Std. Dev. of Demand:              125 per week             Leadtime:                                2 weeks          1. Ignoring the uncertainty in the demand (i.e. looking only at average values), find the optimal order quantity and the reorder point. What is the annual inventory holding and ordering cost for this...
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar....
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar. 1 Beginning inventory 960 $7.15 Mar. 10 Purchase 540 7.65 Mar. 16 Purchase 395 8.25 Mar. 23 Purchase 530 8.95 Marvin sold 1,790 units of inventory during the month. Ending inventory assuming FIFO would be (Do not round your intermediate calculations. Round your answer to the nearest dollar amount): $5,610 $1,156 $6,864 $1,541
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar....
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar. 1 Beginning inventory 1,000 $ 7.26 Mar. 10 Purchase 540 7.71 Mar. 16 Purchase 760 8.14 Mar. 23 Purchase 590 8.54 Marvin sold 1,910 units of inventory during the month. Cost of goods sold assuming FIFO would be:
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost   Mar....
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost   Mar. 1 Beginning inventory 1,070    $7.29      Mar. 10 Purchase 580    7.79      Mar. 16 Purchase 445    8.39      Mar. 23 Purchase 550    9.09    Marvin sold 1,960 units of inventory during the month. Ending inventory assuming FIFO would be
37. Inventory records for MOM Company revealed the following: Date Transaction Number of Units Unit Cost...
37. Inventory records for MOM Company revealed the following: Date Transaction Number of Units Unit Cost Mar. 1 Beginning inventory 200 $66.00 Mar. 6 Purchase 1,000 $66.50 Mar. 16 Purchase 1,000 $66.80 Mar. 23 Purchase 1,000 $66.90 MOM sold 3,190 units of inventory during the month. Ending inventory assuming FIFO would be $______________ 38. Inventory records for STC Company revealed the following: Date Transaction Number of Units Unit Cost Mar. 1 Beginning inventory 100 $25.00 Mar. 3 Purchase 500 $25.50...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT