month in which there is cash assumed to have been made

Cash Budget For the Quarter Ended March 31 Section 1: Cash Receipts Section 2: Cash Payments Section 3: Financing Activities Beginning cash balance Add: Cash receipts Total cash available For inventory purchases For S&A expenses For asset urchases For interest expenses Total disbursements Surplus (shortage) Borrowing (re yments Ending cash balance January $ 6,000.00 $ 127,000 $37,000.00 February $187,000.00 $ 113,000 $ 67,000.00 $ 37,000.00 $ 217,000 (i (j March $255,000.00 $118,500.00 $ 69,000.00 $ 37,000.00 (m) $ 225,170 (o The company desiresto maintain an ending cash balance of at least $7,000 each month. In any month in which there is cash shorta e, thecom n 's bank will extend ita loan ual to the shorta e amount. The loan is assumed to have been made Required: Compute the missing amounts for items (a) through (p) (show work)