1 Prepare: Cost Budget base for the 6 Months suery 2022 to June 2020 on the following data 2 3 Salaries Sales: Purchases Benefits Other Capital Insurance Thees Oct-21 $1,000,000 $300,000 $375,000 $170,000 $225,000 $35,000 $150,000 6 Nov.21 $975,000 $292,500 $365,625 $169,750 Dec-21 $1,100,000 $330,000 $412.500 $187.000 & Jan-22 $1,250,000 $375,000 $468,750 $212,500 $250,000 $35,000 $150,000 $ 9 Feb-22 $1,300,000 $390,000 $487,500 $225,000 10 Mar-22 $1,000,000 $300,000 $375,000 $170,000 Apr-22 $975 con $292,500 $365,625 $165 750 $250,000 $35,000 $150,000 12 May 22 $995,000 $295,500 $369,375 $157,450 13 Jun-22 $965,000 $289,500 $361,875 $164,050 $250,000 14 Jul-22 $975,000 $ $292.500 $365,625 $165,750 $35,000 $150,000 15 Aug 22 $950,000 $23,000 $ $255,250 $16:,500 $ 16 Sep-22 $945,000 $283,500 $330,250 $160,650 17 $12,420,000 19 19 20 22 22 Cash Collection Cash Payments 23 20% month of sale Purchases: Month after Purchase 24 55% 1st month after sale Salaries Benefits: Month of Sale 25 25. 2nd month after sale Other: 2 months after incurred 26 Capital Month of purchase 27 Insurance: Month incurred 28 Beginning Cash Balance: $75,000 Taxes Month incurred 29 30 32 32 33 34 35 36 37 32 39 40 41 42