The Bentfield Company is preparing its cash payments budget. The following items relate to cash payments the company anticipates making during the second quarter of the upcoming year. Click the con to view the cash payment information Requirement Preparo a cash payments budget for April, May, and June and for the quarter (if a box is not used in the table leave the box emoty, do not enter a zero) The Bentfield Company Cash Payments Budget For the Months of April through June April May Cash payments for direct materials: 50% of current month purchases 50% of last month's purchases June Quarter Prepare a cash payments budget for April, May, and June and for the quarter. (If a box is not used in the table leave the bo The St. Germaine Company Cash Payments Budget For the Months of April through June April May June Quarter Cash payments for direct materials: 45% of current month purchases $ 62,550 $ 57,600 $ 66,150 $ 186,300 55% of last month's purchases 61,600 76,450 70,400 208,450 Cash payments for direct labor 44,000 54,000 69,000 167,000 Cash payments for manufacturing overhead 25,600 39,600 60,600 125,800 Cash payments for operating expenses 58,500 70,500 76,500 205,500 Cash payments for new server 6,000 6,000 Cash payment for taxes 14,500 14,500 Total cash payments 252,250 $ 304,150 $ 357,150 $ 913,550 -X i More Info a. The company pays for 50% 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 $ 116,000 $ 132,000 $ 123.000 $ 146,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 $ 60,000 $ 70,000 85,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: March April May June $ 73,000 89,000 $ 86,000 $ 94,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 $2,800 for bad debt expense. e. The company plans to pay $2,000 (cash) for a new server in May. f. The company must make an estimated tax payment of $11,500 on June 15. Print Done