Chapter 8: (Algo) Applying Excel: Exercise (Part 2 of 2) 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 2 2 Budgeted unit sales Selling price per unit 50,000 $7 65,000 105,000 70,000 80,000 95,000 1 Chapter 8: Applying Excel 2 3 Data 4 5 Budgeted unit sales A B D E F G 1 2 3 4 Year 3 Quarter 1 2 50,000 65,000 105,000 70,000 80,000 95,000 6 7 Selling price per unit $ 7 per unit 8 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 11 Desired ending finished goods inventory is 12 Finished goods inventory, beginning 25% 30% of the budgeted unit sales of the next quarter 12,000 units