Question

In: Accounting

Inventory Turnover and days’ sales in inventory Kracker Corp., Foodstuff, Inc., and Winston Stores, Inc. are...

Inventory Turnover and days’ sales in inventory

Kracker Corp., Foodstuff, Inc., and Winston Stores, Inc. are three grocery chains in the United States. Inventory management is an important aspect of the grocery retail business. Recent balance sheets for these three companies indicated the following merchandise inventory (in millions) information:

Kracker
Corp.
Foodstuff
Inc.
Winston
Stores
Cost of merchandise sold $32,850.0 $33,215.0 $35,040.0
Inventory, beginning of year 1,908.9 2,042.0 1,483.2
Inventory, end of year 1,871.1 1,962.0 1,396.8

a. & b. Determine the inventory turnover and the number of days’ sales in inventory (use 365 days and round to the nearest day) for the three companies. Round all interim calculations to one decimal place. For days' sales in inventory, round final answers to the nearest day, and for inventory turnover, round to one decimal place.

Company names Inventory Turnover Days' Sales in Inventory
Kracker fill in the blank 1 fill in the blank 2 days
Foodstuff fill in the blank 3 fill in the blank 4 days
Winston Stores fill in the blank 5 fill in the blank 6 days

c. The inventory turnover ratios and days’ sales in inventory are   for Kracker and Foodstuff. Winston Stores has a   inventory turnover and a   days’ sales in inventory than Kracker and Foodstuff. These results suggest that Kracker and Foodstuff are   efficient than Winston Stores in managing inventory.

d. If Kracker had Winston Stores’ days’ sales in inventory, how much additional cash flow would have been generated from the smaller inventory relative to its actual average inventory position? Round interim calculations to one decimal place and your final answer to the nearest million.
$fill in the blank 11 million

Solutions

Expert Solution

Ans: Inventory Turnover= COGS/Average Inventory

Average Inventory= Opening Inventory+ Closing Inventory/2

For Kracker Corp:

Inventory Turnover= 32,850/[1,908.9+1,871.1]/2

=> 32,850/3,780/2

=> 32,850/1,890

=> 17.38 times

Days Sale in Inventory= 365/Inventory turnover

=> 365/17.38

=> 21 days

For Foodstuff Inc:

Inventory Turnover= 33,215/[2,042+1,962]/2

=> 33,215/4,004/2

=> 33,215/2,002

=> 16.59 times

Days Sale in Inventory= 365/Inventory turnover

=> 365/16.59

=> 22 Days.

For Winston stores:

Inventory Turnover= 35,040/[1,483.20+1,396.80]/2

=> 35,040/2,880/2

=> 35,040/1,440

=> 24.33 times

Days Sale in Inventory= 365/Inventory turnover

=> 365/24.33

=> 15 Days.

C). The inventory turnover ratios and days’ sales in inventory are 17.38 times and 21 days for Kracker Corp.

and for Foodstuff Inc are 16.59 times and 22 days. Winston Stores has a 24.33 times inventory turnover and a 15 days’ sales in inventory than Kracker and Foodstuff

D). If Kracker had Winston Stores’ days’ sales in inventory, additional cash flow would have been generated from the smaller inventory relative to its actual average inventory position

Let Average Inventory be X

Days Sales in Inventory= Average Inventory/{Cost of Merchandise Sold}/365

15= X/{32,850/365}

15= X/ 90

X= $1,350

Cash Flow Potential= Actual Average Inventory- Hypothetical Average Inventory

=> 1,890-1,350

=> 540 million i.e.  additional cash flow would have been generated from the smaller inventory relative to its actual average inventory position


Related Solutions

