Alison's Accessories is a high volume worldwide fashion house with outlets in 65 countries. Sadly, space does not permit an exhaustive list but once the test is over, check out their website. Kalil, the supply chain manager is conducting her usual thorough analysis of her final four candidates for supplier and has developed the following tables of pertinent costs and other shipping metrics. Regardless of supplier, Alison's Accessories will operate 220 days per year and has forecast annual demand of 250,000 units. Kalil has obtained quotes for three different shipment sizes (Freight Costs table). All costs are in US Dollars.
(Please Show Formula not excel)