NEED RESULTS IN EXCELL

AWN Determine the picking sequence for the following set of products. Product Lbs/box Demand/Year 1 15 lbs 50,000 boxes 2 5 lbs 150,000 boxes 3 10 lbs 70,000 boxes . 4 12 lbs 30,000 boxes 5 3 lbs 210,000 boxes 6 7 lbs 80,000 boxes 7 8 lbs 30,000 boxes 8 13 lbs 40,000 boxes 9 10 lbs 80,000 boxes 10 11 lbs 50,000 boxes Determine the handling cost if the labor cost is $.0315 per feet. Each rack as a three level high and the pallet deep is 4'. Also determine the storage utilization. Annual Pallets 32 AA B C C A-1200 B-600 C-2000 10 30 AC to Rotation 42 B 50 This exercise has a value of (10 points)