Please use excel to solve and show the formulas

Rossdale Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales $940 $1,020 $980 $1,080 Sales in the year following this one are projected to be 20 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. (Do not round Intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) 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.) 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.) Q1 Q2 Q3 Q4 a. Payment of accounts b. Payment of accounts Payment of accounts c