Required information The Chapter 8 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter Data Budgeted unit sales Selling price per unit 45,eee 5, 120, eee .eee e .ee 100.ee Chapter 8: Applying Excel Year 3 Quarter Butgeted units 45.000 05.000 120,000 65.000 80,000 7 per unit 65.000 75% 7 Seling price per unit Accounts receivable beginning balance - Sales colected the sales are made 10 Sales colected the Greater sales are made 11-Desired ending finished goods inventory is 12 . Finished goods inventory beginning 13 - Raw materials required to produce one unit 30% of the budgeted unit sales of the next quarter 12.000 units 5 pound