Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell C5 to 75,000 units. The total expected cash collections for the year should now be $2,085,000. 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.

Chapter 8: Applying Excel Enter a formula into each of the cells marked with a? below Review Problem: Budget Schedules Chapter 8: Applying Excel Enter a formula into each of the cells marked with a? below Review Problem: Budget Schedules