prepare a cash budget pls

ending balance of december is 70000

marketable secuirty is 30000

Required # 1 - Sales Budget Februa ry March Decemb er 800,000 200000 600XX00 January 880000 1064800 968000 242000 First Quarter 2912800 728200 2184600 266200 220000 660000 726000 798600 Total Sales Cash Sales Sales on Account Total Sales increase by 10% each month Credit sales are 75% of total sales. So, the cash sales are 25 % of total sales Required # 2 - Schedule of Expected Cash Collection Cash Sales Cash collection from credit sales made during current month Cash collection from credit sales made during preceding month Total Receipt of Cash Februar January March 220000 242000 266200 66000 72600 79860 540000594000 653400 826000 908600999460 First Quarter 728200 218460 1787400 2734060 Required #3 - Purchase Budget March 745360 409948 Decemb Februa er January 560000 616000 677600 308000 938800372680 105028 868000 954800 0 0 308000 338800 868000 646800 711480 First Quarter 2038960 1121428 Budgeted Cost of Good Solds Add-Desired Ending Inventory Total Needed Less Beginning Inventory Purchases 1155308 372680 3160388 1019480 782628 2140908 Required # 4 - Schedule of expected cash disbursement for inventory purchase Months Total Budged Purchase Februar January V March 646800 711480 782628 Quarter 2140908 258720 284592 388080 520800 40% of current mont purchase will be paid in current month 60% of previous month purchase will be paid in current month Expected Cash disbursement for inventory purchase Required #5 - Schedule of expected cash disbursement for operations expense 313051 2 8563632 426888 1335768 739939 2 21921312 779520 672672 January 42000 Februar Y 42000 March 42000 Quarter 126000 96000 32000 Months Salaries Advertising Admin Expense Bond Interest Property Tax Commission 32000 42000 32000 42000 42000 126000 30,000 30,000 10800 9680 10800 29128 10648 8800 154800 Total Expenses 136480 126648 417928