how do I do question 7 using the data above?
May June $ 175,166 $ 259,953 549,500 451,500 724,666 711,453 ZIGBY MANUFACTURING Cash Budget April, May, and June 2019 April Beginning cash balance $ 57,000 Cash receipts from customers 580,000 Total cash available 637,000 Cash payments for + Raw materials 206,300 Direct labor 119,080 Variable overhead 40,304 Sales commissions 29,000 Sales salaries 4,700 General & administrative salaries 29,000 Dividends 0 Loan interest 290 Long-term note interest 4,160 Purchases of equipment 0 Taxes paid 0 Total cash payments 432,834 Preliminary cash balance 204,166 Additional loan (loan repayment) (29,000) Ending cash balance 196,300 136,110 46,068 21,375 4,700 29,000 27,000 219,400 149,110 50,468 27,375 4,700 29,000 0 0 4,160 147,000 0 4,160 0 0 631,213 0 464,713 259,953 0 259,953 80,240 18,760 99,000 $ 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 x 20 per pound x 5% Calculate the Discount for each month and calculate the "net" purchase amount. Projer 4: Page 2 of 11 Total June 22,940 .50 ZIGBY MANUFACTURING Revised Raw Materials Budget April May Production budget (units) 26,320 30,040 Materials requirements per unit 150 .50 (unchanged 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 11,470 5,700 17 170 (3,441) 13,729 $20.00 140.770 $20.00 $274,580 $815,400 $3,729 510.770.00 $270,851 $804,630 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 decreases accounts payable (debit). June 30 Accounts Payable ZIGBY MANUFACTURING Estimated Payments for Raw Material Purchases April May June March 31 Accounts Payable April purchases May Purchases June Purchases Total cash payments
