Global Supply Chain Management
Using the DuPont Model
Conduct research to populate an excel spreadsheet(s) of the DuPont model for these three situations:
According to the data from excel spreadsheets to answer these three questions (analyze the data and answer the question),
- For one company, compare the most currently reported year with a previous year (up to 5 years previous). Comment on all the differences you find. What could have caused them?
- For two companies that compete in the same product/market segment(s), compare one to the other on one spreadsheet. Comment on the differences you find. Why do you think they are they different? (same company can compare)
- For one company (you can make this one and the data up), use the spreadsheet to illustrate the before and after effects of a year-long Supply Chain Management (SCM)/logistics project you will lead to improve ROA. Make it realistic. Describe what you did and the changes reflected by the DuPont model. (make the numbers up, and make it looks good it should be positive not negative. Make profit) (you may make a story to explain it.)
Note: I am looking for how did you analyze the date and your proper explanation
- talk about the sales, net profits, % different, cash flow and so on.
- the key of tactics how the company make profits
- watch out the leverage, the leverage 3-4 is fine, 6 is risky
- does the company make profit or not?
You can google for annual reports or 10K forms from specific companies. You might also look at:
The report should include a printed spreadsheet and your written, double-spaced comments for each of these three situations.
