how do i do question 11 (last two pics) using the data above?

The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. led 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,00 235,300 520,000 755,300 352,000 352,780 704, 780 $1,460,080 arded 31 a. Sales for March total 23,200 units. Forecasted sales in units are as follows: April, 23,200; May, 17,100; 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 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 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. f. 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 9. 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). I. 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. CS nearest whole dollar.) ZIGBY MANUFACTURING Budgeted Income Statement For Three Months Ended June 30, 2019 Sales Cost of goods sold $1,555,000 1,275,100 279,900 $ Operating expenses Sales commissions Sales salaries General administrative salaries Bank loan interest expense Long-term note interest 77,750 14,100 87,000 290 12,480 BIO Total operating expenses Income before taxes Income tax Net income 191,620 88,280 35,312 DIO $ 52,968 ZIGBY MANUFACTURING Budgeted Balance Sheet June 30, 2019 Assets Cash $ Accounts receivable Raw materials inventory Finished goods inventory Total current assets 99,000 438,000 114,000 380,480 $1,031,480 $ 781,000 Equipment Accumulated depreciation Equipment, net (278,960) 502,040 Total assets $1,533,520 $ 228,700 18,760 Liabilities and Equity Liabilities Accounts payable Bank loan payable Income taxes payable Total current liabilities Long-term note payable Stockholders' Equity 35,312 282,772 520,000 Common stock $ 352,000 378,748 Retained earnings Total Stockholders' Equity Total Liabilities and Equity 730,748 $1,533,520 The Company has been approached by a wholesaler requesting a one-time special order to be delivered at the end of May. The special order equals the number of units originally budgeted for May. This will effectively double May's projected sales. The special order will be sold on account at a discount. The discount will be 3% of the normal selling price per unit. Additionally, because this special order was negotiated with Zigby's management, there will be NO sales commissions for this sales revenue. Because the company is limited to $50,000 short-term borrowings, executive management is concerned about the cash strain this order will put on their operations for the quarter and has made some suggestions regarding the master budget. You will need to revise the master budget as indicated below. 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) 427,500 Less Discount (3% of Gross Sales Revenue) 12,825 Net Sales for Special Order 414,67 b) Complete the Revised Sales Budget below by including the "Net Sales for Special Order" in the table below Revised Not Sales 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 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 April ending inventory units 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. 1 May Total ZIGBY MANUFACTURING Change to smooth Production Budget April, May, and June 2019 April Budgeted ending inventory (calculate for 21.680 Aprit, row 3 of comect for May and June) 17,520 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 June 18,560 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 purchasc 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 X520 per pound x5% Calculate the Discount for each month and calculate the "net" purchase amount. IF Project 4: Page 2 of 11 Total June 22,940 ZIGBY MANUFACTURING Revised Raw Materials Budget April May Production budget (units) 26,320 30,040 Materials requirements per unit (funchanged from connect) .50 .50 Materials needed for production 13,160 15,020 Budgeted ending inventory 4,506 3,441 Total materials requirements (units) 17,666 18,461 Beginning inventory 4.580 14.506) Materials to be purchased 13,086 13,955 Material price per unit $20.00 $20.00 Raw Material purchases before Discount $261,720 $279,100 Discount (5% of purchases exceeding 50086 $3959 10,000 lbs Budgeted raw material purchases $258,634 $275,145 .50 11.470 5,700 17,170 (3.441) 13,729 $20.00 40,770 $20.00 $274,580 $815,400 $3.72910,770.00 $270,851 $804,630 4) To maintain moral among their employees, Zigby has agreed to pay employees a wage premium of $3 an hour for excess overtime. Excess overtime has been defined as any hours in excess of 13,000 hours in a month. The Direct Labor Budget will need to be updated for the changes to the production budget and the wage premium added for each month. This table is completed similarly to the budget table in connect Total Budgeted production (units) Labor requirements por unit (hours) Total labor hours needed Direct labor rate (per hour) Base direct labor cost Wage premium (3xhours over 13,000) Total Budgeted direct labor costs ZIGBY MANUFACTURING Revised Direct Labor Budget April May 26,320 30,040 .50 .50 13,160 15,020 13 13 171,080 195,260 480 8,060 171,560 201,320 June 22,940 50 11,470 13 149,110 0 149.110 521,990 I 5) 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 Revised Factory Overhead Budget April May 13 160 15,020 4.20 4.20 55,272 63,084 37,320 37 320 92,592 100,404 June 11,470 4.20 48,174 37320 85,494 166,530 111,960 278,490 6) The spocial order will be on account and the customer is not expected to pay until June. Zigby's management plans to compensate by intensifying collections efforts on their other customers by sending bills out sooner. Management feels these efforts will result in collection of 20% of the credit sales in the month of sale. (This will be in addition to the cash sales for the month). The remainder of credit sales will be collected in the subsequent month. All of Murch 31" receivables are expected to be collected in April. May special order is expected to be collected in June. Complete the tables below to revise the estimate of credit sales. The one-time sale is considered credit ZIGBY MANUFACTURING Revised Cash Receipts from Customers April May June Current month's cash sales (from conned) 116,000 85,500 109,500 Current month's credit sales collected 92,800 68,400 87,600 (20% of current months credit sales) Previous month's credit sales collected 464,000 371,200 273,600 (80% of previous months sales) Special order collected in June 414,675 Total cash receipts 672,800 525,100 885,375 7) Additionally, to conserve cash, the company has decided to delny payment for their raw material purchases. The company previously paid 100% of their raw material purchases (revised budget in 3) in the month after the purchase was made. Starting with March purchases (Accounts Payable balance at 3/31), Zigby plans to 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 (Example: 80% of accounts payable on March 31 will be paid in April and the remaining 20% will be paid in May. April sales will be paid in May and Junc, etc.) Remember: Purchases budgeted in 3 increased accounts payable (credit) while estimated payments here decreases accounts payable (debit). June 30 Accounts Payable ZIGBY MANUFACTURING Estimated Payments for Raw Material Purchases April May June March 31 Accounts Payable 165,040 41,260 April purchases 206,907 51,727 May Purchases 220,116 June Purchases Total cash payments 165,040 248,167 271,843 55,029 270,851 325,880 8) 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 256,746 525,100 781,846 June 200,056 885,375 1,085,431 ZIGBY MANUFACTURING Revised Cash Budget April Beginning cash balance 57,000 Cash receipts from customers (172,800 Total cash available 729,800 Cash payments for: Raw materials 165,040 Direct labor 171,560 Variable overhead 40,304 Sales commissions 29,000 Sales salaries 4,700 General & administrative salaries 29,000 Dividends Loan interest 290 Long-term note interest 4,160 Purchases of equipment Total cash payments 444,054 Preliminary cash balance 285,746 Additional loan (loan repayment) (29,000) Ending cash balance 256,746 248, 167 201,320 46,068 21,375 4,700 29,000 27,000 0 4,160 271,843 149,110 50,468 27,375 4,700 29,000 581,790 200,056 0 200,056 0 4,160 147,000 683,656 401,775 0 401.775 Revised Loan balance: ST note payable April Loan balance - Beginning of month 29.000 Additional loan (loan repayment) (29,000) Loan balance - End of month 0 May June ololo ololo 9) In Zigby's original budget (connect) the average cost for raw material and finished goods was given. Because of the discount to raw material and the increased volume of production, you will need to calculate the weighted average cost per unit to use to value ending inventory, direct material used in production, and cost of goods sold. Start with raw material a) Usc information from March 31 balance sheet (connect) and the revised purchase budget in 3) to complete the table below. $91,600 804,630 ZIGBY MANUFACTURING Weighted Average Cost per Raw Material unit Costs: March 31 Raw Material Balance connect) Raw Material purchases (total from 3 net of discount) Total Costs available for use in production @). Units: Units in 3/31 Raw Material inventory (connect) Units purchased during quarter (from 3) Total units available for production (b) Weighted Averago Cost per unit b) show 2 decimals 896,230 4,580 40,770 45,350 19.76 b) Use the weighted average cost per unit to calculate the June 30 raw material inventory balance and the cost of direct material used in production. Use the notes below the table for assistance ZIGBY MANUFACTURING Raw Material Inventory Allocation of Costs Inventory at Used in 6/30 Production Units 5700 39650 Weighted average cost per unit 19.76 19.76 Allocated costs $112,632 $783,484 Total Accounted for 896, 116 1) Units in inventory at 6/30 are provided on connect (also used in revised purchase budget in 3). ii) Calculate Munits used in production as the Unix Available for production (table above) minus the units in 6/30 inventory. iii) Include the weighted-average cost per unit" from the first table. iv) Calculate the "Allocated costs as the units times the weighted-average cost per unit in each row 10) Connect gives a total product cost" per unit that is used to calculate the ending inventory value and cost of goods sold. This per unit cost includes fixed overhead costs assuming the quarter's original production and sales levels. This average will change because of the one-time sale, Zigby Manufacturing uses weighted average costing for its inventory. Because Zigby does not have any Work-In-Process inventory, we can assume that all production costs flow to finished goods and then to cost of goods sold a) Follow the directions below the table to calculate the revised weighted average cost per unit. ZIGBY MANUFACTURING Welahted Average Cost per Finished Goods Inventory Costs: March 31 Finished Goods Inventory connect) Raw Material used in production (calculated in 9) Budgeted Direct Labor costs (calculated in 4 including wage premium) Budgeted Overhead Costs (calculated in 5. Both variable and fired) Total Costs of Finished Goods available for use sale(a) Units: Units in 3/31 Finished Goods Inventory connect) Units produced during quarter (from 2) Talal units available for sale (b) Weighted Average Cost per unit (Mb) show 2 decimal $380,480 783,484 521,990 278,490 1,964,444 18,560 79,300 97,860 20.07 b) Use the weighted average cost per unit to allocate costs between 6/30 finished goods inventory and COGS ZIGBY MANUFACTURING Finished Goods Inventory Allocation of Costs FG Inventory at 6/30 Sold Units 18,560 79,300 Weighted average cost per unit 20.07 20.07 Allocated costs 372,499 1,591,551 Total Accounted for 1,964,050 i) Units in Finished Goods Inventory at 6:30 are provided on connect (also used in revised production budget in 2). ii) Calculate "units sold as the Units available for sale (table above) minus the units in 6/30 inventory iii) Include the weighted-average cost per unit" from the first table. iv) Calculate the "Allocated costs" as the units times the weighted-average cost per unit in each row. Use these costs for Finished Goods Inventory on the budgeted 6/30 bulance sheet and Cost of Goods Sold in the budgeted income statement for the quarter ending June 30. 11) Using revised budget amounts where appropriate, complete the revised Budgeted Income Statement below. Include amounts in the light blue cells. 1,969,675 1,591,551 378,124 ZIGBY MANUFACTURING Revised Budgeted Income Statement For Three Months Ended June 30, 2019 Sales, net of discount Cost of goods sold from 10 Gross profit Sales commissions 27,375 Sales salaries 4,700 General administrative salaries 29,000 Long-term note interest 4,160 Bank loan interest expense 0 Total operating expenses Income before taxes Income tax Net income 65,235 312,889 125,155.6 Use revised budgets where appropriate and complete the Revised budgeted balance sheet below. Include amounts in the light blue cells. Differences due to rounding will not be marked wrong. Show your work to support all numbers. You must show Retained Earnings balance as Beginning + increasc - decrease - ending balance to carn credit on the balance sheet. IGBY MANUFACTURING Revised Budgated Balance Sheet June 30, 2019 Assets Cash 401,775 Accounts receivable Raw materials inventory Calaculated in 9 Finished goods inventory Calaculated in 10 Total current assets Equipment 781,000 Accumulated depreciation 278,960 Equipment net Total assets Liabilities and Equity Accounts payable updated Bank loan payable Income taxes payable Total current liabilities Long-term note payable Total Liabilities Common stock 352,000 Retained eamings update Total Stockholders' Equity Total Liabilities and Equity 502,040 520,000