I need:

Cash payments for Direct Materials:

50% of current month purchases

50% of last months purchases

cash payments for direct Labor

Cash Payments for MOH

cash payments for operating expenses

cash payments for new server

cash payment for taxes

total cash payments

I need this for April May June and the Quarter

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 118,000 $ 130,000 $ 121,000 $ 147,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 $ 46,000 $ 56,000 $ 71,000 c. Manufacturing overhead is estimated to be 140% of direct labor cost each month. This monthly estimate includes $39,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 $ 71,000 $ 84,000 $ 89,000 $ 96,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 $2,900 for bad debt expense. e. The company plans to pay $3,000 (cash) for a new server in May