Question

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 $34,675.0 $35,040.0
Inventory, beginning of year 1,908.9 2,131.8 1,582.1
Inventory, end of year 1,871.1 2,048.2 1,489.9

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 days
Foodstuff days
Winston Stores days

c. The inventory turnover ratios and days’ sales in inventory are similar for Kracker and Foodstuff. Winston Stores has a higher inventory turnover and a lower days’ sales in inventory than Kracker and Foodstuff. These results suggest that Kracker and Foodstuff are less 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.
$ million

Homework Answers

Answer #1
a&b
Kracker Foodstuff Winston
Corp. Inc. Stores
Cost of merchandise sold $32,850.00 $34,675.00 $35,040.00
Inventory, beginning of year 1,908.90 2,131.80 1,582.10
Inventory, end of year 1,871.10 2,048.20 1,489.90
Average Inventory (beginning Inventory+Ending Inventory)/2 1890 2090 1536
Inventory turnover(cost of good sold/Average Inventory) 17.4 16.6 22.8
Days sales in Inventory (365/Inventory turnover) 21 22 16 days
c These results suggest that Kracker and Foodstuff are less efficient than Winston Stores in managing inventory.
d New Inventory Turnover fr Kracker would be 22.81
Additional cashflow 10206
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
Inventory Turnover and Number of Days' Sales in Inventory Kracker, Foodstuff Inc., and Winston Stores Inc....
Inventory Turnover and Number of Days' Sales in Inventory Kracker, Foodstuff Inc., and Winston Stores Inc. are three large grocery chains. Inventory management is an important aspect of the grocery retail business. Recent balance sheets for these three companies indicated the following merchandise inventory information: Merchandise Inventory End of Year (in millions) Beginning of Year (in millions) Kracker $3,874 $1,976 Foodstuff 3,404 3,608 Winston 3,200 6,400 The cost of goods sold for each company was: Cost of Goods Sold (in...
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 $190,000 and its cost of goods sold was 75% of sales. It turned over its inventory 8.06 times during the year. Its receivables balance at the end of the year was $13,145.01 and its payables balance at the end of the year was $7,416.42. Using this information calculate the firm's cash...
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 $102,000 and its cost of goods sold was 75% of sales. It turned over its inventory 8.09 times during the year. Its receivables balance at the end of the year was $13,152 and its payables balance at the end of the year was $7,403.52. Using this information calculate the firm's cash...
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 $162,000 and its cost of goods sold was 75% of sales. It turned over its inventory 8.4 times during the year. Its receivables balance at the end of the year was $13,143.36 and its payables balance at the end of the year was $7,404.47. Using this information calculate the firm's cash...
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 $112,000 and its cost of goods sold was 75% of sales. It turned over its inventory 8.95 times during the year. Its receivables balance at the end of the year was $13,134.81 and its payables balance at the end of the year was $7,401.66. Using this information calculate the firm's cash...
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 $103,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,174.77 and its payables balance at the end of the year was $7,413.08. Using this information calculate the firm's cash...
3. Winston Inc. is trying to determine the effect of its inventory turnover ratio and days...
3. 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 $127,000 and its cost of goods sold was 75% of sales. It turned over its inventory 9 times during the year. Its receivables balance at the end of the year was $13,105.05 and its payables balance at the end of the year was $7,417.15. Using this information calculate the firm's...
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.13 times during the year. Its receivables balance at the end of the year was $13,152.57 and its payables balance at the end of the year was $7,418.95. Using this information calculate the...
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 2013 sales (all on credit) were $191,000 and its cost of goods sold was 75% of sales. It turned over its inventory 8.53 times during the year. Its receivables balance at the end of the year was $13,106.24 and its payables balance at the end of the year was $7,396.1. Using this information calculate the...
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 2015 sales (all on credit) were $187,000 and its cost of goods sold was 75% of sales. It turned over its inventory 8.46 times during the year. Its receivables balance at the end of the year was $13,132.08 and its payables balance at the end of the year was $7,419.8. Using this information calculate the...