Return to our Required information Data Budgeted unit sales Selling price per unit 1 50,000 $7 Year 2 Quarter 2 3 4 70.000 120.000 75.000 Year 3 Quarter 1 2 85.000 90.000 F Chapter 8: Applying Excel G Data Year 3 Quarter - 2 2 70,000 Budgeted unit sales E 50,000 120,000 75,000 85,000 90,000 per unit $ 5 6 7 8 9 10 11 12 7 65,000 75% . Selling price per unit S - Accounts receivable, beginning balance . Sales collected in the quarter sales are made - Sales collected in the quarter after sales are made Desired ending finished goods inventory is Finished goods inventory, beginning 25% 30% 12,000 of the budgeted unit sales of the next quarter units