Question

In: Finance

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 calculations and round your answer to the nearest whole number, e.g., 32.)


What are the payments to suppliers each quarter? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)


b. 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 a 90-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places e.g., 32.16.)


c. 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 a 60-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places e.g., 32.16.)

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 $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?...
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?
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...
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...
Acme Co. has projected the following sales for 2019: Q1 = $870 Q2 = $920 Q3...
Acme Co. has projected the following sales for 2019: Q1 = $870 Q2 = $920 Q3 = $850 Q4 = $950 Sales for each quarter in 2020 are projected to be 20 percent greater than the previous quarter (ie. Q1 2020 is projected to be 20% higher than Q4 2019). Calculate expected payments to suppliers in each quarter for 2019, assuming: 1) Acme places orders during each quarter equal to 40 percent of projected sales for the next quarter. For...
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 $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT