need help if #9 is correct, if not how do i fix it?

9) Using the revised budgets, complete the revised cash budget. Remember, Zigby Manufacturing will need to maintain the indicated minimum cash balance (given on connect) at the end of each month. Outstanding short-term notes require an interest payment of 1% at each month-end (before any repayment). Repayments of short-term notes payable balance will be made only to the extend the ending cash balance exceeds the minimum required. This table is completed similarly to the budget table in connect May 199,780 552,576 752,356 June 183,635 764,160 947 795 Revised Cash Budget April, May, and June 2019 April Beginning cash balance 65,000 Cash receipts from customers 612,864 Total cash available 677,864 Cash payments for Raw materials 163,600 Direct labor 143,220 Variable overhead 54,684 Sales commissions 54,720 Sales salaries 4,500 General & administrative salaries 27,000 Dividends 0 Loan interest 270 Long-term note interest 3,090 Purchases of equipment 0 Total cash payments 451,084 Preliminary cash balance 226,780 Additional loan (loan repayment) (27,000) Ending cash balance 199,780 230, 180 146,300 55,860 76,800 4,500 27,000 25,000 0 3,090 255,512 138,380 52,836 55,200 4,500 27 000 0 0 3,090 145,000 681,518 266,277 568,730 183,635 0 183,635 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment 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 $ 65,000 437,760 90,200 308,028 900,988 630,000 (165,000) 465,000 $1,365,988 $ 204,500 27,000 231,500 515,000 746,500 350,000 269,488 619,488 $1,365,988 May June $ $ 217,046 April 65,000$ 154,016 547,200 514,560 612,200 668,576 417,600 634,646 Beginning cash balance Cash receipts from customers Total cash available Cash payments for: Raw materials Direct labor Variable overhead Sales commissions Sales salaries General & administrative salaries Dividends Loan interest Long-term note interest Purchases of equipment Shipping Total cash payments Preliminary cash balance Additional loan (loan repayment) Ending cash balance 204,500 99,220 37,884 54,720 4,500 27,000 0 194,700 114,950 43,890 38,400 4,500 27,000 25,000 0 3,090 0 270 3,090 0 218,800 125,730 48,006 55,200 4,500 27,000 0 0 3,090 145,000 0 627,326 7,320 47,680 55,000 0 0 451,530 431,184 181,016 (27,000) 154,016 217,046 0 $ 217,046 Total ZIGBY MANUFACTURING Revised Raw Materials Budget April, May, and June 2019 April May Production budget (units) 26,040 26,600 Materials requirements per unit 0.50 0.50 Materials needed for production 13,020 13,300 Budgeted ending inventory 5,320 5,032 Total materials requirements (units) 18,340 18,332 Beginning inventory (6,510) (5,320) Materials to be purchased 11,830 13,012 Material price per unit $20 $20 Budgeted raw material purchases $236,600 $260,240 June 25,160 0.50 12,580 5,500 18,080 (5,032) 13,048 $20 $260,960 37,890 $20 $757,800 5) The Direct Labor Budget will need to be updated for the changes to the production budget. This table is completed similarly to the budget table in connect. 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 2019 April May 26,040 26,600 0.50 0.50 13,020 13,300 $11 $11 $143,220 $146,300 June 25,160 0.50 12,580 $11 $138,380 38,900 $11 $427,900 6) Factory Overhead Budget will need to be updated for the production and labor requirement changes. This table is completed similarly to the budget table in connect. Total Labor hours needed Variable factory overhead rate Budgeted variable overhead Budgeted fixed overhead Budgeted total overhead ZIGBY MANUFACTURING Factory Overhead Budget April, May, and June 2019 April May 13,020 13,300 4.20 4.20 54,684 55,860 35,020 35,020 89,704 90,880 June 12,580 4.20 52,836 35,020 87,856 163,380 105,060 268,440 Note: The Selling Expense Budget and the General and Administrative Expense Budgets will not need to be revised. Make sure you use the information from the original budgets as prepared on connect. 7) The one-time order will be on account and Zigby's management is concerned about the strain on cash requirements this will have. To attempt to ease the situation, the company plans to intensify illam in nollation of 15% 8) Additionally, to conserve cash, the company has decided to delay payment for their raw material purchases. Where they were previously paying in the month after the purchases were made, the company will now only pay 80% of their purchases in the first month after the purchases are made. The remaining 20% will be paid in the second month after purchase. The March 31 accounts payable will be paid in accordance with this new policy (80% in April and the remaining 20% in May. Complete the following table to estimate the cash payments for RAW MATERIAL purchases in 4 above. The amounts from this table will be used in the revised cash budget in 8 below. Estimated Payments for Raw Material Purchases April May June June 30 Accounts Payable 163,600 40,900 189,280 March 31 Accounts Payable April purchases May Purchases June Purchases Total cash payments 47,320 208,192 52,048 260,960 313,008 163,600 230,180 255,512