create a total cash payments budget

Cash payments for direct materials: 55% of current month purchases 45% of last month's purchases Cash payments for direct labor Cash payments for manufacturing overhead Cash payments for operating expenses Cash payments for new server Cash payment for taxes Total cash payments The Sweeney Compary is preparing its cask payments budget. The following ilems relate to cash payment the company anticipates making during the second cuarter of the upcoming year. (i) (Cick the icon lo view the cath payment intormation) Requirement Prepare a cash payments budget for April, May, and June and foe the quarter, (it a box ia not uted in the table leave the bor emper, co not enter a zero.) 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: 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: c. Manufacturing overhead is estimated to be 140% 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: Monthly operating expenses are paid in the month after they are incurred. Monthly operating expenses include $10,000 for monthly depreciation on administrative offices and equipment, and $3,200 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