Please show the formula that are used. Thanks!

8. Calculating Payments. Brunell Products has projected the following sales for the coming year: Q2 Q3 Sales $680 $765 $915 $840 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? Q2 Q3 Q4 Payment of accounts b. Rework part (a) assuming a 90-day payables period. c. Rework part (a) assuming a 60-day payables period