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 1 2 Budgeted unit sales 45,000 65,000 115,000 75,000 80,000 90,000 Selling price per unit $ G B E F D 2 Year 3 Quarter 4 75.000 80.000 1 2 65,000 3 115.000 2 50.000 45,000 $ $ 1 Chapter 8: Applying Excel 2 3 Data 4 5 Budgeted unit sales 6 7 Selling price per unit 8 Accounts receivable beginning balance 9 Sales collected in the quarter sales are made 10 Sales collected in the quarter after sales are made 11 Desired ending finished goods inventory is 12 - Finished goods inventory beginning 13 - Raw materials required to produce one unit 14 - Desired ending inventory of raw materials is 15 - Raw materials inventory beginning 16 - Raw material costs 17 - Raw materials purchases are paid 18 and 19 Accounts payable for raw materials, beginning balance 7 per unit 65.000 75% 25% 30% of the budgeted unit sales of the next Quarter 12.000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds 0.80 por pound 60% in the quarter the purchases are made 40% in the quarter following purchase 81,500 $ $ SN 2