A B D F G 1 Chapter 8: Applying Excel 2 3 Data Year 3 Quarter 4 1 2 3 4 1 2 5 Budgeted unit sales 45,000 65,000 110,000 75,000 85,000 100,000 6 $ 7 per unit $ 10 7. Selling price per unit 8 Accounts receivable, beginning balance 9 Sales collected in the quarter sales are made Sales collected in the quarter after sales are made 11 . Desired ending finished goods inventory is 12 . Finished goods inventory, beginning 13 - Raw materials required to produce one unit 14 Desired ending inventory of raw materials is 15 . Raw materials inventory, beginning 16 . Raw material costs 17 Raw materials purchases are paid 18 and 19 Accounts payable for raw materials, beginning balance 65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12.000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds 0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase 81,500 $ $ a. What are the total expected cash collections for the year under this revised budget? Expected cash collections for the year