Chapter 8: Applying Excel: Exercise (Part 2 of 2) (Algo) 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 50,000 65,000 110,000 60,000 B0,000 90,000 Selling price per unit 52 C D E F G 1 Chapter 8 Applying Excel 2 3 Data 4 5 budgeted unit les 6 7 Selling price por unit 8 Accounts receivable beginning balance 9 Sales collected in the quarter sales are made 1 50.000 3 110,000 Year 3 Quarter 4 + 60,000 10,000 2 90.000 65,000 $ 5 7 per unit 65.000 75% Chapter 8: Applying Excel: Exercise (Part 2 of 2) (Algo) 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 50,000 65,000 110,000 60,000 B0,000 90,000 Selling price per unit 52 C D E F G 1 Chapter 8 Applying Excel 2 3 Data 4 5 budgeted unit les 6 7 Selling price por unit 8 Accounts receivable beginning balance 9 Sales collected in the quarter sales are made 1 50.000 3 110,000 Year 3 Quarter 4 + 60,000 10,000 2 90.000 65,000 $ 5 7 per unit 65.000 75%