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 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) Assignment 2 Parts Constantin Correct reduction and sales in its for the momendingastos May June Uwy Doctor 140 000 120 000 110,000 Sales 120 000 103 000 190 000 Cachwed broduction costs are budgeted 117 Beritroduced of the production, 20 in the math which are read the balance Selling and admin will amount 100,000 per month The counts payable balance on May 10 300 000 which will be paid All units resort in counter 836 esch Caccions from all we budgeted aros in the month of 2011 in the month folowing the month of so, and the main on the second monitoring the month of Accounts receivable on May socce of which 1105,000 warum Marca's mother ton on Hequired 1 Porschule for each month showing budgeted cash disbursements for the Constellation Corp Show wires with no decocus scoltar sign to dolores point 2 shule for each monowing badpetas concepts for constatation Corp Show les who decimal pas dans for delines 1 Porta

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 17, 2024

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

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:

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)

Assignment 2 Parts Constantin Correct reduction and sales in its for the momendingastos May June Uwy Doctor 140.000 120.000 110,000 Sales 120.000 103.000 190.000 Cachwed broduction costs are budgeted 117 Beritroduced of the production, 20% in the math which are read the balance Selling and admin will amount 100,000 per month The counts payable balance on May 10 300.000 which will be paid All units resort in counter 836 esch Caccions from all we budgeted aros in the month of 2011 in the month folowing the month of so, and the main on the second monitoring the month of Accounts receivable on May socce of which 1105,000 warum Marca's mother ton on Hequired 1 Porschule for each month showing budgeted cash disbursements for the Constellation Corp Show wires with no decocus scoltar sign to dolores point 2. shule for each monowing badpetas concepts for constatation Corp. Show les who decimal pas dans for delines 1 Porta