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

Transcribed Image Text:

Constellation Corp. has projected production and sales in units for the three months ending 7/31 as as follows: Production Sales May June July 140,000 120,000 110,000 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 w are incurred and the balance in the following month. Selling and administrative expenses will amount to $95,000 per month. The 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 mon following the month of sale, and the remaining 15% in the second month following the month of sale. Accounts receivable on M $650,000 of which $185,000 was from March's sales and the remainder from April. Required: Prepare a schedule for Bach month showing budgeted cash disbursements for the Constellation Corp. Show all figures with 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 decima Use dollar signs for dollar figures. (4 Points) Constellation Corp. has projected production and sales in units for the three months ending 7/31 as as follows: Production Sales May June July 140,000 120,000 110,000 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 w are incurred and the balance in the following month. Selling and administrative expenses will amount to $95,000 per month. The 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 mon following the month of sale, and the remaining 15% in the second month following the month of sale. Accounts receivable on M $650,000 of which $185,000 was from March's sales and the remainder from April. Required: Prepare a schedule for Bach month showing budgeted cash disbursements for the Constellation Corp. Show all figures with 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 decima Use dollar signs for dollar figures. (4 Points)