please help thank you! all 1 question,

multiple parts.

Aztec Company sells its product for $180 per unit. Its actual and budgeted sales follow. All sales are on credit. Collections are as follows: 30% is collected in the month of the sale, and the remaining 70% is collected in the the other 40% is paid in the month following purchase. The company has a policy to maintain an ending monthly inventory of 20% of expenses of $110,000 per month are paid in cast. Thery level of 1,200 units is consistent with this policy. Selling and administrative obtained at the end of any month when the prelimi. The company's minimum cash balance at month.end is $100,000. Loans are $100,000 is used to repay loans at month-end. This lory cash balance is below $100,000. Any prellminary cash balance above the company's cash balance is $100,000 Required: 1. Prepare a schedule of cash receipts from sales for each of the months of June and July. 2. Prepare the merchandise purchases budget for June and July. 3. Prepare a schedule of cash payments for merchandise purchases for June and July. Assume May's budgeted merchandise purcheses is $308,000 4. 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. Complete this question by entering your answers in the tabs below. Prepare a schedule of cash receipts from sales for each of the months of June and July expenses of $110,000 per month are paid in cash. The company's minimum cash balance at month-end is $100,000. Loans are obtained at the end of any month when the preliminary cash balance is below $100,000. Any preliminary cash balance above $100,000 is used to repay loans at monthend. This loan has a 1% monthly interest rate. On May 31 , the loan balance is $25,000, and the company's cash balance is $100,000. Required: 1. Prepare a schedule of cash receipts from sales for each of the months of June and July. 2. Prepare the merchandise purchases budget for June and July. 3. Prepare a schedule of cash payments for merchandise purchases for June and July. Assume May's budgeted merchandise purchases is $308,000 4. 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. Complete this question by entering your answers in the tabs below. Prepare a schedule of cash recelpts from sales for each of the months of June and July Required: 1. Prepare a schedule of cash receipts from sales for each of the months of June and July. 2. Prepare the merchandise purchases budget for June and July. 3. Prepare a schedule of cash payments for merchandise purchases for June and July. Assume May's budgeted merchanc purchases is $308,000. 4. Prepare a cash budget for June and July, including any loan activity and interest expense. Compute the loan balance at each month. Complete this question by entering your answers in the tabs below. Prepare the merchandise purchases budget for June and July. Complete this question by entering your answers in the tabs below. Prepare a schedule of cash payments for merchandise purchases for June and July, Assume May's budgeted merthandise purchases is $308,000. Prepare a cash budget for June and July, including any loan activity and interest expense. Compute the Ioan balance at the end of each month. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your answers to the nearest whole dollars.)