please solve it all

blue sky crorbariob make one product and has provide the followinf inforamtion to help prepare the master budget for the next four months of opration

please solve it all

ket system Budgeted unit sales (all on credit): January February March April Raw materials requirement per unit of output Raw materials cost Direct labor requirement per unit of output Direct labor wage rate 9.500 9,900 10,600 12,600 3pounds $5.00per pound 2.2direct labor-hours $18.00per direct labor-bour Credit sales are collected: 40% in the month of the sale & 60% in the following month Raw materials purchases are paid: 30% in the month of purchase & 70% in the following month The ending finished goods inventory should equal 10% of the following month's sales. The ending raw materials intentory should equal 40% of the following month's raw materials production needs. Required: (LO 5) EXCEL a. What are the budgeted sales for February? b. What are the expected cash collections for February? c. According to the production budget, how many units should be produced in February? d. If 32,400 pounds of raw materials are needed for production in March, how many pounds of raw materials should be purchased in February? c What is the estimated cost of raw materials purchases for February? f. If the cost of raw material purchases in January is $145,680, then in February what are the total estimated cash disbursements for raw materials purchases? What is the total estimated direct labor cost for February assuming the direct labor workforce is adjusted to match the hours required to produce the forecasted number of units produced? Paragraph B TEE DII sn F10 FO F9 & 6 7 7 V 8 A 9 9 0 ket system Budgeted unit sales (all on credit): January February March April Raw materials requirement per unit of output Raw materials cost Direct labor requirement per unit of output Direct labor wage rate 9,500 9,900 10,600 12,600 3 pounds $5.00per pound 2.2direct labor-hours $18.00per direct labor-hour Credit sales are collected: 40% in the month of the sale & 60% in the following month Raw materials purchases are paid: 30% in the month of purchase & 70% in the following month The ending finished goods inventory should equal 10% of the following month's sales. The ending raw materials intentory should equal 40% of the following month's raw materials production needs. Required: (LO 5) EXCEL a. What are the budgeted sales for February? b. What are the expected cash collections for February? c. According to the production budget, how many units should be produced in February? d. If 32,400 pounds of raw materials are needed for production in March, how many pounds of raw materials should be purchased in February? c What is the estimated cost of raw materials purchases for February? f. If the cost of raw material purchases in January is $145,680, then in February what are the total estimated cash disbursements for raw materials purchases? B. What is the total estimated direct labor cost for February assuming the direct labor workforce is adjusted to match the hours required to produce the forecasted number of units produced? Paragraph BI SE do DII F9 F10 F FO 592 & 6 7 7 V 8 A 99 0 ket system Budgeted unit sales (all on credit): January February March April Raw materials requirement per unit of output Raw materials cost Direct labor requirement per unit of output Direct labor wage rate 9.500 9,900 10,600 12,600 3pounds $5.00per pound 2.2direct labor-hours $18.00per direct labor-bour Credit sales are collected: 40% in the month of the sale & 60% in the following month Raw materials purchases are paid: 30% in the month of purchase & 70% in the following month The ending finished goods inventory should equal 10% of the following month's sales. The ending raw materials intentory should equal 40% of the following month's raw materials production needs. Required: (LO 5) EXCEL a. What are the budgeted sales for February? b. What are the expected cash collections for February? c. According to the production budget, how many units should be produced in February? d. If 32,400 pounds of raw materials are needed for production in March, how many pounds of raw materials should be purchased in February? c What is the estimated cost of raw materials purchases for February? f. If the cost of raw material purchases in January is $145,680, then in February what are the total estimated cash disbursements for raw materials purchases? What is the total estimated direct labor cost for February assuming the direct labor workforce is adjusted to match the hours required to produce the forecasted number of units produced? Paragraph B TEE DII sn F10 FO F9 & 6 7 7 V 8 A 9 9 0 ket system Budgeted unit sales (all on credit): January February March April Raw materials requirement per unit of output Raw materials cost Direct labor requirement per unit of output Direct labor wage rate 9,500 9,900 10,600 12,600 3 pounds $5.00per pound 2.2direct labor-hours $18.00per direct labor-hour Credit sales are collected: 40% in the month of the sale & 60% in the following month Raw materials purchases are paid: 30% in the month of purchase & 70% in the following month The ending finished goods inventory should equal 10% of the following month's sales. The ending raw materials intentory should equal 40% of the following month's raw materials production needs. Required: (LO 5) EXCEL a. What are the budgeted sales for February? b. What are the expected cash collections for February? c. According to the production budget, how many units should be produced in February? d. If 32,400 pounds of raw materials are needed for production in March, how many pounds of raw materials should be purchased in February? c What is the estimated cost of raw materials purchases for February? f. If the cost of raw material purchases in January is $145,680, then in February what are the total estimated cash disbursements for raw materials purchases? B. What is the total estimated direct labor cost for February assuming the direct labor workforce is adjusted to match the hours required to produce the forecasted number of units produced? Paragraph BI SE do DII F9 F10 F FO 592 & 6 7 7 V 8 A 99 0