"Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell C5 to 75,000 units. The required production for the year should be 274,000 units. The cost of raw materials to be purchased for the year should be $1,106,800, whereas the total cash disbursements for the year should be $1,095,980. If you do not get this answer, find the errors in your worksheet and correct them."

I did not get the correct answers and am lost.

https://docs.google.com/spreadsheets/d/1W7j-Z3KWN-4-iapRsTjCGPZdmLqDAe9QVHBY1M-lSCc/edit?usp=sharing

A B C D E F G H 1 Chapter 8: Applying Excel 3 Data Year 2 Quarter Year 3 Quarter 2 3 4 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 . Selling price per unit $8 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 12 . Finished goods inventory, beginning 12,000 units 13 - Raw materials required to produce one unit 5 pounds 14 . Desired ending inventory of raw materials is 10% of the next quarter's production needs 15 - Raw materials inventory, beginning 23,000 pounds 16 - Raw material costs $0.80 per pound 17 . Raw materials purchases are paid 60% in the quarter the purchases are made 18 and 10% in the quarter following purchase 19 . Accounts payable for raw materials, beginning balance $81,500 20 21 Enter a formula into each of the cells marked with a ? below 22 Review Problem: Budget Schedules 23 24 Construct the sales budget Year 2 Quarter Year 3 Quarter 25 1 2 3 4 2 6 Budgeted unit sales 27 Selling price per unit 28 Total sales 7 29 30 Construct the schedule of expected cash collections Year 2 Quarter 31 1 2 3 4 Year Accounts receivable, beginning balance 33 First-quarter sales 34 Second-quarter sales 35 Third-quarter sales 36 Fourth-quarter sales 37 Total cash collections ? ? ? 38 39 Construct the production budget Year 2 Quarter Year 3 Quarter 40 2 3 4 Year 1 2 41 Budgeted unit sales 42 Add desired finished goods inventory 13 Total needs 44 Less beginning inventory 15 Required production ?Fllglalglallllgiglgllglalglwl\"llgl3|$l3l$lal3l$ll3|3l$l$ilglilglwlllglmlhlmlhlmlgl Construct the sales budget Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales _ 7 7 7 7 7 7 Selling price per unit 7 7 7 7 7 7 Total sales 7 7 7 7 7 7 Construct the schedule of expected cash collections Year 2 Quarter 1 2 3 4 Year Accounts receivable, beginning balance 7 7 Firstquarter sales 7 7 7 Secondquarter sales _ 7 _ 7 7 Thirdquarter sales . . 7 7 _ 7 I Fourthquarter sales 7 7 I Total cash collections 7 7 7 7 7 Construct the production budget Year 2 Quarter Year 3 Quarter 1 2 3 4 Year 1 2 Budgeted unit sales 7 7 7 7 7 7 Add desired nished goods inventory 7 7 7 7 7 7 Total needs 7 7 7 7 _ 7 7 Less beginning inventory 7 7 7 7 7 7 Required production 7 7 7 7 7 7 Construct the rawr materials purchases budget Year 2 Quarter Year 3 Quarter 1 2 3 4 Year 1 Required production {units} 7 7 7 7 7 7 Raw materials required to produce one unit 7 7 7 7 7 7 Production needs [pounds] 7 7 7 7 _ 7 _ 7 Acid desired ending inventory of raw materials {pounds} 7 7 7 7 7 Total needs (pounds) 7 7 7 7 7 Less beginning inventory of raw materials {pounds} 7 7 7 7 7 Raw materials to be purchased 7 7 7 7 7 Cost of raw materials per pound 7 7 7 7 7 Cost of raw materials to be purchased 7 7 7 7 7 Construct the schedule of expected cash payments Year 2 Quarter _ 1 2 3 4 Year Accounts payable, beginning balance 7 7 Firstquarter purchases 7 7 7 Second-quarter purchases 7 7 7 Thirdquarter purchases 7 7 7 Fourth-quarter purchases 7 7 Total cash disbursements 7 7 7 7 7