please show calculations

yes the calculations are solved, I just need help answering the questions A-E

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 1 2 3 4 1 2 Budgeted unit sales 50,000 70,000 120,000 80,000 90,000 100.000 Selling price per unit S7 a. What are the total expected cash collections for the year under this revised budget? b. What is the total required production for the year under this revised budget? c. What is the total cost of raw materials to be purchased for the year under this revised budget? d. What are the total expected cash disbursements for raw materials for the year under this revised budget? e. After seeing this revised budget, the production manager cautioned that due to the limited availability of a complex milling machine, the plant can produce no more than 90,000 units in any one quarter. Is this a potential problem? If so, what can be done about it? D 1 Chapter 8: Applying Excel 2 3 Data 1 50,000 Year 2 Quarter 2 3 70,000 120,000 Year 3 Quarter 1 2 90,000 100,000 80,000 5 Budgeted unit sales 6 7. Selling price per unit 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 inventory beginning 13 - Raw materials required to produce one unit 24. 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 0 1 Enter a formula into each of the cells marked with a ? below 2 Review Problem: Budget Schedules 3 4 Construct the sales budget $7 per unit $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 Budgeted unit salos Selling price per unit Total sales 1 50,000 $7 $350,000 Year 2 Quarter 2 3 70.000 120.000 $7 $7 $490.000 $840,000 4 80,000 $7 $560,000 Year 3 Quarter 1 2 90,000 100.000 $7 $7 $630,000 $700,000 Construct the schedule of expected cash collections Accounts receivable, beginning balance First-quarter sales Second-quarter sales Third-quarter sales Fourth quarter sales Total cash collections Year 2 Quarter 1 F 2 3 4 Year 5 65,000 $ 65,000 262,500 S 87.500 350,000 367 500 $ 122,500 490,000 630,000 $ 210,000 840,000 420.000 420.000 $ 327,500 455,000 S 752,500 $.630,000 $ 2.165,000 A70 fx A. G H D E C A 1 50.000 21,000 71,000 12.000 59,000 Year 2 Quarter 2 3 70,000 120,000 36,000 24,000 106,000 144,000 21,000 36,000 85 000 108,000 80,000 27,000 107.000 24,000 83,000 Year 320,000 27.000 347,000 12,000 335.000 Year 3 Quarter 1 2 90,000 100,000 30.000 120,000 27 000 93 000 38 39 Construct the production budget 40 41 Budgeted unt sales 42 Add desired finished goods inventory 43 Total needs 44 Less beginning inventory 45 Required production 46 47 Construct the raw materials purchases budget 48 49 Required production (units) 50 Raw materiais 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) 55 Raw matenals to be purchased 56 Cost of raw materials per pound 57 Cost of raw materials to be purchased 58 59 Construct the schedule of expected cash payments 60 61 Accounts payable beginning balance 62 First quarter purchases 63 Second quarter purchases 64 Third-quarter purchases 65 Fourth-quarter purchases 66 Total cash disbursements 1 59,000 5 295,000 42.500 337,500 23.000 314,500 $0.80 5251,600 Year 2 Quarter 2 85,000 108,000 5 425,000 540,000 54.000 41,500 479,000 581,500 42.500 54,000 436.500 527,500 $0.80 $0.80 $349 200 $422,000 4 83,000 5 415,000 46,500 461,500 41,500 420,000 $0.80 $336,000 Yoar 3 Quarter Yoar 1 335.000 93,000 5 5 1,675,000 465,000 46,500 1,721,500 23.000 1.698,500 $0.80 $1,358,800 Year 2 Quarter 1 2 3 4 Year $ 81,500 $ 81,500 150,960 $ 100,640 251,600 209,520 $ 139.680 349,200 253,200 $ 168,800 422,000 201,600 201,600 $ 232,460 $ 310 160 $ 392 880$ 370,400 $ 1,305 900 7