On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the companys sales are made on account. The following information has been provided by Spicers Management:I"m having trouble filling in the chart. Any help would be great!

Chap 23 Operational Budgeting HW i 15 points \begin{tabular}{|c|} \hline eBook \\ \hline Print \\ \hline References \\ \hline \end{tabular} The company's collection activity on credit sales historically has been as follows: Spicer's total cash expenditures for March, April, and May have been estimated at $1,200,000 (an average of $400,000 per month). Its cash balance on March 1 of the current year is $500,000. No financing or investing activities are anticipated during the second quarter. Required: Compute Spicer's budgeted cash balance at the ends of March, April, and May. Chap 23 Operational Budgeting HW i 15 points \begin{tabular}{|c|} \hline eBook \\ \hline Print \\ \hline References \\ \hline \end{tabular} The company's collection activity on credit sales historically has been as follows: Spicer's total cash expenditures for March, April, and May have been estimated at $1,200,000 (an average of $400,000 per month). Its cash balance on March 1 of the current year is $500,000. No financing or investing activities are anticipated during the second quarter. Required: Compute Spicer's budgeted cash balance at the ends of March, April, and May