Need help with this

Tyler Company budgets the following unit sales for the next four months: April, 3,500 units; May, 4,700 units; June, 6.600 units; and July. 2,400 units. The company's policy is to maintain finished goods Inventory equal to 40% of the next month's unit sales. At the end of March, the company had 1,400 finished units In Inventory. Prepare a production budget for each of the months of April. May. and June. TYLER COMPANY Production Budget April May June Budgeted sales units 3,500 4,700 6.600 Add: Desired ending inventory Next period budgeted sales units 4,700 6,600 2.400 Ratio of inventory to future sales 40 % 40 %% 40 % Desired ending inventory units 1,880 2,640 980 Total required units Less: Beginning inventory units Units to produceMCO Leather manufactures leather purses. Each purse requires 2 pounds of direct materials at a cost of $5 per pound and 0.7 direct labor hour at a rate of $17 per hour. Variable overhead is budgeted at a rate of $3 per direct labor hour. Budgeted fixed overhead Is $19,000 per month. The company's policy is to end each month with direct materials Inventory equal to 30%% of the next month's direct materials requirement. At the end of August the company had 2,820 pounds of direct materials In Inventory. The company's production budget reports the following. Production Budget September October November Units to produce 4,780 6,560 6,609 (1) Prepare direct materials budgets for September and October. (2) Prepare direct labor budgets for September and October. (3) Prepare factory overhead budgets for September and October. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Prepare direct materials budgets for September and October. MCO Leather Direct Materials Budget September October Units to produce 4.700 8.500 Materials required per unit (pounds) 2 Materials needed for production (pounds) 8.400 13,000 Add: Desired ending materials inventory 2.820 2.820 Total materials required (pounds) 12.220 15.820 Less: Beginning materials inventory Materials to purchase (pounds) 12.220 15,820 Materials cost per pound $ 5 5 Cost of direct materials purchases 61,100 5 79.100 Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and Interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 519,096 $ 466,980 February 412, 090 359,980 March 480, 800 535, 080 Kayak requires a minimum cash balance of $50,000 at each month-end. Loans taken to meet this requirement charge 1%%, Interest per month, pald at each month-end. The Interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $50,000 is used to repay loans at month-end. The company has a cash balance of $50.000 and a loan balance of $100 000 at January 1. Prepare monthly cash budgets for January. February, and March. (Negative balances and Loan repayment amounts (if any) should be Indicated with minus sign.! KAYAK COMPANY Cash Budget January February March Beginning cash balance S 60,000 Total cash available Total cash payments Preliminary cash balance Loan activity Ending cash balance Loan balance Loan balance - Beginning of month 100,000 Additional loan (loan repayment) Loan balance, end of monthKarim Corporation requires a minimum $8,400 cash balance. Loans taken to meet this requirement cost 1% Interest per month (pald at the end of each month). Any preliminary cash balance above $8,400 is used to repay loans at month-end. The cash balance on July 1 Is $8.800, and the company has no outstanding loans. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or Interest payments) follow. July August September Cash receipts $ 24,480 $ 32,480 Cash payments 28, 606 30,480 32,480 Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be Indicated with minus sign. Round your final answers to the nearest whole dollar.) KARIM CORPORATION Cash Budget July August September Beginning cash balance 8.800 5 3,400 3,400 Add: Cash receipts 24.400 32, 400 40,400 Total cash available 33.200 40,800 48.800 Less: Cash payments for Interest on loan All items excluding interest Total cash payments 0 Preliminary cash balance 5 B,400 Loan activity Additional loan (loan repayment) 3.800 1,982 1,838 Ending cash balance 5 8.400 5 8,400 14,544 Loan balance Loan balance - Beginning of month 0 5 3,800 1,962 Additional loan (loan repayment) 3.800 1,982 1,838 Loan balance - End of month 3,800 5 1,982