PLEASE ANSWER ALL 10 REQUIREMENTS

Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Nauam Mtamithrbitina Data table - : Requirements 1. Phepse a exhadule of cash colecticns for January. February and Mach. and for the qavier in xisl: 3. Prepere a direci miaterisis sucuet. 4. Phepsre a cash psymens budpet to. the drect msterial surchsees trem Requbement I IUse the 5. Puapore a cah paymens budoen for diect lasol 7. Pispare a cosh paymerss budpet for operasing tepenses. 3. Prepsre s combined cash budpet. budgeted on le \$timo per ant for lta yeat? Budgexd cost of inanufoctiring ons init a Mumber of ushs sold. More info a. Actuel seles in December were ST1,C00. Selirg price per unit is projected no remsin stable en 312 per unit throughout the budant oariod. Sakes tar tha first five months of tha upcoming yenr are budgated ta be as falows: b. Sales arn 35\% cash and ES\% cradit. Al crodi sales are collacted on tha manth follawing the saln. c. Devon Varufacturizg has a policy that states that each month's encing imentory of frished goods stould be 10 of of the foilawing month's sales (in unts). d, of each merth's direce materlal purchases 20 ars are paid for in the month of purchase, 'wile the remainder ks paid for in the manth folcwirg purchig6e. Thee pounds af cirect material s needed per unit at $2.00 pet pound. Ending inventary of drect materiels should be 20% of next month's procucticn needs. e. Mast of the labar al the manu/acturing facility is indirect, but there is some direct labor incurred. The direct labar hours per unt is 0.05. The direct labor rate per hour is $9 per haur. Ali dinct iabor is paid for in the month in atich the work is partormed. The elirect laber total cest for each of the uscaming three morhe ls ss folcws: 1. roantnry marungctunng ovemesc coats are 55.500 for factory rant. 52,500 far other fured manjfacturing axperses. and $1.10 pe urit for variable mernufacturing overhesd. No depreciation is included in these figures. Al expecises are paid in the month in which thay are insurred. c. Campunar equipment tor the adminlstrative offices wil be purchased in the upcoming quarter. In Jaruary, Davon Manudachuring wil purchase ecuperent for 55,000 (cash) while February's cash expendture will be 512,200 gnd Merchis cash expendibute wil be $16 tiveo. h.Operating expenses are budgeted oo be $1.25 per unit sold plus fured cperating expense8 of \$1.800 per menth. All aperating experses are gaid in the murth in which they ate incur ted. No depecistion is roduded in these fgures. L. Depreaiation on the builing and oquipment for the ganeral and admiristrative oftices is bucgatad bo be $5,100 tor the entire cuarte: wtich includes dearecistion on few acouisions J. Devon Manufacturing has a policy that the ending cash balance in each month must be at least $4,000. It has a line of credit with a local bank. The company can borrow in increments of $1,000 at the beginning of each month, up to a total outstanding loan balance of $110,000. The interest rate on these loans is 1% per month simple interest (not compounded). The company would pay down on the line of credit balance in increments of $1,000 if it has excess funds at the end of the quarter. The company would also pay the accumulated interest at the end of the quarter on the funds borrowed curing the quarter. k. The company's income tax rate is projected to be 30% of operating income less interest expense. The company pays $10,000 cash at the end of February in estimated taxes. Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Nauam Mtamithrbitina Data table - : Requirements 1. Phepse a exhadule of cash colecticns for January. February and Mach. and for the qavier in xisl: 3. Prepere a direci miaterisis sucuet. 4. Phepsre a cash psymens budpet to. the drect msterial surchsees trem Requbement I IUse the 5. Puapore a cah paymens budoen for diect lasol 7. Pispare a cosh paymerss budpet for operasing tepenses. 3. Prepsre s combined cash budpet. budgeted on le \$timo per ant for lta yeat? Budgexd cost of inanufoctiring ons init a Mumber of ushs sold. More info a. Actuel seles in December were ST1,C00. Selirg price per unit is projected no remsin stable en 312 per unit throughout the budant oariod. Sakes tar tha first five months of tha upcoming yenr are budgated ta be as falows: b. Sales arn 35\% cash and ES\% cradit. Al crodi sales are collacted on tha manth follawing the saln. c. Devon Varufacturizg has a policy that states that each month's encing imentory of frished goods stould be 10 of of the foilawing month's sales (in unts). d, of each merth's direce materlal purchases 20 ars are paid for in the month of purchase, 'wile the remainder ks paid for in the manth folcwirg purchig6e. Thee pounds af cirect material s needed per unit at $2.00 pet pound. Ending inventary of drect materiels should be 20% of next month's procucticn needs. e. Mast of the labar al the manu/acturing facility is indirect, but there is some direct labor incurred. The direct labar hours per unt is 0.05. The direct labor rate per hour is $9 per haur. Ali dinct iabor is paid for in the month in atich the work is partormed. The elirect laber total cest for each of the uscaming three morhe ls ss folcws: 1. roantnry marungctunng ovemesc coats are 55.500 for factory rant. 52,500 far other fured manjfacturing axperses. and $1.10 pe urit for variable mernufacturing overhesd. No depreciation is included in these figures. Al expecises are paid in the month in which thay are insurred. c. Campunar equipment tor the adminlstrative offices wil be purchased in the upcoming quarter. In Jaruary, Davon Manudachuring wil purchase ecuperent for 55,000 (cash) while February's cash expendture will be 512,200 gnd Merchis cash expendibute wil be $16 tiveo. h.Operating expenses are budgeted oo be $1.25 per unit sold plus fured cperating expense8 of \$1.800 per menth. All aperating experses are gaid in the murth in which they ate incur ted. No depecistion is roduded in these fgures. L. Depreaiation on the builing and oquipment for the ganeral and admiristrative oftices is bucgatad bo be $5,100 tor the entire cuarte: wtich includes dearecistion on few acouisions J. Devon Manufacturing has a policy that the ending cash balance in each month must be at least $4,000. It has a line of credit with a local bank. The company can borrow in increments of $1,000 at the beginning of each month, up to a total outstanding loan balance of $110,000. The interest rate on these loans is 1% per month simple interest (not compounded). The company would pay down on the line of credit balance in increments of $1,000 if it has excess funds at the end of the quarter. The company would also pay the accumulated interest at the end of the quarter on the funds borrowed curing the quarter. k. The company's income tax rate is projected to be 30% of operating income less interest expense. The company pays $10,000 cash at the end of February in estimated taxes