Prepare master budget for april, may, and june. Please see image $.$

The management of Zigby Manufacturing prepared the following balance sheet for Matehi' 31 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Equipment Less: Accumulated depreciation Total assets Balance Sheet March 31 labl lit j; and Equity $ 152,e ILiabivIlg AcCount$ 1.308, 720 foam" 374 *3 1.237 / 052 Comrt', 570, 1, 710 po elai q I i ty $ 763i8 12 j 2 16 272 833 272 To prepare a master budget for April, May, and June, management athers the 'i a. sales for March total 77,900 units. Budgeted sales in units 76,000; and July, 77,900, The b. Raw materials inventory consists solely of direct materialS thai osi 20 pet hdlgompany policy calls for a given month's ending materials inventory to equal 50% of the next montb'$ dire Olerial$. requirementS)Jhe March 31 raw materials inventory to i pounds, Each finished unit requires OSO is 18715 pounds. The budgeted June 30 ending raw material pound of direct materials. o 80% Of the next month's budgeted unit sales. c. Company policy calls for a given month's ending finished The March 31 finished goods inventory is 62,320 units d. Each finished unit requires 0.50 hour of direct labor e. 'The predetermined variable overhead rate is $2,79 pett, dlbo of $76,000 per month is the only fixed factory overhead item, f. Sales commissions of 8% of sales are paid in the menth Of g e $lieli The es manager's monthly salary is $11,400. g. Monthly general and administrative expenses include $45$09 salaries and 0.9% monthly interest on the long- h. The company budgets 30% of sales to be for cash credit Credit sales are collected in full in the month following the sale (no credit sales are collectedin i. All raw materials purchases are on credit, and account$ payabl $01eiy tiedio raw materials purchases. Raw materials purchases are fully paid in the next month (none ane paid th Ot purchase). j. The minimum ending cash balance for all months is $152 9001!! hc SSBry, 'the company borrows enough cash using a loan to reach the minimum. Loans require an interest payment "Of at monthnd ibefore any repayment). Ifthe month-end preliminary cash balance exceeds the minimum, the Will!} repay any loans. k. Dividends of $38,000 are budgeted to be declared and paid l. No cash payments for _income taxes are budgeted in the see;nd eplenidat quarter, Income tax will be assessed at 35% in the quarter and budgeted to be paid in the third calendar quarte*' m. Equipment purchases of $380,000 are budgeted for' the last day Of Required: 1. Sales budget, 2. Production budget, 3. Direct materials budget 4. Direct labor budget, 5. Factory overhead budget 6. Selling expense budget 7. General and administrative expense budgek. 8. Schedule of cash receipts, 9. Schedule of cash payments for direct 11. Budgeted income statement for entire seconf quarter (not monthly). 12. Budgeted balance sheet at June 30, Complete this question by entering your answers In the tabs below. Req3 Req 2 Req 4 Sales budget. ZIGBY MANUFACTURING Sales Budgets May Bu#ted sales units Selling price per unit Total budgeted sales Req 5 Req 6 Req 7 Req2 > Req 8 to 10 Reqll Req 12 June