how do i do question 13 using the data above?

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 $ 57,000 464,000 91,600 380, 480 993, 080 634,000 (167,000) 467,000 $1,460,080 $ 206,300 29,000 235, 300 520,000 755, 300 352,000 352, 780 704, 780 $1,460,080 a. Sales for March total 23,200 units. Forecasted sales in units are as follows: April, 23,200; May, 17100; June, 21,900; and July 23,200. Sales of 257,000 units are forecasted for the entire year. The product's selling price is $25.00 per unit and its total product cost is $20.50 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 4,580 units, which complies with the policy. The expected June 30 ending raw materials inventory is 5,700 units. Raw materials cost $20 per unit. Each finished unit requires 0.50 units of raw materials. c. Company policy cells for a given month's ending finished goods inventory to equal 80% of the next month's expected unit sales, The March 31 finished goods inventory is 18,560 units, which complies with the policy. d. Each finished unit requires 0.50 hours of direct labor at a rate of $13 per hour. e. Overhead is allocated based on direct labor hours. The predetermined variable overhead rate is $4.40 per direct labor hour. Depreciation of $37,320 per month is treated as fixed factory overhead. 1. Sales representatives' commissions are 5% of sales and are paid in the month of the sales. The sales manager's monthly salary is $4,700 g. Monthly general and administrative expenses include $29,000 administrative salaries and 0.8% monthly interest on the long-term note payable h. The company expects 20% of sales to be for cash and the remaining 80% 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 $99,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 $27,000 are to be declared and paid in May. 1. 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 $147,000 are budgeted for the last day of June. 1) For Zigby's sales, complete the following: a) Complete the table below to determine the net sales amount for the special order. ZIGBY MANUFACTURING Special Order Number of Units (equals May's units from connect) 17,100 Sales Price per unit (from connect) 25.00 Gross Sales Revenue (multiply) 4.27500 Loss Discount (3% of Gross Sales Revenue) 2,825 Net Sales for Special Order (14,675 b) Complete the Revised Sales Budget below by including the "Net Sales for Special Order in the table below. ZIGBY MANUFACTURING Sales Budget April May and June 2019 Original Budgeted Net Sales for Special Sales Dollars Order $580,000 427,500 $414.675 547 500 1,555,000 Revised Net Sales April 2019 May 2019 June 2019 Totals for the 2nd quarter $580,000 842,175 547,500 1,969,675 2) Zigby's production manager has suggested that the company try to even out the production between April and May for this large order. Zigby typically produces enough finished goods to establish its desired ending finished goods inventory. Because the of the increased to May sales for the special order, management is concerned about the stress this order will put on April's production requirements. To accommodate this, Zigby's production manager has suggested the company try to even out the production between April and May. May's desired ending finished goods inventory will remain unchanged from their original production budget (connect). However, April's budgeted ending inventory units will only be increased by 8,000 units, rather than the targeted percentage relating to the special order. Complete the revised production budget below for the quarter. Note: Remember to add 8,000 units to Apriliending inventory as and double May's budgeted units sales (double May sales used on connect). You may want to refer to the schedules used in connect to assist in completion of the schedules here. I Total June 18,560 ZIGBY MANUFACTURING Change to smooth Production Budget April May, and June 2019 April May Budgeted ending inventory (calculate for 21 080 17,520 April row 3 of connect for May and Junie) Budgeted units sales for month 23,200 34 200 Required units of available production 44,880 51,720 Beginning inventory (units) (18,560) (21,680) Units to be produced during the month 26,320 30,040 21,900 40,460 (17,520) 22,940 79,300 3) To conserve cash, the purchasing manager has asked to reduce April and May's ending raw materials inventory to equal 30% (down from 50%) of next month's materials requirements. Junc ending raw materials inventory will remain unchanged (same as on connect). Note - This % changes the calculation of required ENDING INVENTORY of raw material (row 4 of the table) and DOES NOT change the raw material required per unit of production (row 2). This table is completed similarly to the budget table in connect. Additionally, the purchase department has negotiated a 5% discount on raw material if they purchases exceed 10,000 pounds in any given month. The 5% will be only for the pounds purchased over 10,000. (Pounds of material purchased - 10.000 pounds