E D F G c Production is scheduled at a level high enough to take care of current needs and to carry into each month 30% of the next month's unit sales, Direct materials, direct labot, and variable manufacturing overhead are estimated at S10, 88, and $3 per unit, respectively. Total fixed manufacturing overhead is budgeted at $520,000 per month. The inventory at January I consists of 20,000 units. IH 19 7 Sales for April, May, June, and July are estimated at 80,000,100,000, 95,000, and 110,000 units with a rate of $60 per unit, 9 Variable selling and administrative expenses are $20 per unit. Fixed selling and administrative expenses are $800,000 per month. a) Prepare a sales budget for the second quarter by month. 12 b) Prepare a schedule showing the budgeted production in units for April May, and Juno. 13 c) Prepare a schedule showing the budgeted cost of goods sold for the same three months. d) Prepare a budgeted income statement for the first quarter by month 15 16 Alt Problem A: Sales, Production, Cost of Goods Sold Budgets and Budgeted Income Statement 17 RD Company Sales Budget 20 For Second Quarter 21 April May June 2nd Quarter 22 Budgeted Sules in its 80,000 100,00 95,000 275.000 The month has been done for you 23 Ave Sales priceperunt $ 605 GO 24 Sales 4,800,000 1.00 5 16,500,000 25 20 27 CRD Company 30 Production Budget 20 For Second Quarter 30 April May 2nd Quarter 11 Sales in onits from sales budget 80,000 100.00 275.000 That has been for you! 32 Add desired ending finished goods in 30,000 10,000 WON TotalFished good intory needed 110,000 as Ondect: Bleished goods intory 20,000 36 for stor which include in problem meneem to be deducted as I Units to be producted 90.000 001 June + Alternate Problem A Problum D Probleme Alternate Problem nat ' ' $ 96 ) MAC Condo For CO 35 8 H 4 8 X D Make sure you fill in all Yellow cells. Yellow cells left blank will receive zero credit. 1 2 3 Alternate Problem A: CRD Company prepares monthly operating and financial budgets. Estimates of sales in units are made for each month. 59 points Production is scheduled at a level high enough to take care of current needs and to carry into cach month 30% of the next month's unit sales. Direct materials, direct labor, and variable manufacturing overhead are estimated at $10, $8, and $3 per unit, respectively. Total fixed manufacturing overhead is budgeted at $520,000 per month. The inventory at January I consists of 20,000 units, Sales for April, May, June, and July are estimated at 80,000, 100,000, 95,000, and 110,000 units with a rate of $60 per unit 9 Variable selling and administrative expenses are $20 per unit. Fixed selling and administrative expenses are $800,000 per month 11 a) Prepare a sales budget for the second quarter by month. 12 b) Prepare a schedule showing the budgeted production in units for April, May, and June. 13 c) Prepare a schedule showing the budgeted cost of goods sold for the same three months. 14 d) Prepare a budgeted income statement for the first quarter by month. 15 16 Alt Problem A: Sales, Production, Cost of Goods Sold Budgets and Budgeted Income Statement 17 18 CRD Company 19 Sales Budget 20 For Second Quarter 21 April May June 2nd Quarter 22 Budgeted Sales (in units) 80,000 100,000 95.000 275.000 The Best month has been done for 23 Avg. Sales price per unit $ 505 603 60 24 Sales revenue $ 4,800,000 6,000,000 5,700,000 $ 16,500,000 25 26 Alternate Problem A Problem D Problem Acte Problem x x G B C A D 13 2nd Quarter 275,000 (The first month has bee 16,500,000 11 a) Prepare a sales budget for the second quarter by month 12 b) Prepare a schedule showing the budgeted production in units for April, May, and June. c) Prepare a schedule showing the budgeted cost of goods sold for the same three months. 14 d) Prepare a budgeted income statement for the first quarter by month, 15 16 Alt Problem A: Sales, Production, Cost of Goods Sold Budgets and Budgeted Income Statement 17 18 CRD Company 19 Sales Budget 20 For Second Quarter 21 April May June 22 Budgeted Sales (in units) B0,000 100,000 95,000 23 Avg Sales Price per unit $ 605 GOS 60 24 Sales revenue $ 4,800,000 6,000,000 $ 5,700,000 25 26 27 CRD Company 28 Production Budget 29 For Second Quarter 30 April May June 31 Sales in units (from sales budget) 80,000 100,000 95.000 32 Add: desired ending finished goods inv. 30,000 30,000 28.500 33 next quarter's sales x 30%) 34 Total Finished goods Inventory needed 110,000 35 Deduct: Beg finished goods inventory (20,000) 36 previous ar ENDING balance except for 1st qtr which is given in problem and given in problem 37 Units to be producted 90.000 2nd Quarter 275,000 (The first month has (Remember to enter Alternate Problem A Problem D Problem E Alternate Problom D +