basic problem that can be seen in (MRP) Material requirement planning

basic problem that can be seen in (MRP) Material requirement planning Exercise 2 Material Requirement Planning for each part and Sub-Assembly a. It has been done in the attached excel sheet. b.Problems The basic problem that can be seen in MRP is the decision that the company should take with respect to procuring a sub-assembly directly or manufacturing it by using the raw materials. It has been seen that even though the lead time of the raw material like rubber face is 10 weeks, it is economical to manufacture the product through it. This is because, there has been enough time given before the first set of demand is predicted by the company. Hence, it is useless for the company in both cases to procure handle assembly or face assembly directly. The standard cost of manufacturing with the given lead times has cost it lesser. Also, one has to keep track of availability of all the materials so that the final product can be manufactured. Hence, maintaining unnecessary inventory to the maximum is the biggest challenge in this entire MRP design. No te: As procuring handle assembly directly costs more than making it through raw materials, hence handle assembly has been made with raw materials taking appropriate lead time and EOQ into account.ÂÂ   The same concept has been used for face assembly as well in the MRP. c. Alternatives For any further problem that the company identifies, it is appropriate that it is able to analyse the costs of all the sub-parts and sub-assemblies even before the actual forecasting is done. This would not put on into a dilemma as to how to approach the same. Also, the company has given the starting week of sales from week 13 which is far too late. MRP should be done on a closer basis so that none of the days get wasted. Here, we can see that none of the sub-parts required the first or second week of work. At the same time, one has to maintain least possible inventory. Exercise 3 It has been done in the attached excel sheet Exercise 4 It is certain that the average inventory value of the co mpany would increase with the imposition of safety lead time. The reason for the same is that initially it had been planned that while justifying the lead time of all the sub-parts, one would endeavour for least possible inventory. In all the cases, zero-inventory has been maintained over the exercise except for those occasions where there was initial inventory on week 1 itself. Even this has been used judicially so that the company is not left with the inventory once the sales proceeds as predicted by the company management of Psycho Sports. Hence, efficiency on this ground is certain to decrease this way hence raining the average inventory. Also, it is important to note here that while the safety lead time had been imposed, a number of sub-parts where procured to be remained in inventory without having any processing done. This also raises the cost of inventory for the company. But as it brings safety, there is lesser amount of risk involved in keeping the same. The exact values o f the same have been shown in the attached excel sheet. This safety lead time only decreases the dependency on the sales department of the company on achieving the exact sales in the week specified.