Homework: Cha... Question 4, E9-31A (simi... HW Score: 82.14%, 5.75 of 7 points Save Part 1 of 7 Points: 0 of 1 The Berkner 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 icon to view the cash payment information) Requirement Prepare a cash payments budget for April, May, and June and for the quarter. (1 a box is not used in the table leave the box empty, do not enter a zero.) The Berkner Company Cash Payments Budget For the Months of April through June April May Cash payments for direct materials: 55% of current month purchases $ 74,250 $ 66,550 $ 45% of last month's purchases 65450 74250 June Quarter 78,100 $ 66550 218,900 206250 Save -- hg the second quarter 2000.) Question 4, E9-31A (simil... HW Score: 82.14%, 5.75 of 7 points Homework. A More Info The Berkner Company ter of the upcoming year. (Click the icon to y 7/21 a. The company pays for 55% of its direct materials purchases in the month of purchase and the Requirement remainder the following month. The company's direct material purchases for March through June pol Prepare a cash payme are anticipated to be as follows: TU March April May June $ 119,000 $ 135,000 $ 121,000 $ 142,000 ons b. Direct labor is paid in the month in which it is incurred. Direct Inbor for each month of the second quarter is budgeted as folows: April May June $ 50,000 (0/1 $ 60,000 $ 75,000 Cash payments for din e Manufacturing overhead is estimated to be 150% of direct labor cost each month. This monthly 55% of current mol estimate includes $36,000 of depreciation on the plant and equipment. All manufacturing overhead (excluding depreciation) is paid in the month in which it is incurred 45% of last month d. Monthly operating expenses for March through June are projected to be as follows: March April May June 5 78,000 5 85,000 5 82.000 $ 92,000 Monthly operating expenses are paid in the month after they are incurred. Monthly operating expenses include $15,000 for monthly depreciation on administrative offices and equipment, and $3,000 for bad debt expense e. The company plans to pay $5,000 (cash) for a new server in May. Manag on Print Done Help Me Solve Trus VICE Geture Top TUT Check