Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started