Managerial Accounting Chapter 9- Budget Excel Spreadsheet Complete and Return Course Mail Attachment Budgeted sales are expected to be April June August Selling Price 40,000 Units 30,000 Units 20,000 Units 35,000 Units 30,000 Units $20 Per unit Prepare the Budgets for second quarter!! All sales are on account. The company collects 60% in month of sale and 35% in the following month. The remaining 5% is uncollectable March 31 AR is 40,000 and all is collectable Month of sale Collections Following month collections 60% 35% Sales Budget April June Quarter 40,000 30,000 20,000 90,000 Budgeted sales in units Times selling price per unit Budgeted sells in dollars Check # 1,800,000 Schedule of Cash Collections ril Ma June Quarter AR $40,000 March 31 Balance April Sales May Sales June Sales Check # $1,610,000 Total Cash Collections Managerial Accounting Chapter 9- Budget Excel Spreadsheet Complete and Return Course Mail Attachment Budgeted sales are expected to be April June August Selling Price 40,000 Units 30,000 Units 20,000 Units 35,000 Units 30,000 Units $20 Per unit Prepare the Budgets for second quarter!! All sales are on account. The company collects 60% in month of sale and 35% in the following month. The remaining 5% is uncollectable March 31 AR is 40,000 and all is collectable Month of sale Collections Following month collections 60% 35% Sales Budget April June Quarter 40,000 30,000 20,000 90,000 Budgeted sales in units Times selling price per unit Budgeted sells in dollars Check # 1,800,000 Schedule of Cash Collections ril Ma June Quarter AR $40,000 March 31 Balance April Sales May Sales June Sales Check # $1,610,000 Total Cash Collections