Required:

1. Prepare a table that shows the computation of cash collections of its credit sales (accounts receivable) in each of the months of June and July. (Omit the "$" & "%" signs in your response.)

2.Prepare a table that shows the computation of budgeted ending inventories (in units) for April, May, June, and July. (Omit the "%" sign in your response.)

3.Prepare the merchandise purchases budget for May, June, and July. Report calculations in units and then show the dollar amount of purchases for each month

4.Prepare a table showing the computation of cash payments on product purchases for June and July.

5. Prepare a cash budget for June and July, including any loan activity and interest expense. Compute the loan balance at the end of each month.