The accounting team at Concord Corp. plans to get a jump-start on its budget for the...

Transcribed Image Text:

The accounting team at Concord Corp. plans to get a jump-start on its budget for the second quarter, since the first quarter is going well. Team members want to make sure to determine the cash effects of the company's sales as well as its biggest production-related cash expenditure, direct materials. The team has gathered the following information: 1. 2. 3. 4. 5. The budgeted selling price for the year is $2.40 per unit. Sales volumes are budgeted as follows for the last month of quarter 1, for all of quarter 2, and for part of quarter 3. (a) March 24,200 April May 22,300 24,600 23,500 June July 24,800 August 22,600 Historically, 25% of Concord's sales are cash sales. Of the remaining credit sales, 40% are collected in the month of sale, while 56% are collected the following month. The remainder is deemed uncollectible. Management sets its ending FG Inventory goal at 10% of the following month's sales volume. The accounting team expects this policy will be met at the beginning of the second quarter. The target ending inventory for Concord's primary direct material is 20% of the following month's production needs, since it's not unusual for suppliers to stock out of this key resource. Each completed unit requires 4 pounds of DM at an expected cost of $0.20 per pound. Concord pays for 35% of its purchases in the month of purchase and 65% the month after purchase. Total budgeted purchases in March are $18,700. For all quarterly budgets, report monthly amounts as well as the total for the quarter. Prepare the sales forecast and corresponding cash receipts budget for Concord Corp. for its second quarter. (Round budgeted selling price per unit to 2 decimal places, e.g. 15.25.) $ $ Cash Collections Budget Beginning A/R (April) April cash sales. April credit sales May cash sales (Round answers to 2 decimal places, e.g. 15.25.) May credit sales June cash sales June credit sales April Total cash. receipts $ 22300 $ 2.4 53520 $ April $ May $ 24600 2.4 59040 May $ $ June $ $ 23500 2.4 56400 June $ $ Quarter $ 70400 2.4 168960 Qui Production Budget Purchases Budget $ $ April April $ $ May May $ $ June June Prepare Concord Corp's cash disbursements budget for the DM purchases for the second quarter. (Round answers to 2 decimal places, e.g. 15.25.) A/P balance from March April purchases May purchases June purchases Total cash disbursements April $ LA $ May LA $ LA June LA LA Calculate how much the total COGS per unit could be for the company to generate 40% gross margin on its sales. Considering the DM cost per unit already known, how much of this total COGS per unit is available to cover DL and MOH cost? (Round answers to 2 decimal places, e.g. 15.25.) ✓: M:[ eTextbook and Media $ $ The accounting team at Concord Corp. plans to get a jump-start on its budget for the second quarter, since the first quarter is going well. Team members want to make sure to determine the cash effects of the company's sales as well as its biggest production-related cash expenditure, direct materials. The team has gathered the following information: 1. 2. 3. 4. 5. The budgeted selling price for the year is $2.40 per unit. Sales volumes are budgeted as follows for the last month of quarter 1, for all of quarter 2, and for part of quarter 3. (a) March 24,200 April May 22,300 24,600 23,500 June July 24,800 August 22,600 Historically, 25% of Concord's sales are cash sales. Of the remaining credit sales, 40% are collected in the month of sale, while 56% are collected the following month. The remainder is deemed uncollectible. Management sets its ending FG Inventory goal at 10% of the following month's sales volume. The accounting team expects this policy will be met at the beginning of the second quarter. The target ending inventory for Concord's primary direct material is 20% of the following month's production needs, since it's not unusual for suppliers to stock out of this key resource. Each completed unit requires 4 pounds of DM at an expected cost of $0.20 per pound. Concord pays for 35% of its purchases in the month of purchase and 65% the month after purchase. Total budgeted purchases in March are $18,700. For all quarterly budgets, report monthly amounts as well as the total for the quarter. Prepare the sales forecast and corresponding cash receipts budget for Concord Corp. for its second quarter. (Round budgeted selling price per unit to 2 decimal places, e.g. 15.25.) $ $ Cash Collections Budget Beginning A/R (April) April cash sales. April credit sales May cash sales (Round answers to 2 decimal places, e.g. 15.25.) May credit sales June cash sales June credit sales April Total cash. receipts $ 22300 $ 2.4 53520 $ April $ May $ 24600 2.4 59040 May $ $ June $ $ 23500 2.4 56400 June $ $ Quarter $ 70400 2.4 168960 Qui Production Budget Purchases Budget $ $ April April $ $ May May $ $ June June Prepare Concord Corp's cash disbursements budget for the DM purchases for the second quarter. (Round answers to 2 decimal places, e.g. 15.25.) A/P balance from March April purchases May purchases June purchases Total cash disbursements April $ LA $ May LA $ LA June LA LA Calculate how much the total COGS per unit could be for the company to generate 40% gross margin on its sales. Considering the DM cost per unit already known, how much of this total COGS per unit is available to cover DL and MOH cost? (Round answers to 2 decimal places, e.g. 15.25.) ✓: M:[ eTextbook and Media $ $