For example, in cell B$26$ enter the formula $"=$ B$5".$

Required:

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,007$ 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.