Inventory Turnover and days’ sales in inventory Kracker Corp., Foodstuff, Inc., and Winston Stores, Inc. are...
Inventory Turnover and days’ sales in inventory Kracker Corp., Foodstuff, Inc., and Winston Stores, Inc. are three grocery chains in the United States. Inventory management is an important aspect of the grocery retail business. Recent balance sheets for these three companies indicated the following merchandise inventory (in millions) information: Kracker Corp. Foodstuff Inc. Winston Stores Cost of merchandise sold $34,310.0 $33,945.0 $35,040.0 Inventory, beginning of year 1,993.7 2,086.9 1,582.1 Inventory, end of year 1,954.3 2,005.1 1,489.9 a. & b. Determine...
Inventory Turnover and days’ sales in inventory Kracker Corp., Foodstuff, Inc., and Winston Stores, Inc. are...
Inventory Turnover and days’ sales in inventory Kracker Corp., Foodstuff, Inc., and Winston Stores, Inc. are three grocery chains in the United States. Inventory management is an important aspect of the grocery retail business. Recent balance sheets for these three companies indicated the following merchandise inventory (in millions) information: Kracker Corp. Foodstuff Inc. Winston Stores Cost of merchandise sold $34,310.0 $34,675.0 $35,405.0 Inventory, beginning of year 1,993.7 2,131.8 1,498.7 Inventory, end of year 1,954.3 2,048.2 1,411.3 a. & b. Determine...
Inventory Turnover and days’ sales in inventory Kracker Corp., Foodstuff, Inc., and Winston Stores, Inc. are...
Inventory Turnover and days’ sales in inventory Kracker Corp., Foodstuff, Inc., and Winston Stores, Inc. are three grocery chains in the United States. Inventory management is an important aspect of the grocery retail business. Recent balance sheets for these three companies indicated the following merchandise inventory (in millions) information: Kracker Corp. Foodstuff Inc. Winston Stores Cost of merchandise sold $33,580.0 $34,675.0 $35,040.0 Inventory, beginning of year 1,951.3 2,131.8 1,582.1 Inventory, end of year 1,912.7 2,048.2 1,489.9 a. & b. Determine...
Winston Inc. is trying to determine the effect of its inventory turnover ratio and days sales...
Winston Inc. is trying to determine the effect of its inventory turnover ratio and days sales outstanding on its cash conversion cycle. Winston's 2015 sales (all on credit) were $168,000 and its cost of goods sold was 75% of sales. It turned over its inventory 8.03 times during the year. Its receivables balance at the end of the year was $13,172.98 and its payables balance at the end of the year was $7,400.17. Using this information calculate the firm's cash...
1. Winston Inc. is trying to determine the effect of its inventory turnover ratio and days...
1. Winston Inc. is trying to determine the effect of its inventory turnover ratio and days sales outstanding on its cash conversion cycle. Winston's 2015 sales (all on credit) were $185,000 and its cost of goods sold was 75% of sales. It turned over its inventory 8.67 times during the year. Its receivables balance at the end of the year was $13,192.07 and its payables balance at the end of the year was $7,411.93. Using this information calculate the firm's...
Inventory Turnover and days’ sales in inventory Kroger, Sprouts Farmers Market, Inc., and Whole Foods Markets,...
Inventory Turnover and days’ sales in inventory Kroger, Sprouts Farmers Market, Inc., and Whole Foods Markets, Inc. are three grocery chains in the United States. Inventory management is an important aspect of the grocery retail business. Recent balance sheets for these three companies indicated the following merchandise inventory (in millions) information: Kroger Sprouts Whole Foods Cost of merchandise sold $85,512 $2,541 $9,973 Inventory, end of year 5,688 165 500 Inventory, beginning of year 5,651 143 441 a. & b. Determine...
Inventory Turnover and days’ sales in inventory Kroger, Sprouts Farmers Market, Inc., and Whole Foods Markets,...
Inventory Turnover and days’ sales in inventory Kroger, Sprouts Farmers Market, Inc., and Whole Foods Markets, Inc. are three grocery chains in the United States. Inventory management is an important aspect of the grocery retail business. Recent balance sheets for these three companies indicated the following merchandise inventory (in millions) information: Kroger Sprouts Whole Foods Cost of merchandise sold $85,512 $2,541 $9,973 Inventory, end of year 5,688 165 500 Inventory, beginning of year 5,651 143 441 a. & b. Determine...
Inventory Turnover and days’ sales in inventory Kroger, Sprouts Farmers Market, Inc., and Whole Foods Markets,...
Inventory Turnover and days’ sales in inventory Kroger, Sprouts Farmers Market, Inc., and Whole Foods Markets, Inc. are three grocery chains in the United States. Inventory management is an important aspect of the grocery retail business. Recent balance sheets for these three companies indicated the following merchandise inventory (in millions) information: Kroger Sprouts Whole Foods Cost of merchandise sold $85,512 $2,541 $9,973 Inventory, end of year 5,688 165 500 Inventory, beginning of year 5,651 143 441 a. & b. Determine...
Average Inventory, Inventory Turnover Ratio, Inventory Turnover in Days Belt Company had net sales of $1,891,675,000...
Average Inventory, Inventory Turnover Ratio, Inventory Turnover in Days Belt Company had net sales of $1,891,675,000 and cost of goods sold of $1,713,635,000. Belt had the following balances: January 1 December 31 Inventories $301,500,000 $385,000,000 Required: Assume 365 days per year. 1. Calculate the average inventory. $ 2. Calculate the inventory turnover ratio. Round to two decimal places. times 3. Calculate the inventory turnover in days. Round to two decimal places. days
Quantitative Problem: Winston Inc. is trying to determine the effect of its inventory turnover ratio and...
Quantitative Problem: Winston Inc. is trying to determine the effect of its inventory turnover ratio and days sales outstanding on its cash conversion cycle. Winston's 2017 sales (all on credit) were $162,000 and its cost of goods sold was 75% of sales. It turned over its inventory 8.51 times during the year. Its receivables balance at the end of the year was $13,115.93 and its payables balance at the end of the year was $7,410.39. Using this information calculate the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT