Previews Data:

A. Certain data from theBalnnce Sheerou March 31. 20 n: B. projected and actual sales for several months em] as: are: H \"A $30000 $03500 [E :m 500 $80100 $53 300 C. mmdatm l. I. Monthly.r sales are 20% in cash and 30% on credit. Credit sales from the previous month are charged in full in the following month (therefore. what is in accounts receivable at the end of March is 30% of March sales} | The gross prot margin generated by Ocorporation on its sales is 23%. . The ending inventory for each month is equal to 25% of the budgeted cost of sales for the next month. 40% of montth merchandise piu'chases are paid in the month of purchase and the remainder in the month following the purchase The expected monthly expenses are salaries S 9 100; advertising, 3 4,350 per month and remaining expenses (except depreciation) represent 9 % of sales It assumes that these expenses are paid every month (nothing is owed at the end of the month]. The depreciation expense is $10,000 for the quarter and includes the portion that corresponds to the assets acquired during the period. Cash equipment was acquired: 3 2,100 in April and $12,100 in Ma)r 20 xx. Management wishes to maintain a minimum cash balance at the end of each month of 3 8,000. when the business isinnnednfmoney. it can borrow from a local bank in increments of 3 1,000 at the beginning of each month up to a loan ceiling of$ 20,0007 The interest rate that the bank charges on these loans is 1% per month and the interest is paid next month (we assume that it is not compound interest and that each loan is made at the end of the month). The mpddixmds S 2100 June. Using the data and information from the JKL Corporation, and the results you obtained previously prepare the cash budget for the quarter ending in June. Use the following table as a. model: Q1933; m junta tom! Initial cash balance Cash collections Cash available Less outlays: Shopping administrative and sales Purchase of equipment Dividends Total disbursements Cash excess {deficiency} Financing: Loan Loan payments Interests Financing