Question

In: Finance

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?

Solutions

Expert Solution


Related Solutions

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?...
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...
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...
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...
Do all the Q1, Q2, Q3 and Q4 The cash budget is the primary tool used...
Do all the Q1, Q2, Q3 and Q4 The cash budget is the primary tool used in short-term financial planning. As with many calculations, the sales forecast is a primary input. As an example of the cash budgeting process, we will use the Fun Toys Corporation. The sales projections and other information provided are: Q1 Q2 Q3 Q4 Sales $    200,000,000 $      300,000,000 $    250,000,000 $    400,000,000 Beginning receivables: $    120,000,000 Receivables period (days):                        45 With the receivables period shown, we can calculate the percentage...
Production Budget Q1 Q2 Q3 Q4 Total Sales in Units        1,000        1,200        1,500...
Production Budget Q1 Q2 Q3 Q4 Total Sales in Units        1,000        1,200        1,500        2,000        5,700 Add: Desired Ending Inv.                240            300            400            400            400 Total Needs        1,240        1,500        1,900        2,400        6,100 Less:Beginning Inv.                180            240            300            400            180 Units to be produced        1,060        1,260        1,600        2,000        5,92 The Direct Materials Budget tells management how much...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT