1 Chapter 8: Applying Excel 46 Construct the raw materials purchases budget 48 49 Roquired production (units) 50 Raw materials roquired to produce one unit 51 Production noeds (pounds) 52. Add des red ending inventory of raw materials (pounds) 53 Total needs (pounds) 54 Less beginning inventory of raw materials (pounds) 55 Raw materials to be purchased 56 Cost of raw materials pee pound 57 Cost of raw materials to be purchased 59 Construct the schedule of expected cash payments 60 Accounts payable, beginning batanco 62 First-quarter purchases 63 Second-quarter purchases 64 Third-quarter purchases 65 Fourth-quarter purchases. 66 Total cash disbursements