Excel if possible please

Problem 3 Using the following information, calculate the inventory carrying cost percentage. Finished goods inventory is $65 million at full manufactured cost. Variable manufactured cost of inventory is 75% of full manufactured cost. Variable transportation cost was $3.7 million. Variable warehousing cost to move inventory into storage was $500,000. The company was experiencing capital rationing and required that new investments earn at least 8% before taxes. Insurance coverage to protect against loss of inventory was $50,000. Storage charges at public warehouses totaled $750,000. Obsolescence was $150,000. Theft of inventory was $55,000. Damage related to inventory storage was $25,000. Transportation cost of cross-shipping inventory to avoid obsolescence was $65,000. Problem 4 A company warehouses numerous products and is interested in determining appropriate levels of inventory for each product. Perform an ABC analysis on the following products to determine Dollar average inventory for each item, and Total dollar average inventory for each item and the warehouse. A items Bitems C items top 22%, need inventory turn of 7 next 37%, need inventory turn of 5 remaining items need inventory turn of 2 Product # A B C D E F G H 1 Number of units 772,108 2,200,508 7,721 231,632 77,211 540,475 386,054 303,439 433,569 463,265 19,302 3,243 77,211 132,089,850 115,816,190 27,444 39,496 11,582 253,500,299 Item Sales $3,286,528.13 $4,676,729.60 $5,455.02 $197,192.16 $98,595.38 $657,305.35 $2,300,570.11 $477,861.83 $492,979.71 $638,901.10 $542,276.70 $427,906.45 $1,643,264.76 $90,015.46 $640,873.48 $230,057.29 $36,020.66 $49,100.73 $16,491,633.92 J K L M N 0 P Q R Total