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: Budgeted unit sales 50,000 65,000 115,000 70,000 85,000 95,000 $7 per unit Selling price per unit 1 Chapter 8: Applying Excel 3 Data Year 2 Quarter 5 Budgeted unit sales 50,000 115,000 70,000 65,000 7 Selling price per unit S7 per unit 8 Accounts receivable, beginning balance S65,000 75% 9 Sales collected in the quarter sales are made 10 Sales collected in the quarter after sales are made 25% 11 Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter 12 Finished goods inventory, beginning 12,000 units 5 pounds 13 Raw materials required to produce one unit 10% of the next quarters production needs 14 Desired ending inventory of raw materials is 15 Raw materials inventory, beginning 23,000 pounds 16 Raw material costs $0.80 per pound 17 Raw materials purchases are paid 60% in the quarter the purchases are made and 40% in the quarter following purchase 19 Accounts payable for raw materials, beginning balance S81,500 20 Year 3 Quarter 95,000 85,000