Jorge, the owner of a hardware store was wondering if he could manage the inventory better....

Jorge, the owner of a hardware store was wondering if he could manage the inventory better. He has decided to develop an ABC classification system to help manage the inventory. The company's inventory consists of the following items:

Item	Cost	Quarterly Demand (units)
Shovel	$ 5.00	1,000
Edger	$25.00	6
Weeder	$ 6.00	400
Hose	$20.00	800
Cutters	$ 4.00	100
Sprinkler	$ 7.00	800
Hedge Trimmer	$ 5.00	5,000
Spreader	$15.00	6
Sprayer	$12.00	20
Clippers	$ 8.00	15

a.	Compute the total dollar value of each of the ten inventory items. What is the total value of all the inventory items?
b.	Which items should be declared "A" items? What percentage of total inventory value does the "A" group represent? What percentage of the total number of inventory items does the "A" group represent?
c.	Which items should be declared "B" items? What percentage of the total inventory value does "B" group represent? What percentage of the total number of inventory items does the "B" group represent?
d.	Which items should be declared "C" items? What percentage of the total inventory value does the "C" group represent? What percentage of the total number of inventory items does the "C" group represent?

Solutions

Expert Solution

a) The total dollar value of each inventory item is as shown below:

Item	Cost ($)	Demand	Value (Cost x Demand)	% of total value
Shovel	5	1000	5000	9.09%
Edger	25	6	150	0.27%
Weeder	6	400	2400	4.36%
Hose	20	800	16000	29.09%
Cutters	4	100	400	0.73%
Sprinkler	7	800	5600	10.18%
Hedge T	5	5000	25000	45.45%
Spreader	15	6	90	0.16%
Sprayer	12	20	240	0.44%
Clippers	8	15	120	0.22%
			55000	100.00%

Total value of all inventory items is $55000.

b) Hose and Hedge Trimmer are A category items.

Percentage of total inventory value of "A" group = 29.09% + 45.45% = 74.54%

Percentage of the total number of inventory items does the "A" group = 2/10 x 100 = 20%

c) Shovel, Weeder and Sprinkler are B category items.

Percentage of total inventory value of "B" group = 9.09% + 4.36% + 10.18% = 23.63%

Percentage of the total number of inventory items does the "B" group = 3/10 x 100 = 30%

d) Edger, Cutters, Spreader, Sprayer and Clippers are C category items.

Percentage of total inventory value of "C" group = 0.27% + 0.73% + 0.16% + 0.44% + 0.22% = 1.82%

Percentage of the total number of inventory items does the "C" group = 5/10 x 100 = 50%

keosha answered 1 year ago

Next > < Previous

Related Solutions

Question 1 Khalil is the owner and manager of a hardware store. He sells on average...

Question 1 Khalil is the owner and manager of a hardware store. He sells on average 50 industrial hammers per month. He places an order to buy 50 hammers from a wholesaler at a cost of 20 OMR per unit at the end of each month. However, Khalil orders everything himself and finds that it takes a long time. He estimates that the value of his time spent placing each order is 75 OMR. a. What should be the unit...

Question 1 Khalil is the owner and manager of a hardware store. He sells on average...

Edit question Suppose in an effort to manage his inventory levels better, the owner of two...

Edit question Suppose in an effort to manage his inventory levels better, the owner of two steak and seafood restaurants, both located in the same city, hires a statistician to conduct a statistical study. The owner is interested in whether the restaurant located on the south side sells more halibut fillets per night than the restaurant located on the north side of the city. The statistician selects a random sample of 102 nights that the south-side restaurant is open. The...

Jorge contributed land he held as an investment (fair market value $117,000; basis $58,750) and inventory...

Jorge contributed land he held as an investment (fair market value $117,000; basis $58,750) and inventory (fair market value $72,500; basis $57,750) to ABC Corporation in exchange for 50 percent of the ABC stock (30 shares valued at $114,000) and $75,500 cash in a qualifying §351 exchange. (Do not round intermediate calculations. Round your final answers to the nearest dollar amount.) a-1. What amount of gain does Jorge recognize on the exchange? a-2. What is the character of the gain?...

Jorge contributed land he held as an investment (fair market value $127,000; basis $79,750) and inventory...

Jorge contributed land he held as an investment (fair market value $127,000; basis $79,750) and inventory (fair market value $111,000; basis $104,000) to ABC Corporation in exchange for 50 percent of the ABC stock (52 shares valued at $205,140) and $32,860 cash in a qualifying §351 exchange. (Negative amounts should be indicated by a minus sign. Leave no answer blank. Enter zero if applicable.) a-1. What amount of gain does Jorge recognize on the exchange? a-2. What is the character...

Larry’s Building Supplies (LBS) is a local hardware store. LBS uses a perpetual inventory system. The...

Larry’s Building Supplies (LBS) is a local hardware store. LBS uses a perpetual inventory system. The following transactions (summarized) have been selected for analysis: a. Sold merchandise for cash (cost of merchandise $345,350). $ 725,000 b. Received merchandise returned by customers as unsatisfactory (but in perfect condition) for cash refund (original cost of merchandise $4,900). 7,500 c. Sold merchandise (costing $10,200) to a customer on account with terms n/30. 17,000 d. Collected half of the balance owed by the customer...

Larry’s Building Supplies (LBS) is a local hardware store. LBS uses a perpetual inventory system. The...

Larry’s Building Supplies (LBS) is a local hardware store. LBS uses a perpetual inventory system. The following transactions (summarized) have been selected for analysis: a. Sold merchandise for cash (cost of merchandise $313,350). $ 665,000 b. Received merchandise returned by customers as unsatisfactory (but in perfect condition) for cash refund (original cost of merchandise $4,100). 6,300 c. Sold merchandise (costing $8,280) to a customer on account with terms 2/10, n/30. 13,800 d. Collected half of the balance owed by the...

Development Strategies Lucas is a proud owner of a small grocery store wherein he keeps track...

Development Strategies Lucas is a proud owner of a small grocery store wherein he keeps track of his business transactions and records on his own personal computer. Using his knowledge, he was able to create a database to keep track of the inventory which is manually updated. Using his self-devised system, he was able to track expenses and do the payroll for his employees. The business itself has grown out of proportion and Lucas decided to install a software to...

Larry’s Building Supplies (LBS) is a local hardware store. LBS uses a perpetual inventory system. The following transactions (summarized) have been selected for analysis:

Larry’s Building Supplies (LBS) is a local hardware store. LBS uses a perpetual inventory system. The following transactions (summarized) have been selected for analysis: a. Sold merchandise for cash (cost of merchandise $337,350). $ 710,000 b. Received merchandise returned by customers as unsatisfactory (but in perfect condition) for cash refund (original cost of merchandise $4,700). 7,200 c. Sold merchandise (costing $9,720) to a customer on account with terms n/30. 16,200 d. Collected half of...

Larry’s Building Supplies (LBS) is a local hardware store. LBS uses a perpetual inventory system. The following transactions (summarized) have been selected for analysis:

Larry’s Building Supplies (LBS) is a local hardware store. LBS uses a perpetual inventory system. The following transactions (summarized) have been selected for analysis: a. Sold merchandise for cash (cost of merchandise $361,350). $ 755,000 b. Received merchandise returned by customers as unsatisfactory (but in perfect condition) for cash refund (original cost of merchandise $5,300). 8,100 c. Sold merchandise (costing $11,160) to a customer on account with terms n/30. 18,600 d. Collected half of...

Subjects