ExercisesCash conversion cycle Metal Supplies is concerned about its cash management.On average, the day's sales in inventory (duration of inventory on shelf) is 90days. Accounts receivable are collected in 90 days, while accounts payable arpaid in 60 days. Metal Supplies has annual sales of $14 million; cost of goodssold total $9.5 million, and purchases are $5 million. (Note: Use a 365-dayyear.)a. Calculate Metal Supplies' operating cycle.b. What is Metal Supplies' cash conversion cycle?c. Calculate the amount of resources needed to support Metal Supplies' cashcon- version cycle.14

Operating cycle = Average age of inventory + Average collection period Cash conversion cycle =…

Answered: Cash conversion cycle Metal Supplies is…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Zane Corporation has an inventory conversion period of 76 days, an average collection period of 35 days, and a payables deferral period of 20 days. Assume 365 days in year for your calculations. What is the length of the cash conversion cycle? Round your answer to two decimal places.days If Zane's annual sales are $2,030,230 and all sales are on credit, what is the investment in accounts receivable? Do not round intermediate calculations. Round your answer to the nearest cent.$ How many times per year does Zane turn over its inventory? Assume that the cost of goods sold is 75% of sales. Use sales in the numerator to calculate the turnover ratio. Do not round intermediate calculations. Round your answer to two decimal places.x
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $127,000 November 159,000 December 232,000 The Accounts Receivable balance on September 30 was $85,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc.Schedule of Cash Collections from SalesFor the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 September sales on account:…
Page Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are collected in the month of sale, 25% in the month following sale, and 12% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year: Month Total sales Total cash receipts in Month 4 will be: Multiple Choice $27,230. $47,900. 1 2 3 $ 60,000 $ 70,000 $50,000 $30,000 £36 230
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customer while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remainim 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October November December $109,000 136,000 199,000 The Accounts Receivable balance on September 30 was $73,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dolla OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 November Receipts from cash sales: Cash sales September sales on account: Collected in October October sales on account: Collected in October Collected in November November sales on account: October…
Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of goods ($ millions) 33 29 26 23 21 21 a. Fifty percent of goods are supplied cash-on-delivery. The remainder are paid with an average delay of one month. If Dynamic Futon starts the year with payables of $23 million, what is the forecasted level of payables for each month? (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.) b. Suppose that from the start of the year the company stretches payables by paying 50% after one month and 30% after two months. (The remainder continue to be paid cash on delivery.) Recalculate payables for each month assuming that there are no cash penalties for late payment. (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.)
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year 01 02 04 Sales # 330 $390 a. Accounts receivable at the beginning of the year are $360. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables 03 $450 Beginning receivables Sales Cash collections Ending receivables S Beginning receivables Sales Cash collections Ending receivables 01 01 300 330 01 330 b. Accounts receivable at the beginning of the year are $360. The company has a 60-day collection period Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e-g.. 32. 02 330 02 390 Q² 390 03 350 03 450 03 c. Accounts…
Schedule of cash collections of accounts receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 30% pay their accounts in the month of sale, while the remaining 70% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $58,000 November 65,000 December 72,000 The Accounts Receivable balance on September 30 was $35,000. Prepare a schedule of cash collections from sales for October, November, and December. Enter all amounts as positive numbers. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 Line Item Description Receipts from cash sales: Cash sales September sales on account: Collected in October October sales on account: Collected in October Collected in November November sales on account: Collected…
7. Desai Inc. has the following data, in thousands. Assuming a 365-day year, what is the firm's cash conversion cycle? Round to the nearest whole day. Annual sales = Annual cost of goods sold = Inventory = Accounts receivable = $45,000 $23,500 $4,500 $1,800 $2,500 Accounts payable =
Financial information for Strawberry’s Place is as follows: Cash at 1/1/20X1 is $10,000. The firm desires to maintain a minimum balance of $10,000 at the end of each month. Total monthly sales are as follows: DecemberJanuaryFebruary 20X020X120X1 $120,000150,000 (est.)160,000 (est.) The sales are 40 percent cash and 60 percent credit card. Visa is the only acceptable credit card at Strawberry’s, and assume the charges are converted to cash the day of the sale. The brokerage charge is 2 percent of the sale. Expected other income is $2,000 from interest to be received in February. In addition, in January, a range with a net book value of $300 is expected to be sold for cash, resulting in a $1,000 gain on the sale. Food and beverages are paid for the month following the sale and average 40 percent and 25 percent, respectively. Food sales are four times beverage sales. Total sales consist of only food and beverage sales. Labor is paid for the last day of the month and…
vv. Axis Wells and Excavation(AWE) currently generates 55,000 in annual sales. AWE sells on terms of net 50, and it’s accounts receivable balance averages $11,000. AWE is considering a new credit policy with terms of net 25. Under the new policy, sales will decrease to 36,000, and accounts receivable will average 12,000. Compute the days sales outstanding (DSO) under the existing policy and the proposed policy. Assume there are 360 days ina a year. Round your answer to the nearest whole number. DSO existing: Days DSO new: Days
As an operations management consultant, you have been asked to evaluate a furniture manufacturer's cash-to-cash conversion cycle under the following assumptions: sales of $23.6 million, cost of goods sold of $19.5 million, 50 operating weeks a year, total average on-hand inventory of $2,300,000, accounts receivable equal to $2,440,000, and accounts payable of $3,710,000. What is the cash-to-cash conversion cycle in weeks? Do not round intermediate calculations. Round your answer to one decimal place. week(s) What recommendations can you make to improve performance? -Select- ✓inventory weeks of supply and -Select- ✓accounts receivable weeks of supply or -Select- are ways to improve overall firm performance. accounts payable weeks of supply

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS