Chapter 8 Applying Excel Student For FORMULAS DATA REVIEW VIEW ACROBAT General HOME INSERT PAGE LAYOUT *Cut Arial - 10 A Copy BIU - Format Painter Clipboard Wrap Text Merge & Center - $ % . A Conditional Form Formatting" Tab Number - D Chapter 8: Applying Excel Year 2 Quarter Year 3 Quarter 3 Data 40.000 5 Budgeted unit sales 60.000 100.000 50,000 70.000 80.000 58 per unit 565.000 7 .Selling price per unit Accounts receivable beginning balance 9 . Sales collected in the quarter Sales are made 10 - Sales collected in the quarter after sales are made 11 - Desired ending fished goods inventory 12 - Finished goods inventory beginning 13 - Raw matens required to produce one unit 14 - Desired ending inventory of raw materials is 15 - Raw materials inventory beginning 16 - Raw matemal costs 17 - Raw materials purchases are paid 18 and 19 - ACCOUNts payable for raw materials, beginning balance 30% of the budgeted unit sales of the next quarter 12.000 units 5 pounds 10% of the next quarter's production needs 23 000 pounds 50 80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase 581.500 below 21 Ender a fomento each of the colls marked with 22 Review Probleme Budget Schedules 24 Construct the sales budget 26 Budgated unt sales 28 Total sales Chapter 8 Form Op