URGENT HELP PLEASE!!

Problem 20-4A (Algo) Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of Zigby Manufacturing prepared the following balance sheet for March 31. To prepare a matter bodget for Apnil, May, and June, managerent gathers the following information. a. Sales for March total 49,200 units, Budgeted saies in units follow Apeli, 49.200, May, 46.900; June, 48, 000, and Jhy, 49,200 The products seting price is $24.00 per unit and its total product cort is $19.85 per unit b. Raw materials invertory consists solely of direct materials that cost $20 per pound. Company policy calla for a given moeth's ending materials inventory to equal 50% of the next moneh's direct materials requirements. The March 31 raw materials irventory is 11.820 pounds. The budgeted June 30 ending raw materials inventory is 9.600 pounds. Each thished unit requires 0.50 pound of direct materials. c. Company policy calls for a olven month's ending frished goods inventory to equal sov of the next moneh's budgeted unit sales. The March 31 finsthed goods inventory is 39,360 units. d. Each finithed unit requires 0.50 hour of direct labor at a tate of $15 per hour. 6. The predetermined varlable overhesd rate is $2.70 per direct labor hour. Depreciation of $48,000 per month is the ony. Axed factory overhead atem. 1. Sales commissions of BX, of saies ere paid in the month of the salen. The sales managers monehly salary is $7,200 : 9. Monthy general and administrative expenses include $28,000 for administrative salares and 0.94 monthy interest on the longterm note payable. h. The company budgets 30x of sales to be for cash and the remaining 705 on creda. Credi sales are collected in full in the month following the sole ho credit sales are collected in the month of sale) 1. All Jaw materials purchases are on credit, and accounts payable are solely ted to rew muterials purchases. Rarw materialis purchases are foy paid in the next month (none are paid in the month of puichase) I. The minimum ending cash balance for all months is $96,000 if nechssary, the company bonows enouph cash using a loan to reach the minimum. Loans require an interest payment of 15 at each month-end pelore any reparymenti if the monthend preiminary caun balance exceeds the minimum, the excess wal be used to repay any louns. k. Bividends of $24,000 are budgeted to be declared and poild in May. i. No cash paymerts for income taes are budgeted in the second calendar quarter. income tax wir be assessed at 35% in the quarter and budgeted to be paid in the thind calendar quartec. m. Equpment purchases of $240,000 are budgeted for the last day of June. Complete this question by entering your answers in the tabs below. Sales budget. \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ ZIGBY MANUFACTURING } \\ \hline \multicolumn{5}{|c|}{ Production Budget } \\ \hline & April & May & June & Total \\ \hline \multicolumn{5}{|l|}{ Budgeted sales units } \\ \hline & & & & \\ \hline Next period budgeted sales units & 46,800 & 48,000 & 49,200 & \\ \hline Ratio of inventory to future sales & 80% & 80% & 80% & \\ \hline \multicolumn{5}{|l|}{ Desired ending inventory units } \\ \hline \multicolumn{5}{|l|}{ Total required units } \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Units to produce } \\ \hline &