Managerial accounting help

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 140,000 120,000 110,000 Sales 120,000 103,000 130,000 Cash-related production costs are budgeted at $17 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 $95,000 per month. The accounts payable balance on May 1 totals $395,000, which will be paid in May. All units are sold on account for $35 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: 1. 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) 2. 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)