i need answer please
For the next three months, the direct labour workforce will be paid for a minimum of 1,500 hours per month. At Royal, manufacturing overhead is applied to units of product on the basis of diroct labour hours. The variable manulacturing overhead rate is $20 per direct labour hour required. Fbred manufacturing overhead is $50,000 per month and includes $20,000 of noncash costs (primarly depreciation of piart ausets). At Royal, the selling and administrative expenses budget is divided into variable and foxed components The variable selling and administrative expenses are $0.50 por unit sold. Fixed selling and administrative expenses are $70,000 por month. The foxed selling and administrative expenses include $10,000 in costs - primarly depreciation - that ace not cash outlows of the current month. Royal: 1. Maintains a 16% open line of crodit for $75,000 2. Maintains a minimum cash balance of $30,000 3. Borrows on the first day of the month and repays loans on the last day of the month 4. Pays a cash dividend of $49,000 in Apeil 5. Purchases $143,700 of equipment in May and $48,300 in June (both purchases poid in cash) 6. Has an Apnl 1 cash balance of $40,000 1. Prepare a sales budget, by month and in total, for the quarter. Show the split between crodi sales and cash sales as well beginning with credit saves. 7. Prepare the manutacturing overhead budget. 8. Prepare the compeny's seling and administratve expense budget. 9. Prepare the cash budget. Cash disbursements and borrowings are to be entered as positve numbers. Repayments and interest are to be entered as negatve numbers: Try agafTry agalTn Try agalThy apal Tin Try agailiry agaitin 7. Prepare the manufacturing overhead budoet. Try agai Try agaitry try agai try agai try Try agai Try anaithy Try agai Try agaitry Try agaifry apaitry 8. Prepare the company's solling and administrative exnense hu irinet Try agai Try agaifry Try agailiry agaifry Thy agaiTry agai Try Try agai Try agai Try Try agaitry agal Try Thy agai Try agatiry : 9. Prepare the cash budget Cash disbursements and borrowings are to be entered as positve numbers. Repayments and interest are to be entered as neqative numbers 5. Prepare the expected cash disbursement budget. 6. Prepare the direct labour budget. 7. Prepare the manufacturing overhead budget. 9. Prepare the cash budget. Cash disbursements and borrowings are to be entered as positivn numbers. Repayments and interest are to be entered as negative numbers. Try agaiTry agai Try agaiThy Try agaitry agai Try agal Try Try agaitry agailfy agaitin 2. Prepare a schedule of expected cash collections, by thonth and in tatal. for the ouarter 3. Prepare a production budget for each of the months and the cuarter in total. Plaase enter 4. Prepare the direct materials budget. Please enter al numbers as posbve. Master Budget Comprohensive Exerclse Royal Company is proparing budgets for the quarter ending June 30 . Budgoted sales for the nont fiva mmath. -.. 80% of sales are on account. Royat's collection pattern is: 70% collected in the month of sale, 25% collected in the month following sale, and 5% uncollectible. The March 31 accounts recelvable balance of $30,000 will be collocted in full. The manogement at Royal Company wants ending inventory to be equal to 20% of the following month r budpated sales in units. On March 31, 4,000 units were on hand At Royal Company, five pounds of material are required per unit of product. Management wants materials on hand at the end of each month equal to 10% of the following month s production. On March 31, 13,000 pounds of material are on hand. Material cost is $0.40 per pound. Royal pays 50,40 per pound for its matarials. One-half of a month's purchases is paid for in the month of purchase; the other half is paid in the following monith The March 31 accounts payable balanco is $12,000. At Royal, each unit of product requiros 0.05 hours ( 3 minutos) of diroct labour. The Company has a "no iayoff" policy so all employees wil be paid for 40 hours of work each weok In exchange for the "no layoff policy, workers agree to a wage rate of $10 per hour regardless of the hours worked (po oventine pay) For the next three months, the direct labour workforce will be paid for a minimum of 1,500 hours per month