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...
Period Sales ($million) 2017 Q1 2874 2017 Q2 3000 2017 Q3 2913 2017 Q4 2916 2918...
Period Sales ($million) 2017 Q1 2874 2017 Q2 3000 2017 Q3 2913 2017 Q4 2916 2918 Q1 2910 2018 Q2 3052 2018 Q3 3116 2018 Q4 3210 2019 Q1 3243 2019 Q2 3351 2019 Q3 3305 2019 Q4 3267 The above table represents the quarterly sales (measured in millions of dollars) for the Goodyear Tire from 2017 to 2019. Compute the 4-quarter moving average. Put your answers onto the table. Compute the 4-quarter centered moving average. Put your answers onto...
Direct Materials Budget For the year ending December 31, 2018 Plain t-shirts Q1 Q2 Q3 Q4...
Direct Materials Budget For the year ending December 31, 2018 Plain t-shirts Q1 Q2 Q3 Q4 Total Units to be produced 1060 1260 1600 2000 5920 Direct materials per unit 1 1 1 1 1 Production needs 1060 1260 1600 2000 5920 Desired ending inventory 126 160 200 106 106 Total needs 1186 1420 1800 2106 6026 Less beginning inventory 58 126 160 200 58 Direct materials to be purchased 1128 1294 1640 1906 5968 Cost per t-shirt $       3.00...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT