the last picture is the requirments needed. i already did 1-5 but really confused on 5-10. please help me out.

Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations More Info - a. Actual sales in December were $76,000. Selling price per unit is projected to remain stable at $9 per unit throughout the budget period. Sales for the first five months of the upcoming year are budgeted to be as follows: January $ 80,100 February $ 89,100 March 82,800 April $ 85,500 May $ 77,400 b.Sales are 30% cash and 70% credit. All credit sales are collected in the month following the sale c.Dalley Manufacturing has a policy that states that each month's ending inventory of finished goods should be 10% of the following month's sales in units). d.of each month's direct material purchases, 20% are paid for in the month of purchase, while the remainder is paid for in the month following purchase. Two pounds of direct material is needed per unit at $1.50 per pound. Ending inventory of direct materials should be 20% of next month's production needs e. Most of the labor at the manufacturing facility is indirect, but there is some direct labor incurred. The direct labor hours per unit is 0.03. The direct labor rate per hour is $13 per hour. All direct labor is paid for in the month in which the work is performed. The direct labor total cost for each of the upcoming three months is as follows: January $ 3,510 February $ 3,834 March S 3,600 f. Monthly manufacturing overhead costs are $6,500 for factory rent, $2,900 for other fixed manufacturing a 63 acturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to D g's operations icon to view the data.) (Click the icon to view additional data.) uirements Data Table -X 1. Prepare a ter in total Fd $ $ 4,460 48,000 15,700 $ Current Assets as of December 31 (prior year) Cash Accounts receivable, net Inventory Property, plant, and equipment, net Accounts payable Capital stock Retained earnings $ 123,000 $ 43,000 ollections $ 125,500 23,200 at 2. Prepare a Print Done For the Quarter Ended marchT Month umber in the edit fields and then continue to the next question. @ 63 Cho 5. Prepare a cash payments budget for direct labor. 6. Prepare a cash payments budget for manufacturing overhead costs. 7. Prepare a cash payments budget for operating expenses 8. Prepare a combined cash budget 9. Calculate the budgeted manufacturing cost per unit (assume that fixed manufacturing overhead is budgeted to be $0.90 per unit for the year) 10. Prepare a budgeted income statement for the quarter ending March 31 (Hint: Cost of goods sold = Budgeted cost of manufacturing one unit x Number of units sold) Print Done Month Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertaint Manufacturing's operations (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements ed Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total Dalley Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month March Quarter January 24030 Cash sales February 26730 56070 24840 62370 75600 166440 48000 Credits sales 72030 82800 87210 242040 Total cash collections Requirement 2. Prepare a production budget. (Hint Unit sales = Sales in dollars / Selling price per unit.) Dalley Manufacturing Production Budget For the Quarter Ended March 31 Month OR Enter any number in the edit fields and then continue to the next question. a 64 hp) Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dal Manufacturing's operations: (Click the icon to view the data) Click the icon to view additional data.) Read the requirements Requirement 2. Prepare a production budget. (Hint Unit sales - Sales in dollars / Selling price per unit) Dalley Manufacturing Production Budget For the Quarter Ended March 31 Month Quarter January 8900 990 February 9900 March 9200 28000 920 950 950 Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce 9890 10820 10150 28950 1744 990 920 1744 8146 9830 9230 27206 Requirement 3. Prepare a direct materials budget. (Round your answers to the nearest whole dollar.) Dalley Manufacturing Direct Materials Budget Earthenortar Ended March 21 Enter any number in the edit fields and then continue to the next question. a 64 Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations E (Click the icon to view the data.) (Click the icon to view additional data) Read the requirements Direct Materials Budget For the Quarter Ended March 31 Month January February March Quarter Units to be produced 8146 9830 9230 27206 2 2 2 2 Multiply by: Quantity (pounds) of DM needed per unit Quantity (pounds) needed for production 16291 19660 18460 54411 3932 3692 3764 2823 Plus Desired ending inventory of DM Total quantity (pounds) needed 20223 23352 22224 57234 3258 3923 3692 3258 Less: Beginning inventory of DM Quantity (pounds) to purchase 16965 19420 18532 53976 1.5 1.5 1.5 1.5 Multiply by Cost per pound 25447 29130 27798 80964 Total cost of DM purchases Requirement 4. Prepare a cash payments budget for the direct material purchases from Requirement 3. (Use the accounts payable balance at December 31 of prior year for the prior month payment in January) (Round your answers to the nearest whole dollar) Enter any number in the edit fields and then continue to the next question. a 64 PR hp Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations: E (Click the icon to view the data) (Click the icon to view additional data.) Read the requirements Requirement 4. Prepare a cash payments budget for the direct material purchases from Requirement 3. (Use the accounts payable balance at December 31 of prior year for the prior month payment in January) (Round your answers to the nearest whole dollar) Dalley Manufacturing Cash Payments for Direct Materials Budget For the Quarter Ended March 31 Month January February March Quarter 20% of current month DM purchases 5089 5826 5558 16473 23304 22238 45542 80% of last month's DM purchases 48089 29130 27796 105015 Total cash payments Requirement 5. Prepare a cash payments budget for direct labor. Dalley Manufacturing Cash Payments for Direct Labor Budget For the Quarter Ended March 31 Month Enter any number in the edit fields and then continue to the next question. a 64 . Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations (Click the icon to view the data.) (Click the icon to view additional data) Read the requirements For the Quarter Endea marcn 31 Month January February March Quarter 20% of current month DM purchases 5089 5826 5558 16473 80% of last month's DM purchases 23304 22238 45542 48089 29130 27796 105015 Total cash payments Requirement 5. Prepare a cash payments budget for direct labor Dalley Manufacturing Cash Payments for Direct Labor Budget For the Quarter Ended March 31 Month January February March Quarter 3176.94 3833.7 35997 1061034 Total cost of direct labor Requirement 6. Prepare a cash payments budget for manufacturing overhead costs. (Round your answers to the nearest whole dollar) Enter any number in the edit fields and then continue to the next question. a 64 hp)