Supply chain assi

Background: Days on Hand or Days in Inventory provides a metric for comparison of supply chain operations within the same industry. Days in Inventory represent “the average number of days a company holds its inventory before selling it.” A lower number of days indicates a lower cash investment and less inventory on the floor. Less inventory on the floor results in less floor space needed, less chance for obsolescence, and less chance for damage and theft.

Calculate Days on Hand by dividing the inventory by daily COGS. Annual COGS (Cost Of Goods Sold, Cost of Revenue, or Cost of Sales) is found on the Income Statement, and Inventory is found on the Balance Sheet. Each of these financial documents can be found in the companies’ annual report Form

1

0-K. Look for the “Financial Statements and Supplementary Data” section. (Refer to the section on Measuring Supply Chain Performance in Chapter 11 of the text.)

Improvement in operational efficiency, as indicated by a lower Days on Hand, yields two financial benefits. First, the reduced inventory results in a lower inventory carrying cost. Second, the reduced inventory results in a first-year reduction in expenditures (operations based on already purchased inventory) and, therefore, a positive cash flow impact equivalent to the reduction in inventory.

You cannot just declare a lower inventory level. You can not reduce inventory without reducing the
need
for inventory (i.e., variation in lead time, forecast accuracy, or quality). Reducing inventory without reducing the need results in problems in operations and customer satisfaction.

Assignment: Compare the 2019 Days on Hand results for Nike and Under Armour. You can find the data you need in the annual reports for each of these companies on the internet.

Write an executive summary (use the model provided) detailing the daily Cost of Goods Sold, respective days of inventory for 2019, and the potential financial impact if the under-performing company could match the Days on Hand measure of the higher-performing company (by improving processes so that they would require less inventory to operate). Assume a 25% carrying cost ratio. There is information on how to do these calculations in the example provided.

Be careful to use the correct units for the financial impact. (Financial numbers in Income Statements and Balance Sheets are often in $ millions.) Also, comment on any other noticeable differences in performance or situation. Provide the date for the financial information.

Explain differences in performance (merely stating that a difference in size exists is not adequate).

Submit to D2L a single Word document with a minimum of one page single-spaced, 12 pt font. Your submission should follow the format of the example analysis provided. Use good grammar. Get help if you need it (Grammarly is one option). Use expressive language. Be careful about using the word “very” (what does that mean?) and do not use the word “thing” – not even once. Submit one file with the filename DaysOnHand x.

Grading
: Assignment is worth 45 points as follows:

· Introduction 10 points

· Comparison of the two companies in a manner that gives the reader an understanding of the industry, company sizes, sturctures, sales, and strategies

· Results Table 8 points

· Result Calculations 4 points

· 1 point for each formula (2 formulas) 2 points

· 1 point for each result (2 results) 2 points

· Results Narrative 5 points

· Assessment of results

· Improvement Opportunity 11 points

· Narrative assessment 5 points

· 1 point for each formula (3 formulas) 3 points

· 1 point for each result (3 results) 3 points

· Formatting 2 points

· Style/Grammar 5 points

· 0-1 style/grammar issues 5 points

· 2-3 style/grammar issues 4 points

· 4-5 style/grammar issues 3 points

· 6-7 style/grammar issues 2 points

· 8-9 style/grammar issues 1 point

· >9 style/grammar issues 0 points

1

{Current Date}

Subject: {Company #1} vs. {Company #2} on Hand Analysis

From: {Your Name}

Introduction: {Provide a summary comparison of the two companies, including items such as what business they are in, annual sales, number of stores, number of distribution centers, etc. Include any company strategy differences such as target markets, price points, etc.} – an example is provided below. However, if you use the same words and replace the names and numbers, you will have points deducted. Create your own comparison summary!!!

Dollar General

is a discount retailer with annual sales of $19.23 billion out of approximately 12,575 stores supported by 13 distribution centers.

Dollar Tree

is also a discount retailer (with subsidiaries Dollar Tree Canada and Family Dollar) with $18.54 billion in sales from 13,851 stores supported by 23 distribution centers. Dollar Tree stores are focused on items priced at $1.00. Family Dollar stores are comparable to Dollar General and Fred’s discount stores.

Results: Days in Inventory = Inventory / Daily COGS.

Company	Cost of Revenue (Millions)	Inventory (Millions)	Daily COGS	Days of Inventory
Dollar General	$15,203.96	$3,258.78	41.6547	78.2
Dollar Tree	$14,324.50	$2,865.80	39.2452	73

** It is acceptable to provide a table like the one above with your companies’ data

{Detail your calculations in this section}

Dollar General calculations:

Days of inventory = Inventory / Daily COGS = $3,258.78M / $41.6547M/d = 78.2 days

Dollar Tree calculations:

Days of inventory = Inventory / Daily COGS = $2,865.80M/$39.2452M/d = 73.0 days

{In this section, provide your analysis of the results} – an example is provided below. However, if you use the same words and replace the names, you will have points deducted. Create your own comparison summary!!!

The results are close enough to be believable. Interestingly, the days of inventory numbers favor Dollar Tree, yet the key stats and ratios generally favor Dollar General. I suspect the differences are due to slight differences in the nature of their operations. Even though both companies are in the same industry, Dollar Tree has a different business model in terms of variety and price points than Dollar General.

{In this section, provide your improvement opportunity suggestion} – an example is provided below. You may use the same concept to determine savings.

Improvement opportunity: If Dollar General could achieve the same Days in Inventory as Dollar Tree (same cost of sales, but reduced inventory to support the sales),
DG could reduce their first-year inventory expenses (cash flow) by $218.04 million and reduce their annual inventory carrying cost by $54.51 million,
as shown in the following calculations.

In order to evaluate the improvement opportunity, you must calculate the following:

New Inventory Level = New Days in Inventory X Existing daily COGS = 73 Days X $15,203.96 million / 365 Days = $3,040.79 million.

Reduction in inventory = Old Inventory – New Inventory = $3,258.78 million – $3,070.79 million = $218.04 million.

Annual savings = Inventory reduction x carrying cost rate = $218.04 million X 0.25 = $54.51 million.