As the information given earlier, I need help with these 3 parts to be specific.

Problem 20-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment, gross Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity 46,000 386,925 96, 290 327,831 857, 846 612,000 (156,000) 456, eee $ 1,313,846 $ 196,190 18,000 214,190 506,00 720,190 341,000 251,856 592,856 $ 1,313,046 To prepare a master budget for April, May, and June of 2017, management gathers the following information: 1. Sales budget. 2. Production budget. 3. Raw materials budget. 4. Direct labor budget. 5. Factory overhead budget. 6. Selling expense budget. 7. General and administrative expense budget. 8. Cash budget. 9. Budgeted income statement for the entire second quarter (not for each month separately). 10. Budgeted balance sheet. Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Required 9 Required 10 Cash budget. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.) Calculation of Cash receipts from customers: $ $ $ Total budgeted sales Cash sales Sales on credit April 552,750 165,825 386,925 May 519,750 155,925 363,825 June 541,750 162,525 379,225 30% 70% $ $ $ Total cash receipts from customers April May June 9. Budgeted income statement for the entire second quarter (not for each month separately). 10. Budgeted balance sheet. Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required S Required 6 Required 7 Required 8 Required 9 Required 10 Sales budget. (Round Budgeted unit price to 2 decimal places.) ZIGBY MANUFACTURING Sales Budget April, May, and June 2017 Budgeted Unit Sales Budgeted Unit Price $ April 2017 May 2017 June 2017 Totals for the second quarter 20,100 18,900 19,700 58,700 27.50 27.50 27.50 Budgeted Sales Dollars $ 552,750 519,750 541,750 $ 1,614,250 Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Required 9 Required 10 Production budget. Total Next month's budgeted sales (units) Ratio of inventory to future sales Budgeted ending inventory (units) Budgeted units sales for month Required units of available production Beginning inventory (units) Units to be produced ZIGBY MANUFACTURING Production Budget April, May, and June 2017 April May 18,900 19,700 70% 70% 13,230 13,790 20,100 18,900 33,330 32,690 14,070 13,230 19,260 19,460 June 20.100 70% 14,070 19,700 33,770 13,790 19,980 58,700 Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Required 9 Required 10 Raw materials budget. (Round per unit values to 2 decimal places.) June Total Production budget (units) Materials requirements per unit Materials needed for production Budgeted ending inventory Total materials requirements (units) Beginning inventory Materials to be purchased Material price per unit Budgeted raw material purchases ZIGBY MANUFACTURING Raw Materials Budget April, May, and June 2017 April May 19,260 19,460 0.50 0.50 9,630 9,730 4,865 4,995 14,495 14,725 4,815 4,865 9,680 9,860 $ 20 $ 20 $ 193,600 $ 197,200 19,980 0.50 9,990 4,600 14,590 4,995 9,595 20 191,900 29,135 20 $ 582,700 $ * Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Required 9 Required 10 Direct labor budget. (Round per unit values to 2 decimal places.) Total Budgeted production (units) Labor requirements per unit (hours) Total labor hours needed Direct labor rate (per hour) Budgeted direct labor cost ZIGBY MANUFACTURING Direct Labor Budget April, May, and June 2017 April May 19,260 19,460 0.50 0.50 9,630 9,730 $ 21 $ 21s $ 202,230 $ 204,330 $ June 19,980 0.50 9,990 21 209,790 29,350 $ 21 $ 616,350 Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Required 9 Required 10 Factory overhead budget. (Round per unit values to 2 decimal places.) Total ZIGBY MANUFACTURING Factory Overhead Budget April, May, and June 2017 May 9,630 9,730 $ 3.00 $ 3.00 $ 28,890 $ 29,190 25,440 25,440 Labor hours needed Variable factory overhead rate $ June 9,990 3.00 29,970 25,440 55,410 $ Budgeted fixed overhead 88,050 76,320 164,370 Budgeted total overhead $ 54,330 $ 54,630 $ S Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Required 9 Required 10 Selling expense budget. Total ZIGBY MANUFACTURING Selling Expense Budget April, May, and June 2017 April May $ 552,750 $ 519,750 6% 6% $ 33,165 $ 31,185 3,600 3,600 36,765 $ 34,785 Budgeted sales Sales commission percent Sales commissions Sales salaries Total budgeted selling expenses June $ 541,750 6% $ 32,505 3,600 $ 36,105 $ 96,855 10,800 107,655 $ Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Required 9 Required 10 General and administrative expense budget. ZIGBY MANUFACTURING General and Administrative Expense Budgets April, May, and June 2017 April May Salaries $ 18,000 $ 18,000 $ Interest on long-term note 2,530 2,530 Total budgeted G&A expenses $ 20,530 S 20,530 $ $ June 18,000 2,530 20,530 Total 54,000 7,590 61,590 $ Required 6 Required 8 > Cash budget. (Negative balances and Loan repayment amounts (if any) should be indicatel Calculation of Cash receipts from customers: $ $ $ Total budgeted sales Cash sales Sales on credit April 552,750 165,825 386,925 May 519,750 155,925 363,825 June 541,750 162,525 379,225 30% 70% $ S $ June Total cash receipts from customers April $ 165,825 386,925 $ 552.750 $ Current month's cash sales Collections of receivables Total cash receipts $ May 155,925 386,925 542.850 162,525 363,825 526,350 $ $ ZIGBY MANUFACTURING Cash Budget April, May, and June 2017 April 46.000 552,750 598.750 June Beginning cash balance $ $ Cash receipts from customers 96,145 542.850 638,995 140,560 526,350 666 910 Total cash available 196,190 197,200 209.790 202.230 Cash payments for Raw materials Direct labor Sales commissions Variable overhead General administrative salaries 38,765 x 193,600 204.330 34785 29.190 20.530 28.890 29.970 20.530 X 16.000 Dividends Purchases of equipment 136.000 529 595 498.435 140.580 37,315 Total cash payments Preliminary cash balance Additional loan (loan repayment) Ending cash balance 484,605 114,145 (18,000) 96,145 $ 140.500 $ 45,000 Loan balance - Beginning of month 0 18,000S (18000) Additional loan on repayment) 8685 Loan balance - End of month Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Required 9 Required 10 Budgeted Income statement for the entire second quarter (not for each month separately). (Round your final answers to the nearest whole dollar.) ZIGBY MANUFACTURING Budgeted Income Statement For Three Months Ended June 30, 2017 Operating expenses Total operating expenses 0 Required 8 Required 10 > Budgeted balance sheet. (Round your final answers to the nearest whole dollar.) ZIGBY MANUFACTURING Budgeted Balance Sheet June 30, 2017 Assets Total current assets Equipment, net Total assets Liabilities and Equity Liabilities Total current liabilities Stockholders' Equity Total Stockholders' Equity Total Liabilities and Equity Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required Budgeted balance sheet. (Round your final answers to the nearest whole dollar....... ZIGBY MANUFACTURING Budgeted Balance Sheet June 30, 2017 Assets Total current assets Equipment, net Total assets Liabilities and Equity Liabilities Total current liabilities Stockholders' Equity Total Stockholders' Equity Total Liabilities and Equity