What would be your observation and action plan

Assignment Help Supply Chain Management
Reference no: EM131361455

Your manager calls you with a concern regarding the European inventory. There are two KPI's which are regularly reviewed: 1.) Total inventory in KG and USD by plant and 2.) desDays Of Sale. Both KPI's show increased values versus prior year end and versus the same period last year. You know one of the reasons for the increase in inventory is the manufacturing insourcing project, but there are many other factors that influence the monthly inventory & DOS values like forecast accuracy, manufacturing lot sizes, safety stock, and so on.

The question he asks you is:

"Can you can come up with an action plan to reduce the inventory towards year end? But please ensure that we do not jeopardize our SIFOT service commitment of 97%"

A colleague has brought up the idea to split the inventory in the following buckets:

  • Blocked stock,
  • Safety stock,
  • Batch size related stock,
  • excess and obsolete and
  • Other inventory.

You like his idea and think it would really help you both in your daily stock management and to define a list of possible actions to achieve a healthy inventory reduction by year end. You believe you can quickly build some sort of report based on existing data.

Question 1

Please describe in sufficient detail which tools and data you would use to prepare this analysis and how you would construct it. The analysis should give you an aggregated overview of the inventory by plant / region. The analysis needs to contain a graphical representation of the inventory split and the tool you build / analysis you do should be reusable.

After accepting the 'split inventory proposal' from a colleague I realized some steps (possible actions) in an effort to reduce the overall total inventory in Europe are as follows:

1. Obsolete inventory portion will need to be taken out. It needs to be written off/disposed since material doesn't have an outlet (cannot be recertified any longer due to reaching the end of its life cycle completely).

2. Since blocked stock refers to material that shows on hand, but cannot be accounted for (e.g. residual percentage/qty in tanks/tankers/silos; 3 to 5% of any given bulk material stored in tanks should be subtracted for inventory accuracy, resulting in a fixed reduction percentage in the overall inventory total.

3. Recalculation of safety stocks every quarter, so that it can be up to date fully aligned with the current demand based and DOS variation.

4. J.I.T.  Implementation not only on semi-finished goods (that cannot be kept in stock), but on medium to low rotation materials (products type B and C). This will definitely produce immediate impact on total inventory reduction, minimizing the supply risk for high rotation materials (products type A) due to stocking priority being given to these.

5. Aged Material Purchasing Rule: implementation of a tool that flags any aged material against any purchase order placed in order to avoid material duplication/excess and overall total inventory increase.

Question 2

a. If the DOS = 30 days for both plants, what would be your observation and action plan?

b. If the DOS = 80 days for both plants, would your observation and action plan be different?

Attachment:- Assignment.rar

Reference no: EM131361455

Questions Cloud

Calculate the following for this system : Calculate the following for this system in terms of T, V, N
Describe and examining your familys connections : Describing and examining your family's connections to farming / agriculture - Provide evidence, experience or both to the connections and Connect (explicate) to the larger historical discourse/conversation surrounding the farm.
Confidence interval for the proportion of games : There were 2430 Major League Baseball (MLB) games played in 2009, and the home team won in 54.9% of the games.1 If we consider the games played in 2009 as a sample of all MLB games, find a 95% confidence interval for the proportion of games the h..
Find a confidence interval for a proportion : Use the normal distribution to find a confidence interval for a proportion  P given the relevant sample results. Give the best point estimate for P, the margin of error, and the confidence interval. Assume the results come from a random sample.
What would be your observation and action plan : If the DOS = 30 days for both plants, what would be your observation and action plan? If the DOS = 80 days for both plants, would your observation and action plan be different
Determine annas basket weaving studio should carry basic kit : Determine whether Anna's basket weaving studio should carry the basic introductory kit with undyed and uncut reeds or the Stage 2 kit with reeds already dyed and cut. Prepare an incremental analysis to support your answer.
Give the answer of muliple choice question : One of the results of the 2005 Hurricanes Katrina and Rita in Louisiana has been an increase in the influx of Spanish-speaking workers. Incorporating cultural and linguistic competence to meet the health needs of this population would include.A me..
How many different states are accessible to system a : System A contains one particle, x. System B contains two particles, y and z. The three particles are distinguishable. Each of these systems has the same two accessible single-particle states.
Proximal goals and long-term goals of evaluation research : What are the differences between proximal goals and long-term goals of evaluation research? Provide one example for each that is related to human services research.

Reviews

len1361455

1/20/2017 2:31:51 AM

Please check and get back with confirmation. I need to create a model in excel. Please describe in sufficient detail which tools and data you would use to prepare this analysis and how you would construct it. The analysis should give you an aggregated overview of the inventory by plant / region. The analysis needs to contain a graphical representation of the inventory split and the tool you build / analysis you do should be reusable.

Write a Review

Supply Chain Management Questions & Answers

  Supply chain network design for cwc

This assignment explain the supply chain management process of cwc. What is the current annual supply chain cost?

  Criteria when making new location decisions

Identify a number of the typical criteria used when making new location decisions

  Draw the project network

Determine the mean critical path for Brent's job search process. What is the variance of the project duration?

  Compare and contrast economic - market, and relevancy

Please compare and contrast economic, market, and relevancy value.

  Brushing up on inventory control

Health system in Pennsylvania

  Supply chain strategy

Supply chain strategy

  What is the economic order quantity for fans in units

Nittany Fans of Lewistown, Pennsylvania, is a distributor of industrial fans used in plants, warehouses, and other industrial facilities.

  What factors reduce the capacity of the organization

What factors reduce the capacity of the organization to get its objectives?

  What is the total annual cost

What is the total annual cost

  Supply chain management questions

Briefly define the following two supply chain metrics: (i) inventory turnover ratio and (ii) supply chain velocity.

  Explain the supply chain management concept

Explain the supply chain management concept, Differentiate between public and private sector organisations in terms of their supply chain objectives and strategies

  How warehouses can add value in the supply chain

How warehouses can add value in the supply chain

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd