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: Data Budgeted unit sales. Selling price per unit 1 2 3 4 5 6 7 8 9 10 11 12 13 11 Chapter 8: Applying Excel Data Budgeted unit sales A 1 45,000 $7 Year 2 Quarter 2 3 65,000 105,000 Selling price per unit Accounts receivable, beginning balance Sales collected in the quarter sales are made Sales collected in the quarter after sales are made Desired ending finished goods inventory is Finished goods inventory, beginning Raw materials required to produce one unit $ $ B 1 4 75,000 45,000 C 2 7 per unit 4.00/ 5 pounds Year 3 Quarter 1 80,000 65,000 2 90,000 D 3 105,000 E 4 65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 75,000 F Year 3 Quarter 1 80,000 G 2 90,000

reyute <. the company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping selling price from to would like use following projections in budget: a. what are total expected cash collections for year under this revised budget b. is required production c. cost of raw materials purchased d. disbursements>