Question

In: Finance

Lewellen Products has projected the following sales for the coming year: Sales Q1:$ 970, Q2: $...

Lewellen Products has projected the following sales for the coming year:

Sales Q1:$ 970, Q2: $ 1,050, Q3: $ 1,010, Q4: $ 1,110

Sales in the year following this one are projected to be 15 percent greater in each quarter.

a. Calculate payments to suppliers assuming that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assume that the company pays immediately. What is the payables period in this case?. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

Payment of accounts Q1:$__, Q2: $__, Q3: $___, Q4: $___

b. Calculate payments to suppliers assuming a 90-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

Payment of accounts Q1:$__,Q2: $__, Q3:$__, Q4: $__

c. Calculate payments to suppliers assuming a 60-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

Payment of accounts Q1: $__, Q2:$__. Q3:$__, Q4:__

Solutions

Expert Solution


Related Solutions

Wentworth Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4   Sales...
Wentworth Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4   Sales $360 $450 $600 $540 Sales in the year following this one are projected to be 10 percent greater in each quarter. Calculate payments to suppliers assuming that the company places orders during each quarter equal to 25 percent of projected sales for the next quarter. Assume that the company pays immediately. a. What is the payables period in this case? (Do not round intermediate...
Wentworth Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4   Sales...
Wentworth Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4   Sales $650 $740 $875 $805 Sales in the year following this one are projected to be 15 percent greater in each quarter. a. Assume that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assuming that the company pays immediately, what is the payables period? (Do not round intermediate calculations and round your answer to the...
Brunell Products has projected the following sales for the coming year:    Q1 Q2 Q3 Q4...
Brunell Products has projected the following sales for the coming year:    Q1 Q2 Q3 Q4 Sales $480 $570 $720 $660    Sales in the year following this one are projected to be 10 percent greater in each quarter.    Calculate payments to suppliers assuming that the company places orders during each quarter equal to 25 percent of projected sales for the next quarter. Assume that the company pays immediately.    a. What is the payables period in this case?...
The Litzenberger Company has projected the following quarterly sales amounts for the coming year: Q1 Q2...
The Litzenberger Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $ 790 $ 820 $ 900 $ 980 a. Accounts receivable at the beginning of the year are $380. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. A negative answer should be indicated by...
The Geller Company has projected the following quarterly sales amounts for the coming year: Q1 Q2...
The Geller Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4   Sales $420 $480 $540 $690 a. Accounts receivable at the beginning of the year are $270. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.)     b. Accounts receivable at the beginning of the year...
The Doak Company has projected the following quarterly sales amounts for the coming year: Q1 Q2...
The Doak Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $3,900 $4,700 $4,300 $3,600 Accounts receivable at the beginning of the year are $1,700. a. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.) b. The company has a 60-day collection period. Calculate cash...
All That Remains Products has projected sales for next year of: Q1 Q2 Q3 Q4 Sales...
All That Remains Products has projected sales for next year of: Q1 Q2 Q3 Q4 Sales $ 76,000 $ 79,775 $ 86,500 $ 93,480 The company places orders each quarter that are 52 percent of the following quarter's sales and has a 60-day payables period. What is the accounts payable balance at the end of the third quarter?
Problem 26-7 Calculating Payments Rossdale Products has projected the following sales for the coming year: Q1...
Problem 26-7 Calculating Payments Rossdale Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales $ 740 $ 665 $ 785 $ 890 Sales in the year following this one are projected to be 15 percent greater in each quarter. The company places orders during each quarter equal to 30 percent of projected sales for the next quarter. a. Calculate payments to suppliers assuming that the company pays immediately. (Do not round intermediate calculations and...
The Jallouk Company has projected the following quarterly sales amounts for the coming year:     Q1...
The Jallouk Company has projected the following quarterly sales amounts for the coming year:     Q1 Q2 Q3 Q4 Sales $450 $510 $570 $720    a. Accounts receivable at the beginning of the year are $240. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.)     Q1 Q2 Q3 Q4 Beginning receivables $...
The Jallouk Company has projected the following quarterly sales amounts for the coming year:     Q1...
The Jallouk Company has projected the following quarterly sales amounts for the coming year:     Q1 Q2 Q3 Q4 Sales $450 $510 $570 $720    a. Accounts receivable at the beginning of the year are $240. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.)     Q1 Q2 Q3 Q4 Beginning receivables $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT