Question: how do you use the ABC anayslis with this data: Item No . Annual Demand ( D ) Item Price Annual Carrying Rate ( H

how do you use the ABC anayslis with this data: Item No. Annual Demand (D) Item Price Annual Carrying Rate (H) Ordering Cost (S) Item Carrying Cost EOQ Average Inventory (Annual demand/EOQ) Total Annual Inventory Cost =(Avg Inventory*Holding cost)+(order costs*Annual demand/EOQ)
1104 $2,225.000.12 $6.00267 $101.981.026.24
2260 $5,000.000.1 $5.00500161.251.61 $8.22
3728 $3,550.000.08 $12.00284467.331.56 $18.82
41248 $1,205.000.12 $28.00145763.151.64 $45.99
5104 $11,100.000.02 $18.00222432.670.24 $4.33
61040 $1,500.000.2 $32.00300576.891.80 $58.05
7780 $1,900.000.11 $50.00209842.080.93 $46.42
8884 $3,700.000.09 $12.00333485.521.82 $22.01
9780 $6,400.000.02 $35.001281652.270.47 $16.53
10520 $2,700.000.05 $12.00135499.601.04 $12.54

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!