PLEASE SHOW FORMULA FOR EACH "?" THANK YOU

Chapter 8: Applying Excel 2 3 Data Year 2 Quarter Year? Quarley 4 5 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 6 7 . Selling price per unit $8 per unit - Accounts receivable, beginning balance $65,000 9 Sales collected in the quarter sales are made 75% 10 Sales collected in the quarter after sales are made 25% 11 Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter 12 - Finished goods inventory, beginning 12,000 units 13 Raw materials required to produce one unit 5 pounds 14 Desired ending inventory of raw materials is 107 of the next quarter's production needs 15 - Raw materials inventory, beginning 23,000 pounds 16 - Raw material costs $0.80 per pound 17 Raw materials purchases are paid 60% in the quarter the purchases are made 18 and 40% in the quarter following purchase 19 Accounts payable for raw materials, beginning balan $81,500 20 21 Enter a Kumwa ina eat the cells Maried with a hely 22 Review Problem: Budget Schedules 23 24 Construct the sales budger year 2 Qarley Year? Qualer 25 .? 26 Budgeted unit sales ? ? ? ? ? ? 27 Selling price per unit ? ? ? ? ? ? 28 Total sales ? ? ? ? ? ? 29 30 Construct the schedule of espected casta Year 2 Quarley 31 -7 year 32 Accounts receivable, beginning balance ? ? 33 First-quarter sales ? ? ? 34 Second-quarter sales ? ? ? 35 Third-quarter sales ? ? ? 36 Fourth-quarter sales ? ? 37 Total cash collections ? ? ? ? 38 39 Construct the production budger year 2 qaley year. Quarley 40 2 + year 41 Budgeted unit sales ? ? ? ? ? ? 42 Add desired finished goods inventory ? ? ? ? ? ? 43 Total needs ? ? ? ? ? ? 44 Less beginning inventory ? ? ? ? ? ? 45 Required production ? ? ? ? ? ? 46 47 Construct the var malerials purchases but year 2 Quarter year? Quayley 48 I 22 .? / 49 Required production (units) ? ? ? ? ? ? 50 Raw materials required to produce one unit ? ? ? ? ? ? 51 Production needs (pounds) ? ? ? ? ? ? 52 Add desired ending inventory of raw materials (pound ? ? ? ? ? 53 Total needs (pounds) ? ? ? ? ? 54 Less beginning inventory of raw materials (pounds) ? ? ? ? ? 55 Raw materials to be purchased ? ? ? ? ? 56 Cost of raw materials per pound ? ? ? ? ? 57 Cost of raw materials to be purchased ? ? ? ? ? 58 59 Construct the schedule of espected cashy Year 2 Quarley 60 .? + year 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 ? ? ? ? ? 67 ?