Aztec Company sells its product for $170 per unit. Its actual and budgeted sales follow. May (Actual) June (Budget) July (Budget) August (Budget) Sales units Sales dollars 1,800 $ 306,000 5,000 $ 850,000 4,000 $ 680,000 3,600 $ 612,000 All sales are on credit. Collections are as follows: 26% is collected in the month of the sale, and the remaining 74% is collected in the month following the sale. Merchandise purchases cost $110 per unit. For those purchases, 60% is paid in the month of purchase and the other 40% is paid in the month following purchase. The company has a policy to maintain an ending monthly inventory of 19% of the next month's unit sales. The May 31 actual inventory level of 950 units is consistent with this policy. Selling and administrative expenses of $129,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 month-end. This loan has a 0.5% monthly interest rate. On May 31, the loan balance is $36,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 $264,880. 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. Required 1 Required 2 Required 3 Required 4 Prepare a schedule of cash receipts from sales for each of the months of June and July. AZTEC COMPANY Schedule of Cash Receipts from Sales Sales Cash receipts from: Collections of current period sales Collections of prior period sales Total cash receipts May June July $ 306,000 $ 850,000 $ 680,000 $ 0 $ 0 < Required 1 Required 2 > Required 1 Required 2 Required 3 Required 4 Prepare the merchandise purchases budget for June and July. AZTEC COMPANY Merchandise Purchases Budgets Budgeted sales units Add: Desired ending inventory Next period budgeted sales units Ratio of inventory to future sale Desired ending inventory units Total required units June July 5,000 4,000 5,000 4,000 Less: Beginning inventory units Units to purchase Cost per unit Cost of merchandise purchases 5,000 4,000 $ 110 $ 110 EA $ 550,000 $ 440,000 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Prepare a schedule of cash payments for merchandise purchases for June and July. Assume May's budgeted merchandise. purchases is $264,880. AZTEC COMPANY Schedule of Cash Payments for Merchandise Purchases Merchandise purchases Cash payments for Current period purchases Prior period purchases Total cash payments for merch. purchases May June July $ 185,130 $ 0 $ 0 $ 0 $ 0 AZTEC COMPANY Cash Budget June and July June July Beginning cash balance Add: Cash receipts from sales Total cash available Less: Cash payments for: Selling and administrative expenses Interest expense Total cash payments Preliminary cash balance Additional loan (loan repayment) Ending cash balance Loan balance - Beginning of month Additional loan (loan repayment) Loan balance - End of month 0 0 $ 0 Loan balance June July 0