Download the Applying Excel form and enter formulas in all cells that contain question marks.

For example, in cell B26 enter the formula "= B5".

Required:

1. 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.

Excel File Edit View Insert Format Tools Data Window Help Wed Nov 1 8:58 PM Ashley iMac Q = . . . AutoSave O OFF A B 9 9 . C ... 1 Chapter_8_Applying_Excel_Student_Form.xIs - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Automate Acrobat ? Tell me Share Comments A Cut Arial 10 AA 29 Wrap Text v General Comma [0] 2 Currency [0] 2 Currency 2 Normal_Proc... Percent 2 _ AutoSum . A Paste Copy Format Merge & Center $ ~ % " Conditional Format Normal Bad Good Neutral Calculation Insert Delete Format Fill Formatting as Table Clear v Sort & Select Analyze Data Create PDF and share link * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates Check for Updates A1 fx Chapter 8: Applying Excel AG AH Chapter 8: Applying Excel Data Year 2 Quarter Year 3 Quarter Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,00 . Accola price per a Accounts receivable, beginning balance 65,009 per unit . Sales collected in the q arter sales are made Sales collected in the quarter after sales ar . Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter Finished goods inventory, beginning 2,000 units rials required to produce one ur 5 pounds . Desired ending inventory of raw materials is 10% of the next quarter's production needs Raw materials inventory. beginning 3,000 pounds . Raw material costs $0.80 per pound . Raw materials purchases are paid and 60% in the quarter the purchases are made 40% in the quarter following purchase Accounts payable for raw materials, beginning balance $81.500 Enter a formula into each of the cells marked with a ? below Review Problem: Budget Schedules Construct the sales budget Year 2 Quarter Year 3 Quarter 5 Budgeted unit sales Selling price per unit Total sales Construct the schedule of expected cash collections Year 2 Quarter Year Accounts receivable, beginning balance First-quarter sales Fourth-quarter sales Total cash colections 9 Construct the production budget ar 2 Quarte Year 3 Quarter Year budgeted unit sales had desired finished goods inventory Total needs Required production Construct the raw materials purchases budget Year 2 Quarter Year 3 Quarter Year Required production (units) Raw materials require doaction needs (pou dd desired ending inventory of raw materials (pounds) Less beginning inventory of raw materials (pounds) Cost of raw mustHave Cost of raw materials to Construct the schedule of expected cash payments Year 2 Quarter Year Accounts payable, beginning balance First-quarter purchases Second-quaner purchases Third-quarter purchases Fourth-quarter purchases Total cash disbursements Chapter 8 Form + Ready Accessibility: Unavailable 100% OLOO NOV ... 1 stv