Mini-Case Problem #2: Categorizing leatory at PSC Note: If you would like to use Excel for riis problem, please less. If you choose this option please make sure to submir an Excel file so I casi see your formules and soft place your wers in the land dormear as well PSC designs and produces a variety of laser bar code scanning devices. The products include handheld bar code readers, high-speed fixed-position industrial scanner and retail checkout Scanners as well as a full line of cossories, software and supplies to support its products Headquntered in Eugene, Oregon, the company has manufacturing facilities in Eugene and Paris, France, with roughly 1.200 employees worldwide. Bar code scanners are designed for a vanety of situations that can move long-tige scanning reading small bar codes, and performing high-speed scans. They were med extensisely in industry business, and government to manage and control the entire supply cham, which includes suppliers, production, warehousing distribution, retail sales and service Examples of bar code readers include the familiar point-of-sale scanners encountered at supermarkets and other retail stores They come in a variety of formas ning from handheld to built-in models High-speed, attended scanners are used for automated material handling and sorting Typical installations include high-volume distribution centers such as JC Penney's eatalos operation and airport baggage handling system. We of bar code readers bas greatly increased the speed and accuracy of data collection, resulting in increased productivity improved production and in catory tracking and control and improved market information The company uses a variety of methods for inventory manageriat, ad it attempts to minimize the amount of inventory. A computer determines component requirements and generates purchase orders for the components for each order, and then appropriate orders for various components from vendors are prepared. However, the company maintains a stock of standard components that are replenished sine a reorder point system. The cost of capital Ge holding cost percentage) - 20% for items H1.000-6.000,25% for stems TS-000-TS-999, 30% for items PL-000-P5-000, 35% for items V1-100-V1-999 and 40% for items P9-000-P12-000. The company has adopted point of-use replenishment for some areas of operations, having deliveries come directly to the production floor. Finished products are inediately shipped to the customer, which chances the company's delivery perfomance and avonds fittished goods investory Linated Ordering Unit Ahmad 2000 250 400 90 28.50 6461 12.00 7.90 4750 90 7500 22.00 TS 300 6.00 TS-400 40.00 TS- 30 2010 40 22 BADM 567 MM: PROCESS MANAGEMENT - MINI CASE PROBLEM SET #3 Using the data above and the information from the case, please do the following: 1.Perform an ABC Inventory classification analysis on the system above. The company has set the following policy for classification: A itens should represent between 70-73% of the anal dollar value: items should represent between 16 -18% of the manual dollar value items should represent 9-12% of the annual dollar vahe. (Round your percentages the 2 decimal places) 2.) Determine the EOQ (using the basic EOQ model for each item (Round your answers the nearest whole unit) 3.) Using your answers from land #2. please explains how the company should go about managing its inventory Ge which inventory should be tracked more ordered more, conted more prioritize, and e)