GEP 111 Activity 12 Cash Budges collections and payments template-1 Home Insert Drew Page Layout Formulas Data Review Vien Tell me Share Comments Calib (Rocy! ~ 11 A A w Araplast General Nam Bad JE Aosum yo X Cut ngr; Format PARIN = = Ciud Netral Merce Co S Trover I Carlo Fonds Table Sarl Fiat Ana Final Suk SangY Clear - FE X Vf A B C D E F 1 K L M N O P 32 Prepare budget for cash disbursements for accounts payable 33 Bearcat City purchases raw materials on account for use in production. Bearcat City typically pays 30% 34 on account in the month of the billing and the remaining 70% is paid in the following month. Prepare a 35 schedule of expected cash disbursements for the months of September and October based on the direct 36 materials purchases budget shown below of expected purchases on account: 37 38 August $ 370,000 39 September $ 400,000 40 October $ 425,000 41 42 43 Calculation: 44 $ credit purchases % paid Month of Payment 45 August September October 40 46 47 * 48 September 49 50 50 31 51 52 October 53 54 Monthly Total 55 56 57 58 59 60 61 62 +2 X X Sheet1 Erte # INDU- + 178