aztec organization sells its item for $170 per unit. its genuine and planned deals pursue.are below

Units Dollars

April (actual) 4,000 $680,000

May (actual) 2,800 476,000

June (budgeted) 4,500 765,000

July (budgeted) 3,500 764,000

August (budgeted) 4,500 765,000

All deals are using a credit card. Ongoing knowledge demonstrates that 24% of credit deals is gathered in the long stretch of the deal, 46% in the month after the deal, 25% in the second month after the deal, and 5% demonstrates to be uncollectible. The item's price tag is $110 per unit., 60% of buys made in a month is paid in that month and the other 40% is paid in the following month. The organization has an approach to keep up a closure month to month stock of 24% of the following month's unit deals in addition to a wellbeing load of 170 units. The April 30 and May 31 genuine stock levels are predictable with this arrangement. Selling and regulatory costs for the year are $1,548,000 and are paid equitably during the time in real money. The organization's base money balance at month-end is $120,000. This base is kept up, if vital, by obtaining money from the bank. In the event that the equalization surpasses $120,000, the organization reimburses as a significant part of the advance as it can without going beneath the base. This sort of advance conveys a yearly 13% loan cost. On May 31, the advance equalization is $40,000, and the organization's money parity is $120,000. (Round definite responses to the closest entire dollar.)

Required:

Prepare table that shows the computation of cash collections of its credit sales (accounts receivable) in each of the months of June and July.

2. Prepare table that shows the computation of budgeted ending inventories (in units) for April, May, June, and July.

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 table showing the computation of cash payments on product purchases for June and July.

5. Prepare cash budget for June and July, including any loan activity and interest expense. Compute the loan balance at the end of each month. (Do not round intermediate calculations).