Data 1 Year 2 Our 2 3 00.000 100.000 4 50.000 Year Quarter 1 2 70,000 30.000 Buod nas 525000 75 Seling proper Accounts receivable beginning bare Sales collected in the sales are made Sales collected in regulate als we made Desired ending firshed goods inventory . Frished god invertory beginning Raw material required to produce ore unt Des red erdira etory of a Paw materia invertory beginning - Raw material Raw mater purchased - Accounts payable for a material bearing balance Construct the sales budget Budgeted units 30% of the budete un sales of the retur 12.000 5 pounds 10% of the returer's production need 23.000 pounds 500 per pound so in the quarter the purchase are made O in the water following the 581,500 Yew ? Que 2 3 40.000 100 000 50.000 53 50 70.000 Yow 2 Quarto 2 3 4 56.000 Year 259.000 Construct the raw materiale purchases budget Required production Raw matured to produce one unit Production de pode Add desired ending mentory of material pounds) Lees beginning nentory of water sounde) Raw materials to be purchased cost of raw materials to be purchased 46.000 20600 35.000 22.000 13.000 16.000 20000 2009 20 1600 20000 23.000 IN D 5002 500 Required: a) Prepare a Schedule of Expected Cash Collections for the quarters of Year 2. b) Prepare a Schedule of Expected Cash Payments for the quarters of Year 2. Assume the company intends to purchase a new equipment costing S439,000; you are required to advise the manager on this matter. Data 1 Year 2 Our 2 3 00.000 100.000 4 50.000 Year Quarter 1 2 70,000 30.000 Buod nas 525000 75 Seling proper Accounts receivable beginning bare Sales collected in the sales are made Sales collected in regulate als we made Desired ending firshed goods inventory . Frished god invertory beginning Raw material required to produce ore unt Des red erdira etory of a Paw materia invertory beginning - Raw material Raw mater purchased - Accounts payable for a material bearing balance Construct the sales budget Budgeted units 30% of the budete un sales of the retur 12.000 5 pounds 10% of the returer's production need 23.000 pounds 500 per pound so in the quarter the purchase are made O in the water following the 581,500 Yew ? Que 2 3 40.000 100 000 50.000 53 50 70.000 Yow 2 Quarto 2 3 4 56.000 Year 259.000 Construct the raw materiale purchases budget Required production Raw matured to produce one unit Production de pode Add desired ending mentory of material pounds) Lees beginning nentory of water sounde) Raw materials to be purchased cost of raw materials to be purchased 46.000 20600 35.000 22.000 13.000 16.000 20000 2009 20 1600 20000 23.000 IN D 5002 500 Required: a) Prepare a Schedule of Expected Cash Collections for the quarters of Year 2. b) Prepare a Schedule of Expected Cash Payments for the quarters of Year 2. Assume the company intends to purchase a new equipment costing S439,000; you are required to advise the manager on this matter