$1.$ Check your worksheet by changing the budgeted unit sales in Quarter $2$ of Year $2$ in cell C$5$ 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.