System ID 27048

Q4 Prepare a cash budget for the Ace Manufacturing Company, indicating receipts and disbursements for May, June, and July. Actual and forecasted sales are January $50,000 May $ 70,000 February 50,000 June 80,000 March 60,000 July 100,000 April 60,000 August 100,000 i. Accounts receivable: Sales equal to sum of last two digits of your System ID are on cash basis and remaining are credit sales. With respect to credit sales, 60 percent are collected in the month after the sale, 30 percent in the second month, and 10 percent in the third. Bad-debt losses are insignificant. ii. Cost of goods manufactured: 70 percent of sales: 90 percent of this cost is paid the following month and the remaining 10 percent one more month later. iii. Selling, general, and administrative expenses: $10,000 per month plus 10 percent of sales. . V. iv. All of these expenses are paid during the month of incurrence. Interest payments: A semiannual interest payment on $150,000 of bonds outstanding (12 percent coupon) is paid during July. An annual $50,000 sinking-fund payment is also made at that time. vi. Taxes: Income tax payments of $1,000 will be made in July