Gem Service anticipates the following sales revenue over a five-month period: Click the icon to view the sales data) The company's sales are 30% cash and 70% credit, Its collection history indicates that credit sales are collected as follows: (Click the icon to view the collections data) How much cash will be collected in January? In February? In March? For the quarter in total? Complete the cash budget to determine how much cash will be collected in January, February March and for the quarter in total. (Round your answers to the nearest whole dollar) Gem Service Cash Collections Budget For the Months of January through March January Cash sales Collection of credit sales: 20% Month of sale 40% Month after TELE 30% Two months after Total cash collections January of credit sales: onth of sale i Data Table November March December $ 10,200 January $ 15,800 February $ 12,400 Sales revenue $ 16,300 $ 14,400 Print Done January II * More Info 20% in the month of the sale 40% in the month after the sale 30% two months after the sale 10% are never collected Print Done Secure Corporation is preparing its cash payments budget for next month. The following information pertains to the cash payments: Click the icon to view the data.) How much cash will be paid out next month? Secure Corporation Cash Payments Budget Cash payments for direct materials: 50% of last month's purchases 50% of next month's purchases Cash payments for direct labor Cash payments for manufacturing overhead Cash payments for operating expenses Cash payment for taxes Total cash payments % of last month's purchases 5% of next month's purchases payments for direct labor pavments for manufacturing overhead 2 PL i More Info p 1 a. Secure Corporation pays for 50% of its direct materials purchases in the month of purchase and the remainder the following month. Last month's direct material purchases were $77,000, while the company anticipates $89,000 of direct material purchases next month. b. Direct labor for the upcoming month is budgeted to be $37,000 and will be paid at the end of the upcoming month. c. Manufacturing overhead is estimated to be 150% of direct labor cost each month and is paid in the month in which it is incurred. This monthly estimate includes $17,000 of depreciation on the plant and equipment d. Monthly operating expenses for next month are expected to be $43,000, which includes $2,000 of depreciation on office equipment and $1,300 of bad debt expense. These monthly operating expenses are paid during the month in which they are incurred. e. Secure Corporation will be making an estimated tax payment of $7,000 next month. Print Done