Question

Inventory Management Williams & Sons last year reported sales of $55 million, cost of goods sold...

Inventory Management

Williams & Sons last year reported sales of $55 million, cost of goods sold (COGS) of $45 million, and an inventory turnover ratio of 5. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 9 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Enter your answer in dollars. For example, an answer of $1.23 million should be entered as 1,230,000,000. Round your answer to the nearest dollar.

Homework Answers

Answer #1

The amount of cash is computed as shown below:

Inventory when inventory turnover is 5 is computed as follows:

Inventory turnover = Cost of goods sold / Average Inventory

5 = $ 45 million / Average inventory

Average inventory = $ 45 million / 5

= $ 9 million

Inventory when inventory turnover is 9 is computed as follows:

Inventory turnover = Cost of goods sold / Average Inventory

9 = $ 45 million / Average inventory

Average inventory = $ 45 million / 9

= $ 5 million

So, the amount of cash freed up is computed as follows:

= $ 9 million - $ 5 million

= $ 4,000,000

Feel free to ask in case of any query relating to this question      

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Williams & Sons last year reported sales of $32 million, cost of goods sold (COGS) of...
Williams & Sons last year reported sales of $32 million, cost of goods sold (COGS) of $24 million, and an inventory turnover ratio of 4. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 6 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Enter your answer in...
Williams & Sons last year reported sales of $49 million, cost of goods sold (COGS) of...
Williams & Sons last year reported sales of $49 million, cost of goods sold (COGS) of $40 and an inventory turnover ratio of 4. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 5 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Round your answer to the...
Williams & Sons last year reported sales of $73 million, cost of goods sold (COGS) of...
Williams & Sons last year reported sales of $73 million, cost of goods sold (COGS) of $60 and an inventory turnover ratio of 5. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 6 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Round your answer to the...
Williams & Sons last year reported sales of $22 million, cost of goods sold (COGS) of...
Williams & Sons last year reported sales of $22 million, cost of goods sold (COGS) of $18 and an inventory turnover ratio of 2. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 3 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Round your answer to the...
Problem 16-01 Inventory Management Williams & Sons last year reported sales of $74 million, cost of...
Problem 16-01 Inventory Management Williams & Sons last year reported sales of $74 million, cost of goods sold (COGS) of $60 and an inventory turnover ratio of 5. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 6 while maintaining the same level of sales and COGS, how much cash will be freed up?
1.) Williams & Sons last year reported sales of $32 million, cost of goods sold (COGS)...
1.) Williams & Sons last year reported sales of $32 million, cost of goods sold (COGS) of $24 million, and an inventory turnover ratio of 4. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 6 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Enter your answer...
1 Last year a company reported sales of $ 10 million and an inventory turnover ratio...
1 Last year a company reported sales of $ 10 million and an inventory turnover ratio of 5. It is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 8 while maintaining the same level of sales, how much cash will be freed up? 2 A company has days sales outstanding of 18 days. It averages $ 6,500 in credit sales every day....
Sauerbraten Corp. reported 2007 sales ($ in millions) of $2,157 and cost of goods sold of...
Sauerbraten Corp. reported 2007 sales ($ in millions) of $2,157 and cost of goods sold of $1,827. Inventories at year - end 2007 and 2006, respectively, were $553 and $562. The company uses the LIFO method for inventory valuation and discloses that if the FIFO inventory valuation method had been used, inventories would have been $63.3 million and $56.8 million higher in 2007 and 2006, respectively. Compared to the inventory turnover ratio reported, if Sauerbraten had exclusively used the FIFO...
REGRESSION AND INVENTORIES Jasper Furnishings has $350 million in sales. The company expects that its sales...
REGRESSION AND INVENTORIES Jasper Furnishings has $350 million in sales. The company expects that its sales will increase 10% this year. Jasper's CFO uses a simple linear regression to forecast the company's inventory level for a given level of projected sales. On the basis of recent history, the estimated relationship between inventories and sales (in millions of dollars) is as follows: Inventories = $40 + 0.2(Sales) A. Given the estimated sales forecast and the estimated relationship between inventories and sales,...
The King Corporation has ending inventory of $386,735, and cost of goods sold for the year...
The King Corporation has ending inventory of $386,735, and cost of goods sold for the year just ended was $4,981,315. a. What is the inventory turnover? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the days' sales in inventory? (Use 365 days a year. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. How long on average did a unit of inventory sit...