3. Below are the details of the inventory of a store dealing with automobile spare parts.Using the concepts of ABC analysis, categorize the spare parts into A, B, and C categories. (If required, you may have assumptions, but do mention them in your answer.)

Sno.	Item	Unit Cost (Rs)	Annual Usage
1	Oil Filter	2200	150
2	Head Lamp	395	140
3	Ful Filter	270	95
4	Rod Bearing	1430	45
5	Air Filter	860	120
6	Wind Screen	12000	90
7	Piston Rink	4500	250
8	Bumper	8000	110
9	Main Bearing	1130	120
10	Bush	169	1160

4. Here is the dataof Tata Motors and Ashok Leyland. Compare the year-wise performance of these two companies based on the techniques covered in SCM. Also, please state which company is doing better and why.

5.Here is the data on passenger traffic of a very busy international airport. Using MS Excel build-in Forecast Sheet, forecast for next 5 years for domestic and international passenger traffic.Share insights on your forecast.

6. Demand for the Carrom Board at a sports shop is 500 units per month. This shop incurs a fixed order placement, transportation, and receiving cost of Rs. 4,000 each time an order is placed. Each carrom board costs Rs. 500 and has a holding cost of 20 percent. Evaluate the number of carrom boards that the store manager should order in each replenishment lot. Secondly, also calculate thetotal cost for EOQ.