# Problems on ABC analysis for inventory control, EOQ

Please see the attached file for full problem description.

TABLE 11.3 DOLLARS OF ADDITIONAL SALES NEEDED TO EQUAL $1 SAVED THROUGH THE SUPPLY CHAIN

PERCENT OF SALES SPENT IN THE SUPPLY CHAIN

PRESENT NET PROFIT OF FIRM 30% 40% 50% 60% 70% 80% 90%

2 $2.78 $3.23 $3.85 $4.76 $6.25 $9.09 $16.67

4 $2.70 $3.13 $3.70 $4.55 $5.88 $8.33 $14.29

6 $2.63 $3.03 $3.57 $4.35 $5.56 $7.69 $12.50

8 $2.56 $2.94 $3.45 $4.17 $5.26 $7.14 $11.11

10 $2.50 $2.86 $3.33 $4.00 $5.00 $6.67 $10.00

Using Table 11.3, determine the sales necessary to equal a dollar of savings oon purchases for a company that has:

a. A net profit of 6% and spends 60% of its revenue on purchases

b. A net profit of 8% and spends 80% of its revenue on purchases.

12.1

George Walker has complied the following table of six items in inventory along with the unit cost and the annual

demand in units

identification code unit cost ($) annual demand in units

XX1 $5.84 1,200

B66 $5.40 1,110

3CPO $1.12 896

33CP $74.54 1,104

R2D2 $2.00 1,100

RMS $2.08 961

Using ABC analysis, which item(s) should be carefully controlled using a quantitative inventory technique

and which item(s) should not be closely controlled?

12.5

William Beville's computer training school, in Richmond, stsocks workbooks with the following characteristics:

Demand D = 19,500 units/year

Ordering cost S = $25/order

Holding cost H = $4/unit/year

a. Calculate the EOQ for the workbooks

b. What are the annual holding costs for the workbooks

c. What are the annual ordering costs

12.13

Joe Henry's machine shop uses 2,500 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away.

the following information is known about the brackets.

annual demand 2,500

holding cost per bracket per year $1.50

order cost per order $18.75

Lead time 2 days

working days per year 250

a. Given the above information, what would be the economic order quanity (EOQ)?

b. Gicen the EOQ, what would be the average inventory? What would be the annual inventory hold cost?

c. Given the EOQ, how many orders would be made each year? What would be the annual order cost?

d. Given the EOQ, what is the total annual inventory cost?

e. What is the time between orders?

f. What is the reorder point (ROP)?

12.19

Cesar Rogo Computers,a Mississippi chain of computer hardware and software retail outlets, supplies both

educational and commercial customers with memory and storage devices. It currently faces the

following order decision related to purchase of DC-ROMs:

D = 36,000 Disks

S = $25

H = $0.45

Purchase price = $0.85

Discount price = $0.82

Quantity needed to qualify for the discount = 6,000 disks

Should the discount be taken?

#### Solution Preview

Please see the attached file for complete answers.

TABLE 11.3 DOLLARS OF ADDITIONAL SALES NEEDED TO EQUAL $1 SAVED THROUGH THE SUPPLY CHAIN

PERCENT OF SALES SPENT IN THE SUPPLY CHAIN

PRESENT NET PROFIT OF FIRM 30% 40% 50% 60% 70% 80% 90%

2 $2.78 $3.23 $3.85 $4.76 $6.25 $9.09 $16.67

4 $2.70 $3.13 $3.70 $4.55 $5.88 $8.33 $14.29

6 $2.63 $3.03 $3.57 $4.35 $5.56 $7.69 $12.50

8 $2.56 $2.94 $3.45 $4.17 $5.26 $7.14 $11.11

10 $2.50 $2.86 $3.33 $4.00 $5.00 $6.67 $10.00

Using Table 11.3, determine the sales necessary to equal a dollar of savings oon purchases for a company that has:

a. A net profit of 6% and spends 60% of its revenue on purchases $4.35 (See table above)

b. A net profit of 8% and spends 80% of its revenue on purchases. $7.14 (See table above)

12.1

George Walker has complied the following table of six items in inventory along with the unit cost and the annual

demand in units

identification code unit cost ($) annual demand in units

XX1 $5.84 1,200

B66 $5.40 1,110

3CPO $1.12 896

33CP $74.54 1,104

R2D2 $2.00 1,100

RMS $2.08 961

Using ABC analysis, which item(s) should be carefully controlled using a quantitative inventory technique

and which item(s) should not be closely controlled?

identification code unit cost ($) annual demand in units annual demand in $ % of Total $ Volume Rank

XX1 $5.84 1,200 $7,008.00 6.97% 2

B66 $5.40 1,110 $5,994.00 5.96% 3

3CPO $1.12 896 $1,003.52 1.00% 6

33CP $74.54 1,104 ...

#### Solution Summary

Four problems on Supply Chain, ABC analysis for inventory control, EOQ (Economic Order Quantity).