Requirement 2: er would ke o use te following project ons in the budget. The com am has st hired a new marke n manager who m sts hat unit sa es can be dramatica y mcreased by dro ping he selling price from S8?S7 The marketing man Data Budgeted unit sales Year 2 Quarter Year 3 Quartes 45,000 65,000 105,000 70,000 85,000 100,000 Selling price per unit $7 per unit 1 Chapter 9: Applying Excel 3 Data Year 2 Quarter Year 3 Quarter 5 Bugeted unit sales 45,000 65,000 05,000 70,000 85,000 100,000 .Selling price per unit $7 per unit Accounts receivable, beginning balance $65,000 Sales colleced in the quarier sales are made 0Sale5 colectad in the quarter after sales are made 1Desired ending tinisned goods inventory is 2 Finished goods inventory, beginning 3Raw materials required to produce one uni 4Desired anding inventory of raw materials is 5 Raw matenals inventory, beginning 6Raw matenial costs 30% of the budgeted unrt sales ofthe next quarter 12,000 units 5 pounds 10% of the naxt quarter's production needs 23,000 pounds 50.80 per pound Raw materials purchapes are paid 18 and 19 ACCounts payable tor raw materials, beginning balance 60% in the quarter the purchases are made 40% in the quarter following purchase 581,500