Chp 8-Apolying Excel 2 Part 2 of 2 5 poin Required information Chapter 8: (Algo) Applying Excel (LO8-2, LOB-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: (Algo) Applying Excel: Exercise (Part 2 of 2) Requirement 2: The company has just hired a new marketing meneger who insists that un sales can be dramaticaly ncreased by dropping the selling. price from $8 to $7. The marketing manager would like to use the following projections in the budget Roo Budgeted weit sales Selling price per unit R 0 1 Chapter 8: Applying Excel Mc Ain 2 Data 4 5 Budgeted und sales 6 7-Selling price per un A Your Quarter Your Quarter 1 2 115, 18, 98,000 98,092 37 8 Accounts recevable, beginning balance 9 Sales collected in the quaner sales are made 10 Sales colected in the saber ater sales a mace 11 Desred ending thehed goods inventory is 12 Fressed goods inventory, beginning 13 Raw materials required to produce one unt 14 Dered ending nventory of raw manis 15 Raw materials Inventory beginning 16 Raw mater co 17 Raw materials purchases are pai 18 115 19 Accounts payable for raw matenas, beginning balance B C D E F G T 2 3 4 45 000 20.000 115.000 70.000 $ 7 perur $ 55000 75% 25% 30% of the budgeted unit sales of the need quarter 12000 5 pounds 10% at the red que's pros 20.000 pounds 030 per poun 60% in the quarter the purchases are made 40% $1,900 quarter e. What are the total expected cash collections for the year under this revised budget? Expected cash collections for the ears 2.042.500 w Year 3 Quarter . 2 30.000 90.000 < Etey of 2 Next > Help Save & Exit Submit Check my work