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 hetes payable Total current abilities Longters note payable Total liabilities Con Stock tained warnings Total tochtholder uity Total listies and oty 89,000 432,000 86,000 348,40 2:35.40 614,000 (see 457.000 5 1,334 5 17. 12 101.700 513.00 212, A2, 1192 To prepare a master budget for Apr May, and June of 2019. management gathers the following information 6. Sales for Match total 18.000 units Forecasted sales in units are as follows April 18.000 Moy. 17,000: June 20700 on July 10.000 Soies of 247000 units are forecasted for the entire year. The products caling price $35.00 unit and its totoroduct.com To prepare a master budget for April, May, and June of 2019, management gathers the following information a. Sales for March total 18,000 units. Forecasted sales in units are as follows: April 18,000; May, 17,000, June, 20700, and July 18,000 Sales of 247000 untts are forecasted for the entire year. The product's selling price is $30.00 per unit and its total product cost is $24.20 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 300 units, which complies with the policy. The expected June 30 ending raw materials Inventory is 4700 units. Raw materials cost $20 per unit. Each finished unit requires 050 units of raw materials c. Company policy calls 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 twentory is 14.400 units, which complies with the policy d. Each finished unit requires 6 50 hours of direct laborat a rate of $22 per hour e overhead is allocated based on direct labor hours. The predetermined variable overhead rate is $3.40 per direct labor hour Depreciation of $27.850 per month is treated as fixed foctory overhead, 1. Sales representatives commissions are 8 of sales and are paid in the month of the sales. The sales manager's monthly salary is $3700 9. Monthly general and administrative expenses include 519.000 samicutive salaries and 6 monthly interest on the long-term note payable h. The company expects 20% of sales to be for coin and the remaining Boon Credit Receivables are collected in full in the month following the sale (none are collected in the month of the cold 1. All raw material purchases are on credit and no payables are from any other transactions. One month's raw material purchases are fully paid in the next month ). The minimum ending cach balance for a month $55.000. If necessary, the comany borows enough cash using a short tem note to reach the minimum Short-term notes require an interest Dayment of not each month-end before any repayment the ending chance exceeds the minimum the web applied to regoying the short-term nato payable balance Weds of 57000 bre to be oeclared and old in May I No Coth payment for income taxes are to be made oring the second Calendar oubite income will be assessed at the Quarter and gnid in the colender quarter m Eiment purchases of 5137000 are budgeted for the last day one 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 9 Required 9 Required 10 Factory overhead budget. (Round per unit values to 2 decimal places) ZIQBY MANUFACTURING Factory Overhead Budget April May, and June 2010 April May June Total Labor hours Med Budgetdermed Bed 4 Heged