Question
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started