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 50,000 $7 65,000 115,000 75,000 90,000 100,000 D 1 Chapter 8: Applying Excel 3 Data Year 3 Quarter 1 4 5 Budgeted unit sales 50.000 65,000 115.000 75.000 90.000 100.000 S 7 . Selling price per unit 8 - 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 finished goods inventory is 12 - Finished goods inventory beginning 13 - Raw materials required to produce one unit 14 - Desired ending inventory of raw materials is 15 - Raw materials inventory, beginning 16 - Raw material costs 75% 25% 30% 12.000 of the budgeted unt sales of the next quarter units pounds of the next quarter's production needs 10% 23.000 pounds per pound