Part 1

Constellation Corp. has projected production and sales in units for the three months ending 7/31 as as follows:

	May	June	July
Production	150,000	130,000	120,000
Sales	130,000	113,000	140,000

Cash-related production costs are budgeted at $20 per unit produced. Of these production costs, 25% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $85,000 per month. The accounts payable balance on May 1 totals $400,000, which will be paid in May.

All units are sold on account for $40 each. Cash collections from sales are budgeted at 65% in the month of sale, 20% in the month following the month of sale, and the remaining 15% in the second month following the month of sale. Accounts receivable on May 1 totaled $650,000 of which $185,000 was from March's sales and the remainder from April.

Required:

Prepare a schedule for each month showing budgeted cash disbursements for the Constellation Corp. Show all figures with no decimal places. Use dollar signs for dollar figures. (4 points)

Prepare a schedule for each month showing budgeted cash receipts for Constellation Corp. Show all figures with no decimal places. Use dollar signs for dollar figures. (4 Points)