could you please solve applying excel for managerial accounting for managers, 4th edition chapter 9. it is page 415 on the book?

1 Chapter 9: Applying Excel 3 Data 5 Budgeted unt sales Year 2 Quarter 60.000 100.000 Yew 3 Quarter 70.000 80.000 40000 50000 $65.000 755 7 - Selling price per un 8 - Accounts receivable beginning balance 9 . Sales collected in the quarter sales are made 10. Sales collected in the quarter after sales are made 11 . Desired ending finished goods inventory is 12 - Finished goods inentory beginning 13 - Raw materials required to produce one unit 14 - Desired ending inventory of raw materiais 15 - Raw materials inventory beginning 16 - Raw matenal costs 17 - Raw materials purchases we paid 18 and 19 - Accounts payable for raw materials beginning balance 30% of the budgeted unt sales of the next quarter 12000 units 5 pounds 10% of the neat 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 581.500 21 Enter a formula into each of the cells marked with a 22 Review Problem: Budget Schedules below 24 Construct the sales budget 26 Budgeted unit sales 27 Seling price per unit 28 Total sales Year 2 Quarter 30 Construct the schedule of expected cash collections 32 Accounts receivable, beginning balance 33 First-quarter sales 34 Second-quarter sales 35 Third-quarter sales 36 Fourth quarter sales 37 Total cash collections 39 Construct the production budget 41 Budgeted unit Sales 42 Add desired finished goods inventory 43 Total needs 44 Less beginning inventory 45 Required production 47 Construct the raw materials purchases budger 49 Required production (units) 50 Ras materials required to produce one unit 51 Production needs pounds) 52 Add desired ending Inventory of raw materials (pounds) 53 Total needs (pounds) 54 Less beginning inventory of raw materials (pounds) 35 Raw materials to be purchased 56 Cost of raw materials per pound 57 Cast of materials to be purchased Ye2 Quarte 59 Construct the schedule of expected cash payments 61 Accounts payable, beginning balance 62 First quarter purchases 5 Second quarter purchases 54 The quarter purchases Funhouarter purchases 66 Tot cash disbursements Chapter Form For Chapter Form