Saved Help Save excel Chapter 8: Applying Excel (LO8-2, LO8-3, LO8-4) The Chapter 8 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. Chapter 8: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B26 enter the formula - B5". Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell C5 to 75,000 units. The required production for the year 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 be $1,095,980. If you do not get this answer, find the errors in your worksheet and correct them, Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click Save." You will use this worksheet to answer the questions in Part 2 upload a response file (15MB max) Choose File No file chosen download reference file Chapter 8 Applying_Excel_Student Form.xlsx 16 17 of 17 10 AA BTUA. A f x Chapter 8: Applying Excel Margo & Camera $ - % . Sonderform C. A1 x Year s of the rest quan Account beginning balance Bas colected in the vaneres are 10. Sal t ed in the quarter teresare made 11 - Desired energ e d goods inventory 12 Fished goods wertery beginning 13 - Raw materials quired to produce or und 14 Desired ending inventory of the materials 15 - Raw material tory beginning 16 Raw material oss 17 aw purchase paid 19 - Accounts payable for raw ma t eng balance 30% of the build 12.000 5 pounds 10% of the next product 80in the quarter the purchases and Pegguh e with a bow 21 Fra formulate the them 22 Review Problem Burt Schedules 14 Co t the sales budget 36 tedna 2 Berg priceperunt a ns 30 Construct the schedule 31 Accounts receiv expected cash i ng Consulte produtos de Add wedished goods Les begeninger Consulte raw materiale purchases ar Chapter 8 Form + Formatting C D E F 34 Second quarter sales 35 Third-quarter sales 36 Fourth quarter sales 37 Total cash collections 39 Construct the production budget 41 Budgeted unt sales 42 Add desired finished goods inventory 43 Total needs 44 Less beginning inventory 45 Required production 47 Construct the raw materials purchases budget 49 Required production units) 50 Raw materials required to produce one unit 51 Production needs (pounds) 52 Add desired ending inventory of raw materials (pounds) 53 Total needs pounds) 54 Less beginning inventory of raw materials (pounds) SS Raw materials to be purchased 56 Cost of raw materials per pound 57 Cost of raw materials to be purchased 59 Construct the schedule of expected cash paymen 61 Accounts payable beginning balance 62 First quarter purchases 63 Second quarter purchases 64 Third-quarter purchases 65 Fourth quarter purchases 66 Total cash disbursements Saved Help Save excel Chapter 8: Applying Excel (LO8-2, LO8-3, LO8-4) The Chapter 8 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. Chapter 8: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B26 enter the formula - B5". Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell C5 to 75,000 units. The required production for the year 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 be $1,095,980. If you do not get this answer, find the errors in your worksheet and correct them, Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click Save." You will use this worksheet to answer the questions in Part 2 upload a response file (15MB max) Choose File No file chosen download reference file Chapter 8 Applying_Excel_Student Form.xlsx 16 17 of 17 10 AA BTUA. A f x Chapter 8: Applying Excel Margo & Camera $ - % . Sonderform C. A1 x Year s of the rest quan Account beginning balance Bas colected in the vaneres are 10. Sal t ed in the quarter teresare made 11 - Desired energ e d goods inventory 12 Fished goods wertery beginning 13 - Raw materials quired to produce or und 14 Desired ending inventory of the materials 15 - Raw material tory beginning 16 Raw material oss 17 aw purchase paid 19 - Accounts payable for raw ma t eng balance 30% of the build 12.000 5 pounds 10% of the next product 80in the quarter the purchases and Pegguh e with a bow 21 Fra formulate the them 22 Review Problem Burt Schedules 14 Co t the sales budget 36 tedna 2 Berg priceperunt a ns 30 Construct the schedule 31 Accounts receiv expected cash i ng Consulte produtos de Add wedished goods Les begeninger Consulte raw materiale purchases ar Chapter 8 Form + Formatting C D E F 34 Second quarter sales 35 Third-quarter sales 36 Fourth quarter sales 37 Total cash collections 39 Construct the production budget 41 Budgeted unt sales 42 Add desired finished goods inventory 43 Total needs 44 Less beginning inventory 45 Required production 47 Construct the raw materials purchases budget 49 Required production units) 50 Raw materials required to produce one unit 51 Production needs (pounds) 52 Add desired ending inventory of raw materials (pounds) 53 Total needs pounds) 54 Less beginning inventory of raw materials (pounds) SS Raw materials to be purchased 56 Cost of raw materials per pound 57 Cost of raw materials to be purchased 59 Construct the schedule of expected cash paymen 61 Accounts payable beginning balance 62 First quarter purchases 63 Second quarter purchases 64 Third-quarter purchases 65 Fourth quarter purchases 66 Total cash disbursements