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

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...
Coopers Company reported the following information: Units Unit Cost Units Sold Jan 1 Beginning inventory 190...
Coopers Company reported the following information: Units Unit Cost Units Sold Jan 1 Beginning inventory 190 $50 Mar 8 Sale 100 Apr 10 Purchase 320 55 Jun 20 Sale 240 Oct 10 Purchase 570 60 Nov 30 Sale 450 Total Selling price per unit during the year: $75    790 Required Complete the following table. Cost Total Periodic Perpetual Date Purchased per Unit Cost Sold FIFO Weighted Average Units $ $ Units Units $ $ Units $ $
Given the following: Number purchased Cost per unit Total January 1 inventory 40 $ 4 $...
Given the following: Number purchased Cost per unit Total January 1 inventory 40 $ 4 $ 160 April 1 60 7 420 June 1 50 8 400 November 1 55 9 495 205 $ 1,475 a. Calculate the cost of ending inventory using the LIFO (ending inventory shows 61 units). Cost of ending inventory            $ b. Calculate the cost of goods sold using the LIFO (ending inventory shows 61 units). Cost of goods sold            $
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT