how do i do question 9 using the data above?

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 $ 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 To prepare a master budget for April, May, and June of 2019, management gathers the following information rded nces 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 seling 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). 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-enpl (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. 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 Tell me what you want to do 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 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 April 2019 May 2019 June 2019 Totals for the 2 quarter Revised Net Sales $580,000 842,175 547,500 1,969,675 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. June 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 $20 per pound85% Calculate the Discount for each month and calculate the "net" purchase amount I Project 4: Page 2 of 11 Total ZIGBY MANUFACTURING Revised Raw Materials Budget April May Production budget (units) 26,320 30,040 Materials requirements per unit .50 .50 funchanged from connect) 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) (4,506) Materials to be purchased 13.086 13,955 Material price per unit $20.00 $20.00 Raw Material purchases before $261,720 $279,100 Discount Discount (5% of purchases exceeding 10,000 lbs) $3,086 $3,955 Budgeted raw material purchases $258,634 $275 145 June 22,940 .50 11,470 5,700 17,170 (3.441) 13 729 $20.00 40,770 $20.00 $274,580 $815,400 $3,729 $10.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 bour for excess overtime. Excess overtime has been defined as any hours in excess of 13,000 bours 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 per unit (hours) Total labor hours needed Direct labor rate (per hour) Base direct labor cost Wage premium (3xhours over 13.0001 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 6,060 171,560 201,320 June 22,940 .50 11,470 13 149, 110 NO 149,110 521,990 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 11470 4.20 48,174 37,320 85 494 166,530 111,960 278,490 6) The special 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 March 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 connect) 116,000 85,500 109,500 Current month's credit sales collected 92,800 758,400 87,600 (20% of current months credit salos) 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 delay 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 June, etc.) Remember: Purchases budgeted in 3 increased accounts payable (credit) while estimated payments here decrcases 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 Play 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 672,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 18,760 420,535 May 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 ololo June 0 18,760 18,760 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) Use information from March 31 balance sheet (connect) and the revised purchase budget in 3) to complete the table below. $25.00 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 (a) Units: Units in 3/31 Raw Material inventory (connect) Units purchased during quarter (from 3) Total units available for production (b) Weighted Average Cost per unit (a) (b) show 2 decimal 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 Total Accounted for ZIGBY MANUFACTURING Raw Material Inventory Allocation of Costs Inventory at Used in 6/30 Production Units Weighted-average cost per unit Allocated costs $ $ i) Units in inventory at 6:30 are provided on connect (also used in revised purchase budget in 3) in) Calculate "imits used in production as the "Units available for production" (table above) minus the units in 6/30 inventory i) 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