800 points 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 3 Quarter Year 2 Quarter Budgeted unit sales 65,000 115,000 75.000 90.000 Selling price per unit $7 per unit Chapter 8: Applying Excel 3 Data Year 2 Quarter Year 3 Quarter Budgeted unit sales 7 Selling price per unit $7 per unit Accounts receivable, beginning balance $65,000 Sales collected in the quarter sales are made 75% 0 Sales collected in the quarter aher sales are made 11 .Desired endng snished goods inventory is 30% of the budgeted unit sales of the next quarter 2 Finished goods inventory, beginning 12,000 units 13 .Raw materials required to produce one unit 5 pounds Desired ending inventory of raw materials is 0% of the next quarters producton needs 15 "Raw materials inventory, beginning 23,000 pounds Raw material costs $0.80 per pound 7 Raw materials purchases 60% in the quarter the purchases are made 18 40% in the quarter following purchase 19 Accounts payable for raw materials, beginning balanoe Sa1 500 2 3 4 5 6 7 8 9