Which of the following formulas is able to help you calculate the unit price of the remaining items, based on the corresponding year and product, to obtain the same value as shown in cells K4:K12?

Munabhai

Given scenario A hospital is administering a polio vaccine (“polio drops”) to children under the age of 5 in Mexico. It costs the hospital $2 to purchase one shot, and they charge $3 for administering it to a child. Unused vaccines are destroyed. The hospital management needs to decide the number of vaccines to be ordered. Since the hospital has been administering these shots for the last 6 years (24 quarters), they have been able to compile the demand for the vaccine. Determine the optimal service level and optimal order quantity, for the vaccine. Quarter Demand 1 15 2 18 3 21 4 15 5 17 6 22 7 20 8 16 9 22 10 18 11 25 12 15 13 26 14 29 15 16 16 30 17 17 18 25 19 18 20 16 21 19 22 23 23 20 24 15

Algro Inc. keeps a wide range of parts and materials on hand for use in its production processes. Management has recently had difficulty managing parts inventory as demand for its finished goods has increased; they frequently run out of some critical parts while having an endless supply of others. They would like to classify their parts inventory according to the ABC approach to better control inventory. The following is a list of parts, along with their annual usage and unit value: Item Annual Unit Item Annual Unit Number Usage Cost Number Usage Cost 1 36 $350 2 510 30 3 50 23 4 300 45 5 18 1900 6 500 8 7 710 4 8 80 26 9 344 28 10 67 440 11 510 2 12 682 35 13 1216 95 50 14 10 3 15 820 1 KARAN2222222222 16 60 $610 17 120 20 18 270 15 19 45 50 20 19 3200 21 910 3 12 4750 23 30 2710 24 24 1800 25 870 105 26 244 30 27 750 15 28 45 110 29 46 160 30 165 25 a. Classify the inventory items according to the ABC approach using the dollar value of annual demand. b. Clearly explain why you…