This is the data. Need help solving all the dashed red. THANK YOU!!!

Chapter 8: Applying Excel Construct the raw materials purchases budget Required production (units) Raw materials required to produce one unit Production needs (pounds) Add desired ending inventory of raw materials (pounds) Total needs (pounds) -ess beginning inventory of raw materials (pounds) Raw materials to be purchased Cost of raw materials per pound Cost of raw materials to be purchased Construct the schedule of expected cash payments Accounts payable, beginning balance =irst-quarter purchases Second-quarter purchases Third-quarter purchases Eourth-quarter purchases Total cash disbursements Chapter 8: Applying Excel Construct the raw materials purchases budget Required production (units) Raw materials required to produce one unit Production needs (pounds) Add desired ending inventory of raw materials (pounds) Total needs (pounds) -ess beginning inventory of raw materials (pounds) Raw materials to be purchased Cost of raw materials per pound Cost of raw materials to be purchased Construct the schedule of expected cash payments Accounts payable, beginning balance =irst-quarter purchases Second-quarter purchases Third-quarter purchases Eourth-quarter purchases Total cash disbursements