Question

Kiley Corporation had the following data for the most recent year (in millions). The new CFO...

Kiley Corporation had the following data for the most recent year (in millions). The new CFO believes (1) that an improved inventory management system could lower the average inventory by $4,000, (2) that improvements in the credit department could reduce receivables by $2,000, and (3) that the purchasing department could negotiate better credit terms and thereby increase accounts payable by $2,000. Furthermore, she thinks that these changes would not affect either sales or the costs of goods sold. If these changes were made, by how many days would the cash conversion cycle be lowered?

 

Original

Revised

Annual sales: unchanged

$110,000

$110,000

Cost of goods sold: unchanged

$80,000

$80,000

Average inventory: lowered by $4,000

$20,000

$16,000

Average receivables: lowered by $2,000

$16,000

$14,000

Average payables: increased by $2,000

$10,000

$12,000

Days in year

365

365

 

a. 49.8

b. 41.2

c. 34.0

d. 37.4

e. 45.3

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

Solution-

Days Inventory outstanding= average inventory / Cost of goods sold*365

Original =20000/80000*365= 91.25 days

Revised =16000/80000*365= 73 days

Days sales outstanding = average receivables/ annual sales*365

Original= 16000/110000*365=53.09 days

Revised = 14000/110000*365= 46.45 days

Days payable outstanding = average payable/cost of goods sold*365

Original = 10000/80000*365=45.62 days

Revised =12000/80000*365= 54.75 days

Cash conversion cycle= days inventory outstanding+ days sales outstanding- days payable outstanding

Original= 91.25 days+53.09 date- 45.62 days=98.72 days

Revised= 73 days +46.45 days -54.75 days=64.70 days

Net effect = Original - Revised

=98.72-64.70=34.02 days

So correct answer is option C i.e. 34.0 days

Add a comment
Know the answer?
Add Answer to:
Kiley Corporation had the following data for the most recent year (in millions). The new CFO...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Data on Nathan Enterprises for the most recent year are shown below, along with the days...

    Data on Nathan Enterprises for the most recent year are shown below, along with the days sales outstanding of the firms against which it benchmarks. The firm's new CFO believes that the company could reduce its receivables enough to reduce its DSO to the benchmarks' average. If this were done, by how much would receivables decline? Use a 365-day year. Sales $110,000 Accounts receivable $16,000 Days sales outstanding (DSO) 53.09 Benchmark days sales outstanding (DSO) 20.00

  • Use the following information to answer items 4-7: For its most recent year a company had...

    Use the following information to answer items 4-7: For its most recent year a company had Sales (all on credit) of $830,000 and Cost of Goods Sold of $525,000. At the beginning of the year its Accounts Receivable were $80,000 and its Inventory was s100,000. At the end of the year its Accounts Receivable were $86,000 and its Inventory was $110,000. 4. The inventory turnover ratio for the year was . 5. The accounts receivable turnover ratio for the year was 6. On...

  • Dewey Corporation has the following data, in thousands. Assuming a 365-day year, what is the firm's...

    Dewey Corporation has the following data, in thousands. Assuming a 365-day year, what is the firm's cash conversion cycle? Annual sales = $55,000 Annual cost of goods sold = $38,500 Inventory = $4,000 Accounts receivable = $2,000 Accounts payable = $2,400 a)36 days b)21 days c)28 days d)27 days e)24 days

  • Nordstrom, Inc. operates department stores in numerous states. Selected hypothetical financial statement data (in millions) for...

    Nordstrom, Inc. operates department stores in numerous states. Selected hypothetical financial statement data (in millions) for 2022 are presented below. End of Year Beginning of Year Cash and cash equivalents $790 $67 Accounts receivable (net) 2,000 1,850 Inventory 890 900 Other current assets 290 333 Total current assets $3,970 $3,150 Total current liabilities $2,050 $1,600 For the year, net credit sales were $8,258 million, cost of goods sold was $5,328 million, and net cash provided by operating activities was $1,251...

  • Nordstrom, Inc. operates department stores in numerous states. Selected hypothetical financial statement data (in millions) for...

    Nordstrom, Inc. operates department stores in numerous states. Selected hypothetical financial statement data (in millions) for 2022 are presented below. End of Year Beginning of Year Cash and cash equivalents $ 760 $ 77 Accounts receivable (net) 2,080 1,890 Inventory 810 890 Other current assets 730 363 Total current assets $4,380 $3,220 Total current liabilities $2,000 $1,610 For the year, net credit sales were $8,258 million, cost of goods sold was $5,328 million, and net cash provided by operating activities...

  • Saxton Company's inventory records for the most recent year contain the following data: (Click the icon...

    Saxton Company's inventory records for the most recent year contain the following data: (Click the icon to view the data.) Saxton Company sold a total of 18,500 units during the year. Read the requirements. Requirement 1. Using the average-cost method, compute the cost of goods sold and ending inventory for the year. (Round the average cost per unit to the nearest cent.) Using the average-cost method, the cost of goods sold is $ 20000 and the ending inventory is $...

  • Use the following information for que stions 2 and 3: For its most recent year a...

    Use the following information for que stions 2 and 3: For its most recent year a company had Sales (all on credit) of $830,000 and Cost of Goods Sold $525,000. At the beginning of the year its Accounts Receivable was $80,000 and its Inventory $100,000. At the end of the year its Accounts Receivable was S86,000 and its Inventery $110,000. On average how many days of sales were in Inventory during the year? On average how many days of sales...

  • For the c Data Table Selected income statement data for the current year: Digitized Very Network...

    For the c Data Table Selected income statement data for the current year: Digitized Very Network Net Sales Revenue (all on credit) 416,830 $ 497,860 Cost of Goods Sold 206,000 259,000 Interest Expense 19,000 Net Income 48,000 76,000 Print Done %24 price/eamings ratios but that your decision deper data.) Selected balance sheet and market price data at the end of the current year: Digitized Very Network companies for Current Assets: st ratio. Cash %24 25,000 $ 20,000 Short-term Investments 42,000...

  • Question 4 Garmin Ltd. uses the periodic inventory system and had the following inventory information available:...

    Question 4 Garmin Ltd. uses the periodic inventory system and had the following inventory information available:                                                                Units               Unit Cost           Total Cost Jan         1          Beginning inventory        100                    $4                   $   400              20          Purchase                         500                    $5                     2,500 Jul        25          Purchase                         100                    $6                        600 Nov      20          Purchase                        300                    $7                   2,100                                                                1,000                                           $5,600 A physical count of inventory on December 31 showed that there were 350 units on hand. Instructions Answer the following independent questions and show calculations supporting...

  • 2020 Question #3 Springhill Corporation Balance Sheet December 31, 2021, and December 31", 2020 (in thousands)...

    2020 Question #3 Springhill Corporation Balance Sheet December 31, 2021, and December 31", 2020 (in thousands) 2021 Assets Current Assets: Cash $90,000 Accounts Receivable 60,000 Inventory 18,000 Prepaid Expenses 2,000 Total Current Assets 170,000 Capital Assets (PP&E) 50,000 Total Assets $220,000 $57,000 40,000 10,000 1,000 108,000 30,000 $138,000 Liabilities: Accounts Payable Accrued Liabilities Income Taxes Payable Total Current Liabilities Long Term Debt Total liabilities $11,000 6,000 5,000 22,000 40,000 362,000 $4,000 3,000 8,000 15,000 8,000 S23,000 Shareholders' Equity Common Shares...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT