Can somebody please do 7-10

PLEASEEE 7-10

The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. 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 99,808 500,250 101, eee 482,500 1, 102,750 618,000 (159,eee) 459,000 $ 1,561,750 209,700 21,000 230,700 505,000 735,700 344,000 482,050 826,050 $ 1,561,750 To prepare a master budget for April, May, and June of 2019, management gathers the following information Check my a. Sales for March total 23.000 units. Forecasted sales in units are as follows: April, 23,000: May 19,000, June, 18,800, and July 23,000. Sales of 249,000 units are forecasted for the entire year. The product's selling price is $29.00 per unit and its total product cost is $25.00 per unit b. Company policy calls for a given month's ending raw materials inventory to equal 50% of the next month's materials requirements The March 31 raw materials inventory is 5.050 units, which complies with the policy. The expected June 30 ending raw materials inventory is 4.500 units. Raw materials cost $20 per unit. Each finished unit requires 0.50 units of raw materials c. Company policy calls for a given month's ending finished goods inventory to equal 70% of the next month's expected unit sales The March 31 finished goods inventory is 16,100 units, which complies with the policy. d. Each finished unit requires 0.50 hours of direct labor at a rate of $24 per hour. e. Overhead is allocated based on direct labor hours. The predetermined variable overhead rate is $3.60 per direct labor hour Depreciation of $24,320 per month is treated as fixed factory overhead. f. Sales representatives' commissions are 10% of sales and are paid in the month of the sales. The sales manager's monthly salary is $3,900 g. Monthly general and administrative expenses include $10,000 administrative salaries and 0.8% monthly interest on the long-term note payable h. The company expects 25% of sales to be for cash and the remaining 75% on credit. Receivables are collected in full in the month following the sale (none are collected in the month of the sale) 1. All raw materials purchases are on credit, and no payables arise from any other transactions. One month's raw materials purchases are fully paid in the next month j. The minimum ending cash balance for all months is $110.000. If necessary, the company borrows enough cash using a short-term note to reach the minimum. Short-term notes require an interest payment of 1% at each month-end (before any repayment). If the ending cash balance exceeds the minimum, the excess will be applied to repaying the short-term notes payable balance k. Dividends of $19.000 are to be declared and paid in May. L No cash payments for income taxes are to be made during the second calendar quarter Income tax will be assessed at 40% in the quarter and paid in the third calendar quarter m. Equipment purchases of $139,000 are budgeted for the last day of June Prey 1 of 2 Next > Required: Prepare the following budgets and other financial information as required. All budgets and other financial information should be prepared for the second calendar quarter, except as otherwise noted below. (Round calculations up to the nearest whole dollar, except for the amount of cash sales, which should be rounded down to the nearest whole dollar): 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 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 Sales budget. (Round Budgeted unit price to 2 decimal places.) ZIGBY MANUFACTURING Required 1 Required 2 Required 3 Required 4 Required 5 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 2019 Budgeted Budgeted Budgeted Unit Sales Unit Price Sales Dollars April 2019 23,000 $ 29.00 667,000 May 2019 19.000 29.00 551,000 June 2019 18.800 29.00 545.200 Totals for the second quarter $ 1.763 200 Required 2 > Required 1 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Required 9 Required 10 Production budget. May June Total 23,000 ZIGBY MANUFACTURING Production Budget April, May, and June 2019 April Next month's budgeted sales (units) 19,000 18,800 Ratio of inventory to future sales 70% Budgeted ending inventory (units) 13,3001 13.160 Budgeted units sales for month 23.000 19.0001 Required units of available production 36,300 32. 160 Beginning inventory (units) (16.100) (13,300) Units to be produced 20.2001 18.860 70% 16,100 18.800 34.900 13.160) 21.740 50 800 (Required 1 Required 3 > Prev 1 of 2 Next > Help Save & EX Chec Required 1 Required 2 Requiry 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 21740 ZIGBY MANUFACTURING Raw Materials Budget April, May, and June 2019 April May Production budget (units) 20.2001 18.860 Materials requirements per unit 1 0 .50 0.50 Materials needed for production 10.100 9 .430 Budgeted ending inventory 4,715 5,435 Total materials requirements (units) 14 815 14.865 Beginning inventory 5.050 (4.715) Materials to be purchased 9.765 10.150 Material price per unit is 208 208 Budgeted raw material purchases $ 195,300 5 203.000 0.50 1 0870 15 370 (5.435) 9935 208 198.700 5 $ 597000 Prev 1 of 2 Next > Ched Required 1 Required 2 Required 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.) June Total ZIBY MANUFACTURING Direct Labor Budget April, May, and June 2019 April May Budgeted production (units) T 20,2001 18,860 Labor requirements per unit (hours) 0.50 0.50 Total labor hours needed 10,1001 9.4301 Direct labor rate (per hour) 24 s 24 Budgeted direct labor cost $ 242.400 $ 226,320 21,740 0.50 10.870 2415 260, 880 $ 30.400 s $ 729 600 Check Required 1 Required 2 Required 3 Required 4 Required Required 6 Required 7 Required 8 Required 9 Required 10 Required 9 Factory overhead budget. (Round per unit values to 2 decimal places.) Total Labor hours needed Variable factory overhead rate Budgeted variable overhead Budgeted fored overhead Budgeted total overhead ZIGBY MANUFACTURING Factory Overhead Budget April, May, and June 2019 April May 10.1007 9430 $ 3.60 $ 3.60 $ 36,360 $ 33,948 $ 24 320 24320 60,680 $ 58,2685 $ 35 V 10.870 3.60 39,132 $ 24,320 634525 109.440 72.960 182,400 Help Save & E Ched Required 1 Required 2 Required 3 Required 4 Required 5 equired Required 7 Required 8 Required 9 Required 10 Selling expense budget. Total Budgeted sales Sales commission percent Sales commissions Sales salaries Total budgeted seling expenses ZIGBY MANUFACTURING Selling Expense Budget April, May, and June 2019 April May 5 667,000 $ 551000 10% 10% 66,700 S 55,100 3.900 3900 5 70,600 $ 59,000 $ 545,200 10% 54.520 3.900 58,420 S 176 120 11.700 $ 5 188,020 Saved Help Save & 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 Budget April, May, and June 2019 April May June Total budgeted G&A expenses (Required 6 Required 8 > Prev 1 of 2 Hii Next > repayment amounts if any) should be indeed with us on.) Cash buttort. (Neostre blancs and to Chuttamaha ! Total budged sales Cash is Sales on credit 25 Cumartmones caches Cactions of Tech ZEY MANUFACTURING - - Beginning change Cash payments for End Loan bine 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 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, 2019 Operating expenses Required a Required 10 > 1 of 2 Next > Budgeted balance sheet. (Round your final answers to the nearest whole dollar.) ZGBY MANUFACTURING Budgeted Balance Sheet June 30, 2019 Total current assets Equipment, net Total assets Liabilities and Equity Labilities Total current table Total Stockholders Equity Total abilities and Equity Required