Requirement 2: The company just hired a new marketing manager who insists 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 3 12 Budgeted unit sales 45,000 65, 000 120,000 75 , 900 85, 000 90, 000 Selling price per unit LL m H Chapter 8: Applying Excel N Im Data Year 3 Quarter N m Budgeted unit sales 45,000 65,000 120,000 75,000 85.000 90.000 Selling price per unit 7 per unit . Accounts receivable, beginning balance 65,000 . Sales collected in the quarter sales are made 75% 10 Sales collected in the quarter after sales are made 25% . Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter - Finished goods inventory, beginning 12,000 units . Raw materials required to produce one unit . Desired ending inventory of raw materials is 10% of the next quarter's production needs Raw materials inventory, beginning 23,000 pounds - Raw material costs 0.80 per pound Raw materials purchases are paid 60% in the quarter the purchases are made CO and 40% in the quarter following purchase 19 . Accounts payable for raw materials, beginning balance 81,500