Unde Capboard A1 Budgeting Data Budgeted unit sales D H KL M No Video Year 1 Quarter Year 2 Quarter 2 3 4 2 60,000 75,000 90,000 80,000 90,000 100,000 $7 per unit $65,000 75% 25% -Selling price per unt 9 Sales collected in the quarter sales are made 10 11 Desired ending finished goods inventory is 12 Accounts receivable, beginning balance i Sales collected in the quarter after sales are made Beginning finished goods inventory, Quarter 1 13 Raw materials required to produce one unit 14 Desired ending inventory of raw materials is Raw matenais inventory, beginning 20 Raw material costs Raw materials purchases are paid and Accounts payable for raw materials, beginning balance Review Problem: Budget Schedules 30% of the budgeted unit sales of the next quarter 12.000 5 pounds 10% of the next quarter's production needs 25,250 50.60 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $81.500 Construct the sales budget Budgeted unit sales Selling price per unit Total sales Construct the schedule of expected cash collections Accounts recevable, beginning balance First-quarter sales Second quarter sales 34 The quarter sales 35 Fourth quarter sales Tatal cash collections Year 1 Quarter Year 2 Quarter 2 3 Year 1 Quarter Year