a) What are the total expected cash collections for the year under this revised budget?Expected cash collections for the year __________________b) What is the total required production for the year under this revised budget?Total required production for the year ____________________c) What is the total cost of raw materials to be purchased for the year under this revised budget?Total cost of raw materials to be purchased for the year __________________d) What are the total expected cash disbursements for raw materials for the year under this revised budget? Total expected cash disbursements for raw materials for the year _____________

Required information Chapter 8: Applying Excel (Algo) [LO8-2, LO8-3, LO8-4] The Chapter 8 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. Chapter 8: Applying Excel: Exercise (Part 2 of 2) (Algo) Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter Data 2 Budgeted unit sales 50,000 70,000 105,000 75,000 80,000 90, 000 Selling price per unit A B C D E F G 1 Chapter 8: Applying Excel 2 3 Data Year 3 Quarter 4 1 2 3 2 Budgeted unit sales 50,000 70,000 105,000 75,000 80,000 90,000 6 7 . Selling price per unit $ 7 per unit 8 Accounts receivable, beginning balance 65,000 9 Sales collected in the quarter sales are made 75% 10 Sales collected in the quarter after sales are made 25% 11 Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter Finished goods inventory, beginning 12,000 units 12 . Raw materials required to produce one unit 5 pounds 13 . Desired ending inventory of raw materials is 10% of the next quarter's production needs 14 . Raw materials inventory, beginning 23,000 pounds 15 . Raw material costs $ 0.80 per pound 16 . Raw materials purchases are paid 60% in the quarter the purchases are made 17 and 40% in the quarter following purchase 18 . Accounts payable for raw materials, beginning balance 81,500 19 a. What are the total expected cash collections for the year under this revised budget? Expected cash collections for the year