need the whole table done please

ACCT 256-Managerial Accounting-Summer 19 omework: Chapter 9 Homework Score: 0 of 2 pts 4 of 6 4 complote) hw Score: 39.1 7% 9-29A (similar to) EQues The Sesnie Company is preparing ts cash payments budget. The folewing nems relate to cash (Click the koon to view the cash payment information) Prepare a cash payments budget for April, May, and June and for the quarter (lf a box is not used in the tatie lave the box emply do not enter a zero,) The Sesnie Company For the Months of April through June April Cash payments for direct materials 49% of current month purchases 55% of last month's purchases Cash payments for direct labor Cash payments for operating expenses Cash payments for new sorver This question is Move your Homework 4 of 6 (4 complete) More Info a. The company pays for 55% of its direct materials purchases in the month of purchase and the remainder the following month. The company's direct material purchases for March through June are anticipated to be as follows: March April May June S 111,000 134,000 129,000 $ 144,000 b. Direct labor is paid in the month in which it is incurred. Direct labor for each month of the second quarter is budgeted as follows: April May June $ 52,000 62,000 77,000 c. Manufacturing overhead is estimated to be 160% of direct labor cost each month. This monthly estimate includes $37,000 of depreciation on the plant and equipment. All manufacturing overhead (excluding depreciation) is paid in the month in which it is incurred. d. Monthly operating expenses for March through June are projected to be as follows: April March May June $ 73,000 89,000 82,000 $ 91,000 Monthly operating expenses are paid in the month after they are incurred. Monthly operating expenses include $11,000 for monthly depreciation on administrative offices and equipment, and $3,400 for bad debt expense. en PrintDone 9 Homework 4 of 6 (4 complete) More Info the are anticipated to be as follows May, an March April May June S111,000 134,000 129,000 144,000 he LaC ash Pay b. Direct labor is paid in the month in which it is incurred. Direct labor for each month of the second quarter is budgeted as follows: April May June $ 52,000 $62,000 $77,000 c. Manufacturing overhead is estimated to be 160% of direct labor cost each month. This monthly estimate includes $37,000 of depreciation on the plant and equipment. All manufacturing overhead (excluding depreciation) is paid in the month in which it is incurred d. Monthly operating expenses for March through June are projected to be as follows: April May June March $ 73,000 89,000 82,000 91,000 Monthly operating expenses are paid in the month after they are incurred. Monthly operating expenses include $11,000 for monthly depreciation on administrative offices and equipment, and $3,400 for bad debt expense. e. The company plans to pay $4,000 (cash) for a new server in May f. The company must make an estimated tax payment of $14,000 on June 15 and then clid Print Done 20 F7 F3