Soprano Co. is in the process of preparing the second quarter budget for 2016, and the following data have been assembled:

econt quaa tie en assembled preparing h Sopiano Co es: n the praces ar piepai rK thtesettind cianter tunic el fur 2016 and the falkning data hav th e company selS sin le product at a seling nce or SM perunt The estimated sales volume or the next six months is as 010 5 8,100 units 9300 units 6.400 units 7 500 units July 10.100 units Augus 6,400 units A sales are on aco unt. The oam aws collection ex enen e has been that 44% 8 month's sales are collected n t sale, 51% are o ecled in the mon o own the sale and 5% a e uncallect ble t s expected that the net realizable value of acounts fece able e acccunts receivable less alkn uncalleclible accounts) will be $143,616 an March 31, 2016 Management's poicy 1s to maintain endng tinished oods inventory each month at a level equal to 5 % t he next mon h's budgeted Sales 'he tn hed oods nventory on Mar 3 2016, s ex ected to be 3 00 unns To makc one unit of nnshed p oduct. 4 pounds of maten is arc requred Management's policy o have cnough at nals on hand at e cnd of cach month to cqual 41% te nex month's cs me cd usage The aw mater s i emory IS C pected O bc 14 517 pounds on March 31 It is expected the month af obc 14,517 pounds on 01 33 449 on March 31 an ma ena purchases is ex ected to be a abe balance fo month The accouns o in o purchase the remainder is paid in the e mont r al purchases are paid orin 4 00 and 73% ound of raw mate al is The cost per c. Prepare a production budget in units, by month and in total, for the second quarter of 2016 Answer is complete but not entirely correct. Total May June April ,212 8,724 12,936 4,836 8,100 3,900 8,852 12,752 5.252 7,500 5.252 9,060 14,312 4,212 10,100 ginning inventory of finished goods Units to be produced Goods available for sale Desired ending inventory of finished 13,364 26,636 40,000 14,300 25,700 oods Quantity of goods d. Prepare a materials purchases budget in pounds, by month and in total, for the second quarter of 2016. (Do not round intermediate calculations.) Total May June April 14,517 Beginning inventory of raw materials Purchases of raw materials Raw materials available for use Desired ending inventory of raw materials Quantity of raw materials to be used in production 14,517 30,000 (15,483) e. Prepare a schedule of cash payments for materials, by month and in total, for the second quarter of 2016. (Do not round intermediate calculations.) Total Cash payments for: March purchases April purchases May purchases June purchases Total cash payments May June April