Required: 1. Prepare a schedule of expected cash collections for July, August, and September and for the quarter in total. Credit sales: 2. Prepare the following for merchandise inventory: a. A merchandise purchases budget for July, August, and September. 2. Prepare the following for merchandise inventory: a. A merchandise purchases budget for July, August, and September. JANUS PRODUCTS, INC. Merchandise Purchases Budget July August September Total needsb. A schedule of expected cash disbursements for merchandise purchases for July, August, and September and for the quarter in total. Total cash disbursements $ 0 $ 0 $ 0 $ 0 3. Prepare a cash budget for July, August, and September and for the quarter in total. (Roundup "Borrowing" and "Repayments" answers to the nearest whole dollar amount. Any "Repayments" and "Interest" should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.) Total cash available Deduct: Disbursements: Excess (deciency) of cash available over disbursements - - - - Totamnancing