Part I: Supply Chain Performance Consider a firm with an annual net income of $20 million,...
Part I: Supply Chain Performance
Consider a firm with an annual net income of $20 million, revenue of $60 million and cost of goods sold of $25 million. If the balance sheet amounts show $2 million of inventory and $500,000 of property, plant & equipment.
a) What is the inventory turnover?
b) How many weeks of supply does the firm hold?
Homework Answers
A.
Inventory turnover ratio = cost of goods sold / average inventory
Inventory turnover ratio = 25/2
Inventory turnover ratio = 12.5 times
B.
Weeks of supply = (average inventory/ cost of goods sold)*52 weeks
Weeks of supply = (2/25)*52
Weeks of supply = 4.16 weeks
Add Answer to:
Part I: Supply Chain Performance
Consider a firm with an annual net income of $20 million,...
The following data are pulled from a recent Walsh Manufacturing annual report. Assets Raw material inventory ...
The following data are pulled from a recent Walsh Manufacturing annual report. Assets Raw material inventory $130,000 Work-in-process inventory $60,000 Finished goods inventory $310,000 Property, plant & equipment $500,000 Other assets $200,000 Total assets $1,200,000 Condensed Income Statement Revenue $2,000,000 Cost of goods sold $600,000 Other expenses $1,000,000 Net income $400,000 Calculate: (a) Percent invested in inventory (b) Inventory turnover (c) Weeks of supply. Please provide detail work on each calculation.
The following data are pulled from a recent Walsh Manufacturing annual report. Assets Raw material inventory...
The following data are pulled from a recent Walsh Manufacturing annual report. Assets Raw material inventory $150,000 Work-in-process inventory $50,000 Finished goods inventory $330,000 Property, plant & equipment $500,000 Other assets $140.000 Total assets $1,170,000 Condensed Income Statement Revenue $2,000,000 Cost of goods sold $700,000 Other expenses $1,000,000 Net income $300,000 Calculate the weeks of supply. O 0.47 O24.51 39 37 Assets Raw material inventory Work-in-process inventory Finished goods inventory Property, plant & equipment Other assets Total assets $150,000 $50,000...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $11 million, cost...
The 2021 income statement of Anderson Medical Supply Company
reported net sales of $11 million, cost of goods sold of $5.7
million, and net income of $845,000. The following table shows the
company's comparative balance sheets for 2021 and 2020:
The 2021 income statement of Anderson Medical Supply Company reported net sales of $11 million, cost of goods sold of $5.7 million, and net income of $845,000. The following table shows the company's comparative balance sheets for 2021 and 2020:...
The 2018 income statement of Anderson Medical Supply Company reported net sales of $10 million, cost...
The 2018 income statement of Anderson Medical Supply Company reported net sales of $10 million, cost of goods sold of $5.6 million, and net income of $840,000. The following table shows the company's comparative balance sheets for 2018 and 2017: 0182017 $460 540 Assets Cash Accounts receivable Inventory Property, plant, and equipment (net) 860 1,300 1,100 3,2002,920 $5,820 $5,140 Total assets Liabilities and shareholders equity Current liabilities Bonds payable Paid-in capital Retained earnings $1,120 990 1,600 1,600 1,800 1,800 1...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $12 million, cost...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $12 million, cost of goods sold of $6.2 million, and net income of $870,000. The following table shows the company's comparative balance sheets for 2021 and 2020: (5 in 2021 2020 Assets $ 580 1,600 BBCO $6,960 60 540 1,010 2920 55,830 McCounts receivable Inventory Property, plant, and equipment (net) Total assets Liabilities and shareholders' equity Current liabilities Bonds payable Common stock Retained earnings Total liabilities and...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $12 million, cost...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $12 million, cost of goods sold of $5.8 million, and net income of $850,000. The following table shows the company's comparative balance sheets for 2021 and 2020: ($ in thousands) 2021 2020 $ 500 900 1,400 3,400 $6,200 $ 580 600 1,200 3,120 $5,500 Assets Cash Accounts receivable Inventory Property, plant, and equipment (net) Total assets Liabilities and shareholders' equity Current liabilities Bonds payable Common stock Retained...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $10 million, cost...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $10 million, cost of goods sold of $6.0 million, and net income of $860,000. The following table shows the company's comparative balance sheets for 2021 and 2020: ($ in thousands) 2021 2020 Assets Cash $ 540 $ 620 Accounts receivable 940 620 Inventory 1,500 910 Property, plant, and equipment (net) 3,600 3,320 Total assets $6,580 $5,470 Liabilities and shareholders' equity Current liabilities $1,280 $1,070 Bonds payable 1,800...
Imagine that you are the supply chain manager for the Magic Widget company and you need...
Imagine that you are the supply chain manager for the Magic Widget company and you need to measure your supply chain performance. The chart shows the financial variables that you will need to perform your task. Financial Variables Financial Variables Amount in $ Billions Inventory Investment 7.5 Total Assets 54.3 Cost of Goods Sold 35.2 Raw Material Inventory .25 Work-in-progress Inventory .16 Finished Goods Inventory .85 Compute the percentage of assets committed to inventory and inventory turnover. Round your answers...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $11 million, cost...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $11 million, cost of goods sold of $5.4 million, and net income of $830,000. The following table shows the company's comparative balance sheets for 2021 and 2020: ($ in thousands) 2021 2020 $ 420 820 1,200 3,000 $5,440 $ 500 560 1,000 2,720 $4,780 Assets Cash Accounts receivable Inventory Property, plant, and equipment (net) Total assets Liabilities and shareholders' equity Current liabilities Bonds payable Common stock Retained...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $9 million, cost...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $9 million, cost of goods sold of $5.2 million, and net income of $820,000. The following table shows the company's comparative balance sheets for 2021 and 2020- ($ in thousands) 2021 2020 $ 380 789 1,100 2,800 $5,060 $ 460 540 900 2,520 $4,420 Assets Cash Accounts receivable Inventory Property, plant, and equipment (net) Total assets Liabilities and shareholders' equity Current liabilities Bonds payable Common stock Retained...
The following data are pulled from a recent Walsh Manufacturing annual report. Assets Raw material inventory $150,000 Work-in-process inventory $50,000 Finished goods inventory $330,000 Property, plant & equipment $500,000 Other assets $140.000 Total assets $1,170,000 Condensed Income Statement Revenue $2,000,000 Cost of goods sold $700,000 Other expenses $1,000,000 Net income $300,000 Calculate the weeks of supply. O 0.47 O24.51 39 37 Assets Raw material inventory Work-in-process inventory Finished goods inventory Property, plant & equipment Other assets Total assets $150,000 $50,000...
The 2021 income statement of Anderson Medical Supply Company
reported net sales of $11 million, cost of goods sold of $5.7
million, and net income of $845,000. The following table shows the
company's comparative balance sheets for 2021 and 2020:
The 2021 income statement of Anderson Medical Supply Company reported net sales of $11 million, cost of goods sold of $5.7 million, and net income of $845,000. The following table shows the company's comparative balance sheets for 2021 and 2020:...
The 2018 income statement of Anderson Medical Supply Company reported net sales of $10 million, cost of goods sold of $5.6 million, and net income of $840,000. The following table shows the company's comparative balance sheets for 2018 and 2017: 0182017 $460 540 Assets Cash Accounts receivable Inventory Property, plant, and equipment (net) 860 1,300 1,100 3,2002,920 $5,820 $5,140 Total assets Liabilities and shareholders equity Current liabilities Bonds payable Paid-in capital Retained earnings $1,120 990 1,600 1,600 1,800 1,800 1...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $12 million, cost of goods sold of $6.2 million, and net income of $870,000. The following table shows the company's comparative balance sheets for 2021 and 2020: (5 in 2021 2020 Assets $ 580 1,600 BBCO $6,960 60 540 1,010 2920 55,830 McCounts receivable Inventory Property, plant, and equipment (net) Total assets Liabilities and shareholders' equity Current liabilities Bonds payable Common stock Retained earnings Total liabilities and...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $12 million, cost of goods sold of $5.8 million, and net income of $850,000. The following table shows the company's comparative balance sheets for 2021 and 2020: ($ in thousands) 2021 2020 $ 500 900 1,400 3,400 $6,200 $ 580 600 1,200 3,120 $5,500 Assets Cash Accounts receivable Inventory Property, plant, and equipment (net) Total assets Liabilities and shareholders' equity Current liabilities Bonds payable Common stock Retained...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $10 million, cost of goods sold of $6.0 million, and net income of $860,000. The following table shows the company's comparative balance sheets for 2021 and 2020: ($ in thousands) 2021 2020 Assets Cash $ 540 $ 620 Accounts receivable 940 620 Inventory 1,500 910 Property, plant, and equipment (net) 3,600 3,320 Total assets $6,580 $5,470 Liabilities and shareholders' equity Current liabilities $1,280 $1,070 Bonds payable 1,800...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $11 million, cost of goods sold of $5.4 million, and net income of $830,000. The following table shows the company's comparative balance sheets for 2021 and 2020: ($ in thousands) 2021 2020 $ 420 820 1,200 3,000 $5,440 $ 500 560 1,000 2,720 $4,780 Assets Cash Accounts receivable Inventory Property, plant, and equipment (net) Total assets Liabilities and shareholders' equity Current liabilities Bonds payable Common stock Retained...
The 2021 income statement of Anderson Medical Supply Company reported net sales of $9 million, cost of goods sold of $5.2 million, and net income of $820,000. The following table shows the company's comparative balance sheets for 2021 and 2020- ($ in thousands) 2021 2020 $ 380 789 1,100 2,800 $5,060 $ 460 540 900 2,520 $4,420 Assets Cash Accounts receivable Inventory Property, plant, and equipment (net) Total assets Liabilities and shareholders' equity Current liabilities Bonds payable Common stock Retained...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago