(Solved): ANSWER PLEASE WHILE SHOWING THE EXCEL FORMULAS FOR ALLSECTIONS. .12 An allergy and asthma specialist ...

.12 An allergy and asthma specialist group practice orders various allergy testing and im- munotherapy supplies from a national supplier. An order quantity of fifty items has been set based on the past three years of usage. Table EX 11.12 displays demand and cost information for select inventory items. EXERCISES 391 Table EX 11.12 Item No. Weekly Demand 80 Annual Carrying Cost ($) 10% 1 2 14 Unit Cost ($) $1.15 $2.20 $0.50 $1.75 8% 65 16% 3 4 5 36 7% 28 $0.99 12% 20% 5 6 Ordering Cost (5) $5.00 $3.00 $14.00 $11.00 $ 8.00 $20.00 $18.00 $15.00 $4.00 $6.00 $10.00 $3.00 22 9% 7 15% 8 480 $7.50 $2.35 $0.85 $1.00 $3.80 $1.95 $ 0.60 12% ON 9 50 14% 10 7 22% 11 26 6% 12 21 a. Classify these inventory items according to an A-B-C analysis. b. Determine the economic order quantity for each item. Calculate the total annual inventory management cost for all items. d. Calculate the investment cost for each item. c.